$8888|3888398828$

s unit Unit 7 r unit $125.00 $75.00 $15.00 $30.00 Demand Sales 3 Promus Corp. problem Chapter 13 in textbook); Promus They need to routers to order (O) their supple'S. The routers COSt $75 per unit and 'romus for S12S unm total pmduct by of pumhued product cost the is mrmally With a mean of 106 a a standard d&ation of Sales are minim Lyn of demyd and quantity is by sales times sales pnce es not routers thev mnuS quantity, 'O capture the Of Shortages Shortage COSI iS Shortages the shmage cost pu unit. Likmvi, if too maw/ trey a hoding of order wantity mimos to capture cost of Holdings cannot Holding cost is times the hdding cost per unit Product is pmduct c times cyder quantitw cost s the sum of prod.ct cost. sh"taqe cost. and maldinq cost is revenue mnus total cost As-svwne -hat Promus routers a simuatin a accor&ng to the highllght cells signify area to PLEASE NOTE THAT YOU KILL NEED TO SAVE THE SPREADSHEET OR CLICK 'CALcuLATE ON TAd FOR TO For more gn 'he problem. see Chapter in course textbook. contact the instructor Calculate total product cost b) Create a demarZ variable. Create a sales variable Create Short'ge and COSt variables. Create and holding Cost 'q) Create a total cost Create a profit variable emperitll gtdbabiity that PnuS a Create a data table for mean profit quant.t Is 130 a if *omus to m aimize "fit? or not 29 130 on Trial Uniform Variable for Demand Shortage Shortage Cost listee Holding Holding Cost Revenue Total Cost r Profit Summa Count Minimum Maxi mum Statistics $0 Standard Deviation #DIV/OI #DIV/O!