Answer the following questions applying the Constant Workforce strategy assuming: one daily shift of 8 hours, a $10 hour salary, a hiring cost of $400, a firing cost of $500, a storage cost of $10 , and a late order cost of $20. January February March April May June Total 1 Days 21 20 23 21 22 22 129 2 Units per Worker 126 3 Demand 1840 4068 3980 3540 3180 2642 19250 4 Workers Needed 5 Workers Available 30 6 Workers Hired 7 Hiring Cost 8 Workers Fired 9 Firing Cost 10 Current Workers 11 Labor Cost 12 Produced Units 13 Net Inventory 14 Storage Cost 15 Late Orders Cost 16 Total Cost a) Labor cost in January: b) Net inventory in April: c) Late orders cost in May: d) Produced units in June:
Answer the following questions applying the Constant Workforce strategy assuming: one daily shift of 8 hours, a $10 hour salary, a hiring cost of $400, a firing cost of $500, a storage cost of $10 , and a late order cost of $20. January February March April May June Total 1 Days 21 20 23 21 22 22 129 2 Units per Worker 126 3 Demand 1840 4068 3980 3540 3180 2642 19250 4 Workers Needed 5 Workers Available 30 6 Workers Hired 7 Hiring Cost 8 Workers Fired 9 Firing Cost 10 Current Workers 11 Labor Cost 12 Produced Units 13 Net Inventory 14 Storage Cost 15 Late Orders Cost 16 Total Cost a) Labor cost in January: b) Net inventory in April: c) Late orders cost in May: d) Produced units in June:
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
Answer the following questions applying the Constant Workforce strategy assuming: one daily shift of 8 hours, a $10 hour salary, a hiring cost of $400, a firing cost of $500, a storage cost of $10 , and a late order cost of $20.
|
|
January |
February |
March |
April |
May |
June |
Total |
1 |
Days |
21 |
20 |
23 |
21 |
22 |
22 |
129 |
2 |
Units per Worker |
126 |
|
|||||
3 |
Demand |
1840 |
4068 |
3980 |
3540 |
3180 |
2642 |
19250 |
4 |
Workers Needed |
|||||||
5 |
Workers Available |
30 | ||||||
6 |
Workers Hired |
|||||||
7 |
Hiring Cost |
|||||||
8 |
Workers Fired |
|||||||
9 |
Firing Cost |
|||||||
10 |
Current Workers |
|||||||
11 |
Labor Cost |
|||||||
12 |
Produced Units |
|||||||
13 |
Net Inventory |
|||||||
14 |
Storage Cost |
|||||||
15 |
Late Orders Cost |
|||||||
16 |
Total Cost |
a) Labor cost in January:
b) Net inventory in April:
c) Late orders cost in May:
d) Produced units in June:
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
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.