Complete the chase production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you complete the plan correctly, your hiring, layoff, and inventory costs should match those given here. Month Forecasted sales March 1,890 April 1,548 May 1,512 June 1,017 July 1,971 August 2,475 September 2,871 October 2,673 November 3,573 December 3,600 January 2,655 February 2,286
Complete the chase production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you complete the plan correctly, your hiring, layoff, and inventory costs should match those given here. Month Forecasted sales March 1,890 April 1,548 May 1,512 June 1,017 July 1,971 August 2,475 September 2,871 October 2,673 November 3,573 December 3,600 January 2,655 February 2,286
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
Complete the chase production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you complete the plan correctly, your hiring, layoff, and inventory costs should match those given here.
Month Forecasted sales
March 1,890
April 1,548
May 1,512
June 1,017
July 1,971
August 2,475
September 2,871
October 2,673
November 3,573
December 3,600
January 2,655
February 2,286
March 1,890
April 1,548
May 1,512
June 1,017
July 1,971
August 2,475
September 2,871
October 2,673
November 3,573
December 3,600
January 2,655
February 2,286
Transcribed Image Text:Fill in the production plan table below (enter your responses as whole numbers).
Sales in
worker
hours
to meet
sales
average = 260
Month
Forecasted
sales
Actual
workers
Actual
production
Layoffs
Hiring
Ending
inventory
Transcribed Image Text:Totals
Costs
Cost of plan
Planning values
Starting inventory
Starting and ending workforce
Hours worked per month per worker
Hours per unit
Hiring cost per worker
Layoff cost per worker
Monthly per-unit holding cost
Layoff
309
$927,000
Hiring
Inventory
309
24,000
$1,236,000 $216,000
$2,379,000
2,000
234
360
40
$4,000
$3,000
$9
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 2 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.