Trend Formula

M

Mario.cortez306

New member
Joined
Dec 3, 2014
Messages
2
Reaction score
0
Points
0
Hello everyone I'm having trouble with this on getting the trend formula and the growth formula for the rest of the year in the book enter a simple trend to calculate the flours projection for October, within is to also project the inventory expenses for milk & butter based on it's relationship to the flours on the hint part said this "Use the Flours for July-Sept as the known x-values and the Flours expense for October as the new x-value" it also goes for the growth but both say to click on cell e13 to create the formula. can some on help me with this thank you
 

Whole Grains Bread
Salem, Oregon Office
Forecasted Inventorey Needs
Actual
Predicted
July
August
September
October
November
December
Flours
 $ 2,250
$ 2,902
$ 1,770
Milk & Buttermilk
 $ 278
$ 358
$ 95
Eggs
 $ 165
$ 213
$ 156
Sugars
 $ 859
$ 908
$ 294
Buttr
 $ 2,142
$ 2,762
$ 1,733
Oil
333.286391
429.764031
214
Oats
 $ 1,565
$ 2,018
$ 535
Cornmeal
1543.7432
991
1528
Yeast
 $ 2,844
$ 3,668
$ 973
Fruit
1566.74
1020
1536
Herbs & Spices
 $ 1,222
$ 576
$ 1,418
 
Not sure if I got you correct, but you can try this ... HTH

=TREND($I8:$K8,I$7:K$7,L$7)
JulyAugustSeptemberOctoberNovemberDecember
Flours$2,250.00 $2,902.00 $1,770.00 $1,570.00 $1,590.00 $1,670.00
Milk & Buttermilk$278.00 $358.00 $95.00 $77.04 $211.05 $247.95
Eggs$165.00 $213.00 $156.00 $139.88 $182.91 $174.66
Sugars$859.00 $908.00 $294.00 $307.02 $557.04 $716.16
Buttr$2,142.00 $2,762.00 $1,733.00 $1,540.30 $2,204.61 $2,186.34
Oil$333.29 $429.76 $214.00 $186.96 $310.97 $324.90
Oats$1,565.00 $2,018.00 $535.00 $432.97 $1,189.48 $1,396.53
Cornmeal$1,543.74 $991.00 $1,528.00 $1,719.96 $1,268.77 $1,399.71
Yeast$2,844.00 $3,668.00 $973.00 $787.28 $2,162.40 $2,538.25
Fruit$1,566.74 $1,020.00 $1,536.00 $1,726.68 $1,286.02 $1,420.11
Herbs & Spices$1,222.00 $576.00 $1,418.00 $1,630.98 $1,024.16 $1,112.57
 
You must log in or register to reply here.
Back
Top