I'm attempting to calculate some projected numbers out for the next few months using the data below;
On Rows 3, 4, 9, 11, 13, I'd like to correlate the data for each month to the row 17, total tech, data. Row 17 I know definitively for each future month, and am trying to correlate how those increasing amounts affect the projected totals for each of rows 3,4,9,11,13.
I've tried FORECAST, TREND, and GROWTH, but am not returning realistic projected totals for each row for each month.
Am I going about this wrong? Any ideas?
On Rows 3, 4, 9, 11, 13, I'd like to correlate the data for each month to the row 17, total tech, data. Row 17 I know definitively for each future month, and am trying to correlate how those increasing amounts affect the projected totals for each of rows 3,4,9,11,13.
I've tried FORECAST, TREND, and GROWTH, but am not returning realistic projected totals for each row for each month.
Am I going about this wrong? Any ideas?
Primary FSL Activity Volume and Headcount Projection.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | |||
2 | DATA | Jan-05 | Feb-05 | Mar-05 | Apr-05 | May-05 | Jun-05 | Jul-05 | Aug-05 | Sep-05 | ||
3 | PlugTotalRequests-includingSecondaries | 24 | 302 | 378 | 555 | 540 | ||||||
4 | Non-PlugTotalRequests-includingSecondaries | 44 | 160 | 315 | 289 | 244 | ||||||
5 | TotalRequests | 68 | 462 | 693 | 844 | 784 | 0 | 0 | ||||
6 | PlugRequestsPerDay | 3 | 14 | 18 | 25 | 27 | 0 | 0 | ||||
7 | Non-PlugRequestsPerDay | 5 | 8 | 15 | 13 | 12 | 0 | 0 | ||||
8 | TotalRequestsperDay | 8 | 22 | 33 | 38 | 39 | 0 | 0 | ||||
9 | ReplenishmentBoxes | 320 | 165 | 98 | 111 | 188 | ||||||
10 | ReplenishmentBoxesPerDay | 36 | 8 | 5 | 5 | 9 | 0 | 0 | ||||
11 | P&HBoxesInbound | 268 | 444 | 474 | 524 | 538 | ||||||
12 | P&HBoxesInboundPerDay | 30 | 21 | 23 | 24 | 27 | 0 | 0 | ||||
13 | P&HBoxesOutbound | 203 | 412 | 561 | 484 | 526 | ||||||
14 | P&HBoxesOutboundPerDay | 23 | 20 | 27 | 22 | 26 | 0 | 0 | ||||
15 | WorkDays | 9 | 21 | 21 | 22 | 20 | 23 | 21 | ||||
16 | FSLAHeadcount | 4 | 4 | 4 | 5 | 5 | 5 | 5 | ||||
17 | TotalTechsServedfromPrimary | 721 | 721 | 1,281 | 1,281 | 1,652 | 1,652 | 2,215 | ||||
ANTIOCH |