sales and operations planning

aggregate planning

B F G U H . J 3 Chapter 10: Sales & Operations Planning (Aggregate Planning) 4 5 6 DIRECTIONS To generate the key, plug in your 4-digit number used to create the original homework set. Name: KEY *** 4-digit number: 9999 OD NOW 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Pennsylvania Replicas makes two types of traditional Shaker tables: The Simplicity and the Workman. The two lines are made in the same facility using the same labor and equipment. In addition, we know that: Each Simplicity and Workman table requires, on average, about 3.2 hours of labor. . Each employee works 160 hours per month, and there is no effective limit on the number of employees The cost of hiring or firing an employee is $900 The monthly holding cost for a table is $9.50 For planning purposes, the beginning and ending workforce is 35 employees . At the beginning of the planning period, there are 0 units in inventory Simplicity Workman Month Demand Demand November 750 6750 December 875 7875 January 1000 9000 February 1000 9000 March 1250 11250 April 1250 11250 May 1500 13500 June 1500 13500 July 1625 14625 August 1750 15750 Problem 1 Develop a level S&OP for November - August Show aggregated monthly production, workforce and ending inventory levels; monthly hirings and firings, and total hiring, firing, and inventory costs. To keep it simple, assume you can have fractional units in inventory, and that you can hire / fire fractional numbers of employees (ex. - 25.5 employees)