Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: Price Number Sold $2.70 760 $3.50 510 $2.00 980 $4.20 250 $3.10 320 $4.05 480 a. Using these data, how many mocha latte coffees would be forecast to be sold according to simple linear regression if the price per cup were $2.80? [Select] b. What is the MAD? [Select] c. What is the Coefficient of Determination? [Select] [Select] , and what does that tell you?

Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: Price Number Sold $2.70 760 $3.50 510 $2.00 980 $4.20 250 $3.10 320 $4.05 480 a. Using these data, how many mocha latte coffees would be forecast to be sold according to simple linear regression if the price per cup were $2.80? [Select] b. What is the MAD? [Select] c. What is the Coefficient of Determination? [Select] [Select] , and what does that tell you?

Contemporary Marketing

18th Edition

ISBN:9780357033777

Author:Louis E. Boone, David L. Kurtz

Publisher:Louis E. Boone, David L. Kurtz

Chapter14: Pricing Strategies

Section14.2: Forecasting Demand

Problem 1LO

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
ABC Inc. sells patio sets. Monthly sales for a seven-month period were as follows: Month Sales (000) Unites Feb 19 Mar 18 Apr 15 May 20 Jun 18 Jul 22 Aug 20 Forecast September sales volume using the naive approach.
which of the following would be calculated variable from other data: 1. Product Sales Price 2. Product availability 3. Coupon Availability 4. Average Customer rating
If ABC Corporation has following historical data about sales volume: Years Sales Years Sales Years Sales Years Sales 2001 110 2006 99 2011 100 2016 110 2002 112 2007 101 2012 104 2017 111 2003 122 2008 95 2013 108 2018 109 2004 111 2009 98 2014 102 2019 114 2005 104 2010 96 2015 115 2020 112 Note: All the sale values are in thousands. Required: Which type of forecasting approach is suitable for this type of data? Which forecasting technique is best to employ in order to forecast the above data? And also define the suggested technique. Calculate the predicted values by employing the discussed technique in part (b) on the above data.
ABC Inc. sells patio sets. Monthly sales for a seven-month period were as follows: Month Sales (000) Unites Feb 19 Mar 18 Apr 15 May 20 Jun 18 Jul 22 Aug 20 Forecast September sales volume using a five-month moving average approach.
The marketing manager of a company that manufactures and distributes farming equipment (such as combined harvesters, ploughs and tractors) recorded the number of farming units sold quarterly for the period 2007 to 2010. Table 5 Quarter 2007 2008 2009 2010 Summer 57 60 65 64 Autumn 51 56 60 62 Winter 50 53 58 58 Spring 56 61 68 70 a. Find the quarterly seasonal indexes for farming equipment sold. b. Do seasonal forces significantly influence the sale of farming equipment? Comment. c. Derive a least squares trend line for the sales of farming equipment using a sequential numbering system starting with x = 1 in period 1. d. Prepare seasonally-adjusted trend estimates of the number of farming units that this company can expect to sell in each quarter of 2011.
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. ACTUAL June 154 July August 194 225 a. Using a simple three-month moving average, what is the forecast for September? (Round your answer to 2 decimal places.) Forecast for September 191.00 b. Using a weighted moving average, what is the forecast for September with weights of 0.30, 0.40, and 0.30 for June, July, and August, respectively? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Forecast for September 191.30 c. Using single exponential smoothing and assuming that the forecast for June had been 142, forecast sales for September with a smoothing constant a of 0.30. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Forecast for September
The following table shows the quarterly sales (RM'000) for Afeef Café for the past 3 years. Quarter Year 1 2 4 2019 11 17 10 18 2020 19 24 17 29 2021 23 38 31 33 Based on the above data. (b) Calculate the seasonal indices using the multiplicative model.
8.2 Given the following data, calculate the three-month moving average forecasts for months 4, 5, 6, and 7. Month 1 2 3 4 5 6 7 Actual Demand 60 70 40 50 70 65 Forecast
Source Available at: http://panmore.com/walmart-inventory-management [Accessed 18 July 2022] Reading the above, it becomes clear that good inventory management and forecasting can deliver supply chain success for and could ultimately lead to profitability and growth. In a report you are required to evaluate the importance of forecasting for Walmart Your report, must include but is limited to the following: • The importance of forecasting to Walmart. • Examine if a combination of both qualitative and quantitative forecasting may be best suited. • Argue the relevance of cloud-based forecasting for Walmart. NB: • The marks allocated next to each concept in the rubric below should serve only as a guide to the depth your discussion should cover. Your answer should be a minimum of 1 200 to a maximum of 1 500 words. Markers are to stop marking after the threshold of 1 500 words (two-and-a-half to three pages) has been reached. Please indicate the word count at the end of your answer. • You…
How would a fast-moving consumer good (FMCG) retailer use collaborative forecasting to improve supply chain performance? 1) manufacturer new product introductions can be better integrated with category assortment plans 2) retail promotional plans can be shared with suppliers to reduce the bullwhip effect 3) retail promotional plans can be shared with suppliers to ensure adequate availability 4) all of the above
Year Season Sales 2018 Winter 40 2018 Spring 29 2018 Summer 31 2018 Fall 40 2019 Winter 102 2019 Spring 87 2019 Summer 96 2019 Fall 132 2020 Winter 105 2020 Spring 93 2020 Summer 105 2020 Fall 117 2021 Winter 141 2021 Spring 39 2021 Summer 114 2021 Fall 123 What is the slope of the trend equation obtained by linear regression? Round to two decimal digits. What is the intercept of the trend equation obtained by linear regression? Round to two decimal digits. What is the seasonal index for Spring? Round to two decimal digits. The quarter number for Winter of 2018 is 1. What is the quarter number for Spring of 2025? What is the trend based forecast for Spring of 2025. Round to a whole number. What is the seasonally adjusted trend based forecast for Spring of 2025? Please do not use excel to find the slope and intercept, thank you so much!