Felix & Company reports the following information.Period1567698AWNH23410Units Produced0Cost equation =4608601,2601,6602,0602,4602,8603,2603,660Total Costs$ 4,5603,8604,2604,8603,9604,1608,66016,0604,86010,782Use spreadsheet software to use ordinary least-squares regression to estimate the cost equation, including fixed and variable costamounts.per unit

Here 2 independent variable are present i.e. time and number of units produced. We can make it a…

Answered: Felix & Company reports the following…

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

4) A small manufacturing firm has recorded a time series of the cost per unit for the firm's leading product over the past eight years. Year Cost/Unit($) 1 2 3 4 5 6 7 8 20 24.5 28.2 27.5 26.6 30 31 36 a) If you are not given a base value or trend, what would be the forecast for the year 10 made at the end of year 8 (a=0.2, ß=0.4). b) Forecast for the year 9 using 1) 5-month weighted average using 0.1,0.1,0.1,0.2,0.3, with the heaviest weight applied to the recent month 2) Exponential smoothing using a =0.2 and forecast of 21 for year 5 3) If a value was not provided in the question above, what value of a would you choose?
Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 315 February 418 March 390 April 430 May 400 [ June 480 July 430 August 320 September 385 October 530 November 592 555 December 300 400 350 460 390 395 355 245 340 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third 0.25. Do the problem using quarters, as opposed to forecasting separate months. (Round your answer to 2 decimal places.) Forecast for the fourth quarter
Consider the following from an estate agent business: Month Houses Sold Jan 380 Feb 360 Mar 390 Apr 400 May 390 June 380 July 394 Aug 454 Sep 460 Oct 460 Nov 430 Dec 370 a) Calculate the three point moving averages (quarters) and seasonal variation for the above data b) A detective figures he has a one in nine chance of recovering stolen property. His out-of-pocket expenses for the investigation are $9,000. If he is paid his fee only if he recovers the stolen property, what should he charge clients in order to breakeven? c) At the races, your horse, has a probability of 1/20 of coming 151, 1/10 of coming 2nd and a probability of ¼ in coming 3rd. First place pays $4,500 to the winner, second place $3,500 and third place $1,500. Hence, is it worth entering the race if it costs $1,000? d) Your company plans to invest in a particular…
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
The following data are for calculator sales in units at an electronics store over the past nine weeks: Week 1 2 3 4 5 Obtain the error measures. (Enter your responses rounded to two decimal places.) CFE MSE Sales Find the coefficient of determination (²). The coefficient of determination r² = 0. (Enter your response rounded to two decimal places.) 44459 46 51 58 Use trend projection with regression to forecast sales for weeks 10-13. What are the error measures (CFE, MSE, 6, MAD, and MAPE) for this forecasting procedure? How about r²? Obtain the trend projection with regression forecast for weeks 10-13. (Enter your responses rounded to two decimal places.) Forecast, Ft Period 10 11 12 13 Week 6 69809 7 Sales 54 63 53 61 MAD U MAPE %
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: D Price $2.50 $3.40 $2.10 $4.30 $3.00 $4.10 Using 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). Number Sold 765 515 975 245 315 480
a) Using the trend-projection (regression) method, develop a forecastfor the sales of Volkswagen Beetles in Nevada through year 6.b) What is the MAD?~c) What is the MSE?
A forecasting method has produced the following over the past five months. What is the mean absolute percentage error (MAPE)? Actual 11 OA. 0.00% B. 31.87% 5178 11 13 Forecast 13 10 30668 $7
9
Chart and Regression analysis : What does the intercept predict? X: C16 (number of cars on the sales lot) versus Y: C17 (cars sold per day) Equation: y=2.9x + 14.5 Slope:2.9 Intercept:14.5 Does the intercept mean the intercept is 14.5 means that the cars sold per day( Y) predicted number of cars on sale lot(X) to be 14.5, but this intercept has no meaning. So, I will not use to predict cars sold per day?
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
a. Using POM for Windows' least squares-linear regression module, develop a relationship to forecast production ratings from test scores. (Round your responses to three decis and include a minus sign if necessary.) Y= - 23 + .945 x where Y = Production rating and X = Test score. b. If a worker's test score was 54, what would be your forecast of the worker's production rating? 51. (Enter your response as an integer.) c. Comment on the strength of the relationship between the test scores and production ratings. The coefficient of correlation for the least-squares regression model is and the coefficient of determination is (Enter your responses rounded to three decimal places.) More info Test Score Production Rating Production Test Worker Worker Rating Score A 55 43 K 58 57 B 38 43 75 75 93 87 67 48 D 86 77 31 26 E 88 82 62 49 F 66 68 24 25 G 55 47 Q 78 84 Clear all Check 50 46 34 32 41 41 51 58 J 69 74 T 39 30 Print Done LLMN OPoRS

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