Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Maths / Excel Formula Query

  • 24-11-2013 9:53pm
    #1
    wiseoldelf
    Registered Users, Registered Users 2 Posts: 59 ✭✭


    Good Evening folks,

    its being racking my brain for the last few days over this issue.

    I'm looking to buy some products, 10 types overall. Of the products the seller has said they can fit

    1250 of product A in a 40ft container
    1800 of product B in a 40ft container
    1650 of product C in a 40ft container etc etc,

    if I wanted to buy 500 of product A and 300 of product B, how many of product C can I get... is there a simple formula for this? a excel formula would be great thanks


Comments

  • #2
    LashingLady
    Registered Users, Registered Users 2 Posts: 314 ✭✭LashingLady


    Divide the amounts you can fit by 40 to get amounts per foot. Then multiply the result A and B by the amounts you actually want of each - the sum of these two will be the total footage taken up by A and B. Take this total from 40 and then you should be able to figure out how much of C you can get..


  • #3
    ray giraffe
    Registered Users, Registered Users 2 Posts: 338 ✭✭ray giraffe


    Spreadsheet attached! :)

    U can change the figures in column C by trial and error and see the total in column E.


  • #4
    wiseoldelf
    Registered Users, Registered Users 2 Posts: 59 ✭✭wiseoldelf


    great thanks folks, not so much of a wise old elf

    thanks again


  • #5
    FoxT
    Closed Accounts Posts: 4,204 ✭✭✭FoxT


    Be careful! Depending on individual product sizing, you may run in to trouble.

    The total volume of the products you select my be = total volume of container, but they may not all fit (for example, if some are cylindrical).

    or item A may be 1.4 times the size of item B, but because of dimensions may leave space in the container at the top or side, so if you take out 140 Item B's you wont be able to fit 100 item B's unless you chop some of them up...


Advertisement