FORECAST, TREND, GROWTH? Which should I use?

DAGGERGA

New Member
Joined
Aug 12, 2005
Messages
14
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?
Primary FSL Activity Volume and Headcount Projection.xls
ABCDEFGHIJ
1123456789
2DATAJan-05Feb-05Mar-05Apr-05May-05Jun-05Jul-05Aug-05Sep-05
3PlugTotalRequests-includingSecondaries24302378555540
4Non-PlugTotalRequests-includingSecondaries44160315289244
5TotalRequests6846269384478400
6PlugRequestsPerDay31418252700
7Non-PlugRequestsPerDay5815131200
8TotalRequestsperDay82233383900
9ReplenishmentBoxes32016598111188
10ReplenishmentBoxesPerDay36855900
11P&HBoxesInbound268444474524538
12P&HBoxesInboundPerDay302123242700
13P&HBoxesOutbound203412561484526
14P&HBoxesOutboundPerDay232027222600
15WorkDays9212122202321
16FSLAHeadcount4445555
17TotalTechsServedfromPrimary7217211,2811,2811,6521,6522,215
ANTIOCH
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Forum statistics

Threads
1,215,327
Messages
6,124,281
Members
449,149
Latest member
mwdbActuary

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top