NEED HELP ASAP, please do in excel and do it step by step.
I will rate if you do all of it!
The Sinith thanufacturing ootspaty has citimated the follow ong couponenta for a new product Foted cost = $47,500 Maxnrial cost per tunit w 5327 Lakor cost por unit =52.55 Price per unit =51.87 a. Implement am Excel preadabce model to show the reculting frofir if the company decides to make 20 , 000 units of the new protuet? Nampe thu aheet at "itaric Model: [20] b. Lithel and color the parmeneters, decinion variable, and the objective function as discuesed an clasa. Your model layout ahould be neat ar discussed [to] 2. At what production volume doen the breakeven occur? Show your anwer a the spreadsheet. [S] frodactson volume fromi 5,000 to 50,000 in increments of 5,000 . Name thas ihret "Ooe-Way Analysia." [5] e Construci a two-way dats table to show how the profit channes its a function of different production volumet and ditterent valuet of iaiterial cost per unit. Vary the pruduction volume from 5,000 to 50,000 in merentents of 5,000 . Vary materal conts from 52.70 to 53.70 an increments of 50 . to. [10] Fired cont =577500 Materal cont per unit -53.27 T.sbor aout per tinit =$2.55 Price per uait =57k7 ? Modet [20] groduction volume frem 5,000 to 50,000 in incrersentr of 5,000 Nhme thax theet One. Why Anslysite [5] froduction selume from 5.000 to 50000 in increnuent of 5.000 . Viry matrial conte frem 52.70 to 5.70 in incrementa of 50 to. [10] The Sinith thanufacturing ootspaty has citimated the follow ong couponenta for a new product Foted cost = $47,500 Maxnrial cost per tunit w 5327 Lakor cost por unit =52.55 Price per unit =51.87 a. Implement am Excel preadabce model to show the reculting frofir if the company decides to make 20 , 000 units of the new protuet? Nampe thu aheet at "itaric Model: [20] b. Lithel and color the parmeneters, decinion variable, and the objective function as discuesed an clasa. Your model layout ahould be neat ar discussed [to] 2. At what production volume doen the breakeven occur? Show your anwer a the spreadsheet. [S] frodactson volume fromi 5,000 to 50,000 in increments of 5,000 . Name thas ihret "Ooe-Way Analysia." [5] e Construci a two-way dats table to show how the profit channes its a function of different production volumet and ditterent valuet of iaiterial cost per unit. Vary the pruduction volume from 5,000 to 50,000 in merentents of 5,000 . Vary materal conts from 52.70 to 53.70 an increments of 50 . to. [10] Fired cont =577500 Materal cont per unit -53.27 T.sbor aout per tinit =$2.55 Price per uait =57k7 ? Modet [20] groduction volume frem 5,000 to 50,000 in incrersentr of 5,000 Nhme thax theet One. Why Anslysite [5] froduction selume from 5.000 to 50000 in increnuent of 5.000 . Viry matrial conte frem 52.70 to 5.70 in incrementa of 50 to. [10]
