MHB Calculating Cost/Pallet for 5 Months: Terminology & Formula

  • Thread starter Thread starter briandewyea
  • Start date Start date
  • Tags Tags
    Terminology
AI Thread Summary
The discussion focuses on calculating the cost of pallet storage over five months, specifically using arithmetic progression to determine the total. The user is charged $10 per pallet per month and consumes 2 pallets monthly from an initial order of 10. The total storage cost is calculated as $300 based on the series 10, 8, 6, 4, 2, which sums to 30. The arithmetic progression formula is provided for efficiently calculating the sum of the series. The user expresses gratitude for the clarification and plans to incorporate this into their spreadsheet.
briandewyea
Messages
2
Reaction score
0
Hi,
I am working on building some excel spreadsheets, and need to know the terminology for a math process to help with building formulas. This is the situation I'm working on:
I am charged \$10/pallet of goods per month.
I order 10 pallets of material, of which 2 pallets every month are consumed.
It will take 5 months to go through all my stock.

My question is: What is the term called to figure this out? I know it's 10+8+6+4+2=30...so it will cost \$300 in storage...but I don't know what it's called. Is there some sort of formula I can use, rather than doing it long-hand?

Thanks!
 
Last edited by a moderator:
Mathematics news on Phys.org
I'm guessing the amount of pallets ordered and sold each month is different? If not, you've answered all the questions you need to.
 
briandewyea said:
My question is: What is the term called to figure this out? I know it's 10+8+6+4+2=30...so it will cost \$300 in storage...but I don't know what it's called. Is there some sort of formula I can use, rather than doing it long-hand?
A sequence of numbers that increase or decrease at a constant rate, like 10,8,6,4,2, is called an arithmetic progression. The link in the previous sentence will give you a formula for the sum of the series. The easiest way to state the formula is that you add the first and last terms, multiply by the number of terms, then divide by 2. In the case of your series, that would give $\dfrac{(10+2)\times5}2 = \dfrac{60}2 = 30.$
 
Joppy - Correct, we're continually getting various numbers of pallets of parts that have different amounts on them, all of which are worked down to 0 at different rates

Opalg - Thanks so much! I'll use this link and work that into my spreadsheet. This is exactly what I was looking for!
 
Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
Is it possible to arrange six pencils such that each one touches the other five? If so, how? This is an adaption of a Martin Gardner puzzle only I changed it from cigarettes to pencils and left out the clues because PF folks don’t need clues. From the book “My Best Mathematical and Logic Puzzles”. Dover, 1994.
Thread 'Imaginary Pythagoras'
I posted this in the Lame Math thread, but it's got me thinking. Is there any validity to this? Or is it really just a mathematical trick? Naively, I see that i2 + plus 12 does equal zero2. But does this have a meaning? I know one can treat the imaginary number line as just another axis like the reals, but does that mean this does represent a triangle in the complex plane with a hypotenuse of length zero? Ibix offered a rendering of the diagram using what I assume is matrix* notation...
Back
Top