Optimization Assignment

Submitted By kokybear
Words: 1023
Pages: 5
Open Document
Optimization Assignment
TO 501
Fall 2013 Prof. Lenk

Due Lecture 4, Sept 26
Team assignment with 3 to 5 students per team
Collaboration among teams is not allowed
Each team will hand in one assignment
Answer questions in space provided

Team Names:

Comments
Copy and paste the assignment data tables to EXCEL instead of entering the numbers by hand.
Please copy and paste your Solver model after running it. I find that Paste Special, Picture (Windows Metafile) works best when the Solver model is too big to fit naturally with Paste.
The problems ask you to write the model algebraically and implement them in Solver. The reason for this requirement is that there is a one-to-one relation between the Solver model and its algebraic statement. My experience is that students who have trouble with the algebra tend to have trouble with Solver models. Students learn more by practicing both.
Unfortunately, there is a trend to cut corners and adapt existing workbooks for the problems. It may be a more efficient method to completing the assignment, but it does not help you develop your skills.
High performance students attempt the all of the problems on their own.
Problem 5 appears to be the shortest but may well be the most challenging one.

1. Allocation and Linear Programming. A company produces three products in kilos. Each product requires different amounts of time per kilo in each of four departments (A, B, C, and D). The following table gives the profit contributions per kilo, the available time (minutes) in each department, and time requires per kilo in each department for each product.

Product 1
Product 2
Product 3 Profit Contribution per Kilo
13
17
11

Amount of Time in Departments per Kilo Department
Product 1
Product 2
Product 3
Time Available
A
7
4
8
550
B
3
7
4
300
C
6
9
6
700
D
9
2
5
900

a. Formulate a linear programming model to maximize the company’s profit. State the objective function and constraints algebraically.

b. Implement the problem in Solver. Copy and paste here your Solver model after obtaining the solution.
c. Using Solver, find the production mix for the products that maximizes profits. What is the optimal mix and maximum profit?

Product 1: Product 2: Product 3:

Profit:

d. Which constraints are binding, and which ones are slack?

Department A: Department B:

Department C: Department D:

e. If the optimal amount of Product 3 is zero, how much would the contribution for Product 3 have to increase for the company to start producing Product 3? Use the Sensitivity Report.

f. Suppose that the contribution for Product 1 increases by 3 dollars. What is the new product mix? What is the new profit? Use the Sensitivity Report.

Product 1: Product 2: Product 3: Profit:

g. What is the maximum amount that the company should be willing to pay for 10 more minutes in Department A? Use the Sensitivity Report.

h. What is the maximum amount that the company should be willing to pay for 10 more minutes in Department D? Use the Sensitivity Report.

2. Fixed Costs and Mixed Programming. Consider Problem 1. The products have fixed costs and maximum demands in the following table. Include these parameters with the original Problem 1 statement.

Product 1
Product 2
Product 3
Fixed Costs
400
200
100
Maximum Demand Kilos
300
500
200

a. Formulate a linear programming model to maximize the company’s profit. State the objective function and constraints algebraically.

b. Implement the problem in Solver. Copy and paste here your Solver model after obtaining the solution.

c. What are the optimal production mix and profit?

3. Covering and Linear Programming. An IT firm staffs projects from a pool
Show More

Related Documents: Optimization Assignment

Ebenezer's Financial Case

seeing loopholes in Ebenezer’s firm’s financial statement. It is also about whether to give priority to personal relations over professional conduct. The scenario poses dilemma to Tim among two choices. Primarily, he can go ahead and sanction Ebenezer’s loan by doubling the loan amount. By doing this he would be faithful to his friend and also make sales for the bank. On the other side, he is putting bank’s funds at risk considering the fact that Ebenezer’s financial situation does not sound eligible…

Words 317 - Pages 2

Best Financial Case Essay

Critical Issues Best Financial Services Inc. is faced with the following critical issues. • How to identify new customers and turn them into long term permanent customers. • Making a marketing plan which will target new customers. • Retain the top customers (10% of the customers hold over 50% of the total assets) Decision Criteria • Achieve Linda’s goal to retire in 10 years and the future growth of the company • Should match and meet the requirements of Best Financial Services Inc.’s mission…

Words 508 - Pages 3

Best Financial Case Essay

Team 4 Best Financial Services Inc. Team 4 Critical Issues In order to retain valuable customers and capture a new customer segment for sustainability, Best Financial Services Inc. must address the following:  How to identify a new segment of customers that can be developed for future years so that Best Financial Services can address an aging Sarnia population and differentiate itself against growing competition.  Design a marketing plan which will target the chosen segment so that…

Words 1173 - Pages 5

Financial Aid Compliance Case Study

costs. In a case study conducted by Vanderbilt University, they estimated that overall each intuition complied with 30 different areas of regulations and over 200 federal laws and guidelines (Moran, 2015). “The study estimates of that $27 billion, $17 billion was incurred due to higher-education and all-sector compliance, while $10 billion was estimated to be a result of research-related compliance (Moran, 2015, P.1).” In this short essay, I will focus on accreditation and financial aid compliance…

Words 505 - Pages 3

Financial Analysis Case Study Essay

McDonald's Financial Analysis Case Study The purpose of this study is to assess a company’s future financial health. This study provides a "hands on" experience to synthesize the finance concepts that we learned throughout the course by applying them to a "real life" individual or organization. On this study I elected to assess McDonald Corporation’s future financial health. McDonald’s Corporation franchises and operates McDonald’s restaurants in the global restaurant industry. These restaurants…

Words 2961 - Pages 12

Financial Case Study: Allegiant Air

One example of a smaller carrier is Allegiant Air. Allegiant began their operations by purchasing cheaper, older, used, and inefficient MD-80 series aircraft at the cheap cost of 4 million per aircraft (Allegiant, 2013). As a LCC, Allegiant cites in the 2013 Annual Shareholders Report that they have properly balanced low aircraft ownership costs and operating costs to minimize total costs (Allegiant, 2013). As they have no incentive to reduce emissions, they are able to focus on the overall lower…

Words 478 - Pages 2

Japan Financial Crisis Case Study

a) U.S sub-prime financial crisis on Japan Impact on Capital Markets Due to the eruption of the sub-prime financial crisis, Japanese banks were greatly affected by the capital losses from their equity shareholdings in the Capital Markets as stock prices declined sharply. Japanese banks tried reducing the amount of cross-holdings of shares on banks' balance sheets; however, they were still exposed to the volatility caused by equity shareholdings. On December 2008, the Japanese government passed a…

Words 2089 - Pages 9

Assignment 1: Financial Case Study

Is your real property safe from the Medicaid “spend-down” requirements? If you are not sure, now is the time to find out because waiting until the last minute could result in losing your property. Almost half of all seniors eventually turn to Medicaid for help covering the high cost of long-term care. If you are one of those who needs to qualify for Medicaid at some point, will you be able to keep your real estate? Understandably, it’s a question that worries every senior facing the need to qualify…

Words 991 - Pages 4

Financial Overview - Mcdonalds Case Study Essay

Financial Analysis of the McDonald’s Corporation MCD, NYSE (New York Stock Exchange) One McDonald's Plaza, Oak Brook, IL 60523 Map +1-630-6233000 (Phone) +1-630-6235700 (Fax) Abstract McDonald’s is the most famous and well-known fast-food company in the world. This case study examines McDonald’s from a financial standpoint. This case study will be broken down in three parts. Discussed first will be a full description of McDonald’s corporation, including its background, followed by a financial…

Words 2126 - Pages 9

Financial Statement Analysis Case Alex Essays

Financial Statement Analysis Case: eBay Inc. (EBAY) & Oracle Corporation (ORCL) Part I When comparing eBay Inc. (EBAY) & Oracle Corporation (ORCL) in terms of profitability the most important profitability ratios to analyze are the companies’ Net Margin ratios, Asset Turnover ratios, the Return on Assets ratios, the companies’ Financial Leverage ratios, their Return on Equity, Return on Invested Capital & the companies’ Interest Coverage ratios. These ratios, when compared side by side, help…

Words 2572 - Pages 11