Global Manufacturing, Inc. currently begins each sales cycle with 294,900 units in stock. This stock is depleted at the end of each sales cycle 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 $12,850 per order. Assuming there is no shortage cost for this firm. The E4average cost of each unit of inventory is $58.17. ALWAYS USE CELL REFERENCES to the correct values on your worksheets to do your calculations. NOTE: Cells shaded in YELLOW are the cells you must provide the calculations or analysis. 14 [a] What is the Total Carrying Cost? [Round to the nearest whole dollar. [e. $0 (b) What is the Restocking Cost? [Round to the nearest whole dollar. [e.g. $0 [c] What is the Total Cost of current inventory policy? [Round to the $0 17 nearest whole dollar. [e.g. 1,234]] (d) Calculate the Economic Order Quantity (EOQ). [Round your answer to the nearest whole number of units. [e.g. 1,234]] [e] Calculate the Number of Orders per year that would be required if the EQQ Inventory Policy were implemented. [Round your answer to 2 decimal places. [e.g. 32.16]] These last two calculations are not in Practice Problem 28-12. [f] What would the EOQ Inventory Balance //b//B/ be in the new year if Global switched to the EQQ Inventory Policy? [Do not include the dollar sign [\$]. Round to the nearest whole dollar. [e.g. 1,234] (g) What would the Inventory Turnover ratio be if Global Manufacturing adopted the EOQ Inventory Balance in 2022? [Round your answer to 2 decimal places. [e.g. 32.16]] Global Manufacturing, Inc. currently begins each sales cycle with 294,900 units in stock. This stock is depleted at the end of each sales cycle 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 $12,850 per order. Assuming there is no shortage cost for this firm. The E4average cost of each unit of inventory is $58.17. ALWAYS USE CELL REFERENCES to the correct values on your worksheets to do your calculations. NOTE: Cells shaded in YELLOW are the cells you must provide the calculations or analysis. 14 [a] What is the Total Carrying Cost? [Round to the nearest whole dollar. [e. $0 (b) What is the Restocking Cost? [Round to the nearest whole dollar. [e.g. $0 [c] What is the Total Cost of current inventory policy? [Round to the $0 17 nearest whole dollar. [e.g. 1,234]] (d) Calculate the Economic Order Quantity (EOQ). [Round your answer to the nearest whole number of units. [e.g. 1,234]] [e] Calculate the Number of Orders per year that would be required if the EQQ Inventory Policy were implemented. [Round your answer to 2 decimal places. [e.g. 32.16]] These last two calculations are not in Practice Problem 28-12. [f] What would the EOQ Inventory Balance //b//B/ be in the new year if Global switched to the EQQ Inventory Policy? [Do not include the dollar sign [\$]. Round to the nearest whole dollar. [e.g. 1,234] (g) What would the Inventory Turnover ratio be if Global Manufacturing adopted the EOQ Inventory Balance in 2022? [Round your answer to 2 decimal places. [e.g. 32.16]]
