Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting A Global Perspective

Authors: Rod Monger

1st Edition

0470518405, 978-0470518403

More Books

Students also viewed these Accounting questions