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

 

	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

	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.

Answer rating: 100% (QA)

Formulate Excel model as follows Set up Solver Parameters ... View the full answer