Just scenario one for this problem.
https://ualearn.blackboard.com/bbcswebdav/pid-41 43293-dt.. Format as Table Homewnrk 2 (20 pts) ront Aligement NumberCell Styles Cells Editing ction 1: Questions N20 You own a Honda car dealersbip I own a nerby Toyota dealership. Each of our inancials sIe shown in tbe table below Purchase Prioe: 5glvage Value $12.000.00S11,C00.00 10,000.00S9,000.00 it Probstil NShurtPrui Purchase Price 6 avage Velun Lct'saling n for 20 ohi rfr Marh 2019niber 219 xt yea dels genally hil the k in Marc:lii. In Jaary 2,ef us aeder can from our rspective mnmfart11rers, nnd this is onIT nnly mportimity to order our 2020 models. 10 Cu 11 Crbal Ratic Erc sboan in the Scenario-1 tab of the filc callod Template-Hu2-Sp19.xlsx, Colums E and F Curs sold (mring the selling slibKIn ar" snld at the prirrs s shimi l the ihmvr: tahle, and all cars not sold during the season are eventually sold at the discounted prices shown in the table. In thr event f shortaps, vr ach ofer stTITs str crrlit of hoping thet w rnn krrp them as customers next year Each vebicle we purchase from our respective manufacturers coets us c as sbown in the table. Tbc questions bclow ask you to find the optimal ordcr quantitics for Ilonda 14 Erpeclad Proft 15 10 00010 18 Tayata 18 and Toyots and their corresponding optimal expected profts for a sew differeat soenarloe. 20 Sslrg Price: [4 pts 1. (Scenario 1): Find tbe optimal order quantities for Horda and Toyota and their optimal 5 pt 2. (Scenario 2): This arsider the spillover demand that Honda gets if Toynta optinal ordrr quntity and xpexted pt g thut euch shorta at Trymta rsts in 22 Bavag Value: 1000 C0 prulits as spillover demand. 28 Cu runs short. Su given lal Tuyula uses e order quantiy ro Queti 1, ee Huda pillver demarid for Heicla Frpeclad Proft 5 (Scenario 3): Qustion 2, hvford that n djusts its rraty because of the spillover demand [i.e.. Honda's order quancity in Queetion 2 should be different ro onda's ordrr quantity in Qcstion 1. This socnario cosiders thr spillover demand that Toyota gets If Honda runs short with Honda using the order quantity fom Question2. So given that onda uscs tbe order quatity from Qucetion 2, detcrminc Toyotes optimal ordcr quantity ad expectei prolit aseuning thhat a each slortage at Houda results in spillover demand 35 for Toyota 5 pts 1. (Scenario 1): Here we go agaln... Houda ls now respouding to Toyota's uew order quaatity fro uTht is, shortages at Thyota again result in spillover demand for Honda, bul with Toyola' urde quaity Iroi QQueslin 3. So given tia Toyola Iie order antity from Qucst3, drterin lond's optimalqntity and exprctrd protit 13 assing that a h shortag at. Tyta nult i spilkr clernncl fcr Hiit. pt. ill in yuur reests ta Questons thromgh 4 in the table sunnnry of the tab rled Sunnary Then in a textbox, identify which (if any) of the ensrios is an equilibrlum solution, and explain why it is an ibrium solution If nome aTc oquibria, cxplain why that is the casr. Sunmary Scenario-1 Scenario-2 Sccnario 3 Scena 4 +
