Question
Week Demand 1 4000 2 4250 3 4400 4 5000 5 5250 6 6000 7 6300 8 6500 9 7020 10 7500 11 8200 12
Week Demand 1 4000 2 4250 3 4400 4 5000 5 5250 6 6000 7 6300 8 6500 9 7020 10 7500 11 8200 12 8400
| Week | Demand |
| 1 | 4000 |
| 2 | 4250 |
| 3 | 4400 |
| 4 | 5000 |
| 5 | 5250 |
| 6 | 6000 |
| 7 | 6300 |
| 8 | 6500 |
| 9 | 7020 |
| 10 | 7500 |
| 11 | 8200 |
| 12 | 8400 |
Your company are producing their New Product. In order to produce their New Product, they have 2 machines (2 operators per machine) and they currently have 4 operators/staff. Each machine has a capacity of producing 4500 New Products per year. The demand for the New Product for the next three years is given in the table below:
| Year | 2022 | 2023 | 2024 |
| New Product | 8500 | 7000 | 4500 |
Required:
- Calculate the capacity utilization for 2022, 2023 & 2024.
Notes:
Answer using Microsoft Excel and any explanation or discussion needed can be written under calculations.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Project management the managerial process
Authors: Eric W Larson, Clifford F. Gray
5th edition
73403342, 978-0073403342
