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 B 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 G use a function to find the slope of the model.
In cell G use a function to find the intercept of the model.
In cell G use a formula to calculate what the cupcakes Sold in Year would be using the Trend Projection Forecasting technique.
Note: Ensure you are using the slope in G and the intercept from G Also use the Year located in G as x in this formula.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
