goodmachine
Board Regular
- Joined
- Oct 7, 2009
- Messages
- 70
I have a forecasting question that I would like to solve in Excel. I need to be able forecast what the Inventory Completed should be in the future weeks to be at 90% SLA.
For my forecast, I want to know what volume we must complete to get our SLA at 90%, so the Status moves from Yellow to Green.
<tbody>
</tbody>
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
- Date: represents a business week in a calendar month
- Week: represents the first week in a calendar month (i.e., does not start on the 1st of the month, but on the first Monday of the calendar month)
- Inventory completed: represents all of the inventory completed that month (total of all inventory that met/did not meet 7 day SLA)
- < 7 Days: inventory aging less than 7 days
- > 7 Days: inventory aging greater than 7 days
- Status: Yellow if the % at SLA is less than 90%; Green if the % at SLA is 90% or greater
For my forecast, I want to know what volume we must complete to get our SLA at 90%, so the Status moves from Yellow to Green.
Date | Week # | Inventory Completed* | < 7 Days | > 7 Days | % at SLA | Status |
9/4 - 9/8 | 1 | 1000 | 850 | 150 | 85% | Yellow |
9/11 9/15 | 2 | |||||
9/18 - 9/22 | 3 | |||||
9/25 - 9/29 | 4 |
<tbody>
</tbody>
*SLA is 7 days |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>