During a 46-day period when there were 120 workers, the firm produced 1,700,000 cookies. Assume that there are 100 workers employed at the beginning of month 1 and zero starting inventory. a. Find the minimum constant workforce needed to meet monthly demand. b. Assume c,= SO.10 per cookie per month, cH= $100, and cF = $200. Add columns that give the cumulative on-hand inventory and inventory cost. What is the total cost of the constant workforce plan? c. Solve for the optimal plan using linear programming. Compare your solution to b.

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
icon
Concept explainers
Topic Video
Question
35. The Mr. Meadows Cookie Company can obtain accurate forecasts for 12 months based
on firm orders. These forecasts and the number of workdays per month are as follows:
Demand Forecast
Month
(in thousands of cookies)
Workdays
1
850
26
2
1,260
24
3
510
20
4
980
18
770
22
850
23
7
14
1,050
1,550
1,350
1,000
970
680
21
9.
23
10
24
11
21
12
13
During a 46-day period when there were 120 workers, the firm produced
1,700,000 cookies. Assume that there are 100 workers employed at the beginning of
month 1 and zero starting inventory.
a. Find the minimum constant workforce needed to meet monthly demand.
b. Assume cz= $0.10 per cookie per month, cH= $100, and cp = $200. Add columns
that give the cumulative on-hand inventory and inventory cost. What is the total
cost of the constant workforce plan?
c. Solve for the optimal plan using linear programming. Compare your solution to b.
Transcribed Image Text:35. The Mr. Meadows Cookie Company can obtain accurate forecasts for 12 months based on firm orders. These forecasts and the number of workdays per month are as follows: Demand Forecast Month (in thousands of cookies) Workdays 1 850 26 2 1,260 24 3 510 20 4 980 18 770 22 850 23 7 14 1,050 1,550 1,350 1,000 970 680 21 9. 23 10 24 11 21 12 13 During a 46-day period when there were 120 workers, the firm produced 1,700,000 cookies. Assume that there are 100 workers employed at the beginning of month 1 and zero starting inventory. a. Find the minimum constant workforce needed to meet monthly demand. b. Assume cz= $0.10 per cookie per month, cH= $100, and cp = $200. Add columns that give the cumulative on-hand inventory and inventory cost. What is the total cost of the constant workforce plan? c. Solve for the optimal plan using linear programming. Compare your solution to b.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
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.