calculation the machine capacity

dear all,
i have little problem about calculate the machine capacity utilization and all machine capacity utilization per day and per week

Product Capacicty/day Sat Sun Mon Tue Wed Thu Fri
product.1 Machine.1 500 80% 0% 0% 0% 0% 0% 0%
product.2 Machine.1 400 0% 75% 0% 0% 0% 0% 0%
product.3 Machine.1 300 0% 0% 83% 0% 0% 0% 0%
product.4 Machine.1 200 0% 0% 0% 85% 0% 0% 0%
product.5 Machine.1 700 0% 0% 0% 0% 87% 0% 0%
product.6 Machine.1 800 0% 0% 0% 0% 0% 69% 0%
product.7 Machine.1 900 0% 0% 0% 0% 0% 0% 72%
product.8 Machine.2 450 89% 0% 0% 0% 0% 0% 0%
product.9 Machine.2 550 0% 55% 0% 0% 0% 0% 0%
product.10 Machine.2 660 0% 0% 38% 0% 0% 0% 0%
product.11 Machine.2 300 0% 0% 0% 57% 0% 0% 0%
product.12 Machine.2 800 0% 0% 0% 0% 76% 0% 0%
product.13 Machine.2 900 0% 0% 0% 0% 0% 61% 0%
product.14 Machine.2 1000 0% 0% 0% 0% 0% 0% 65%
total achivement against capacity 169% 130% 121% 142% 163% 130% 137%
machine wise day wise and week wise against capacity

Capacity Utilization.xlsx

Refer the attached sheet.

if i have 20 machine of different capacity and 100 product so what sloution

CU.xlsx
Try this.

I beleive, this gives you a clear idea.

If you want to add more product and machine, please do it and change the ranges in formulas.

Originally Posted by Shareez Saleem

Attachment 397222
Try this.

I beleive, this gives you a clear idea.

If you want to add more product and machine, please do it and change the ranges in formulas.

dear saleem
thanks for your reply but my problem still there because my sheet have 52 week per year and almomst 100 machine and 120 products i need same patren

Hi,

It's the same pattern, i just paste it in as Transpose.

See the attached file.

If this is useful, please close this Thread as "Resolved" and appreciate if you add reputation