LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to convert a weekly data series to monthly jhstone711 Excel Discussion (Misc queries) 1 February 2nd 09 08:50 PM
how do i convert a flat rate into a reducing rate? Sumit Shekhar Excel Worksheet Functions 1 September 17th 08 12:56 PM
I have year based data want to convert into weekly basis Aadhya Excel Worksheet Functions 1 July 23rd 08 11:12 AM
How can I convert a time calc into an overtime pay rate Dic Hill Excel Discussion (Misc queries) 1 November 13th 07 08:45 PM
subtraction of times, convert & multiply by a conditioned rate sanscull Excel Worksheet Functions 6 May 20th 05 02:02 AM


All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"