Please help me solve all parts really need help with all of these ASAP. Thank you very much.

MountAi6 Goat CYcRng Company the is th on "s baes ne rqorts thefonouing 72.000 eat* year. 10 16 21 29 30 32 36 37 38 41 42 48 .49 50 52 53 54 56 57 58 59 70 71 76 Dimct meteriels mtect Varieble ove+ead tk ci'1i on e Allocated nenl overseed Total c Tie deciden before ent Pet -51 40 49 000 $ 61 _li S 480 ooo Aas offeed Mountain Goat Oeling ea:g tAe Xtiets intemaUy and hy Part 1 relevm cogs to the deciMon. Piace next atv of thc followi cogs ro the decifon. A11ated t*ral overhead Ihct labor meet matenals 4: Pbiht point' rot Per tot/t purchase PHCC Number of units rotl vov shi en $72 12,000 $864,000 Outsade hae ce tal Ctauon Variable overhead Part 2 anlyds q the relevant cogs identified above. Cell reference relevant cogs to cxnplete table Total cog Part 3 decidon Should Mountain ler? IF statement to anser uestion Part 4 rtunity cost c*ete tke anal)'Hs below rotal cogs @ j 2.000 units nukin or COM di erentia} BUY less MAKE Write an IF uatennt nuke decision i"' cell F54. An IF stutement is simply a test u*ing less than or greater than & signs. In our case, we need to evaluate cell E49 but there are a few ways to think about itmainly, is it positive or negative? Wc say: Excel, LF cell E49 Is positive, return to if it is negative, return How to translate the above statement in Excel language: TEST, Use < or > to tell Excel to testifeeU E49 is either positive ar negative. It doesn't matter which. ay you gowhat matters is the and [value_ifJdseJ. We wouldn'twant Excel to us something that doesn't make sense. Ifthe space now being used to produce the shifter would otherwise be idle, then Mountain Goat should continue to make itsown shifters and the supplier's offer Should be rejected. But, what if the space now being used to make shifters could be used for some other purpose? Assume the space now being used to make shifters could be used to produce anew cross-country bike that would generate a segment rmrgin of $ annually, New scgrnenj margin be Couderin -e idle Total annual COSI earned/ o one on tennal new TOIJI cost 'Differentiai/fiyuxncial adv.ntgge or disadvanta from out4Ag.yopI@gr