Question: please show work and please dont make it confusing Problem 1. (Chapter 3 Aggregate Planning) Skycell, a major European cell phone manufacturer, is making production

please show work and please dont make it confusing
please show work and please dont make it confusing Problem 1. (Chapter
3 Aggregate Planning) Skycell, a major European cell phone manufacturer, is making
production plans for the coming year. Skycell has worked with its customers

Problem 1. (Chapter 3 Aggregate Planning) 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 the Table below, such as demand in Jan. is 1,000,000 units. Table: Monthly Demand for Cell Phones in Thousands 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 30 curos per hour and a 50 percent premium for overtime. The plant currently employs 1,500 workers. Component costs for each cell phone total 25 euros. Given the rapid decline in component and finished-product prices, carrying inventory from one month to the next incurs a cost of 4 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 employec. Assume that Skycell has a starting inventory of 50,000 units and wants to end the year with the same level of inventory. Assuming no backlogs, no subcontracting, and no new hires. Please construct an aggregate planning model. (Constructing an aggregate planning model means defining the decision variables and writing out the objective function and the constraints for the AP optimization problem. Using Excel to solve aggregate planning model is not required.) Hint (This problem is similar to the Red Tomato example in Chapter 3, Slides 19-25): - You might want to use SOME of the following decision/planning variables for this problem: Ht=# of workers hired in month t(t=1,.,12) L1= \# of workers laid-off in month t(t=1,,12) Wt= \# of workers employed in month t(t=1,,12) Ot= \# of hours of overtime in month t(t=1,.,12) It=# of units (000s) held in inventory at the end of month t(t=1,,12) C1= \# of units (000s) subcontracted in month t(t=1,..,12) Pt=# of units (000s) produced in month t(t=1,.,12)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!