Statistics: Practice Problems Solutions

1. (24 points) If needed, additional workspace is set asided on the next sheet. Doug Moodie is the president of tend Products Limited. Over the last 5 years, his vice president of merchandising has been providing the sales forecast development his redundant focus forecasting technique. The actual sales for the past ten years and the forecasts from the vice president of marketing argon given below. Year Sales VP/Marketing Forecast 1 170,300 2 168,250 3 165,700 4 169,000 5 168,000 6 167,300 170,000 7 175,250 170,000 8 172,500 180,000 9 156,700 180,000 10 176,300 160,000 Doug wonders if perhaps a weighted go average or an exponential smoothing approach to forecasting might be better than having the vice president of arketing prepare the forecast. Doug wants to mensurate a two-period weighted lamentable average with weights of 0. 7 and 0. 3 for the most new and next most recent periods. He also wants to evaluate the exponential smoothing with an ? = 0. 3 and a outset forecast for period 6 of 168,000 units. a) Which of the three methods (weighted moving average, exponential smoothing and VP/Marketing) provides the best forecasting method if you were to evaluate these methods for their forecasting accuracy for Years 8 through 10. Use one of the evaluation methods we have discussed. reckon next page b) In part a) we identified which is the best method of those three methods.However, would you recommend using this method for forecasting sales for Year 11? Why or Why not? gain next page c) What would be the forecast for Year 11 using both the weighted moving average and the exponential smoothing methods? See next page pic 2. (23 points) Lake Charles Seafood makes 500 wooden packing boxes for rattling seafood per twenty-four hour period, working(a) in two 10-hour shifts. The marketing department has advised that demand has increased so that 650 wooden boxes for fresh seafood are required daily. Due to higher demand, plant managers a re considering operating three 8-hour shifts instead. Productivity is thrifty in terms of boxes vexd per hour worked. ) Calculate the productivity of the operation for the two-shift operation producing 500 boxes. 500/20 = 25 boxes per hour b) Calculate the productivity of the operation for the three-shift operation producing 650 boxes. 650/24 = 27. 08 c) Using the two-shift operation as the base, calculate the percentage difference surrounded by the two-shift operation and the three-shift operation as described in separate a) and b). (27. 08-25)25 = 1. 083 or an increase of 8. 3% d) Now suppose that the plant managers want to be able to produce the 650 boxes but only use two 10-hour shifts. What must the productivity be to achieve this production widening? 650/20 = 32. 50 boxes per hour ) If the beau monde believes that to be free-enterprise(a) if it is to produce 650 wooden boxes, the company must reach a productivity measure of 40 boxes per hour. What are the maximum hour s a day the company can work? 650/x = 40 X = 16. 25 hours 3. (19 points) Additional workspace is provided on the next page. Students in a science class have just received their grades on the offset test. The instructor has provided breeding about the graduation exercise test grades in some previous classes as well as the terminal average for the same students. Some of these grades have been sampled and are as follows Student 1 2 3 4 5 6 7 8 9 1st Test Grade 98 77 88 80 96 61 66 95 69 Final norm 93 78 84 73 84 64 64 95 76 You are also provided the results from several different linear regression family relationships for the above data. These provide different regression relationships face at different combination of independent and dependent variables. pica) Develop a linear regression moulding that can be used to predict the final course average based on the first test grade. pic b) Predict the final average of a student who made an 83 on the first test. pic c) Would you recommend using this relationship for forecasting the final averages? Why? Also, explain how strong the relationship is between these two variables. pic d) Suppose a student scored a 38 on the first test. Predict the final average of a student who had this score?What cautions would you recommend about using the linear regression relationship for predicting a final average? pic 4. (18 points) David Upton is president of Upton manufacturing, a producer of Go-Kart tires. Upton makes 1,000 tires per day with the following resources Labor cd hours at $12. 50 per hour Raw Material20,000 pounds per day at $1. 00 per pound Energy$5,000 per day Capital$10,000 per day a) What is the labor productivity for these tires at Upton Manufacturing expressed per labor hour? Labor productivity = 1000 tires/400 hours = 2. 5 tires/hour. b) What is the multi-factor (total factor) productivity expressed per dollar? Original Multifactor productivity is 1000 tires/(400 ? $12. 50 + 20,000 ? $1 + $5,000 + $10 ,000) = ,000 tires/$40,000 = 0. 025 tires/dollar. c) What is the percent change in the total factor productivity if Upton can reduce the cogency bill by $1,000 without cutting production or changing any other inputs? Original Multifactor productivity is 1000 tires/(400 ? $12. 50 + 20,000 ? $1 + $5,000 + $10,000) = 1,000 tires/$40,000 = 0. 025 tires/dollar. Revised Multifactor productivity changes from 1,000/40,000 to 1,000/39,000, or from 0. 025 to 0. 02564 The ratio is 1. 0256, so the change is a 2. 56 percent increase. 5. (16 points) a) Briefly discuss two ways that operations management can provide a company with a competitive advantage. 8 points Open-ended answerSupports the other functions, delivers what is promised to the customer provides a competitive advantage provides a low cost option plan and execute the production and delivery of the loadeds goods and services Ops Mgt is defined as the design, operation, and improvement of the systems that create and deliver the firms old products and services. b) Briefly discuss two of the major issues that are facing operations management staff in the current business environment. 8 points Open-ended answer Global challenge, automation and technology, commoditization of the supplier, coordinating the relationships between inversely supportive but separate organizations, optimizing global supplier, production, and distribution networks, increased co-production of goods and services, managing customer touch points, raising old management awareness of operations as a significant competitive weapon.