Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60units. The MPS rule is to schedule production if the projected on-hand Inventory would be negative without it.Customer orders (committed) are as follows:Week123Customer Orders54382520Use a production lot size of 73 units and no beginning inventory. (In the ATP row, enter a value of 0 (zero) In anyperlods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required.)JuneJulyMPSATPForecastCustomer OrdersProjected On-Hand Inventory60542603836025460205600660076008600

The forecasting method is the one that is used by businesses for determining the value of goods and…

Answered: Prepare a master schedule given this…

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

need help with this question! 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.
5 X Month fx B C D E F G H Problem 7 Given the following forecast and cost information, determine the total cost of a chase plan that uses regular time production output of 400 units per month, overtime is used when needed up to a maximum of 40 units per month, and subcontracting is used if additional units are needed to meet the forecast. 1 2 3 45 6 Font Forecast Cover 440 400 450 460 480 490 Totals Problem 6 Accessibility: Investigate √5 Level Production. Production Overtime Problem 7 Alignment Subcontr acting Inventory Total Holding Cost Problem 8 Problem 18 F Number Ty Costs Formatting Table Styles Production Costs. Regular Overtime Subcontracting $ 555 E 50.00 65.00 75.00 Regular Time Overtime Subcontracting Total Cost M
On the morning of October 31st, Elaine Black, Chief Information Officer at Robatelli'sPizzeria, was waiting for both Jim Saxton, database administrator, and PeterGreyton, operations manager, to come to her office for a meeting. While waiting,Elaine was thinking about the surge of telephone and Internet orders expected to bereceived through the company's customer order center within the next 12 hours.Halloween had always been the most popular day of the year for people in thegreater Pittsburgh area to order pizza from Robatelli's. There were 53 restaurantlocations to serve these customers, but only one location to receive all of the ordersand forward them to the right restaurant. Elaine's thoughts were interrupted as Jimand Peter entered her office. The following conversation took place:ELAINE Well, guys, it's here again, our biggest day of the year. Not only isHalloween a busy day, but we have the upcoming day afterThanksgiving, the week before Christmas, and Super Bowl Sunday. Canour…
please answer within 30 minutes.
Please fill out the simple chart
Develop a production schedule to produce the exact production requirements by varying the workforce size for the following problem. The monthly forecasts for Product X for January, February, and March are 940, 1,520, and 1,230, respectively. Safety stock policy recommends that half of the forecast for that month be defined as safety stock. There are 22 working days in January, 19 in February, and 21 in March. Beginning inventory is 570 units. Manufacturing cost is $170 per unit, storage cost is $5 per unit per month, standard pay rate is $8 per hour, overtime rate is $12 per hour, cost of stock-out is $9 per unit per month, marginal cost of subcontracting is $8 per unit, hiring and training cost is $160 per worker, layoff cost is $260 per worker, and worker productivity is 0.1 unit per hour. Assume that you start off with 44 workers and that they work 8 hours per day. (Leave the cells blank, whenever zero (0) is required. Input all values as positive values. Round up "Workers Required"…
Lot sizing A producer with one product faces the following forecasted demand for the next 10 weeks: week 1. 2. 3. 4. 5. 6. 7. 8. 9. 10 Requirement 30 12 72 11 24 42 35 30 75 68 Assume furthermore that the producer faces a Set-up cost (K) equal to 132 each time production takes place and storage costs (h) of 0.6 per unit per week. a) Find the cost of the two extreme strategies Lot - for - lot (produce exactly what is needed in each period) and Produce - once (produce everything needed in the first period).
Cotton Island Fashions, a clothing producer, has generated a forecast for the next eightweeks. Demand is expected to be fairly steady, except for periods 3 and 4, which havehigher demands.Month 1 2 3 4 5 6 7 8 TotalForecast 1200 1200 1400 3000 1200 1200 1200 1200 11600The company typically hires seasonal workers to handle the extra workload in periods 3and 4. The cost for hiring and training a seasonal worker is $50 per worker, and thecompany plans to hire two additional workers and train them in period 3, for work in period4, and then lay them off (no cost for layoff). Develop an aggregate plan that uses steadyoutput from regular workers with added output from the two seasonal workers in period 4.The output rate for the seasonal workers is slightly less than that of regular workers, sotheir cost per unit is higher. The cost per unit for regular workers is $4 per unit, while costper unit for the seasonal workers is $5 per unit. Backlog cost is $1 per unit per period.
Please do not write in column A Problem 6 Given the following forecast and cost information, determine the total cost of a plan that uses regular time production output of 600 units per month, overtime is used when needed up to a maximum of 60 units per month, and subcontracting is used if additional units are needed to meet the forecast. Regular time cost $ 40.00 per unit Overtime cost $ 60.00 per unit subcontracting cost $ 80.00 per unit holding cost $ 10.00 per unit per month Production Inventory Costs Month Forecast Level Production Overtime Subcontracting Total Holding Cost Regular Time Overtime Subcontracting Total Cost 1 563 0 2 608 3 648 4 668 5 666 6 688 Totals
Backorders: A company is working on its quarterly aggregate production plan. Its quarter forecasts are 6000, 1000, 2500 and 2000, respectively. Suppose that it will use a level plan with backorders (one that produces at the average demand over the four quarters). What is the ending inventory in Quarter 3? (Do not round your intermediate calculations. Round your final answer to the nearest whole number. Only enter the number. Do not enter any units.)
4/Do not solve it in excel , please.
The Silver Star Bicycle Company will be manufacturing both men's and women's models of its Easy-Pedal 10-speed bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men's and 125 women's models to be shipped during the first month and 200 men's and 150 women's models to be shipped during the second month. Additional data are shown: Production Labor Requirements (hours) Current Model Costs Manufacturing Assembly Inventory Men's $120 2.0 1.5 20 Women's $90 1.6 1.0 30 Last month the company used a total of 1000 hours of labor. The company's labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of…

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