The Operations Manager at Incline Electronics is responsible for producing three different products in a plant that operates35hours per week. Each product requires the following processing times (in minutes) across each of three machines:

For next Monday, the schedule calls for the following product mix: 500 PCA’s, 670 FCA’s and 1,300 MBA’s. Any excess machine capacity can be used for processing of other products from other departments. As such, the Operations Manager wants assignment of Assemblies to Machines to find the shortest processing time.

A. Formulate the LP decision model

B. Create a Solver decision model

C. What is the optimal decision?

D. What is the optimal decision if the build changes to 1,300PCA’s, 670 FCA’s and 500 MBA’s?

E. If 1,300 of each product must be made, modify the decision model to determine how much overtime (or subcontractor time)would be required to accommodate this build schedule.

Machine 1 Machine 2 Machine 3 Printed Circuit Assembly (PCA) 2 3 4 Flex Circuit Assembly Motherboard (FCA) Assembly (MBA) 2 4 6 1 6 5