Assignment 5 - Aggregate planning End of Chapter question Refer to the book to page 229-231 and start your assignment by doing the end of the chapter qurstions I have attached an excel sheet to help you working on your assignment. Refer to the chapter for how to construct the constrains and the cost formulas All groups should work on questions 1. abcd 2. abcd Final work to submit is an excel sheet with questions seperated is different sheets in ONE excel file. File to be submitted by Leaders only. Any member who does not participate shall have a Zero mark. This is a group work and you should gather to solve the questions TOGETHER and brainstom how to tackle such questions. Questions will be asked about the assignment randomly and if any student does not understand the concept of how to construct the excel sheet he will not be granted a mark even if he/as a grouo has submitted a file. Exercises 1. Skycell, a major European cell phone manufacturer, is making production plans for the coming year. Skycell has worked with its customers (the service providers) to come up with forecasts of monthly requirements (in thousands of phones) as shown in Table 8-9. Manufacturing is primarily an assembly operation, and capacity is governed by the number of people on the production line, The plant operates for 20 days a month. eight hours each day. One person can assemble a phone every 10 minutes. Workers are paid 20 euros per hour and a 50 percent premium for overtime. The plant currently employs 1.250 workers, Component costs for each cell phone total 20 euros. Given the rapid decline in component and finished product prices, carrying inventory from one month to the next incurs a cost of 3 euros per phone per month. Skycell currently has a no-layoff policy in place. Overtime is limited to a maximum of 20 hours per month per employee. Assume that Skycell has a starting inventory of 50,000 units and wants to end the year with the same level of inventory 3. Assuming no backlogs, no subcontracting, and no new hires, what is the optimum production schedule? What is the annual cost of this schedule? Table 8-9 Monthly Demand for Cell Phones, in Thousands Month Demand January 1,000 February 1,100 March 1,000 April 1,200 May 1,500 June 1,600 July 1,600 August 900 September 1.100 October 800 November 1,400 December 1,700 Is there any value for management to negotiate an increase of allowed overtime per employee per month from 20 hours to 407 c. Reconsider parts (a) and (b) if Skycell starts with only 1.200 employees. Reconsider parts (a) and (b) ir Skycell starts with 1.300 employees. What happens to the value of additional overtime as the workforce size decreases? d. Consider part (a) for the case in which Skycell aims for a level production schedule such that the quantity produced each month does not exceed the average demand over the next 12 months (1,241,667) by 50,000 units. Thus, month- ly production including overtime should be no more than 1,291,667. What would be the cost of this level production schedule? What is the value of overtime flexibility? 2. Reconsider the Skycell data in Exercise 1. Assume that the plant has 1.250 employees and a no-layoff policy. Overtime is limited to 20 hours per employee per month. A third party has offered to produce cell phones as needed at a cost of $26 per unit (this includes component costs of $20 per unit) a. What is the average per unit of in-house production (including inventory holding and overtime cost) if the third party is not used? . How should Skycell use the third party? How does your answer change if the third party offers a price of $25 per unit? c Should Skycell use the third party if the per unit cost is $28? d. Why would Skycell use the third party even when the per-unit cost of the third party is higher than the average per-unit cost (including inventory holding and overtime) for in-house production? Assignment 5 - Aggregate planning End of Chapter question Refer to the book to page 229-231 and start your assignment by doing the end of the chapter qurstions I have attached an excel sheet to help you working on your assignment. Refer to the chapter for how to construct the constrains and the cost formulas All groups should work on questions 1. abcd 2. abcd Final work to submit is an excel sheet with questions seperated is different sheets in ONE excel file. File to be submitted by Leaders only. Any member who does not participate shall have a Zero mark. This is a group work and you should gather to solve the questions TOGETHER and brainstom how to tackle such questions. Questions will be asked about the assignment randomly and if any student does not understand the concept of how to construct the excel sheet he will not be granted a mark even if he/as a grouo has submitted a file. Exercises 1. Skycell, a major European cell phone manufacturer, is making production plans for the coming year. Skycell has worked with its customers (the service providers) to come up with forecasts of monthly requirements (in thousands of phones) as shown in Table 8-9. Manufacturing is primarily an assembly operation, and capacity is governed by the number of people on the production line, The plant operates for 20 days a month. eight hours each day. One person can assemble a phone every 10 minutes. Workers are paid 20 euros per hour and a 50 percent premium for overtime. The plant currently employs 1.250 workers, Component costs for each cell phone total 20 euros. Given the rapid decline in component and finished product prices, carrying inventory from one month to the next incurs a cost of 3 euros per phone per month. Skycell currently has a no-layoff policy in place. Overtime is limited to a maximum of 20 hours per month per employee. Assume that Skycell has a starting inventory of 50,000 units and wants to end the year with the same level of inventory 3. Assuming no backlogs, no subcontracting, and no new hires, what is the optimum production schedule? What is the annual cost of this schedule? Table 8-9 Monthly Demand for Cell Phones, in Thousands Month Demand January 1,000 February 1,100 March 1,000 April 1,200 May 1,500 June 1,600 July 1,600 August 900 September 1.100 October 800 November 1,400 December 1,700 Is there any value for management to negotiate an increase of allowed overtime per employee per month from 20 hours to 407 c. Reconsider parts (a) and (b) if Skycell starts with only 1.200 employees. Reconsider parts (a) and (b) ir Skycell starts with 1.300 employees. What happens to the value of additional overtime as the workforce size decreases? d. Consider part (a) for the case in which Skycell aims for a level production schedule such that the quantity produced each month does not exceed the average demand over the next 12 months (1,241,667) by 50,000 units. Thus, month- ly production including overtime should be no more than 1,291,667. What would be the cost of this level production schedule? What is the value of overtime flexibility? 2. Reconsider the Skycell data in Exercise 1. Assume that the plant has 1.250 employees and a no-layoff policy. Overtime is limited to 20 hours per employee per month. A third party has offered to produce cell phones as needed at a cost of $26 per unit (this includes component costs of $20 per unit) a. What is the average per unit of in-house production (including inventory holding and overtime cost) if the third party is not used? . How should Skycell use the third party? How does your answer change if the third party offers a price of $25 per unit? c Should Skycell use the third party if the per unit cost is $28? d. Why would Skycell use the third party even when the per-unit cost of the third party is higher than the average per-unit cost (including inventory holding and overtime) for in-house production
