ts $300 to make, and each requires, on average, 3.2 hours of labor.  Each employee works 160 hours per month, and there is no effective limit on the number of employees.  The cost of hiring or laying off an employee is $300.  The monthly holding cost for a table is $15.  For planning purposes, Castergourd will

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...
icon
Related questions
Question

Castergourd Home Products makes two types of butcherblock tables: the
Beefeater and the Deutschlander. The two tables are made in the same facility
and require the same amount of labor and equipment. In addition, we know the
following:
 Each table costs $300 to make, and each requires, on average, 3.2 hours of
labor.
 Each employee works 160 hours per month, and there is no effective limit
on the number of employees.
 The cost of hiring or laying off an employee is $300.
 The monthly holding cost for a table is $15.
 For planning purposes, Castergourd will begin and end with 20 employees
and 0 tables in inventory.
Forecasted sales data is reported on Excel file attached.
a. Develop a top-down level production plan for Castergourd for the 10-
month planning period. Calculate the total production, hiring, layoff, and
inventory costs for your plan.
b. Repeat part a, except in this case develop a chase production plan.
c. Repeat part a, except in this case develop a Mixed production plan.
d. Suppose hiring and layoff costs increase dramatically. In general, will this
make a level plan look better or worse than a chase or mixed plan? Explain.

Attached is the Information to answer the question above

BEEFEATER DEUTSCHLANDER
FORECAST
MONTH
FORECAST
Nov-16
650
3,048
2,899
3,198
2,671
2,919
Dec-16
676
Jan-17
624
Feb-17
624
Mar-17
696
Apr-17
May-17
Jun-17
3,102
2,964
2,409
3,381
3,965
475
566
819
Jul-17
754
Aug-17
982
Information:
Starting inventory:
Starting and ending workforce:
Hours worked per month per worker:
Production cost per unit:
Hours per unit:
Hiring cost per worker:
Layoff cost per worker:
Monthly per-unit holding cost:
20
160
$300
3.2
$300
$300
$15
Transcribed Image Text:BEEFEATER DEUTSCHLANDER FORECAST MONTH FORECAST Nov-16 650 3,048 2,899 3,198 2,671 2,919 Dec-16 676 Jan-17 624 Feb-17 624 Mar-17 696 Apr-17 May-17 Jun-17 3,102 2,964 2,409 3,381 3,965 475 566 819 Jul-17 754 Aug-17 982 Information: Starting inventory: Starting and ending workforce: Hours worked per month per worker: Production cost per unit: Hours per unit: Hiring cost per worker: Layoff cost per worker: Monthly per-unit holding cost: 20 160 $300 3.2 $300 $300 $15
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.