Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please solve this in excel and show all the formulas!! please help me as soon as possible! thankyou very much!!!!! 4. 10 Zippy Motors has
please solve this in excel and show all the formulas!! please help me as soon as possible! thankyou very much!!!!!
4. 10 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 Zippy electric cruiser 18.5 17.5 Team 2 Team 3 can't make 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,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started