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 1,020, 1,480, and 1,180, 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 480 units. Manufacturing cost is $160 per unit, storage cost is $6 per unit per month, standard pay rate is $6 per hour, overtime rate is $9 per hour, cost of stockout is $8 per unit per month, hiring and training cost is $140 per worker, layoff cost is $240 per worker, and worker productivity is 0.1 unit per hour. Assume that you start off with 42 workers and that they work 8 hours per day. (Round Workers Required up to the next higher whole number. Round all other variables off to the nearest whole number. Use previous rounded answers as required to compute subsequent answers. Input all values as positive values. Leave no cells blank - be certain to enter "0" wherever required.) Forecast Safety stock Beginning inventory Net production required Workers required Hired Laid off Actual production Ending inventory Labor Inventory Hiring Layoff Total S January 1,020 January C February 1,480 February Total March March 1,180
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 1,020, 1,480, and 1,180, 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 480 units. Manufacturing cost is $160 per unit, storage cost is $6 per unit per month, standard pay rate is $6 per hour, overtime rate is $9 per hour, cost of stockout is $8 per unit per month, hiring and training cost is $140 per worker, layoff cost is $240 per worker, and worker productivity is 0.1 unit per hour. Assume that you start off with 42 workers and that they work 8 hours per day. (Round Workers Required up to the next higher whole number. Round all other variables off to the nearest whole number. Use previous rounded answers as required to compute subsequent answers. Input all values as positive values. Leave no cells blank - be certain to enter "0" wherever required.) Forecast Safety stock Beginning inventory Net production required Workers required Hired Laid off Actual production Ending inventory Labor Inventory Hiring Layoff Total S January 1,020 January C February 1,480 February Total March March 1,180
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...
Related questions
Question
Transcribed Image Text: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
1,020, 1,480, and 1,180, 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 480 units.
Manufacturing cost is $160 per unit, storage cost is $6 per unit per month,
standard pay rate is $6 per hour, overtime rate is $9 per hour, cost of stockout is $8
per unit per month, hiring and training cost is $140 per worker, layoff cost is $240
per worker, and worker productivity is 0.1 unit per hour. Assume that you start off
with 42 workers and that they work 8 hours per day. (Round Workers Required up
to the next higher whole number. Round all other variables off to the nearest
whole number. Use previous rounded answers as required to compute
subsequent answers. Input all values as positive values. Leave no cells blank - be
certain to enter "0" wherever required.)
Forecast
Safety stock
Beginning inventory
Net production required
Workers required
Hired
Laid off
Actual production
Ending inventory
Labor
Inventory
Hiring
Layoff
Total
g
January
January
1,020
Ĉ
February
1,480
February
Total
March
March
$
$
$
1,180
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
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
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
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.