Results 1 to 3 of 3

Thread: Trend Formula

  1. #1

    Lightbulb Trend Formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    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

  3. #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
  •