Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Whittenberg Distributors, a major retailing and mail-order operation, has been in business for the past 10 years. During that time, its mail-order operations have grown

Whittenberg Distributors, a major retailing and mail-order operation, has been in business for the past 10 years. During that time, its mail-order operations have grown from a sideline to represent more than 80 percent of the company's annual sales. Of course, the company has suffered growing pains. At times, overloaded or faulty computer programs resulted in lost sales. And scheduling temporary workers to augment the permanent staff during peak periods has always been a problem. Peter Bloom, manager of mail-order operations, has developed procedures for handling most problems. However, he is still trying to improve the scheduling of temporary workers to take customer telephone orders. Under the current system, Peter keeps a permanent staff of 60 employees who handle the base telephone workload and supplements this staff with temporary workers as needed. The temporary workers are hired on a daily basis; he determines the number needed for the next day the afternoon before based on his estimate of the upcoming telephone volume. Peter has decided to try regression analysis to improve the hiring of temporary workers. By summarizing the daily labor-hours into weekly totals for the past year, he determined the number of workers used each week. In addition, he listed the number of orders processed each week. After entering the data into a spreadsheet, Peter ran two regressions. Regression 1 related the total number of workers (permanent staff plus temporary workers) to the number of orders received. Regression 2 related only temporary workers to the number of orders received. The output of these analyses follows: Regression model: W = a + b T where: W = workers; T = telephone orders Regression 1 Regression 2 a 21.938 -46.569 b .0043 .0051 Standard error of the estimate 3.721 1.495 t-value 1.95 2.04 Coefficient of determination .624 .755 Durbin Watson statistic 1.33 1.67 Required: 1. Peter Bloom estimates that Whittenberg Distributors will receive 12,740 orders during the second week of December. a. Predict the number of temporary workers needed for this week using regression 1. Round your answer to the nearest whole number. b. Using regression 2, predict the number of temporary workers needed during this week. Round your answer to the nearest whole number. 2. Which of the two regression analyses appears to be better? Explain your answer. 3. Describe at least three ways that Peter Bloom could improve his analysis to make better predictions than either of these regression results provides. (CMA Adapted)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

New Trends In Shape Optimization

Authors: Aldo Pratelli, Günter Leugering

1st Edition

3319175637, 9783319175638

More Books

Students also viewed these Mathematics questions

Question

b. A workshop on stress management sponsored by the company

Answered: 1 week ago