B C D E F G H K M 2018 2019 2020 Sales Forecast 2021 Cost per unit 150 max daily August ary 790 853 929 January 1,069 0 Inventory Holding Cost per unit 172.5 150x15% ruary 800 864 944 February 1,086 ch 1,300 1,404 1,544 March 1,776 Z-score 1.35 2,084 1,560 1,685 1,943 April 2,235 Standard Deviation of Demand 785.65 1,620 1,750 2,469 May 2,839 Safety Stock 867 1,970 2,128 2,584 June 2,972 2,140 2,311 2,539 July 2,920 EOQ (Q*) 1,441 ust 2,230 2,408 2,541 August 2,923 Maximum Inventory, (Q* + SS) 2,308 ember 1,560 1,685 2,426 September 2,790 Average Inventory, (Q*/2) 721 ber 1,280 1,382 1,573 October 1,809 Number of Orders 17 ember 1,070 1,156 1,271 November 1,462 Re-order Point 2,922 ember 940 1,015 976 December 1,123 17,260 18,641 21,740 Total 25,004 Total Ordering Cost $16,216 Inventory Carrying Cost Safety Stock Carrying Cost $130,105 heet1 +The Grommet is manufactured in Thailand. Orders take 30 days to arrive via sea freight. With the costs of communications, customs, and freight, each order placed incurs an expenditure of $935. Once the boards arrive at the warehouse, the inventory carrying cost is 15% per year/ per unit of the COGS. Dran Retail 400 COGs is 150 Based on the information provided in this case study, you will create a 2021 inventory plan for Surf Shaper. Using the spreadsheet provided and the formulas you learned and practiced last week: 1. Create a Sales Forecast showing a 15% increase in sales over 2020. 2. Using your 2021 Sales Forecast, determine the amount of Safety Stock Surf Shapers should keep on-hand to meet their service level goal. 3. Utilizing the EOQ method, identify: a. The optimal order quantity (Q*) b. The number of orders to be completed c. The Re-Order Point d. Total ordering cost e. Inventory carrying cost f. Safety Stock Carrying cost g. COGS h. Total Cost of the inventory plan