The H.W. Grant Corporation used regression analysis to predict the annual cost of indirect materials. The results were as follows:Indirect Materials Cost Explained by Units ProducedConstant$15,675Standard error of Y estimate$3,5000.7776Number of observations16X coefficient(s)10.25Standard error of coefficient(s)2.195What is the cost estimation equation?O A. Y= $12,175 + $10.25XO B. Y= $3,500 + $7.97XO C. Y= $19,175 + $4.67XO D. Y= $15,675 + $10.25X

Answered: The H.W. Grant Corporation used…

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

A marketing analyst wants to examine the relationship between sales (in $1,000s) and advertising (in $100s) for firms in the food and beverage Industry and collects monthly data for 25 firms. He estimates the model Sales-o Advertising. The following ANOVA table shows a portion of the regression results. Regression Residual df 1 23 55 78.53 504.02 MS 78.53 21.91 T 3.58
An auditor used regression analysis to evaluate the relationship between utility costs andmachine hours. The following information was developed using a computer softwareprogram: Intercept 2,050 Standard error of estimate 200Regression 0.825 Number of observations 36Correlation coefficient 0.800 How much is the utility cost if the company’s 10 machines will use 2,400 hours next month?a. ₱3,830b. ₱3,970c. ₱4,030d. ₱4,050
2. Given the data below, forecast Year Mileage 3000 3800 3500 3800 3700 12345 a. the 6th year using the weighted moving average w/weights.7.&.3 b.The 6th year using Exponential Smoothing with F1 =3000 and alpha = .7 c.Calculate the MAD for a and b, tell me which one is the best model d. Calculate the regression line, the forecast for the 6th and the 12th years, the residual of the 4th year, and tell me if it is s good or a bad model
d. Now based on regression analysis predict the number of patients that Dr. Fok will see in year 11 and 12 based on the forecasted Robbery Rate - year 11 is 117.1 and year 12 is 120.8. e. What is the MAD? f. What is the correlation Coefficient – r-value? % g. Based on the overall analysis, how well does each model fit the data?
Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $14.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR I II III IV QUANTITY (UNITS) Y = 14 20 28 18 QUARTER THIS YEAR I II III IV QUANTITY (UNITS) 20 26 30 15 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) > Answer is complete but not entirely correct. 18.535 X + 0.630 t
Da
Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the past 12 months were as follows: a) Use a 2-month moving average on all the data and plot the averages and the prices.b) Use a 3-month moving average a nd add the 3-month plot to the graph created in part (a).c) Which is better (using the mean absolute deviation): the 2-month average or the 3-month average?d) Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of $1.80. Use a = .I, then a = .3, and finally a = .5. Using MAD, whicha is the best?
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Sales (1,000s of gallons) Week 1 17 2 21 3 19 23 5 18 6 16 7 21 8 19 9 23 10 21 11 16 12 23 (a) Using a weight of - for the most recent observation, for the second most recent observation, and - for third most recent observation, compute a three-week weighted moving average for the time series. (Round your answers to two decimal places.) Time Series Value Weighted Moving Average Forecast Week 1. 17 2 21 19 4 23 5 18 6 16 7 21
Apple Corporation is planning to produce their new product called the next generation low cost iPhone the said product will compete the product lines of Samsung, the management is hoping that it will further increase their revenue starting 2nd Quarter of 2021 Below is the historical data of actual sales and forecast of iPhone last 2020: Forecast Sales in Million Actual sales in Million Month Units Units Jan 51 55.3 Feb 52 54.1 Mar 53 62.3 Apr 55 61.1 May 57 58.6 June 60 59.2 July 62 67.3 Aug 65 70.2
I posted this question and it's been 18 hours that it still hasn't been answered. I only need the last two questions please (:
Q3. Find forecasted value for 2017 using a = 0.5 and a = 0.7 using exponential smoothing method. Which a is better (10 Years Sales Forecasted sale 2012 25 2013 17 2014 2015 30 2016 27 2017 21
Q30

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