Need help with decision support systems homework problem.

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 PCAs, 670 FCAs and 1,300 MBAs. 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,300PCAs, 670 FCAs and 500 MBAs?

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.

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