A SOP data given in the Excel file. By reading following information, answer appropriately to the questions
a) For the data that you have, provide both level and chase. Discuss the main characteristics of these two plans in contrast with each other. Between these two plans,
which plan would you recommend the company to choose? Explain about the answers. (Find productivity first. Do not round down or up number of employees and other
numbers) 

b) Board of organization in SBP level has decided to rearrange the demands in level strategy answer in part (a). In this case they want to change the demand of March and
April with May and June respectively. Explain about the following question and convince your answers:
1- What is the new number employee needed? 
2- what is/are the new characteristics that the organization will face? What is/are your suggestion to solve this problem(s)? Negative inventory. Solutions:
3- What is the total cost of the plan?  

 

SALES Forecast Actual OPERATIONS Plan Employees used Capacity Working days/ month Actual INVENTORY Plan Actual Days supply (1000 $) Daily Wage Unit price= (units) (missing/excess) (1000 $) Employee Productivity Hiring cost Layoff cost Inv carrying cost Backlogging cost Min inventory level Beginning labour force $ 212 42 $ $ $ $ HISTORY December 4 per month 7.0 per month o days 50 employees $ Hires Layoffs 399 $ 9500 8600 9500 50 9500 19 9900 ? units/day 400 per employee COSTS: 800 Hires Layoffs Inventory Backorder 1300 0 3.3 Labour Cost January $ $ $ S 353 $ 8400 - PLAN February March 21 $ $ $ S 382 $ 9100 - 20 $ S $ $ April 388 $ 9240 23 $ $ $ S May 344 $ 8200 20 $ $ $ $ S 323 $ 7700 - June 22 $ S $ $ S 429 $ 10220 - 22 January $ $ $ 420 10000 Tot Cost $ $ $ 20 Excluding Labour Including Labour.