5. A toy company produces three different model cars based on exotic production versions: Ferrari, BMW, and Lotus. Each model requires production in five departments: Molding, Sanding, Polishing, Painting and Finish Assembly; see the table below. A Ferrari model sells for $500, a BMW model sells for $320, and a Lotus model sells for $300. Molding (Minutes) Sanding (Minutes) Polishing (Minutes) Painting (Minutes) Finishing Assembly (Minutes) Ferrari BMW 5 4 3.5 3.75 4 3.5 3.2 2 3.25 1 Lotus 1 2 3 1.75 2 Minutes Available 600 600 480 480 500 Formulate a linear programming model to find the optimal schedule for the company, assuming fractional solution is acceptable. Write the LP formulation and solver it in Excel.

Fig: 1