a)
Level Strategy
EXCEL FORMULAS:
Cell | Formula | Copy to |
C6 | =C3-SUM(C4:C5) | C6:J6 |
C7 | =480*C9-C4 | C7:J7 |
C8 | =120*C9-C5 | C8:J8 |
C9 | =B9+C10-C11 | C9:J9 |
K3 | =SUM(C3:J3) | K3:K11 |
M5 | =K5*L5 | M5:M11 |
M14 | =SUM(M3:M11) |
---------------------------------------------------------
b)
Chase strategy
---------------------------------------------------------
c)
Monthly demand given in the beginning of the question is different than the demand in the table in part (c)
Cost of plan is shown for both demands
Based on demand in beginning of the question:
Based on demand in part (c):
Bob Carlton's golf camp estimates the following workforce requirements for its services over the next two...
Tim Booker's tennis camp estimates the workforce requirements for its services over the next two years in the accompanying table. Quarter 1 2 3 4 5 6 7 8 Demand(hours) 4,200 6,400 3,000 4,800 4,400 6,240 3,600 4,800 Each certified instructor puts in 480 hours per quarter regular time and can work an additional 120 hours overtime. Regular-time wages and benefits cost Booker $ 7,200 per employee per quarter for regular time worked up to 480 hours, with an overtime...
Each certified instructor puts in 480 hours per quarter regular time and can work an additional 120 hours overtime. Regular-time wages and benefits cost Carlton $7,200 per employee per quarter for regular time worked up to 480 hours, with an overtime cost of $20 per hour. Unused regular time for certified instructors is paid at $15 per hour. There is no cost for unused overtime capacity The cost of hiring, training, and certifying a new employee is $10,000. Layoff costs...
#8 7. Suppose that Sam's Cat Hotel in the problem above uses a P system instead of a system. The average daily demand is d = 96/6 = 16 bags, and the standard deviation of daily demand is 0, od = 16 = To = 6.142 bags "week_15 a. What P (in working days) and T should be used to approximate the cost trade-offs of the EOQ? b. How much more safety stock is needed with a P system than...
Find a level workforce plan that relies just on overtime and the minimum amount of undertime possible. Overtime can be used to its limits in any quarter. What is the total cost of the plan? $954200 (Enter your response as an integer.) How many undertime hours does it call for? 21500 hours. (Enter your response as an integer.) b. Use a chase strategy that varies the workforce level without using overtime or undertime. What is the total cost of this...
The Barberton Municipal division of Road Maintenance is charged with road repair in the city of Barberton and the surrounding area. Cindy Kramer, road maintenance director, must submit a staffing plan for the next year based on a set schedule for repairs and on the city budget. Kramer estimates that the labor hours required for the next four quarters are 7,000, 13,000, 19,000, and 10,000, respectively. Each of the 11 workers on the workforce can contribute 500 hours per quarter....
The Barberton Municipal division of Road Maintenance is charged with road repair in the city of Barberton and the sumounding area. Cindy Kramer, road maintenance director, must submit a staffing plan for Kramer estimates that the labor hours required for the next four quarters are 6,000, 12.000. 20,000, and 9.000 the 11 workers on the workforce can contribute 500 hours per quarter. Payroll costs are $6,000 in wages per worker for regular time worked up to 500 hours, with an...
02 Consuelo Chua, Inc., is a disk drive manufacturer in need of an aggregate plan for July through December. The com- pany has gathered the following data: COSTS Holding cost $8/disk/month Subcontracting 580/disk Regular-time labor $12 hour Overtime labor $18 hour for hours above 8 hours/workerday Hiring cost $4000/ worker Layoff cost $8000/worker DEMAND Note: In this problem (and Q3) the production cost should be computed based on the labor cost OTHER DATA Current worden 8 people Labor hours disk...
Plan production for the next year. The demand forecast is: spring, 19,500; summer, 9,400; fall, 15,000; winter, 18,800. At the beginning of spring, you have 66 workers and 990 units in inventory. The union contract specifies that you may lay off workers only once a year, at the beginning of summer. Also, you may hire new workers only at the end of summer to begin regular work in the fall. The number of workers laid off at the beginning of...
USE LEVEL AGGREGATE PLAN: Cost data Regular time labor cost per hour $10 Overtime time labor cost per hour $15 Subcontracting cost per unit $80 Back order cost per unit per period $20 Inventory holding cost per unit per period $10 Hiring cost per employee $400 Firing cost per employee $500 Capacity data Beginning workforce 40 employees Beginning inventory 0 units Beginning backorders 0 units Production standard per unit (hours) 2 hours of labor per unit Regular time available per...
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1.400 May 2,100 2,300 February March 1,700 June 1.800 July 1,700 April 1.800 August 1,400 considering a new plan, which beains in January with 200 units inventory on hand. Stockout cost of lost sales is S70 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. Evaluate the Her operations managen following plan. This...