12. MANUFACTURING. Bards Pewter Company (BPC) manufactures pewter plates, mugs, and steins that include the campus name
Question:
12. MANUFACTURING. Bard’s Pewter Company (BPC) manufactures pewter plates, mugs, and steins that include the campus name and logo for sale in campus book stores. The time required for each item to go through the two stages of production (molding and finishing) and the corresponding unit profits are given in the following table. Molding Finishing Unit Time (min.) Time (min.) Profit Plates 2 8 $2.50 Mugs 3 12 $3.25 Steins 6 14 $3.90 BPC employs 12 workers, each of whom works 8 hours per day; 4 are assigned to the molding operation, the others to the finishing operation. BPC’s marketing department has recommended the following: • At least 150 mugs should be produced daily. • The number of steins produced can be at most twice the combined total number of plates and mugs produced. • Plates can account for no more than 30% of the total daily unit production. solve in excel. show how you got max profit as well as the values for x1 x2 and x3. use excels solver function to produce a sensitivity report.
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier