Jubilees Yogurt Shoppe sells a variety of single-serve frozen yogurt flavors and toppings. The owner of Jubilees
Question:
Jubilee’s Yogurt Shoppe sells a variety of single-serve frozen yogurt flavors and toppings.
The owner of Jubilee’s is trying to forecast its frozen yogurt sales for the upcoming year.
The owner suspects that the number of times that Jubilee’s is mentioned in any news or social media each week helps to predict the sales volume in quarts of its frozen yogurt.
The owner has gathered the weekly sales volume of frozen yogurt from the past year and the number of media mentions in those same weeks. The following is a sample of the table of the records in that Excel file. Access the full data set online in the MyLab Accounting exercise.
Requirement:
Using the full data set online and Excel, perform the following tasks and answer the questions.
1. Use the FORECAST.LINEAR function to predict sales volume at the levels of 425, 450, and 475 media mentions.
2. Does it appear that the number of media mentions will be a good predictor of sales of frozen yogurt? How can you tell?
3. How many quarts of frozen yogurt could Jubilee’s expect to sell if there were 460 mentions of Jubilee’s frozen yogurt in news and social media in a given week?
Step by Step Answer:
