please if you can do it thru excel and show the formulas you used to get it the answers

Home Baseball card emporium students temples Compatibility Mode] Insert Page Layout Formules Data Review View Garamond 12 - AA- Cut Le Copy Format Paste Harpa BT NU U HA Merge 5 CF Foming ent Omce Update Top-to-date with security updates and improvements, choose Check for Updates F22 x E A c D 1 CASE 9-2: BASEBALL CARD EMPORIUM 2 3 DATA 4 R 7.000 units Annual demand, cases of cards 5 V $ 96 Case Value Price 6 W 30% Inventory carrying cost 7 A 75 Cost per Order to replenish inventory 8 Y 18% In Transit inventory carrying out 9 Motor transit time (MTT) 4 Transit Time using motor carrier 10 Motorcycle time (MCT) 7 days Cycle Time ering motor camer 11 Air transit time (ATT) 1 days Transit Time using at camer 12 Air cycle time (ACT) 2 days Cycle time using alt camer 13 Freight Motor 1.20 per unit Motor camernite per cwt (100 lbs.) 14 Freight Ait $ 2.50 per unit Air camernte per cwt (100 lbs.) 15 Weight 50 pounds Unnit Weight per case 18 S-VW $ 29 Inventory carrying cost per unit per year (per unit per year) 17 Motor cwt 0.60 18 Air cwt 365 19 Days per year 20 Order Cycle (OC) 10 days Days per year/R 21 22 QUESTION 1: EOQ for Nittany Fans in units? In pounds? 2R 23 Q-SQRT (2RA/VW) LIPE 24 190.94 units 25 Q- 26 Q 27 28 QUESTION 2: Total Cost (not considering transportation-related costs of the EOQ 29 Shad Sold DARE 1.25 pounds R TAC 10vw+12 Numer lo S - % Garamond - 12 A A Copy Wrap Ten Paste Format B U. Marge Center Omice Update To keep up-to-date with security updates, fees, and improvements, choose Chuck for Update F22 4 x x Coretical Porn D E F 27 28 QUESTION 2: Total Cost (not considering transportation-related costs) of the EOQ 29 20 TAC= (4)* QV + AR/Q 31 B2 TAC- TAC c=serw+44 34 QUESTION 3: Total Cost for using motor carrier transportation 35 TIC motor carrier = QVW + AR/Q+(MIT/OC)*QVY 36 TAC motor = TIC Motor + Motor cwt R 87 TIC motor 38 TAC motor 39 O QUESTION 4: Total Cost for using air carrier transportation 1 TIC air = QVW + AR/Q+ (ATT/OC*QVY 2 TAC air = TIC air + Air cwt *R 13 TIC air 14 TAC air 5 6 QUESTION 5: Which alternative should BBE use? #7 8 Please put a check mark in your recommendation 99 Air Carrier 50 Motor Carrier 51 52 53 CASE 9-2 Sheets She