Details of this Paper

Saint GBA334 module 3 assignment

Description

solution


Question

Question;Homework unit 3Chapter 4: 4-10, 4-13, 4-28, 4-30.4-10 The operations manager of a musical instrument distributor feels that demand for bass drums may be related to the number of television appearances by the popular rock group Green Shades during the preceding month. The manager has collected the data shown in the following table: DEMAND FOR GREEN SHADES BASS DRUMS TV APPEARANCE 3 3 6 4 7 7 5 6 10 8 8 5 (a) Graph these data to see whether a linear equation might describe the relationship between the group?s television shows and bass drum sales.(b) Using the equations presented in this chapter, compute the SST, SSE, and SSR. Find the least squares regression line for this data. (c) What is your estimate for bass drum sales if the Green Shades performed on TV six times last month?Problem 4-13Students in a management science class have just received their grades on the first test. The instructorhas provided information about the first test grades in some previous classes as well as the final averagefor the same students. Some of these grades have been sampled and are as follows:STUDENT 1 2 3 4 5 6 7 8 91st test grade 98 77 88 80 96 61 66 95 69Final average 93 78 84 73 84 64 64 95 76(a) Develop a regression model that could be used to predict the final average in the course based onthe first test grade.(b) Predict the final average of a student who made an 83 on the first test.(c) Give the values of r and for this model. Interpret the value of in the context of this problem.Problem 4-28Use the data in Problem 4-27 to develop a multiple linear regression model. How does this compare with each of the models in Problem 4-27?Problem 4-30A sample of nine public universities and nine private universities was taken. The total cost for the year (including room and board) and the median SAT score (maximum total is 2400) at each school were recorded. It was felt that schools with higher median SAT scores would have a better reputation and would charge more tuition as a result of that. The data is in the table below. Use regression to help answer the following questions based on this sample data. Do schools with higher SAT scores charge more in tuition and fees? Are private schools more expensive than public schools when SAT scores are taken into consideration? Discuss how accurate you believe these results are using information related the regression models.Category Total Cost Median SATPublic 21,700 1990Public 15,600 1620Public 16,900 1810Public 15,400 1540Public 23,100 1540Public 21,400 1600Public 16,500 1560Public 23,500 1890Public 20,200 1620Private 30,400 1630Private 41,500 1840Private 36,100 1980Private 42,100 1930Private 27,100 2130Private 34,800 2010Private 32,100 1590Private 31,800 1720Private 32,100 1770Chapter 5: 5-13, 5-15, 5-25, 5-27,5-13 Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD. A 3-month moving average forecast was developed in the section on moving averages in the Table Below.MONTH ACTUAL SHED SALES 3-MONTH MOVING AVERAGE January 10 February 12 March 13 April 16 (10 + 12 + 13)/ 3 = 11.67 May 19 (12 + 13 + 16)/ 3 = 13.67 June 23 (13 + 16 + 19)/ 3 = 16.00 July 26 (16 + 19 + 23)/ 3 = 19.33 August 30 (19 + 23 + 26)/ 3 = 22.67 September 28 (23 + 26 + 30)/ 3 = 26.33 October 18 (26 + 30 + 28)/ 3 = 28.00 November 16 (30 + 28 + 18)/ 3 = 25.33 December 14 (28 + 18 + 16)/ 3 = 20.67 January ? (18 + 16 + 14)/ 3 = 16.00Wallace Garden Supply decides to forecast storage shed sales by weighting the past 3-months as follows: WEIGHTS APPLIED PERIOD 3 Last month 2 Two months ago 1 Three months ago 3 ? Sales last month + 2 ? Sales two months ago + 1 ? Sales three months ago 6 Sum of the weightsProblem 5-15Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the table attached. Develop a 3-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1. Which method do you think is best?Problem 5-25Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows:Sales (1,000s) MONTH Sales (1,000s) MONTH11 January 14 August14 February 17 September16 March 12 October10 April 14 November15 May 16 December17 June 11 January11 July (a) Using a moving average with three periods, determine the demand for vacuum cleaners for next February.(b) Using a weighted moving average with three periods, determine the demand for vacuum cleans for February. Use 3, 2 and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively. For example, if you were forecasting the demand for February, November would have a weight of 1, December would have a weight of 2, and January would have a weight of 3.(c) Evaluate the accuracy of each of these methods.(d) What other factors might R. Lowenthal consider in forecasting sales?Problem 5-27Emergency calls to Winter Park, Florida?s 911 system, for the past 24 weeks are as follows: (Attached Excel Data) (a) Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of 50 calls in the first week and use smoothing constant for forecasts=0.1 What is the forecast for the 25th week? (b) Reforecast each period using smoothing constant for forecasts= 0.6 (c) Actual calls during the 25th week were 85. Which smoothing constant provides a superior forecast?Week Calls Week Calls Week Calls1 50 9 35 17 552 35 10 20 18 403 25 11 15 19 354 40 12 40 20 605 45 13 55 21 756 35 14 35 22 507 20 16 25 23 408 30 16 55 24 65

 

Paper#61510 | Written in 18-Jul-2015

Price : $41
SiteLock