A company manufactures four different products, each of which must be assembled, painted, and inspected. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company manufactures four different products, each of which must be assembled, painted, and inspected. The required number of hours for each of these processes is listed in the following table. Product 1 Assembly 3 Painting Inspection Product 2 2 1 1 Product 3 2 2 2 Product 4 4 3 1 Each week the company has 480, 400, and 400 hours of time for assembly, painting, and inspection, respectively. The per unit profits for the four products are $6, $4, $6, and $8, respec- tively. The company must provide at least 50 units of product 1 and at least 100 units of any com- bination of products 2 and 3 on a weekly basis. A maximum of only 25 units of product 4 should be produced. The company wants to know how many units of each product should be produced to maximize profit. Formulate this problem as a linear programming problem and solve using Excel's Data/Solver. Print out the "Answer" and "Sensitivity" reports. Using the "Answer" and "Sensitivity" reports, answer the following questions: a. What is the largest possible profit for the company while satisfying all of the constraints? b. How many units of each product should be produced and sold in order to maximize the profit? A company manufactures four different products, each of which must be assembled, painted, and inspected. The required number of hours for each of these processes is listed in the following table. Product 1 Assembly 3 Painting Inspection Product 2 2 1 1 Product 3 2 2 2 Product 4 4 3 1 Each week the company has 480, 400, and 400 hours of time for assembly, painting, and inspection, respectively. The per unit profits for the four products are $6, $4, $6, and $8, respec- tively. The company must provide at least 50 units of product 1 and at least 100 units of any com- bination of products 2 and 3 on a weekly basis. A maximum of only 25 units of product 4 should be produced. The company wants to know how many units of each product should be produced to maximize profit. Formulate this problem as a linear programming problem and solve using Excel's Data/Solver. Print out the "Answer" and "Sensitivity" reports. Using the "Answer" and "Sensitivity" reports, answer the following questions: a. What is the largest possible profit for the company while satisfying all of the constraints? b. How many units of each product should be produced and sold in order to maximize the profit?
Expert Answer:
Related Book For
Engineering Economy
ISBN: 978-0132554909
15th edition
Authors: William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Posted Date:
Students also viewed these finance questions
-
Cameron's inventory turnover during 20X9 was (amounts rounded) 5 times. 6 times. 7 times. none of the above. Camerons Accounts 20x9 20x8 Cash and cash equivalents $ 5,550 $ 5,094 Receivables 1,813...
-
On January 1,2008 Halston Enterprises issued 8%, 20-year bonds with a face amount of $3,000,000 at ? Interest is payable semiannually on June 30th and December 31st. Effective rate is 12% Prepare the...
-
Determine whether the lines intersect, and if so, find the point of intersection and the cosine of the angle of intersection. x= 2 _ y = 2. - -3 6 z - 3, = Z r- * z 3 =y+5= L 2 2 4
-
Answer the following question based on the information presented for Cloud 9 in the appendix to this text and the current and earlier chapters. You should also consider your answers to the case study...
-
Leader Enterprises Ltd. follows IFRS and has provided the following information: 1. In 2016, Leader was sued in a patent infringement suit, and in 2017, Leader lost the court case. Leader must now...
-
George Wilson dies on March 1, 2013, leaving a valid will. The will reads as follows: I leave my home, furnishings, remaining bank account balances and personal possessions to my wife Helen. I leave...
-
Explain what is meant by dynamic world planning.What is meant by probabilistic planning? What is the difference between probabilistic planning and nondeterministic planning?
-
In Problem S1-3 the Landloc real estate development firm has hired an economist to assign a probability to each direction interest rates may take over the next five years. The economist has...
-
Rhiannon files single and claims her daughter, Cobie ( 2 5 ) . Her adjusted gross income ( AGI ) is $ 1 8 5 , 0 0 0 . What is the maximum amount Rhiannon may potentially be able to claim for the...
-
Information for Abbott Health Company who makes vaccines. Budgeted Actual Average Selling Price Per Vial 8.30 $ 8.20 Total Direct Materials Cost Per Vial $ 3.60 $ 3.90 Direct Manufacturing Labor Cost...
-
The salespeople at Culver, a notebook manufacturer, commonly pressured operations managers to keep costs down so the company could give bigger discounts to large customers. David, the operations...
-
Calculate the firm weighted average cost of capital. For the firm debt, the interest coupon rate is 4%, and the yield to maturity is 2%. Interest is paid annually. The cost of equity is 8%. The...
-
3. A two stock (A & B) portfolio is formed. The expected returns are ra = 10% and rb = 15%. The standard deviation for Stock A is 12% and 15% for Stock B. If the correlation coefficient of the two...
-
RWC Incorporated a monthly ledger balance and deposit float of $200,000 and $25,000, respectively. Regions Bank pays RWC an earnings credit rate of 40 basis points, the reserve requirement ratio is...
-
Mai, age 40, is leaving the workforce. The average life expectancy for a 40-year old female is age 90. She has the opportunity to commute the value of her pension. Assuming an expected rate of return...
-
Terra Company issued a $300,000, 7.50%, 10-year bond on June 1, 2015. Additional information on the bond follows: Bond Date: January 1, 2015 Maturity Date: December 31, 2024 Yield (Market) Rate: 8%...
-
Would you use the adjacency matrix structure or the adjacency list structure in each of the following cases? Justify your choice. a. The graph has 10,000 vertices and 20,000 edges, and it is...
-
Refer to Example 5-13. Create a single spreadsheet that calculates PW, FW, AW, IRR, and ERR for the proposed investment. Assume that = MARR = 20% per year. Does your recommendation change if the...
-
A geometric gradient has a positive cash flow of $1,000 at EOY zero (now), and it increases 5% per year for the following five years. Another geometric gradient has a positive value of $2,000 at EOY...
-
The furnace of a boiler in a power plant cost $100,000 five years ago. The furnace had the capacity to produce 70X106 kcal/hour. Now, a furnace with a capacity of 100X10 kcal/hour is desired. With a...
-
Does higher expected inflation increase, decrease, or have no effect on the required rate of return?
-
What methods can a company use to raise capital?
-
Does a company share its risk by issuing equity or debt?
Study smarter with the SolutionInn App