If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Convert Turn Rate to Weekly Supply
A1 = Monthly Inventory Value of 12
A2 = Monthly Cost of Goods Sold of 3 A3 = =A1*12/A2 [this give me the turn rate of: 3 To calculate the weeks supply of product I would use the following formula: =A1/SUM(SUM(A2*12)/52) [this gives me 17.333 weeks supply] It would be helpful to have a calculation that could arrive at the weeks supply without having to have access to both the Inventory Value or the Cost of Goods Sold. Is it possible to calculate the Weeks supply with only the turn rate and one of the other two? In other words if all you had was the turn rate and the inventory or just the turn rate and the cost of goods sold, could you come up with the weeks supply? |
#2
|
|||
|
|||
Convert Turn Rate to Weekly Supply
=A3/144*52
-- __________________________________ HTH Bob "Joe" wrote in message ... A1 = Monthly Inventory Value of 12 A2 = Monthly Cost of Goods Sold of 3 A3 = =A1*12/A2 [this give me the turn rate of: 3 To calculate the weeks supply of product I would use the following formula: =A1/SUM(SUM(A2*12)/52) [this gives me 17.333 weeks supply] It would be helpful to have a calculation that could arrive at the weeks supply without having to have access to both the Inventory Value or the Cost of Goods Sold. Is it possible to calculate the Weeks supply with only the turn rate and one of the other two? In other words if all you had was the turn rate and the inventory or just the turn rate and the cost of goods sold, could you come up with the weeks supply? |
#3
|
|||
|
|||
Convert Turn Rate to Weekly Supply
Perhaps, Joe, you could give us a clue what you intended the two SUM
functions to achieve in =A1/SUM(SUM(A2*12)/52) when you haven't given the function a number of arguments to sum? Why not just =A1/((A2*12)/52) ? If you don't understand what the SUM function does, look it up in Excel help. -- David Biddulph Joe wrote: A1 = Monthly Inventory Value of 12 A2 = Monthly Cost of Goods Sold of 3 A3 = =A1*12/A2 [this give me the turn rate of: 3 To calculate the weeks supply of product I would use the following formula: =A1/SUM(SUM(A2*12)/52) [this gives me 17.333 weeks supply] It would be helpful to have a calculation that could arrive at the weeks supply without having to have access to both the Inventory Value or the Cost of Goods Sold. Is it possible to calculate the Weeks supply with only the turn rate and one of the other two? In other words if all you had was the turn rate and the inventory or just the turn rate and the cost of goods sold, could you come up with the weeks supply? |
#4
|
|||
|
|||
Convert Turn Rate to Weekly Supply
David Biddulph wrote:
Perhaps, Joe, you could give us a clue what you intended the two SUM functions to achieve in =A1/SUM(SUM(A2*12)/52) when you haven't given the function a number of arguments to sum? Why not just =A1/((A2*12)/52) ? or, of course, =A1/(A2*12/52) If you don't understand what the SUM function does, look it up in Excel help. Joe wrote: .... To calculate the weeks supply of product I would use the following formula: =A1/SUM(SUM(A2*12)/52) [this gives me 17.333 weeks supply] .... -- David Biddulph |
#5
|
|||
|
|||
Convert Turn Rate to Weekly Supply
I goofed and had one of the formulas backwards
Original: A3 = =A1*12/A2 [this give me the turn rate of: 3 Corrected: A3 = =A2*12/A1 [this give me the turn rate of: 3 I'm not sure if that had anything to do with it or not but weeks supply using these numbers is 17.333. Your formula =A3/144*52 returns 1.0833. "Bob Phillips" wrote: =A3/144*52 -- __________________________________ HTH Bob "Joe" wrote in message ... A1 = Monthly Inventory Value of 12 A2 = Monthly Cost of Goods Sold of 3 A3 = =A1*12/A2 [this give me the turn rate of: 3 To calculate the weeks supply of product I would use the following formula: =A1/SUM(SUM(A2*12)/52) [this gives me 17.333 weeks supply] It would be helpful to have a calculation that could arrive at the weeks supply without having to have access to both the Inventory Value or the Cost of Goods Sold. Is it possible to calculate the Weeks supply with only the turn rate and one of the other two? In other words if all you had was the turn rate and the inventory or just the turn rate and the cost of goods sold, could you come up with the weeks supply? |
#6
|
|||
|
|||
Convert Turn Rate to Weekly Supply
Thank you for your help in simplifing =A1/SUM(SUM(A2*12)/52) but that really
is not the problem I am trying to solve. I am trying to come up with a formula that will allow me to back into the weeks supply without have to have both the inventory and the cost of goods sold at the same time by using the turn rate as a substitute for one of them. Thanks "David Biddulph" wrote: David Biddulph wrote: Perhaps, Joe, you could give us a clue what you intended the two SUM functions to achieve in =A1/SUM(SUM(A2*12)/52) when you haven't given the function a number of arguments to sum? Why not just =A1/((A2*12)/52) ? or, of course, =A1/(A2*12/52) If you don't understand what the SUM function does, look it up in Excel help. Joe wrote: .... To calculate the weeks supply of product I would use the following formula: =A1/SUM(SUM(A2*12)/52) [this gives me 17.333 weeks supply] .... -- David Biddulph |
#7
|
|||
|
|||
Convert Turn Rate to Weekly Supply
You will need to spell it all out again because none of it makes any sense
now. The formula you give now returns 3 not 17.333. -- __________________________________ HTH Bob "Joe" wrote in message ... I goofed and had one of the formulas backwards Original: A3 = =A1*12/A2 [this give me the turn rate of: 3 Corrected: A3 = =A2*12/A1 [this give me the turn rate of: 3 I'm not sure if that had anything to do with it or not but weeks supply using these numbers is 17.333. Your formula =A3/144*52 returns 1.0833. "Bob Phillips" wrote: =A3/144*52 -- __________________________________ HTH Bob "Joe" wrote in message ... A1 = Monthly Inventory Value of 12 A2 = Monthly Cost of Goods Sold of 3 A3 = =A1*12/A2 [this give me the turn rate of: 3 To calculate the weeks supply of product I would use the following formula: =A1/SUM(SUM(A2*12)/52) [this gives me 17.333 weeks supply] It would be helpful to have a calculation that could arrive at the weeks supply without having to have access to both the Inventory Value or the Cost of Goods Sold. Is it possible to calculate the Weeks supply with only the turn rate and one of the other two? In other words if all you had was the turn rate and the inventory or just the turn rate and the cost of goods sold, could you come up with the weeks supply? |
#8
|
|||
|
|||
Convert Turn Rate to Weekly Supply
Ok here it is:
A B C D 1 2 12 3 3 17.333 Cells A2 and B2 are values entered: A2: 12 B2: 3 Cells C2 and D2 are formulas: C2: =B2*12/A2 [which returns 3] D2: =A2/(SUM(B2*12)/52) [which returns 17.333] A2 = Inventory B2 = Cost of Goods Sold C2 = Turn Rate D2 = Weeks Supply Is it possible to come up with D2 (Weeks Supply) by using only A2 (Inventory) and C2 (Turn Rate) or by using only B2 (Cost of Goods Sold) and C2 (Turn Rate)? "Bob Phillips" wrote: You will need to spell it all out again because none of it makes any sense now. The formula you give now returns 3 not 17.333. -- __________________________________ HTH Bob "Joe" wrote in message ... I goofed and had one of the formulas backwards Original: A3 = =A1*12/A2 [this give me the turn rate of: 3 Corrected: A3 = =A2*12/A1 [this give me the turn rate of: 3 I'm not sure if that had anything to do with it or not but weeks supply using these numbers is 17.333. Your formula =A3/144*52 returns 1.0833. "Bob Phillips" wrote: =A3/144*52 -- __________________________________ HTH Bob "Joe" wrote in message ... A1 = Monthly Inventory Value of 12 A2 = Monthly Cost of Goods Sold of 3 A3 = =A1*12/A2 [this give me the turn rate of: 3 To calculate the weeks supply of product I would use the following formula: =A1/SUM(SUM(A2*12)/52) [this gives me 17.333 weeks supply] It would be helpful to have a calculation that could arrive at the weeks supply without having to have access to both the Inventory Value or the Cost of Goods Sold. Is it possible to calculate the Weeks supply with only the turn rate and one of the other two? In other words if all you had was the turn rate and the inventory or just the turn rate and the cost of goods sold, could you come up with the weeks supply? |
#9
|
|||
|
|||
Convert Turn Rate to Weekly Supply
To calculate weeks' supply from turn rate, use:
=52/a3 Where a3 is your turn rate. You don't need either inventory or COGS. Regards, Fred. "Joe" wrote in message ... A1 = Monthly Inventory Value of 12 A2 = Monthly Cost of Goods Sold of 3 A3 = =A1*12/A2 [this give me the turn rate of: 3 To calculate the weeks supply of product I would use the following formula: =A1/SUM(SUM(A2*12)/52) [this gives me 17.333 weeks supply] It would be helpful to have a calculation that could arrive at the weeks supply without having to have access to both the Inventory Value or the Cost of Goods Sold. Is it possible to calculate the Weeks supply with only the turn rate and one of the other two? In other words if all you had was the turn rate and the inventory or just the turn rate and the cost of goods sold, could you come up with the weeks supply? |
#10
|
|||
|
|||
Convert Turn Rate to Weekly Supply
Try
=52/C2 -- __________________________________ HTH Bob "Joe" wrote in message ... Ok here it is: A B C D 1 2 12 3 3 17.333 Cells A2 and B2 are values entered: A2: 12 B2: 3 Cells C2 and D2 are formulas: C2: =B2*12/A2 [which returns 3] D2: =A2/(SUM(B2*12)/52) [which returns 17.333] A2 = Inventory B2 = Cost of Goods Sold C2 = Turn Rate D2 = Weeks Supply Is it possible to come up with D2 (Weeks Supply) by using only A2 (Inventory) and C2 (Turn Rate) or by using only B2 (Cost of Goods Sold) and C2 (Turn Rate)? "Bob Phillips" wrote: You will need to spell it all out again because none of it makes any sense now. The formula you give now returns 3 not 17.333. -- __________________________________ HTH Bob "Joe" wrote in message ... I goofed and had one of the formulas backwards Original: A3 = =A1*12/A2 [this give me the turn rate of: 3 Corrected: A3 = =A2*12/A1 [this give me the turn rate of: 3 I'm not sure if that had anything to do with it or not but weeks supply using these numbers is 17.333. Your formula =A3/144*52 returns 1.0833. "Bob Phillips" wrote: =A3/144*52 -- __________________________________ HTH Bob "Joe" wrote in message ... A1 = Monthly Inventory Value of 12 A2 = Monthly Cost of Goods Sold of 3 A3 = =A1*12/A2 [this give me the turn rate of: 3 To calculate the weeks supply of product I would use the following formula: =A1/SUM(SUM(A2*12)/52) [this gives me 17.333 weeks supply] It would be helpful to have a calculation that could arrive at the weeks supply without having to have access to both the Inventory Value or the Cost of Goods Sold. Is it possible to calculate the Weeks supply with only the turn rate and one of the other two? In other words if all you had was the turn rate and the inventory or just the turn rate and the cost of goods sold, could you come up with the weeks supply? |
|
Thread Tools | |
Display Modes | |
|
|