real life prob: sports organisation is paying for the manufacturer of equipment....

alamshar03

New member
Joined
Apr 15, 2016
Messages
6
Hi all

I thought this was going to be simple before I started to do the maths and discovered that it's hurting my head. This is a real life problem that I need to solve.

My sports organisation is paying for the manufacturer of equipment for it's member clubs that are located in many different locations. The clubs have to pay for the delivery of this equipment but I have negotiated a considerable discount on the delivery costs and thus will be requesting them to pay me and I will pay the courier. The courier has provided a quote for the entire delivery and has not broken it down. In any case, I don't want it broken down.
I need to work out how to charge each club for the equipment and I want to do it using the cash value of the equipment that they have ordered as a way to calculate the delivery costs

There are 4 types of equipment, A, B, C & D and I know the cash value of each.
The total order is for 31 pieces of equipment but I don't want the quantities of each type to be a factor.
I know the total delivery cost.

I need the delivery charge that I should apply to each piece of equipment.


I'd love your help with the maths.

Thank you
 
...I need to work out how to charge each club for the equipment and I want to do it using the cash value of the equipment that they have ordered as a way to calculate the delivery costs...but I don't want the quantities of each type to be a factor.
How do you intend to use "the cash value" of the items, but without taking "the quantities of each type" of item into account? For instance, if Club 1 ordered one item costing $100 while Club 2 ordered six of the same item, would it really be equitable to charge the two clubs the same for delivery? Will the shipper be charging you by item type, or also by quantities of items?

When you reply, please include a clear listing of your thoughts and efforts so far, as this will be helpful in our efforts to figure out what is going on. Thank you! ;)
 
How do you intend to use "the cash value" of the items, but without taking "the quantities of each type" of item into account? For instance, if Club 1 ordered one item costing $100 while Club 2 ordered six of the same item, would it really be equitable to charge the two clubs the same for delivery? Will the shipper be charging you by item type, or also by quantities of items?

When you reply, please include a clear listing of your thoughts and efforts so far, as this will be helpful in our efforts to figure out what is going on. Thank you! ;)

Hi

The shipper has given a total cost for the delivery of 31 items. There's no breakdown. If I get the delivery cost that I need to add to each item type then I just add them at the end. You can just assume that 31 clubs are ordering 31 items. The quantity of each item type is irrelevant for the same reason

I'll give you the numbers if it helps
Total Delivery Cost = €12000
Purchase Price Equipment Type A = €2100
Purchase Price Equipment Type B = €1950
Purchase Price Equipment Type B = €1360
Purchase Price Equipment Type D = €580

What weight do I need to attach to each Type? I hope that's clear
 
How do you intend to use "the cash value" of the items, but without taking "the quantities of each type" of item into account? For instance, if Club 1 ordered one item costing $100 while Club 2 ordered six of the same item, would it really be equitable to charge the two clubs the same for delivery? Will the shipper be charging you by item type, or also by quantities of items?

When you reply, please include a clear listing of your thoughts and efforts so far, as this will be helpful in our efforts to figure out what is going on. Thank you! ;)

Hi

The quantities of each type can be just added at the end but I'll give you all the figures if it helps

Total Delivery Cost = €12000. There is no breakdown by equipment type nor location nor quantity ordered by each club. It's not relevant anyway.
Value of Equipment Type A = €2100; Quantity = 12
Value of Equipment Type A = €1950; Quantity = 1
Value of Equipment Type A = €1360; Quantity = 2
Value of Equipment Type A = €580; Quantity = 16

So I just need to know the delivery cost I need for each equipment type by unit but I need to see the maths because the numbers may change

Thanks
 
The quantities of each type can be just added at the end...
I don't see how this makes sense...? (It certainly wouldn't make sense in "real life", but we're doing math homework here.)

Total Delivery Cost = €12000. There is no breakdown by equipment type nor location nor quantity ordered by each club.
Any shipper, delivering to different locations, would include that information for each shipment address. (But, again, we're doing math, not "real life".)

Value of Equipment Type A = €2100; Quantity = 12
Value of Equipment Type A = €1950; Quantity = 1
Value of Equipment Type A = €1360; Quantity = 2
Value of Equipment Type A = €580; Quantity = 16

So I just need to know the delivery cost I need for each equipment type by unit...
Which is it? Does the exercise say that the type and quantity do not matter, or they do? It can't be both!

Please reply with the full and exact text of the exercise, the complete instructions, and a clear listing of your thoughts and efforts so far. Thank you! ;)
 
Hi all

I thought this was going to be simple before I started to do the maths and discovered that it's hurting my head. This is a real life problem that I need to solve.

My sports organisation is paying for the manufacturer of equipment for it's member clubs that are located in many different locations. The clubs have to pay for the delivery of this equipment but I have negotiated a considerable discount on the delivery costs and thus will be requesting them to pay me and I will pay the courier. The courier has provided a quote for the entire delivery and has not broken it down. In any case, I don't want it broken down.
I need to work out how to charge each club for the equipment and I want to do it using the cash value of the equipment that they have ordered as a way to calculate the delivery costs

There are 4 types of equipment, A, B, C & D and I know the cash value of each.
The total order is for 31 pieces of equipment but I don't want the quantities of each type to be a factor.
I know the total delivery cost.

I need the delivery charge that I should apply to each piece of equipment.


I'd love your help with the maths.

Thank you
Seems like this could be a radically unfair way to compute delivery costs; someone pays $1000 for something 10mX3mX3m, & weighing 1000 kg, i.e. requiring something like a large truck [or railroad] flatbed for deliver pays less for shipping than someone paying $10000 for something that might ship in a small box. One would hope this couldn't be the case.

Anyways
V = total cost of equipment ordered
vj = cost of equipment jth club ordered
V = sum of vj
C = total cost of delivery
cj = cost of delivery of equipment for jth club [not yet known]
C = sum of cj
a = \(\displaystyle \frac{C}{V}\)

\(\displaystyle c_j\, =\, a\, v_j\)
 
I don't see how this makes sense...? (It certainly wouldn't make sense in "real life", but we're doing math homework here.)


Any shipper, delivering to different locations, would include that information for each shipment address. (But, again, we're doing math, not "real life".)


Which is it? Does the exercise say that the type and quantity do not matter, or they do? It can't be both!

Please reply with the full and exact text of the exercise, the complete instructions, and a clear listing of your thoughts and efforts so far. Thank you! ;)

Sorry about the double entry above but I thought the first one didn't submit properly. Please just focus on the information given. There are non mathematical reasons why the shipper does not give a breakdown by location & equipment type which would be of no use in resolving this problem. In addition, I don't want it broken down for other non mathematical reasons. The type matters but the only quantity that matters is the total number of equipment pieces, i.e. 31. I need to attach a delivery value to each of the 4 types per unit. Once that is done the rest is simple addition.
Lets try to simplify this:

Imagine it is three pieces of equipment; Type A x 2 and Type B x 1.
Purchase cost of Type A is €1000 going to Clubs X & Y
Purchase cost of Type B is €100 going to Club Z

To deliver separately Type A to Club X costs €450
Type A to Club Y costs €450
Type B to Club Z costs €100
Total delivery cost = €1000

However, you negotiate a €300 discount on shipping because of the multiple order so total delivery cost is €700. What do you charge each club using the purchase value to each piece of equipment? You cannot use the €450 x 2 and €100 amounts in the calculation because it is unknown in the real example because I never asked for it and it would be impractical to do so. I am only giving it as an example to bring some non maths clarity.

In the real example, the equipment is bulky and heavy corresponding to each item's value. Hence I want to use this measure to be fair with each club in what I charge them. Taking a simple average would be totally unfair

Sorry if I can't be clearer but that's as good as I can explain it.
 
Thanks for that effort but I don't think it's right unfortunately. When I punch in the numbers it doesn't add up to the total delivery cost. Here is what I mean

3006 3005 3002 3015
V€37,897.20 €37,897.20 €37,897.20 €37,897.20
Vj€582.01 €1,362.01 €1,952.01 €2,102.01
C€11,954.80 €11,954.80 €11,954.80 €11,954.80
Cj? ? ? ?
a0.31545 0.31545 0.31545 0.31545
Cj = aVj€183.60 €429.65 €615.77 €663.09
12x183.60 + 1x429.65 + 2x615.77 + 16x663.09 = €12,370 (It should equal C - €11955!
I don't see how this can be calculated without using the total quanties of equipment, i.e. 31

3006 etc are the the equipment codes (not important of course) and the multiples are the quantities of each piece of equipment ordered but I don't think that should be required until the very end where simple addition will get the final total.
 
Thanks for that effort but I don't think it's right unfortunately. When I punch in the numbers it doesn't add up to the total delivery cost. Here is what I mean

3006300530023015
V€37,897.20€37,897.20€37,897.20€37,897.20
Vj€582.01€1,362.01€1,952.01€2,102.01
C€11,954.80€11,954.80€11,954.80€11,954.80
Cj????
a0.315450.315450.315450.31545
Cj = aVj€183.60€429.65€615.77€663.09
12x183.60 + 1x429.65 + 2x615.77 + 16x663.09 = €12,370 (It should equal C - €11955!
I don't see how this can be calculated without using the total quanties of equipment, i.e. 31

3006 etc are the the equipment codes (not important of course) and the multiples are the quantities of each piece of equipment ordered but I don't think that should be required until the very end where simple addition will get the final total.
If I'm understanding you correctly, your numbers don't match up
V37897.2
C11954.8
a0.31545338
Cj = aVj
ItemItem CostQuanityVjTotal S$HIndv S&H
3006 582.012 1164.02 367.19 183.60
3005 1362.0111 362.01 429.65 429.65
3002 1952.012 3904.02 1231.54 615.77
3015 2102.0116 33632.16 10609.38 663.09
CHECK2165.01682.96
The Vj column [except for the CHECK row] is the total cost of the item in the Item column. The Cj = aVj column [except for the CHECK row] is the total cost of the S&H for the item in the Item column. The Indv S&H is the individual cost of the S&H for the item in the Item column. The CHECK row in column Vj is the sum of Vj minus V which should be zero [thus the individual Vj's are off somewhere]. The CHECK column, Cj=aVj row is the sum of the Cj minus the cost C, you should note that this is a times the amount off for the CHECK in the previous column as a further check.
 
If I'm understanding you correctly, your numbers don't match up
V37897.2
C11954.8
a0.31545338
Cj = aVj
ItemItem CostQuanityVjTotal S$HIndv S&H
3006 582.0121164.02 367.19 183.60
3005 1362.0111 362.01 429.65 429.65
3002 1952.012 3904.02 1231.54 615.77
3015 2102.011633632.16 10609.38 663.09
CHECK2165.01682.96
The Vj column [except for the CHECK row] is the total cost of the item in the Item column. The Cj = aVj column [except for the CHECK row] is the total cost of the S&H for the item in the Item column. The Indv S&H is the individual cost of the S&H for the item in the Item column. The CHECK row in column Vj is the sum of Vj minus V which should be zero [thus the individual Vj's are off somewhere]. The CHECK column, Cj=aVj row is the sum of the Cj minus the cost C, you should note that this is a times the amount off for the CHECK in the previous column as a further check.
My sincerest apologies!! Your calculations are absolutely correct. I made a mistake in in the excel formula :eek:. Many Many Thanks for that :cool:
 
Top