Cost and volume analysis and Forecasting

---

---

For a list of 3000 batch numbers we have the total number of pages received and the total number of pages not printed for each batch. Would like to determine the delta for avg number of pages not printed for each bucket per batch(ex: bucket #1 total pages 1-50 pages and not printed average for those records was x amt) and the avg cost savings is x amt. Additionally what the percent of the total is that bucket from the sample for that bucket (ex: 1-50 was 10% of the sample) using this information would like to determine a potential forecast for future savings if 1100 batches are received in a month with a month to month savings. The sample provided was over a 3 year span. The cost to print per page is identified in the spreadsheet

Price: $100.0

Forecasting Business Modeling Microsoft Excel