(Bid with 5 hours)

Anonymous
timer Asked: Nov 18th, 2016

Question description

Please create the following Excel solution and answer in text boxes inside Excel.

Jordan Enterprises is the largest maker and distributor of smartphones in the world, and is planning its production for next year. Jordan's monthly demand forecasts are shown in the following table:

SEE ATTACHED FILE

Jordan's production is hand-assembly, which is labor intensive, and represents the largest limiting factor in its production capacity. Component costs for each smartphone are $20 per unit. The facility works 8 hours per day, 20 days per month. Each worker can assemble a smartphone in 12 minutes, on average, and are paid $25 per hour, with the usual time-and-a-half pay for overtime work. Jordan currently employs 1,500 production workers.

Jordan's inventory holding costs are $5 per smartphone per month, and is starting off with an inventory of 50,000 smartphones, which is what the ending inventory must be as well. Overtime cannot exceed 20 hours per month per employee, and there is a policy that there can be no layoffs of employees.

1. What is the optimum production schedule, if we assume that there can be no hires, no backlogs, and no subcontracting? What is the cost of this schedule?

2. Does it help with the schedule in question 1 above if we increase the overtime limit to 35 hours per employee per month?

3. Reconsider #s 1 and 2 assuming that Jordan starts with only 1350 employees. What about 1200 employees? Does the addition of more overtime become important if we decreases the workforce?

4. Reconsider #1 assuming a "level" approach to scheduling production. In this approach, the quantity produced must not exceed the average demand by more than 50,000 units. What is the cost of this approach compared to the "chase" approach used in #1? Does overtime become important here?

Please create the following Excel solution and answer in text boxes inside Excel. Along with instructions on how the proble completed. Jordan Enterprises is the largest maker and distributor of smartphones in the world, and is planning its production for next ye monthly demand forecasts are shown in the following table: Month January February March April May June July August September October November December Demand (Thousands) 1100 1200 1050 1200 1400 1200 1000 800 1200 1600 1800 1300 Jordan's production is hand-assembly, which is labor intensive, and represents the largest limiting factor in its production cap Component costs for each smartphone are $20 per unit. The facility works 8 hours per day, 20 days per month. Each worker c assemble a smartphone in 12 minutes, on average, and are paid $25 per hour, with the usual time-and-a-half pay for overtim Jordan currently employs 1,500 production workers. Jordan's inventory holding costs are $5 per smartphone per month, and is starting off with an inventory of 50,000 smartphon what the ending inventory must be as well. Overtime cannot exceed 20 hours per month per employee, and there is a policy can be no layoffs of employees. Questions on tabs are based on the above question. nside Excel. Along with instructions on how the problem is s in the world, and is planning its production for next year. Jordan's Component Cost Per Unit Working Hours Working Days Smartphone Assemble Time Per hours Rate Total Worker 20$ 8 20 12 25$ 1500 presents the largest limiting factor in its production capacity. works 8 hours per day, 20 days per month. Each worker can per hour, with the usual time-and-a-half pay for overtime work. nd is starting off with an inventory of 50,000 smartphones, which is 20 hours per month per employee, and there is a policy that there Q1. What is the optimum production schedule, if we assume that there can be no hires, no backlogs, and no subcontracting? What is the cost of this schedule? Q2. Does it help with the schedule in question 1 above if we increase the overtime limit to 35 hours per employ ime limit to 35 hours per employee per month? Q3. Reconsider #s 1 and 2 assuming that Jordan starts with only 1350 employees. What about 1200 employees? Does the addition of more overtime become important if we decrease the workforce? es. What about 1200 employees? kforce? Q4. Reconsider #1 assuming a "level" approach to scheduling production. In this approach, the qauantity produ the average demand by more than 50,000 units. What is the cost of this approach compared to the "chase" app this overtime become important here? is approach, the qauantity produced must not exceed ach compared to the "chase" approach used in #1? Does

Tutor Answer

(Top Tutor) Studypool Tutor
School: UIUC
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors