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
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
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
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 (:
Asvnch Problem - Statistical Forecasting Data Set – Eunice BC Fashion Monthly Sales, in million units. Year Total Sales Year Total Sales 2010 38 2016 43 2011 41 2017 40 2012 40 2018 45 2013 45 2019 47 2014 50 2020 42 2015 42 2021 48 Questions: a. Find the naïve forecast. b. Use the 3 years moving average forecast. c. Have a 5 years weighted moving average. d. Develop forecast using exponential smoothing with a = 0.2. e. Determine the trend line equation and present the forecast. f. Find the best forecast for year 2022. Note: Use the first 5 years as the training samples and the last 5 years as the forecasting samples. Solve it in Excel Sheet/Sheet with Equations as possible.
45 A forecasting method has produced the following over the past five months. What is the mean absolute deviation? Actual Forecast Error |Error| 10 11 -1 1 8 10 -2 2 10 8 2 2 6 6 0 0 9 8 1 1 Select one: a. -0.2 b. 1.2 c. 8.6 d. -1.0 e. 0.0
Your company is preparing an estimate of its production costs for the coming period. The controller estimates that direct materials costs are $45 per unit and that direct labor costs are $23 per hour. Estimating overhead, which is applied on the basis of direct labor costs, is difficult. The controller's office estimated overhead costs at $4,000 for fixed costs and $17 per unit for variable costs. Your colleague, Lance, who graduated from a rival school, has already done the analysis and reports the "correct" cost equation as follows. Overhead = $10,511 + $15.94 per unit Lance also reports that the correlation coefficient for the regression is 0.81 and says, "With 81% of the variation in overhead explained by the equation, it certainly should be adopted as the best basis for estimating costs." When asked for the data used to generate the regression, Lance produces the following: Month LEMASTOSOHN3 1 2 4 5 6 7 8 9 10 11 12 13 Overhead Unit Production $57,064 60,683 77,008 56,624 81,700…
Using linear regression analysis, what would you estimate demand to be for each month next year? Month Forecast January February March April May June July August September October November December
What is the seasonal relative for the summer? (Please keep 3 decimal places for your answer)

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