1. ## Trend Formula

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

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

3. Not sure if I got you correct, but you can try this ... HTH

=TREND(\$I8:\$K8,I\$7:K\$7,L\$7)
 July August September October November December 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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•