+ Reply to Thread
Results 1 to 9 of 9

calculation the machine capacity

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    20

    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
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,523

    Re: calculation the machine capacity

    How you want your result
    please attach desired output format
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    01-11-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    20

    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. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    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.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  5. #5
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    691

    Re: calculation the machine capacity

    Capacity Utilization.xlsx

    Refer the attached sheet.

  6. #6
    Registered User
    Join Date
    01-11-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: calculation the machine capacity

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

  7. #7
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    691

    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. #8
    Registered User
    Join Date
    01-11-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: calculation the machine capacity

    Quote Originally Posted by Shareez Saleem View Post
    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. #9
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    691

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Working code on my machine is returning out of range error on another machine.
    By je.suis.ketan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2012, 11:51 PM
  2. Macro runs fine on my machine; won't run on another user's machine
    By brl8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-29-2010, 03:16 PM
  3. Capacity Calculation
    By verticalavenue in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2008, 12:37 PM
  4. [SOLVED] Reference & update destin. cells on 1st machine from source workbook on 2nd machine
    By eastside877@yahoo.com in forum Excel General
    Replies: 2
    Last Post: 03-01-2006, 12:25 AM
  5. Replies: 6
    Last Post: 02-28-2006, 01:20 AM

Bookmarks

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