Question: Instructions: In cell B 3 , enter your full name. Problem: Eliza Bennett, the owner of Sweet Blossom Bakery in Portland, OR , is trying

Instructions:
In cell B3, enter your full name.
Problem:
Eliza Bennett, the owner of Sweet Blossom Bakery in Portland, OR, is trying to predict what cupcake sales will be for the following month,
for each previous month. Eliza is wanting to use Trend Projection as the forecasting method.
In cell G17, use a function to find the slope of the model.
In cell G18, use a function to find the intercept of the model.
In cell G21, use a formula to calculate what the cupcakes Sold in Year 5 would be using the Trend Projection Forecasting technique.
Note: Ensure you are using the slope in G17 and the intercept from G18. Also use the Year located in G20 as "x" in this formula.
 Instructions: In cell B3, enter your full name. Problem: Eliza Bennett,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!