Project #94388 - Aggregate Planning Assignment (EXCEL)

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:
Month Demand (Thousands)
January 1100
February 1200
March 1050
April 1200
May 1400
June 1200
July 1000
August 800
September 1200
October 1600
November 1800
December 1300
 
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?

Subject Business
Due By (Pacific Time) 11/21/2015 12:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy