Q22 please help me The following are historical demand data:YEAR2 years agolast yearSEASONSpringSummerFallWinterSpringSummerFallWinterACTUALDEMAND203*144382565471271686955Use regression analysis and seasonal indexes to forecast this summer's demand.Note: Do not round intermediate calculations. Round your answer to the nearest whole number.Forecast for this summer's demand

I have calculated this problem using excel. I have attached a screenshot of my calculation in excel…

The following are historical demand data: YEAR 2 years ago last year SEASON Spring Summer Fall Winter Spring Summer Fall Winter ACTUAL DEMAND 203 144 382 565 Forecast for this summer's demand 471 271 686 955 Use regression analysis and seasonal indexes to forecast this summer's demand. Note: Do not round intermediate calculations. Round your answer to the nearest whole number.

The following are historical demand data: YEAR 2 years ago last year SEASON Spring Summer Fall Winter Spring Summer Fall Winter ACTUAL DEMAND 203 144 382 565 Forecast for this summer's demand 471 271 686 955 Use regression analysis and seasonal indexes to forecast this summer's demand. Note: Do not round intermediate calculations. Round your answer to the nearest whole number.

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)

14th Edition

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Chapter4: Estimating Demand

Section: Chapter Questions

Problem 5E

See similar textbooks

Similar questions

Consider the following actual and forecast demandlevels for Big Mac hamburgers at a local McDonald’s restaurant:DAY ACTUAL DEMAND FORECAST DEMANDMonday 88 88Tuesday 72 88Wednesday 68 84Thursday 48 80FridayThe forecast for Monday was derived by observing Monday’sdemand level and setting Monday’s forecast level equal to this demand level. Subsequent forecasts were derived by using expo-nential smoothing with a smoothing constant of 0.25. Using this exponential smoothing method, what is the forecast for Big Macdemand for Friday?
d. If the director used these 4 weeks of data to create a linear regression, what does that linear regression formula suggest for this week's forecast of employee appointments? What does the regression analysis suggest in general about employee appointments for Director Very Busy?
In your company (electrical goods manufacturing), you want to forecast demand as well of a particular range of Smart TVs. Its monthly sales previous year, are presented in the table below: Month Sales January 400 February 650 March 1,150 April 1,700 May 500 June 900 July 1,150 August 1900 September 600 October 650 November 1,600 December 2050 Based on the above historical sales data: A) Create the corresponding graph and comment on the demand (sales) in terms of in trend, seasonality and periodicity please draw the diagram!!!!
A company wants to use regression analysis to forecast the demand for the next quarter.In such a regression model, demand would be the independent variable. True or false?a. Trueb. False
The demand of a product of a company is given below for the periods. Can we use Winter method for forecasting demands of the A following 3 periods? Why? If yes, apply it past 4. 6. Demand 27 31 40 31 35 45
I Consider the demand for trading cards listed below. Month Demand Jan. 51,000 48,000 Feb. March 55,000 April May 58,000 66,000 June 69,000 80,000 July Aug. 95,000 Use Excel to prepare a forecast for September, October, and November using linear regression Print out the sheet of results, as well as a sheet containing the formulas that you used ( can be used to toggle between displaying values and displaying formulas or you can click on Formulas>Formula Auditing→Show Formulas.) and for the cars is 16.000
Forecast the demand for the rice for a country for the year 2019 on the basis of 7-year data given in table: Year 2012 2013 2014 2015 2016 2017 2018 Population (millions) 10 12 15 20 25 30 40 Rice consumed (million tonnes) 40 50 60 70 80 90 100
Economics You own a restaurant near the beach. Business has been growing each year, but obviously spikes during the summer months. A regression produces the following equation: M = 30,000 + 500t + 1,000S Where M is monthly sales, t is years past 2010, and S is a dummy variable for the summer months. If the month is June, July, or August, insert a "1". If not, the value for S is zero. What are the predicted sales for July 2020? Enter as a value.
Which are behavioural equations in the model?
Based on the information in the following table, use the Exponential Smoothing Approach (a = 0.5) to forecast the demand for periods 4-11 PERIOD MONTH Demand Forecast Jan 89 2. Feb 151 89 3 Mar 60 120 4. Apr 107 May 131 9. Jun 140 7 Jul 71 8. Aug 94 sep 102 10 Oct 119 11 Nov
Q3. You are working as a researcher in an economic Institute, you want to study the relation between the Unit sales as a Dependent variable and the following independent variables (selling expenditure, advertising, competitive price) As shown in the following model Unit Sales + = b0+b1 Exp + + b2 Adv t b3 t+ compt + Ut After collecting your data, and estimating your linear regression over the data, you got the following regression equation comp t Unit Sales t = -10.5 - 0.51 Exp + + 0.09 Adv 3.05 b3 t + (2.45) (-1.5) t- value (4.2) (2.94) R² = 0.24 F- Value 0.33 ' 1- What is the economic meaning of the coefficient b0 (-10.5) 2- Describe the meaning of R² and its value, F - Value 3- What do you think about the Model as a whole, with F, R2 values....is it significant or not ....explain your answer
Setting: U.S. Auto manufacturers are trying to develop a multivariate function with which to estimate the demand for their gas-electric hybrid compact cars. Here is one that Motors General developed for its Jolt: Qj = 65000 – 20Pj + 20Pf + 35Pt – 5Pb + 0.2Tc + 0.05Y + 10Mg + 0.04A Where Qj = the number of Jolts demanded per week. Pj = the price of each new Jolt (in $). Pf = the price of each new Ford gas-electric hybrid (in $). Pt = the price of each new Toyota gas-electric hybrid (in $). Pb = the price of replacement batteries for the Jolt (in $). Tc = the amount of tax credit incentive offered with the purchase of a new hybrid (in $). Y = average weekly disposable income of a typical Jolt purchaser (in $). Mg = the miles per gallon of gas rating of the Jolt (in miles per gallon). A = average weekly Jolt advertising expenditure (in $). 6 If all variables remain unchanged except that the price of the Toyota hybrid (Pt) decreases by $500, then the demand for Jolts will: 7…