Create a level plan with a zero ending inventory for the forecast shown in the table. There is nobeginning inventory and regular production capacity is 300 units. Overtime costs K15 extra and islimited to 25 units per month and subcontracting is limited to 60 units per month and costs K10 perunit. Back orders cost KS0 per unit and there is a cost of KS per month to hold a unit in inventory.What is the total plan cost?|MonthJanuaryFebruaryMarchForecast250300400|April350

It is given that, the regular production capacity is 300 units. Overtime costs are K15 extra and are…

Answered: Create a level plan with a zero ending…

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

Suppose we are formulating a Master Production Schedule (MPS) for an item. Week O projected on- hand is 83 units. The lot-size policy for this item calls for L4L ordering. Lead time for this item is one week. There are no safety stock requirements. Here are the demand forecast and the booked orders for this item . Week 2 3 4 5 6 Forecast 60 45 45 45 45 60 Booked 59 48 30 10 What will be the order size of the first MPS Start Quantity that is needed?
Assume you are the manager of a shop that assembles power tools. You have just received an order for 55 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Item Lead Time (weeks) On Hand Saw A B C D E F 2 1 2 2 1 1 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release Ĉ E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot 15 10 5 65 20 10 30 Skip Extension Tip: Double click to open in new tab Show Transcribed Text Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.) Components A(2), B(1), C(4) E(3), D(1) D (2), F(3) E(2), D (2) Beg. Inv. 1 2 3 190 5 210 6
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely.
Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60 units. The MPS rule is to schedule production if the projected on-hand Inventory would be negative without it. Customer orders (committed) are as follows: Week 1 2 3 Customer Orders 54 38 25 20 Use a production lot size of 73 units and no beginning inventory. (In the ATP row, enter a value of 0 (zero) In any perlods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required.) June July MPS ATP Forecast Customer Orders Projected On-Hand Inventory 60 54 2 60 38 3 60 25 4 60 20 5 60 0 6 60 0 7 60 0 8 60 0
please answer all the parts of the question else i will give negative ratings.
The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with backorders. Given this information, what is the number in the cell with the question mark?
1.Describe the overall frameworks for resource planning in both goods-producing and service-providing organizations. 2.Explain options for aggregate planning 3.Explain the three basic strategies for aggregate planning.
Hotel Galway is a 50 room Boutique hotel in a pop-ular city break destination in Ireland. Until recently the hotel has priced each room at $120 for bed and breakfast. On aver-age 40 rooms are occupied every weekend. The variable cost of each occupied room is $30. Following an internal review man-agement has decided to try a revenue management approach, with rooms priced at $90 for bookings up to one week early and $180 for bookings within a week of their stay. It is esti-mated the hotel will sell 28 rooms at the lower price and 14 at the higher price. Variable costs will not change. Recommendwhich approach is the most feasible.
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?
The table below contains monthly (six months) demand estimates and working days per month. Month Demand Production Days JAN 1,500 20 FEB 1,200 24 MAR 1,000 25 APR 1,600 25 MAY 1,100 20 JUN 1,300 26 For the implementation of “Level” strategy, the average demand (in units/day) over the six- month planning horizon is equal to; a. 40 b. 50 c. 55 d. 75
An X product is composed of A, B, C items. The aggregate plan for February and some of the information are provided as follows. Prepare the master production schedule.
what special issues and considerations are likely to arise in the operation and support of an interorganizational system?

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