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.

Requirements
1. Use the FORECAST.LINEAR function to predict new product sales 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?

Transcribed Image Text:

1 Week 1 2 3 4 23 4 A 56789 5678 10 11 9 10 B Number of Media Mentions 420 496 208 222 498 460 72 483 157 446 C Frozen Yogurt Sales Volume (Quarts) 681 877 578 617 754 716 528 728 524 700