Global Manufacturing, Inc. currently begins each sales cycle with 294,900 units in stock. This stock is depleted at the end of each sales cyde and then reordered. The firm currently places 14 orders per year The carrying cost per unit is $2.009 per year and the fixed order cost is $13,850 per order. Assuming there is no shortage cost for this firm. The average cost of each unit of Inventory is $58.17. 4 5 6 7 8 9 DATA INPUT Beginning inventory Ending Inventory #Orders per year Carrying cost/ unit Fixed order costo Average Inventory cost per unit 294,900 units O units 14 orders $2.009 per year $13,850 per order $58.17 per unit 10 11 12 NOTE: Cells shaded In YELLOW are the cells you must provide the calculations or analysis 13 Always use cell reference for all calculations. 14 $0 (a) What is the total carrying cost? (Round to the nearest wholu dollar. (0.9. 1,2361) $0 (b) What is the restocking cost? (Round to the nearest whicle dollar. (0.9. 1,2,341) $0 (c) What is the total cost of current inventory policy? (Round to the careat whole dollar loo 1.234) (d) Calculate the economic order quantity. Round your answer to the nearest whole bomber of units 9. 1.2341 le) Calculate the number of orders per year that would be required if the EOQ Inventory Polley were CAL DATA COMMONS 2020 COMMON SIZE 2021 CHANGE RATIOS 2020 RATIOS 2001 EVALUATION OF FINDING Always use cell reference for all calculations. (a) What is the total carrying cost? (Round to the nearest whole dollar. (0.9. 1,2341) SO (b) What is the restocking cost? (Round to the nearest whole dollar. (0.9., 1.234)) SO (c) What is the total cost of current inventory policy? (Round to the nearest whole dodlar (eg. 7,234)) 50 7 (a) Calculate the economic order quantity. (Round your answer to the nearest whole number of unts (0.9. 1.230) 0 18 (6) Calculate the number of orders per year that would be required if the EOQ Inventory Policy were Implemented. (Round your answer to 2 decimal pinons, ( 32.16) 0.00 What would the COQ Inventory Balance (in dollars) be in 2022 If the firm switched to the EOQ Inventory Policy? (Do not include the dollar sign (5) Round to the nearest whole dolor, le 9. 1234) This value will automatically Sonvanfory value on your PRG worksheet =E0Q units per order x Average Inventory value per unit 35 26 27 30