9 1 Forecasting Planning 2 INDUSTRIAL TOOLS DIVISION 3 4. Instructions: Complete the yellow shaded table. Calculate forecasted demand given the information you have? Recognize the high 5 and low volume of demand. What would you propose for inventory levels on an aggregate and segment basis needed to meet 6 forcasted customer demand? 7 8 By Segment 9 Total Quantity (ea) Wood Plastic Paper Steel Roofing Agriculture 10 Forecasted Demand (Annual) 11 Highest Volume in Period 12 Lowest Volume in Period 13 Proposed Inventory Level 14 15 Previous Year Consumption. No forecast. By Segment 16 Month Total Quantity (ea) Wood Plastic Paper Steel Roofing Agriculture 17 January 16,000 2,000 8,000 3,500 1,000 1,000 500 18 February 30,000 7,000 11,000 6,500 2,000 2,500 1,000 19 March 32,000 8,500 9,000 7,500 1,500 3,000 2,500 20 April 38,000 12,000 10,000 8,000 1,500 3,500 3,000 21 May 40,000 13,000 9,500 8,500 1,000 5,500 2,500 22 June 34,000 12,500 8,000 7,000 2,000 3,000 1,500 23 July 30,000 11,000 9,000 5,000 1,500 2,500 1,000 24 August 27,000 10,000 10,000 3,000 500 2,000 1,500 25 September 25,000 8,000 7,500 4,000 1,500 1,500 2,500 26 October 22,000 7,000 5,000 5,500 1,000 2,000 1,500 27 November 21,000 5,000 5,500 6,500 1,500 500 2,000 28 December 18,000 4,000 3,500 6,000 2,000 1,000 1,500 9 1 Forecasting Planning 2 INDUSTRIAL TOOLS DIVISION 3 4. Instructions: Complete the yellow shaded table. Calculate forecasted demand given the information you have? Recognize the high 5 and low volume of demand. What would you propose for inventory levels on an aggregate and segment basis needed to meet 6 forcasted customer demand? 7 8 By Segment 9 Total Quantity (ea) Wood Plastic Paper Steel Roofing Agriculture 10 Forecasted Demand (Annual) 11 Highest Volume in Period 12 Lowest Volume in Period 13 Proposed Inventory Level 14 15 Previous Year Consumption. No forecast. By Segment 16 Month Total Quantity (ea) Wood Plastic Paper Steel Roofing Agriculture 17 January 16,000 2,000 8,000 3,500 1,000 1,000 500 18 February 30,000 7,000 11,000 6,500 2,000 2,500 1,000 19 March 32,000 8,500 9,000 7,500 1,500 3,000 2,500 20 April 38,000 12,000 10,000 8,000 1,500 3,500 3,000 21 May 40,000 13,000 9,500 8,500 1,000 5,500 2,500 22 June 34,000 12,500 8,000 7,000 2,000 3,000 1,500 23 July 30,000 11,000 9,000 5,000 1,500 2,500 1,000 24 August 27,000 10,000 10,000 3,000 500 2,000 1,500 25 September 25,000 8,000 7,500 4,000 1,500 1,500 2,500 26 October 22,000 7,000 5,000 5,500 1,000 2,000 1,500 27 November 21,000 5,000 5,500 6,500 1,500 500 2,000 28 December 18,000 4,000 3,500 6,000 2,000 1,000 1,500