Question

Razor Zoomer 3 Bikes Produced Unit Profit 240 $70 420 Total Profit $40 Requirements Polymer Production lime Total Production Product Mix Used Available 900 2400 660 900 2400 700 300 9 10 80

Decision Variable Cells Final Reduced Objective Allowable Allowable Value Cell SC$5 SD$5 Name Bikes Produced Razor Bikes Produced Zoomer Cost Coefficient Increase Decrease 240 420 70 10.00000013 40.00000006 40 53.33333342 5.000000063 Constraints Final Shadow Constraint Allowable Allowable Price R.H. Side Increase Cell SE$9 SE$10 Production Time Used SE$11 Total Production Used SE$12 Product Mix Used Value Name r Used 900 2400 32 2 900 2400 700 300 200 200 1E+30 1E+30 300 800 40 480 180

Max Z=33,600

X1=240

X2=420

Using the solver report and the sensitivity report answer the questions below. Please show your work:

1. Assume that there is a disruption in the supply of polymer. Rather than 900 lbs of polymer, assume the organization only received 700 lbs. What will be the optimal profit?

2. Assume the organization has decided to develop up to 800 bikes, rather than 700. What will the optimal solution change by?


3 0
Add a comment Improve this question Transcribed image text
Answer #1

1)

since shadow price of polymer = 32

hence when polymer decrease by 200 units {900 to 700}

profit will decrease by 200 * 32 = 6400

optimal profit = 33600 - 6400 = 27200

2)

since shadow price of total production used is 0

and allowable increase is infinity

optimal profit will be not change when it is increase from 700 to 800

Please rate

Add a comment
Know the answer?
Add Answer to:
Assume that there is a disruption in the supply of polymer
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and...

    Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed the number of Zoomers by more than 300. Each Razor produced and sold results in a profit of $70 while each Zoomer results in a profit of $40. The bikes are identical mechanically and only differ in...

  • Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and...

    Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed the number of Zoomers by more than 300. Each Razor produced and sold results in a profit of $70 while each Zoomer results in a profit of $40. The bikes are identical mechanically and only differ in...

  • Create a spreadsheet in excel and develop a sensitivity and answer report. Use the sensitivity and...

    Create a spreadsheet in excel and develop a sensitivity and answer report. Use the sensitivity and answer report to answer the questions below. Do not reuse solver. Please show your work and where you get the information: Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed...

  • Create a spreadsheet in excel and develop a sensitivity and answer report. Use the sensitivity and...

    Create a spreadsheet in excel and develop a sensitivity and answer report. Use the sensitivity and answer report to answer the questions below. Do not reuse solver. Please show your work and where you get the information: Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed...

  • 1. COMPUTER PRODUCTION. MVC Enterprises can manufacture four different computer models; the Student, Plus, Net, and...

    1. COMPUTER PRODUCTION. MVC Enterprises can manufacture four different computer models; the Student, Plus, Net, and Pro models. The following gives the configurations of each model Student Celeron 20 gb Plus Pentium 20 gb Net Celeron 20 gb Pro Pentium 30 gb NO YES CD R/W YES DVD DVD + CD R/W Processor Hard Drive Floppy Drives Zip Drive Audio/Video Monitor Case Production Times (hrs.) Unit Profit YES DVD + CD R/W 17" Tower 15" 15 17" Tower Mini-Tower Mini-Tower...

  • Problem 1: Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines):...

    Problem 1: Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed the number of Zoomers by more than 300. Each Razor produced and sold results in a profit of $70 while each Zoomer results in a profit of $A0. The bikes are identical mechanically and only...

  • Help!! - I need excel with formula shown 1) Sungram, an active lifestyle company, manufactures three models of novel fitness trackers called Jump (J), Run (R), and Walk (W). They have a limited supply...

    Help!! - I need excel with formula shown 1) Sungram, an active lifestyle company, manufactures three models of novel fitness trackers called Jump (J), Run (R), and Walk (W). They have a limited supply of common parts---wifi module (450 in inventory), cellular module (250 in inventory), heart rate monitor (800 in inventory), GPS module (450 in inventory), LCD screen (600 in inventory)---that these products use. A Jump model requires a wifi module, 2 heart rate monitors, a GPS module, and...

  • MY QUESTION IS : Prepare a short technical report on the above problem. PLEASE HELP i....

    MY QUESTION IS : Prepare a short technical report on the above problem. PLEASE HELP i. What is the impact on profit of a change in the supply of nonelectronic components? ii. What is the impact on profit if we could increase the supply of electronic components by 400 units (to a total of 5,100)? iii. In the previous question what would happen, if we could increase the supply of electronic components by 4,000 units (to a total of 8,700...

  • Make journal entries for the following and assume transactions up to November 30 have been correctly...

    Make journal entries for the following and assume transactions up to November 30 have been correctly recorded!!! On February 3, 2017, FCM signed an agreement with Deion Sanders to provide media consulting for his football camp. On December 1, FCM completed some of the work for Sanders, and issued an invoice for $15,000. Full payment was received on January 15, 2018. Note: the project did not involve video production. On December 1, to prepare for expansion, FCM issued 1,000 shares...

  • I had a question about Step 5-9. I already completed the general journal with the entries...

    I had a question about Step 5-9. I already completed the general journal with the entries into the general ledger. Now I need help creating the adjusted trial balance, I cant get it to equal to $20,743. Also, I need help completing the financial statements: income statements, statement of owners equity, and a balance sheet. *Net Income has to equal $1024 and total assets has to equal $18,354. The question is how can I balance out my adjusted trial balance...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT