3. Although the BackPack Company has always used a level aggre- gate plan, Tameka is interested in evaluating chase aggregate plans also. She has asked you to calculate how many hires and fires would be necessary to adjust capacity to meet demand exactly each period. If necessary, incur sonte undertime. Calculate the number of workers needed each period. 4. Now that you have calculated the number of workers needed each period in Problem 3, Tameka wants to see how the plan would actu- ally work. You need to: a. Show what would happen if this plan were implemented. b. Calculate the costs associated with this plan. c. Evaluate the plan in terms of cost, customer service, opera- tions, and human resources.

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

I am having trouble answering question 4. Here is the data and the question. Can you hep me in any way possible?

### Problem Data

#### Cost Data
- **Regular-time labor cost per hour:** $12.00
- **Overtime labor cost per hour:** $16.00
- **Subcontracting cost per unit (labor only):** $75.00
- **Holding cost per unit per period:** $8.00
- **Back-order cost per unit per period:** $15.00
- **Hiring cost per employee:** $500.00
- **Firing cost per employee:** $350.00

#### Capacity Data
- **Beginning workforce:** 210 employees
- **Beginning inventory:** 400 units
- **Labor standard per unit:** 6 hours
- **Regular time available per period:** 160 hours
- **Overtime available per period:** 30 hours
- **Subcontracting maximum per period:** 1000 units
- **Subcontracting minimum per period:** 500 units

#### Demand Data
- **Period 1:** 5500 units
- **Period 2:** 4600 units
- **Period 3:** 7600 units
- **Period 4:** 5800 units
- **Period 5:** 6560 units
- **Period 6:** 4000 units

This dataset provides cost, capacity, and demand information which can be used for production planning and workforce management in a manufacturing setting.
Transcribed Image Text:### Problem Data #### Cost Data - **Regular-time labor cost per hour:** $12.00 - **Overtime labor cost per hour:** $16.00 - **Subcontracting cost per unit (labor only):** $75.00 - **Holding cost per unit per period:** $8.00 - **Back-order cost per unit per period:** $15.00 - **Hiring cost per employee:** $500.00 - **Firing cost per employee:** $350.00 #### Capacity Data - **Beginning workforce:** 210 employees - **Beginning inventory:** 400 units - **Labor standard per unit:** 6 hours - **Regular time available per period:** 160 hours - **Overtime available per period:** 30 hours - **Subcontracting maximum per period:** 1000 units - **Subcontracting minimum per period:** 500 units #### Demand Data - **Period 1:** 5500 units - **Period 2:** 4600 units - **Period 3:** 7600 units - **Period 4:** 5800 units - **Period 5:** 6560 units - **Period 6:** 4000 units This dataset provides cost, capacity, and demand information which can be used for production planning and workforce management in a manufacturing setting.
### Evaluating Aggregate Plans: BackPack Company Case Study

#### Task 3: Chase Aggregate Plan Evaluation
Although the BackPack Company has traditionally used a level aggregate plan, Tameka is interested in assessing chase aggregate plans as well. She has requested an analysis of the required hiring and firing to meet exact demand every period. If necessary, some undertime may be incurred. Your task is to calculate the number of workers needed for each period.

#### Task 4: Implementation and Evaluation of the Plan
After calculating the required number of workers for each period in Task 3, Tameka wants to understand the practical implications of this plan. You need to:

a. **Show what would happen if this plan were implemented.**

b. **Calculate the costs associated with this plan.**

c. **Evaluate the plan in terms of cost, customer service, operations, and human resources.**

This exercise provides a comprehensive understanding of the nuances involved in selecting and implementing aggregate planning strategies.
Transcribed Image Text:### Evaluating Aggregate Plans: BackPack Company Case Study #### Task 3: Chase Aggregate Plan Evaluation Although the BackPack Company has traditionally used a level aggregate plan, Tameka is interested in assessing chase aggregate plans as well. She has requested an analysis of the required hiring and firing to meet exact demand every period. If necessary, some undertime may be incurred. Your task is to calculate the number of workers needed for each period. #### Task 4: Implementation and Evaluation of the Plan After calculating the required number of workers for each period in Task 3, Tameka wants to understand the practical implications of this plan. You need to: a. **Show what would happen if this plan were implemented.** b. **Calculate the costs associated with this plan.** c. **Evaluate the plan in terms of cost, customer service, operations, and human resources.** This exercise provides a comprehensive understanding of the nuances involved in selecting and implementing aggregate planning strategies.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 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.