# calculation the machine capacity

1. ## 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

2. ## Re: calculation the machine capacity

How you want your result
please attach desired output format

3. ## Re: calculation the machine capacity

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

4. ## Re: calculation the machine capacity

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.

5. ## Re: calculation the machine capacity

Capacity Utilization.xlsx

Refer the attached sheet.

6. ## Re: calculation the machine capacity

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

7. ## Re: calculation the machine capacity

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.

8. ## Re: calculation the machine capacity

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

9. ## Re: calculation the machine capacity

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

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1