Please solve in Excel format and show step-by-step formulas.

Sally's Solar Car Co. has a plant that can manufacture family sedans, station wagons, and sports coupes. The contribution, variable production time, and fixed cost for these cars are given below. VARIABLE PROFIT MODEL CONTRIBUTION ($) PRODUCTION FIXED COST ($) TIME (Hours) Sedan 6,000 2,000,000 Station Wagon 8,000 15 3,000,000 Coupe 11,000 7,000,000 12 Sally currently has orders for 100 sedans, 200 station wagons, and 300 coupes. She must satisfy these orders. She wants to plan production so she will break even as quickly as possiblethat is, she wants to make sure that the total contribution margin will equal total fixed costs and that total variable pro- duction time is minimized. Formulate this problem as an LP and solve it. Sally's Solar Car Co. has a plant that can manufacture family sedans, station wagons, and sports coupes. The contribution, variable production time, and fixed cost for these cars are given below. VARIABLE PROFIT MODEL CONTRIBUTION ($) PRODUCTION FIXED COST ($) TIME (Hours) Sedan 6,000 2,000,000 Station Wagon 8,000 15 3,000,000 Coupe 11,000 7,000,000 12 Sally currently has orders for 100 sedans, 200 station wagons, and 300 coupes. She must satisfy these orders. She wants to plan production so she will break even as quickly as possiblethat is, she wants to make sure that the total contribution margin will equal total fixed costs and that total variable pro- duction time is minimized. Formulate this problem as an LP and solve it