please show the solution with the steps and excel module

Exercise #1 a. b. c. d

1. Skycelt, a - a ajor European cell plaone manufacturer, is making paduction plans for the coming year, Sky cell has worked with its cistomers (the service providers) to come up with 10 minutes Workers are paid 20 curos per bouk and o 50 perteent premium for overtime. The plant currently employs if. shown in Table $10. Mariuffeturing is primarily an assembly operation. and capacity is governed by the number of peoplo on the 1,250 worker Component eosts for each cell phone 10tal 20 curos. Given the rapid decline in component and finished produet prices. carryiong inyentory from one month to the next incurs a cost of 3 curos per phone per month. Skycell carrently hats a no-layoff policy in place Qvertime is limited to a maximum of 20 hours per month per empioy ce. Assume that Skyeell has A starting inventory of 50,000 voits and wants 10 end the year with the same level of inventory. 4. Assuming no backlogs no sabcontmacting, and nio new hinss. What is the uptitntim production schedule? What is the annual exst of this schedule? b. Is there any value for management to negotiate an increase of allowed overtime per eruployee per month from 20 hours to 40 ? c. Reconsider parts (a) and (b) it Skyeell starts with only 1.200 employess. Reconsider parts (a) and (b) if styeell starts with 1,300 employees. What himpens to the value of additinitil overtime as the workfores size decreless? d. Consider part (at) for the tase in which Shysell aims for a. level production schedule sueh that the guantity produeed each month lwes not exceed the iNerage demand over the neat 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 xalue of overtime flextibility