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

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
Musa's Cashmere Sweaters has authorized the following MPS for her exclusive line of cashmere sweaters. She wants to use the MPS record for promising future orders. Current order promises are included. The MPS order quantity is 60 units. Beginning Inventory is 0. Complete the following MPS record. Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 15 15 15 15 20 20 20 20 25 25 25 25 Customer orders 12 10 8 25 40 0 15 30 30 0 0 40 Projected available Available-to-promise MPS 60
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
14.26. Calculate the available-to-promise row in the following matrix: Period On Hand = 100 1 2 3 4 5 6 Forecast 50 100 50 100 50 100 Customer Orders 50 125 75 175 45 15 Master Production 200 200 Schedule Available-to-Promise
Suppose we are formulating a Master Production Schedule (MPS) for an item. The lot-size policy for this item calls for a fixed quantity of 300 units. Lead time for this item is three weeks. Week O inventory for this item is 400 units. There are no safety stock requirements. Here are the demand forecast and the booked orders for this item.... Week 1 2 3 4 5 6 Forecast 120 120 100 100 100 120 Booked 115 121 71 0 0 0 When the master schedule is complete. what will be the Projected On-Hand in Week 4?
Given the forecast and booked orders shown in the table, and a beginning inventory of 25, what should the master production schedule quantity be for period 4? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Prepare a master schedule based on the following information: Week 1 2 3 4 5 6 7 8 Forecast 500 500 600 600 750 750 900 800 Orders 540 470 325 200 105 45 10 0 Currently there are 700 units in inventory. Policy calls for a fixed order quantity of 1250 units. Can you receive another order for 250 items in week 1? Why? How many orders can be received in each period without altering the plan. If there are 1250 items in stock, what would be the answer of questions 2 and 3?
The Shades Sunglass Company assembles sunglasses from frames, which it makes,and lenses, which it purchases from an outside supplier. The sales department hasprepared the following 6-week forecast for Ebony, a popular model. The sunglassesare assembled in lots of 220, and the opening inventory is 300 pairs. Complete theprojected available balance and the master production schedule.
2. RoadHog Inc. is a small manufacturer of motorcycle accessories. It makes muffler with fins on a linethat is also used to make a variety of other products. Because it is costly to set up the line to produce themin batches, RoadHog has an incentive them in batches. However, while customer demand is known over a6-planning horizon, it is not necessarily constant from week to week. The unit cost, fixed setup cost andmonthly holding cost are given in the table.Data for the RoadHog Dynamic Lot SizingWeek 1 2 3 4 5 6Demand 30 50 60 25 20 40Setup Cost 150 150 150 150 150 150Holding cost 3 3 3 3 3 3a. Find the production plan and the total cost for lot for lot scheduling.b. Find the production plan and the total cost for lot for the fixed order quantity (FOQ = 100)scheduling.c. Find the production plan and the total cost for the fixed order period scheduling (Use FOP = 3weeks).d. Which strategy is the best?
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January February 4,100 4,200 March 3,900 April 4,300 May 4,900 June 4,600 July 5,200 August 4,800 September 5,300 October 5,600 November 6,200 December 5,900
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and Inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders occur. There are 100 workers on January 31. You are given the following demand forecast: February, 80,640; March, 67,200; April, 100,280; May, 40,280. Productivity is four units per worker hour, eight hours per day, 21 days per month. Assume zero Inventory on February 1. Costs are: hiring, $50 per new worker, layoff, $70 per worker laid off, Inventory holding, $11 per unit-month; regular time labor, $12 per hour; overtime, $18 per hour; backorder, $22 per unit. Develop a production plan and calculate…
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders occur. There are 100 workers on January 31. You are given the following demand forecast: February, 90,000; March 65,000; April 110,000; May, 55,000. Productivity is four units per worker hour, eight hours per day, 20 days per month. Assume zero inventory on February 1. Costs are hiring, $50 per new worker; layoff, $70 per worker laid off; inventory holding, $10 per unit-month; straight-time labor, $10 per hour; overtime, $15 per hour; backorder, $20 per unit a. Find the total cost of this plan?

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