LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Days until exhuast

Just as an example, let's say I'm a rental company that rents tools
for long periods of time. I want to understand how many tools are
being rented, how many I have left in inventory still available to
rent, and when I am going to exhaust my inventory. So for instance, I
have the following three primary fields:

1. Number of tools out for rent.
2. Number of tools in inventory still available for rent.
3. Sales growth month over month.

So using the sales growth, I should be able to roughly predict when I
am going to run out of inventory (assuming my sales growth is going to
continue to rise.)

I can't wrap my head around the logic to be honest. The variable I
want is the number of days left until I am going to run out of tools
for run.

Any Ideas?

 
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
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made rhhince Excel Worksheet Functions 1 January 14th 07 09:56 PM
i have two days and i want the difference in days, months, year maja Excel Worksheet Functions 7 April 22nd 06 01:14 AM
Convert days in decimal to days:hours:minutes Todd F. Excel Worksheet Functions 7 March 16th 06 07:17 PM
Convert decimal days to Days,hours, minutes Todd F. Excel Worksheet Functions 3 March 14th 06 03:38 PM
convert Days to Years, Months, Days Klaudebou Excel Discussion (Misc queries) 3 December 29th 05 10:33 PM


All times are GMT +1. The time now is 04:54 AM.

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

About Us

"It's about Microsoft Excel"