**Aggregate Demand Projection and Production Planning**The president of Hill Enterprises, Terri Hill, projects the firm’s aggregate demand requirements over the next 8 months as follows:- **January:** 1,450 - **February:** 1,600 - **March:** 1,600 - **April:** 1,700 - **May:** 2,200 - **June:** 2,200 - **July:** 1,800 - **August:** 1,300 **New Production Plan Discussion**Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. The stockout cost of lost sales is $60 per unit. Inventory holding costs are $20 per unit per month. Ignore any idle-time costs. The plan to be evaluated is titled "Plan D."**Plan D Description**- **Objective:** Keep the current workforce stable at producing 1,600 units per month.- **Additional Capacity:** In addition to regular production, another 20% of the normal production units can be produced in overtime at an additional cost of $50 per unit.- **Constraints:** A warehouse limits the maximum allowable inventory on hand to 600 units or less.- **Note:** Avoid overtime production if regular production or inventory are adequate to meet demand.**Plan D Analysis Table**The table below outlines the production plan for each month, demand, and calculates ending inventory and stockouts:| **Month** | **Demand** | **Production (Units)** | **O.T. Production (Units)** | **Ending Inventory** | **Stockouts (Units)** ||---------------|------------|------------------------|-----------------------------|---------------------|-----------------------|| December | - | - | - | 200 | - || January | 1,450 | 1,600 | | | || February | 1,600 | 1,600 | | | || March | 1,600 | 1,600 | | | || April | 1,700 | 1,600 | | | || May | 2,200 | 1,600 | | | || June | 2,200 | 1,600 |

Aggregate planning is a technique to plan the forecast for different families of products and…

Answered: The president of Hill Enterprises,…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Discuss the role of cross-functional collaboration in effective aggregate planning
Explain the Purchasing Portfolio that is being used in KFC with a diagram
Jet skis and snowmobiles are assembled by Mobile Incorporated. Because both end - items use the same small engine, you can aggregate demand for the engine assembly. Develop an aggregate plan that uses a level production strategy each quarter and the information that follows. What is the total cost? Assume lost sales are backordered and filled during the next quarter. Summarize the plan, its costs, and consequences using manual computations. Initial Inventory Level = 1,000 units Regular Time = $15 Lost Sales Cost/Unit = $24 Inventory Carry Cost per unit = $3 Quarter One Two Three Four Total Beginning Inventory Jet Ski Engine 10, 000 15,000 16,000 3,000 44,000 600 Snowmobile Engine 9,000 7,000 19,000 10,000 45,000 400 Total Engines 19,000 22,000 35,000 13,000 89, 000 1,000 Average Demand Rate/Quarter 22, 000 Units Regular Time Production Rate 22,000 Units
the totalcost, excluding normal time labor costs for plan a= ? $
I completed those steps and it is saying my answer is incorrect
Sapphire Aerospace operates 52 weeks per year, and its costof goods sold last year was $6,500,000. The firm carries eightitems in inventory: four raw materials, two work-in-processitems, and two finished goods. Table 12.3 shows last year’saverage inventory levels for these items, along with their unitvalues.a. What is the average aggregate inventory value?b. How many weeks of supply does the firm have?c. What was the inventory turnover last year?
7. Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months. Month May Jun Jul Forecast 4,000 4,800 5,600 Aug Sep 7,200 Oct 6,400 5,000 Use the following information to develop aggregate plans. Regular production cost Regular production capacity Overtime production cost Subcontracting cost Holding cost Beginning inventory $10 per case 5,000 cases $16 per case $20 per case $1 per case per month 0 Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the lowest total cost? a. Use level production. Supplement using overtime as needed. b. Use a combination of overtime (500 cases per period maximum), inventory, and subcontracting (500 cases per period maximum) to handle variations in demand. c. Use overtime up to 750 cases per period and inventory to handle variations in demand.
A firm’s cost of goods sold last year was $3,410,000, and the firm operates 52 weeks per year. It carries seven items in inventory: three raw materials, two work-in-process items, and two finished goods. The following table contains last year’s average inventory level for each item, along with its value. a. What is the average aggregate inventory value? b. How many weeks of supply does the firm maintain? c. What was the inventory turnover last year?
The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the table. Assuming one-time stockout costs for lost sales of $100 per unit, inventory carrying costs of $25 per unit per month, and zero beginning and ending inventory, evaluate the following plan on an incremental cost basis: Plan A: Produce at a steady rate (equal to minimum requirements) of 1,200 units per month and subcontract additional units at a $70 per unit premium cost. Subcontracting capacity is limited to 500 units per month. (Enter all responses as whole numbers). The total cost, excluding normal time labor costs, for Plan A = $ Month Ending Subcontract Demand Production Inventory (Units) 1 July 1200 1,200 0 0 2 August 1300 1,200 0 100 3 September 1200 1,200 0 0 4 October 1700 1,200 0 500 5 November 1650 1,200 0 450 6 December 1400 1,200 0 200 (Enter your response as a whole number.)
A firm’s cost of goods sold last year was $3,410,000, and the firm operates 52 weeks per year. It carries seven items in inventory: three raw materials, two work-in-process items, and two finished goods. The following table contains last year’s average inventory level for each item, along with its value. a. What is the average aggregate inventory value? b. How many weeks of supply does the firm maintain? c. What was the inventory turnover last year?
VT Company produces lawn movers and leaf blowers. The company must develop an aggregate plan given the forecast for engine demand shown in the table. The department has a regular output capacity of 150 engines per month. Regular output has a cost of RM55 per engine. The beginning inventory is zero engines. Overtime has a cost of RM80 per engine. Month 2 3 4 7 8 Total Forecast 125 135 140 120 125 125 135 135 1,040 Develop an aggregate plan that matches the forecast and compute the total cost of your plan. Regular production can be less than regular capacity. Explain your plan.
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 February 1,500 June 2,200 2,200 March April 1,800 1,700 July August 1,700 1,500 Her operations manager is considering a new plan, which begins in January with 200 units on hand and ends with zero inventory. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan B. Plan B: Produce at a constant rate of 1,400 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $80 per unit. Subcontracting capacity is limited to 800 units per month. Evaluate this plan by computing the costs for January through August. In order to arrive at the costs, first compute the ending inventory and subcontracting units for each month by filling in the table below (enter your responses as whole numbers). Period…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS