Question: please answer question asap thank you so much Problems: A scooter store stocks three types of scooters. The owner of the store would like to

please answer question asap thank you so much
please answer question asap thank you so much
please answer question asap thank you so much
please answer question asap thank you so much
Problems: A scooter store stocks three types of scooters. The owner of the store would like to determine the optimal number of scooters of each type to purchase. The cost of model A is $300, model B costs $200, and model C costs $200. The owner sells model A for $800, model B for $500, and model C for $400. The owner has $10,000 available this month to purchase scooters. Each scooter must be assembled; a model A requires 240 minutes to assemble, a model B requires 480 minutes, and a C requires 720 minutes. He estimates that his employees have 400 hours available to assemble scooters. He has enough space to store 30 scooters Based on past sales, the owner needs to stock at least twice as many models C as the other two combined because they sell better. The model was recently solved using Excel, and the following report was generated. Adjustable Cells Cell $B$12 $B$13 $B$14 Name Model A Model B 130 Final Value 10 0 20 Reduced Cost 0 -200 0 Objective Allowable Coefficient Increase 500 300 200 1E+30 200 300 Allowable Allowable Decrease 200 1E+30 450 Allowable Constraints Name Cell $F$7 Budget ($) Usage $F$8 $F$6 Storage space (scooters) Usage Assembly time (hr) Usage Final Vale 7000 30 280 Shadow Price 0 300 0 Constraint R.H. Side 10000 30 400 Allowable Increase IB+30 12.86 18+30 Allowable Decrease 3000 30 120 Use the information included in the Sensitivity Report presented above to answer the following four questions/problems. 1) What is the optimal number of scooters of each type to purchase, and what is the resulting optimal profit? (4pts.) 2) Should the owner try to increase the budget for purchasing scooters, get more storage space or get additional labor hours to assemble scooters? Briefly explain why. (4pts.) 3) If the owner could hire an additional worker for 30 hours at $12/hr, should he hire the worker? Briefly explain why. (4pts.) 4) If the owner could now purchase Model B for $150 and sell it for $550, would this affect the optimal solution? Briefly explain why. (4pts.) -pears preachi ave to answer the following four questions/problems. 1) What is the optimal number of scooters of each type to purchase, and what is the resulting optimal profit? (4pts.) 2) Should the owner try to increase the budget for purchasing scooters, get more storage space or get additional labor hours to assemble scooters? Briefly explain why. (4pts.) 3) If the owner could hire an additional worker for 30 hours at $12/hr, should he hire the worker? Briefly explain why. (4pts.) 4) If the owner could now purchase Model B for $150 and sell it for $550, would this affect the optimal solution? Briefly explain why. (4pts.) Bonus! Global Awareness(!) Question: 5) Founded in the city of Buenos Aires on April 3 1905, this team has won a total of 69 official titles, making it the most successful soccer FOOTBALL! club in Argentina and one of the most successful clubs in the world

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!