Reference no: EM132970028
CGB Manufacturing produces several products four of which are scheduled for next week. The products are identified by their model number, p6, p225, p238 and p239. The following departments have provided the following helpful information.
Production: Each product goes through 3 manufacturing phases, casting, milling and polishing. There are 60 hours available in casting and polishing and 40 hours in milling for next week.
The processing time for each product in each phase in minutes is listed in the table below:
P6 P225 P238 P239
Casting 19 14 13 9
Milling 5 8 6 7
Polishing 12 13 14 8
Accounting: Accounting has identified that the profit per unit for each product is in the table below:
P6 P225 P238 P239
Profit per Unit $7.00 $6.00 $9.00 $6.00
Marketing: Marketing has developed a contract for 100 of product p225 for next week.
Management: Management would like you to formulate the product and solve it using Excel Solver then forward your recommendations to them.