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:

1. Calculate the capacity utilization for 2022, 2023 & 2024.

Notes:

Answer using Microsoft Excel and any explanation or discussion needed can be written under calculations.