2.15 The opening backlog is 900 units. Forecast demand is shown in the following. Calculatethe weekly production for level production if the backlog is to be reduced to 200 units.Week123456TotalForecast Demand600700700700600500Planned ProductionProjected 900Backlog

The opening backlog = 900 units Projected ending backlog = 200 units

Answered: 2.15 The opening backlog is 900 units.…

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

EE Company has the following aggregate demand requirements and data for the upcoming four quarters. Which of the following production plans has lower cost, Plan A using chase demand or Plan B using pure level strategy or C using 1350 level with subcontracting if needed. * Period 1 Demand Previous output 1300 units 1 1,400 Beginning Inventory 0 units 1,200 Inventory holding cost P10.00 3. 1,600 Hiring workers P40.00 1,500 Stockout cost P50.00 Firing workers Subcontracting cost P80.00 P60.00 Unit cost P30.00 Overtime P15.00 Plan A Plan B Plan C 2m4 OOO
List the strategic objectives of aggregate planning. Which one of these is most often addressed by the quantitative tech-niques of aggregate planning? Which one of these is generally the most important?
12
What is the BOM stock needed for the shoe department for April if the sales are planned at $64,000 and the stock to sales ratio is 18.3?
OQ17
4. The partially completed MPS for a product is given below. Item: Ball bearings Order Policy: 500 units Lead Time: 1 week Week Quantity on Hand: 5 6 7 400 3 4 8 10 Forecast 550 300 400 450 300 350 200 300 450 400 Customer orders 300 350 250 250 200 150 100 100 100 100 (booked) Projected on-hand inventory MPS quantity 500 MPS start Available-to- promise (ATP) inventory a. Develop the MPS for the product. b. Four customer orders arrived in the following sequence. As they arrive, you must decide whether to accept or reject them. Which orders would you accept for shipment? Why?
LMNO Gaskets has formulated a production plan for a product to meet demand over the upcoming four quarters. Demand in each of the four quarters and production, overtime, and subcontracting capacities are reported in the table below, in addition to the feasible production plan. The relevant costs are: • Regular time production cost is $10/unit. Overtime production cost is $14/unit. Subcontracting cost is $18/unit Inventory is held at a cost of $1/unit/quarter. • Units may be backordered at a cost of $4/unit/quarter. Production Resource Regular Time Q1 Overtime Q1 Subcontract Q1 Regular Time Q2 Overtime Q2 Subcontract Q2 Regular Time Q3 Overtime Q3 Subcontract Q3 Demand in Quarter Demand in Quarter Q2 0 20 0 550 Q1 550 230 0 0 0 0 40 40 0 860 250 470 0 40 0 1330 What is the inventory cost for the year? What is the backorder cost for the year? What is the total cost for the year? Q3 0 0 0 0 0 30 510 160 0 700 What is the total overtime production cost for the year? Capacity 550 250 500…
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely.
2. Aggregate planning has been described as the process of matching supply and demand over a medium time horizon. What are some ways this can be accomplished?
WSS company makes weatherproof surveillance systems for parking lots. Demand estimates for the next four quarters are 25, 9, 13, and 17 units. Prepare an aggregate plan that uses inventory, regular time, and over time, and backorders. Subcontracting is not allowed. The regular time capacity is 15 units for quarters 1 and 2, 18 units for quarters 3 and 4. Overtime capacity is 3 units per quarter. The regular time cost is $2000 per unit, while the overtime cost is $3000 per unit. Backorder costs $300 per unit per quarter; inventory holding costs $100 per unit per quarter. The beginning inventory is zero. How many total units will be produced in quarter 1 for delivery in quarter 1? How many units in total will be used to fill back orders over the four quarters? What is the cost to produce one unit in Quarter 4 using overtime to fill a back order in quarter one?
OQ18
Table 5.1: The demand forecast developed for the year ended 31 December 2022. Month Production days Demand forecast Jan 16 150 Feb 16 150 Mar 23 250 Apr 21 250 May 22 400 Jun 22 500 Jul 21 600 Aug 20 750 Sep 20 450 Oct 20 250 Nov 16 150 Dec 16 150 1. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). 2. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number).

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

2.15 The opening backlog is 900 units. Forecast demand is shown in the following. Calculate the weekly production for level production if the backlog is to be reduced to 200 units. Week 1 2 3 4 5 6 Total Forecast Demand 600 700 700 700 600 500 Planned Production Projected 900 Backlog