Question

Problem 11-11 A manager is attempting to put together an aggregate plan for the coming nine...

Problem 11-11

A manager is attempting to put together an aggregate plan for the coming nine months. She has obtained a forecast of expected demand for the planning horizon. The plan must deal with highly seasonal demand; demand is relatively high in periods 3 and 4 and again in period 8, as can be seen from the following forecasts:


    Period 1 2 3 4 5 6 7 8 9 Total
  Forecast 190 230 260 280 210 170 160 260 180 1,940


The department now has 20 full-time employees, each of whom can produce 10 units of output per period at a cost of $8 per unit. Inventory carrying cost is $8 per unit per period, and backlog cost is $10 per unit per period.


Suppose another option is to use part-time workers to assist during seasonal peaks. The cost per unit, including hiring and training, is $12. The output rate is 10 units per worker per period for all workers. A maximum of 10 part-time workers can be used, and the same number of part-time workers must be used in all periods that have part-time workers. The ending inventory in period 9 should be 10 units. The limit on backlogs is 20 units per period. Try to make up backlogs as soon as possible. Compute the total cost for this plan. Assume 20 full-time workers. (Omit the "$" sign in your response.)


  Total cost $   
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Below is the required production plan -

Period 1 2 3 4 5 6 7 8 9 Total Cost per Unit Total Cost
Beginning Inventory 0 10 30 20 0 0 10 50 0
Forecast 190 230 260 280 210 170 160 260 180 1,940
Full Time Production 200 200 200 200 200 200 200 200 200 1,800 8 14400
Part time Production 0 50 50 50 0 0 0 0 0 150 12 1800
Ending Inventory 10 30 20 0 0 10 50 0 10 130 8 1040
Backlog 0 0 0 10 20 0 0 10 0 40 10 400
Total Cost 17640
Add a comment
Know the answer?
Add Answer to:
Problem 11-11 A manager is attempting to put together an aggregate plan for the coming nine...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Given the projected demands for the next six months, prepare an aggregate plan that uses inventor...

    Given the projected demands for the next six months, prepare an aggregate plan that uses inventory, regular time, overtime, subcontract and backorders. Regular time is limited to 150 units per month (Cost per Unit = $30 ). Overtime is limited to a maximum of 20 units per month (Cost per Unit -S45). Units purchased from the subcontractor (Cost per Unit = $54 ) cannot exceed 60 per month and the total purchases from the subcontractor over the 6 month period...

  • sisas (19-21). A manager has prepared a forecast of expected aggregate demand for the nest s perods Develop an aggregate plan to meet this demand given these additional information . A level produ...

    sisas (19-21). A manager has prepared a forecast of expected aggregate demand for the nest s perods Develop an aggregate plan to meet this demand given these additional information . A level production rate of 300 units per month will be used Period 6 Total Forecast 200 200 300 400 500100 Output Regular time Overtime Sabcontract Inventory Outpet- Forecast leventory Backig 19. What is the anding inventory for period 5? A. 0 B. 100 C. -100 D. 200 E -200...

  • You are developing an aggregate plan for a toolbox maker which sells to professional mechanics. The...

    You are developing an aggregate plan for a toolbox maker which sells to professional mechanics. The relevant cost and demand data are shown below: Holding cost $8/toolbox/month Month Demand Subcontract $80/toolbox July 400 Regular time $45/toolbox August 500 OT Regular time cost plus additional $20 per toolbox September 500 Capacity increase $50/unit October 700 Capacity decrease $90/unit November 800 Backlog cost $10/toolbox/month December 700 June capacity and demand 500 toolboxes Beginning inventory 0 toolboxes Plan A: Try a level strategy...

  • QUESTION 23 A Dover, Delaware, plant has developed the forecast shown in the table. The plant...

    QUESTION 23 A Dover, Delaware, plant has developed the forecast shown in the table. The plant has a normal capacity of 550 units per month. Normal output has a cost of S50 per unit. Subcontract is $65 per unit. Workers can be assigned to other jobs if production is less than normal. The beginning inventory is 0 nit. There is no previous backlogs. Demand forecast Period Demand40000 700 80050 Develop a chase plan that matches the forecast. What is the...

  • Aggregate Planning

    A While the demand for regular fabric has declined, the demand for medical-grade fabric has been surging in the market. In response, the management at Fabric Mills quickly bumped up the regular output of medical-grade fabric by reassigning workers from the production of regular fabric and rehiring retired workers. Table 2 shows the demand forecast and capacity for medical-grade fabric. Note that overtime is limited to 20% of the regular capacity. The availability of subcontract is also limited due to...

  • A manager has projected demand for the next six months (below). Given this information, prepare a...

    A manager has projected demand for the next six months (below). Given this information, prepare a LEVEL aggregate plan for production. Assume maximum regular time production is 350 units per month. Overtime is limited to 75 units per month. The limit for subcontracting is 400 per month. The company has a zero beginning inventory and cannot have ending inventory or a backlog at the end of the 6th period. Unit costs are as noted below. Regular Time Cost: $10/unit Overtime...

  • Manager Chris Channing of Fabric Mills, Inc., has developed the forecast shown in the table for...

    Manager Chris Channing of Fabric Mills, Inc., has developed the forecast shown in the table for bolts of cloth. The figures are in hundreds of bolts. The department has a normal capacity of 275(00) bolts per month, except for the seventh month, when capacity will be 250(00) bolts. Normal output has a cost of $40 per hundred bolts. Workers can be assigned to other jobs if production is less than normal. The beginning inventory is zero bolts. Month Forecast Total...

  • The owner of a small mill-working plant that builds cabinets is developing his aggregate plan for...

    The owner of a small mill-working plant that builds cabinets is developing his aggregate plan for the next year. The relevant cost data and forecast for the next 4 quarters is provided below. The company currently has 20 employees and works one 8 hour shift each day with 2 paid 15 minute breaks. Assume each quarter has 65 working days, and that it currently has no units in stock. Use this information and the information from the table to answer...

  • USE LEVEL AGGREGATE PLAN: Cost data Regular time labor cost per hour $10 Overtime time labor...

    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...

  • Manager Chris Channing of Fabric Mills, Inc., has developed the forecast shown in the table for...

    Manager Chris Channing of Fabric Mills, Inc., has developed the forecast shown in the table for bolts of cloth. The figures are in hundreds of bolts. The department has a normal capacity of 275(00) bolts per month, except for the seventh month, when capacity will be 250(00) bolts. Normal output has a cost of $40 per hundred bolts. Workers can be assigned to other jobs if production is less than normal. The beginning inventory is zero bolts. Month 1 2...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT