Holding cost = $7 per unit per month Subcontracting cost = $65 per unit Regular time labor cost = $15 per hour. Each worker works 8 hours per day as regular time laborers Overtime labor cost = $19 per hour for hours above 8 hours per worker per day Hiring cost = $40 per worker Firing cost = $80 per worker Demand during the month of June = 640 units Labor hours per unit = 3 Beginning inventory in July = 150 units Please follow the outlined strategy accurately. The strategy is to fulfill the gross demand in each month, storing any excess units in a warehouse as inventory. The warehouse can only hold 300 units maximum, so any additional units that cannot be warehoused will have to be scrapped and sent to a recycler at a cost of $50 a unit. The recycler will dispose of the units in an environmentally friendly manner. The workers employed during a month, working 8 hours a day as regular time labor, produce exactly the gross demand in the previous month. For example, the regular time labor would produce 720 units (gross demand during August) during the month of September. In case the units produced by regular production and the amount in inventory cannot fulfill the gross demand in any month, the demand is met by subcontracting to a maximum of 20% of the gross demand (NOT net demand) for that month. For example, for the month of October, if necessary, to fulfill demand by subcontracting, the maximum amount allowed for subcontracting will be 20% of 1,040 which is 208 units. Any remaining demand is met using overtime labor. Assume that the month of July begins with all new workers being hired.

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
100%

Holding cost = $7 per unit per month

Subcontracting cost = $65 per unit

Regular time labor cost = $15 per hour. Each worker works 8 hours per day as regular time laborers

Overtime labor cost = $19 per hour for hours above 8 hours per worker per day

Hiring cost = $40 per worker

Firing cost = $80 per worker

Demand during the month of June = 640 units

Labor hours per unit = 3

Beginning inventory in July = 150 units

Please follow the outlined strategy accurately. The strategy is to fulfill the gross demand in each month, storing any excess units in a warehouse as inventory. The warehouse can only hold 300 units maximum, so any additional units that cannot be warehoused will have to be scrapped and sent to a recycler at a cost of $50 a unit. The recycler will dispose of the units in an environmentally friendly manner. The workers employed during a month, working 8 hours a day as regular time labor, produce exactly the gross demand in the previous month. For example, the regular time labor would produce 720 units (gross demand during August) during the month of September. In case the units produced by regular production and the amount in inventory cannot fulfill the gross demand in any month, the demand is met by subcontracting to a maximum of 20% of the gross demand (NOT net demand) for that month. For example, for the month of October, if necessary, to fulfill demand by subcontracting, the maximum amount allowed for subcontracting will be 20% of 1,040 which is 208 units. Any remaining demand is met using overtime labor. Assume that the month of July begins with all new workers being hired.

 

Month
July
August
September
October
November
December
Gross Demand
400
720
400
1040
600
1200
Number of
working days
20
30
27
25
30
25
# of workers
who work during
the month
Regular
production
(units)
Beg Inv
BI
(units)
End Inv
EI
(units)
Subcontract
(units)
Recycle (units) Overtime (units)
Transcribed Image Text:Month July August September October November December Gross Demand 400 720 400 1040 600 1200 Number of working days 20 30 27 25 30 25 # of workers who work during the month Regular production (units) Beg Inv BI (units) End Inv EI (units) Subcontract (units) Recycle (units) Overtime (units)
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
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.