Using an excel spreadsheet.

A manufacturing firm produces four types of automobile parts. Each is first fabricated and then finished. The required worker hours and profit for each part are: Part A Part B Part C Part D Fabrication time (hr/100 units) 2.5 1.5 2.75 2 Finishing time (hr/100 units) 3.5 3 3 2 Profit ($/100 units) 375 275 475 325 The monthly total fabrication time available is 640 hours and the total finishing time is 960 hours. a) Use Excel to solve for the amount of each part that maximizes profit, and enter your answers below. Part A Part B Part C Part D Amount (x100 units) b) Which would further maximize profit, hiring an extra 40 hours of fabrication time or finishing time