please show or write all the formulas because if not I will not get any marks! thank you very much!!!!

Zippy Motors has a 150,000 square feet plant that it devotes to manufacturing three models of electric vehicles: the Z1 electric sedan, the Zip electric truck, the Zippy electric cruiser. Zippy forecasts sales are in Table 2. The plant has three teams of employees. Information on what each team can make, and the time needed (in hours) to manufacturer a vehicle are in Table 1 below. For example, Team 1 can make sedans and cruisers but not trucks. Team 2 can manufacture trucks and cruisers but not sedans. Team 3 can only make trucks. Table 2 displays other operational information for Zippy Motors. Zippy needs to produce at least 10,000 Z1 electric sedans to fill a standing order. How can Zippy Motors maximize profit? Use Excel's simplex LP solver. Team/Vehicle Team 1 Table 1 Z1 electric sedan Zip electric truck 19 can't make can't make 21.5 can't make 22 Team 2 Zippy electric cruiser 18.5 17.5 can't make Team 3 Operations Hours available Contribution margin Demand Table 2 Z1 electric sedan Zip electric truck 400,000 300,000 $15,000 $18,000 25,000 22,500 Zippy electric cruiser 200,000 $15,500 15,000 Zippy Motors has a 150,000 square feet plant that it devotes to manufacturing three models of electric vehicles: the Z1 electric sedan, the Zip electric truck, the Zippy electric cruiser. Zippy forecasts sales are in Table 2. The plant has three teams of employees. Information on what each team can make, and the time needed (in hours) to manufacturer a vehicle are in Table 1 below. For example, Team 1 can make sedans and cruisers but not trucks. Team 2 can manufacture trucks and cruisers but not sedans. Team 3 can only make trucks. Table 2 displays other operational information for Zippy Motors. Zippy needs to produce at least 10,000 Z1 electric sedans to fill a standing order. How can Zippy Motors maximize profit? Use Excel's simplex LP solver. Team/Vehicle Team 1 Table 1 Z1 electric sedan Zip electric truck 19 can't make can't make 21.5 can't make 22 Team 2 Zippy electric cruiser 18.5 17.5 can't make Team 3 Operations Hours available Contribution margin Demand Table 2 Z1 electric sedan Zip electric truck 400,000 300,000 $15,000 $18,000 25,000 22,500 Zippy electric cruiser 200,000 $15,500 15,000