calculation the machine capacity

[spl]

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

[samba_ravi]

How you want your result
please attach desired output format

[spl]

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

[Special-K]

You've added the percentages for each day to get the "total achievement against capacity".
Mathematically, I don't think you can do that.
I think you have to multiply them out again to get the original value.
You can't simply add up percentages.

[Shareez Saleem]

Capacity Utilization.xlsx

Refer the attached sheet.

[spl]

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

[Shareez Saleem]

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.

[spl]

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

[Shareez Saleem]

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