Reference no: EM132974578
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. $6 $9. $6
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.