Calculate weeks of supply

[ravi567]

· Starting inventory TY 3000 ea
· Starting Inventory LY 4000 ea
· No upcoming receipts planned TY
· No additional Inventory received LY
· Last 4 weeks sales TY 2000 ea
· Last 4 weeks sales LY 1000 ea
· Last 4 weeks sales Plan 1500 ea
· TY week 2 had promo and sold 1000 ea Vs 500 ea same week last year
· Upcoming 4 weeks sales LY 1500 ea


We need to carry 8 months of stock. How many inventories would be required based on above scenario?
TY, LY = This year, last year
ea = each
inventory is basically stock.


I am not able to determine avg sales per week because of that promo. That promo built up the sales during week 2

 

[stapel]

· Starting inventory TY 3000 ea
· Starting Inventory LY 4000 ea
· No upcoming receipts planned TY
· No additional Inventory received LY
· Last 4 weeks sales TY 2000 ea
· Last 4 weeks sales LY 1000 ea
· Last 4 weeks sales Plan 1500 ea
· TY week 2 had promo and sold 1000 ea Vs 500 ea same week last year
· Upcoming 4 weeks sales LY 1500 ea

We need to carry 8 months of stock. How many inventories would be required based on above scenario?

Are you able at least to get started? If so, kindly please reply with your efforts so far. Thank you!