Use Excell please.

Skycell, a major European cell phone manufacturer, is making phone total 20 euros. Given the rapid decline in component production plans for the coming year. Skycell has worked and finished-product prices, carrying inventory from one with its customers (the service providers) to come up with month to the next incurs a cost of 3 euros per phone per forecasts of monthly requirements (in thousands of phones) as month. Skycell currently has a no-layoff policy in place. shown in Table Overtime is limited to a maximum of 20 hours per month Manufacturing is primarily an assembly operation, per employee. Assume that Skycell has a starting inventory and capacity is governed by the number of people on the of 50,000 units and wants to end the year with the same production line. The plant operates for 20 days a month, level of inventory. eight hours each day. One person can assemble a phone a. Assuming no backlogs, no subcontracting, and no new every 10 minutes. Workers are paid 20 euros per hour and hires, what is the optimum production schedule? What is a 50 percent premium for overtime. The plant currently employs 1,250 workers. Component costs for each cell b. Is there any value for management to negotiate an increase of allowed overtime per employee per month from 20 hours to 40 ? c. Reconsider parts (a) and (b) if Skycell starts with only 1,200 employees. Reconsider parts (a) and (b) if 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, monthly 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