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$2.70$3.60$1.90Number Sold770505975245315480$4.20$3.20$4.05Using simple linear regression and given that the price per cup is $1.75, the forecasted demand for mocha latte coffees will be cups (enter your response rounded to one decimal place).

Given, Price Number Sold 2.7 770 3.6 550 1.9 975 4.2 245 3.2 315 4.05 480 y =…

Answered: Café Michigan's manager, Gary Stark,…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

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 $2.50 $3.40 $1.90 $4.10 $3.20 $4.00 Number Sold 770 510 975 240 315 475 Using simple linear regression and given that the price per cup is $1.75, the forecasted demand for mocha latte coffees will be (enter your response rounded to one decimal place). cups
14 Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below: Day Bicycle Victims 1 8 2 14 3 8 4 14 5 18 6 15 With an alpha value of 0.31 and a starting forecast in day 3 equal to the 21 , what is the exponentially smoothed forecast for day 4? (Round to two decimal places) 15 What is the exponentially smoothed forecast for day 5? (Round to two decimal places) 16
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 $2.60 $3.50 $1.90 $4.10 $3.00 $4.00 Number Sold 760 515 990 245 320 480 D Using simple linear regression and given that the price per cup is $1.80, the forecasted demand for mocha latte coffees will be to one decimal place). cups (enter your response rounded
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: 3 8 9 6 7 6 3 7 10 11 Year Year Forecast (000) 1 5 1 5 2 5 4 4 4 5 11 Registrations (000) Use exponential smoothing with a smoothing constant of 0.4 to forecast the registrations at the seminar for years 2 through 12. To begin the procedure, assume that the forecast for year 1 was 5,000 people signing up (round your responses to one decimal place): 2 3 5 6 7 8 10 16 9 11 12 10 D 11 12 a) What is the MAD? Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (x) = 0.4 and a starting forecast of F₁ = 5) is thousand registrations (round your response to one decimal place). b) What is the MSE? The mean squared error based on the forecast developed using the exponential smoothing method (with a smoothing constant (x) = 0.4 and a starting forecast of F₁ = 5) is (round your response to two decimal…
A newly operated company producing household items would want to forecast its sales volume for the next month. It has been in operation for ten (10) months now. For the past ten (10) months, forecast and sales data for its top selling Item A are as follow: Time Period Forecasted Value Actual Sales (Quantity) 10th month 405 345 9th month 400 380 8th month 410 400 7th month 370 375 6th month 330 360 5th month 320 325 4th month 320 315 3rd month 305 300 2nd month 290 295 1st month 300 280 The operations manager observes the fluctuations on the sales quantity over the 10-month period that the company is in operation. To forecast for the 11th month, the team decided to evaluate options on what forecasting method to use. Their options are: To use the Moving Average Method using the sales data for the past 10 months, To use the Exponential Smoothing Average assigning a smoothing constant of .6 and To use the Trend-adjusted Exponential Smoothing assigning smoothing constants α =…
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 $2.70 $3.50 $2.10 $4.10 $3.10 $4.05 Number Sold 765 515 990 245 320 480 Using simple linear regression and given that the price per cup is $1.85, the forecasted demand for mocha latte coffees will be cups (enter your response rounded to one decimal place).
Y9
A company wants to generate a forecast for unit demand for year 2017 using exponential smoothing. The actual demand in year 2016 was 120. The forecast demand in year 2016 was 110. Using this data and a smoothing constant alpha of 0.1, which of the following is the resulting year 2017 forecast value?
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: IT Price Number Sold $2.60 $3.60 $2.00 $4.20 $3.10 $4.00 770 505 975 250 315 490 Using simple linear regression and given that the price per cup is $1.85, the forecasted demand for mocha latte coffees will be cups (enter your response rounded to one decimal place).
The manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpet from one of Carpet City's many competitors. The manager has collected the following demand data for the past 8 months: Demand for Soft Shag Month Carpet (1,000 yd.) 1 8 2 12 3 7 4 9 5 15 6 11 7 10 8 12 Compute the exponentially smoothed forecast (a = .20) for the given data. Compute an adjusted exponentially smoothed forecast (with a = .20 and β = .20) for the given data
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year Mileage miles (round your response to the nearest whole number). a) Using a 2-year moving average, the forecast for year 6 = 1 3,050 2 4,000 3 3,450 4 3,750 5 3,750
After using your forecasting model for six months, you decide to test it using a tracking signal. Here are the forecast and actual demands for the six-month period: PERIOD FORECAST ACTUAL May 450 500 June 500 550 July 550 400 August 600 500 September 650 675 October 700 600 Find the tracking signal of each month

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS