Month Average # of customer service Calls received per day for each month the center was...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Month Average # of customer service Calls received per day for each month the center was open in year one Month Jan 25 1 Feb 19 2 Mar 28 3 Apr 32 4 May 42 5 Jun 47 6 Jul 50 7 Aug 49 8 Sep 52 9 Oct 54 10 Nov 53 Dec 59 11 12 a. Using Excel, create a linear regression equation to model the number of calls per month. b. c. At the current rate of growth, how many customer service calls does the regression equation predict for June of year 2? Given your prediction for June of year 2, how many customer service staff members do you forecast will be needed per 12 hour shift to handle the load? Submit your findings in a Word document and include the Excel spread sheet. B. Y = a + bx New Totals Y=a+b13 Y=a+b14 Y=a+b15 Y=a+b16 Y=a+b17 Y=a+b18 C. This can be in a word document or on the excel Year 1 - # of customer service calls received. The online sales office is open from 7am to 7pm, seven days a week, and customer service staff work the entire 12-hour shift. You can assume a single call takes 15 minutes for a customer service rep to handle. B. Y = a + bx Y=a+b13 Y=a+b14 Y=a+b15 Y=a+b16 New Totals Y=a+b17 Y=a+b18 C. This can be in a word document or on the excel Year 1 - # of customer service calls received. The online sales office is open from 7am to 7pm, seven days a week, and customer service staff work the entire 12-hour shift. You can assume a single call takes 15 minutes for a customer service rep to handle. | 24.545 +6.6853(18)=145 calls per day on average. At 145 calls per day, that is 12 calls on average per hour. One person can handle 4 call a hour = how many people 145calls/12 hours 12.08 Month Average # of customer service Calls received per day for each month the center was open in year one Month Jan 25 1 Feb 19 2 Mar 28 3 Apr 32 4 May 42 5 Jun 47 6 Jul 50 7 Aug 49 8 Sep 52 9 Oct 54 10 Nov 53 Dec 59 11 12 a. Using Excel, create a linear regression equation to model the number of calls per month. b. c. At the current rate of growth, how many customer service calls does the regression equation predict for June of year 2? Given your prediction for June of year 2, how many customer service staff members do you forecast will be needed per 12 hour shift to handle the load? Submit your findings in a Word document and include the Excel spread sheet. B. Y = a + bx New Totals Y=a+b13 Y=a+b14 Y=a+b15 Y=a+b16 Y=a+b17 Y=a+b18 C. This can be in a word document or on the excel Year 1 - # of customer service calls received. The online sales office is open from 7am to 7pm, seven days a week, and customer service staff work the entire 12-hour shift. You can assume a single call takes 15 minutes for a customer service rep to handle. B. Y = a + bx Y=a+b13 Y=a+b14 Y=a+b15 Y=a+b16 New Totals Y=a+b17 Y=a+b18 C. This can be in a word document or on the excel Year 1 - # of customer service calls received. The online sales office is open from 7am to 7pm, seven days a week, and customer service staff work the entire 12-hour shift. You can assume a single call takes 15 minutes for a customer service rep to handle. | 24.545 +6.6853(18)=145 calls per day on average. At 145 calls per day, that is 12 calls on average per hour. One person can handle 4 call a hour = how many people 145calls/12 hours 12.08
Expert Answer:
Posted Date:
Students also viewed these general management questions
-
Suppose for a predictive problem, you used an independent test set and had an 80% accuracy. Then for the same predictive problem, you used cross validation and had an accuracy of 85%. Are these two...
-
P&E Shipping reported the following rounded amounts (in millions): 2019 $5,475 (325) $ 5,150 $ 41,500 Accounts Receivable Allowance for Doubtful Accounts Accounts Receivable, Net of Allowance Net...
-
You just finished your MBA degree and your boss wants to show you off in an upcoming staff meeting because she feels you have a lot of potential. Needless to say, you feel some pressure. She says the...
-
The following information provides details of costs, volume and cost drivers for a particular period in respect of ABC plc, a hypothetical company: ( Details Direct Material $25 Cost Direct Labor 4/3...
-
The 10 following statements apply to unrestricted random sampling without replacement. Indicate whether each statement is true or false. Briefly discuss each false statement. a. When sampling from...
-
BC and OP are both private not-for-profit entities. They are combined to create MN, a private not-for-profit with an entirely new board of directors. BC has land with a book value of $300,000 and a...
-
Amado, Inc., manufactures riding lawn mowers. Amado uses JIT manufacturing and carries insignificant levels of inventory. Amado manufactures everything needed for the riding lawn mowers except for...
-
Brazil points to its shrimp-farming industry as an example of how it can compete in world markets. One decade ago, Brazil exported a meager 400 tons of shrimp. Today, Brazil exports more than 58,000...
-
JWI 522: Assignment 1 - HR Snapshot (Replace the RED text with your own content) Mission Write the mission of the organization. Include additional team (or divisional) mission statements, if...
-
Presented below are data for Blossom Company 20202021Assets, January 1$8840$9710 Liabilities, January 14850?Stockholders' Equity, Jan. 1??Dividends16101205Common Stock1448 1286Stockholders' Equity,...
-
Now we travel to another facility and enter a workplace that repairs very large amphibious vehicles. The noise level is high, and large machines are in operation. We see several individuals working...
-
What do you feel are the most important aspects of performance management? How do you feel the changing job market has changed performance management? How do you feel technology has changed...
-
a . Define the term conservatism . b . Explain what the term prudence means. c . Is conservatism and / or prudence in conflict with the concept of neutrality? Explain.
-
Pestle analysis of broadband in Texas Also explain each factor of pestle into trend opportunities and threats. Please explain in detail
-
Explain what policies and/or procedures Oscar should have in place to ensure the hospital does not violate any software licensing agreements and end up in a similar situation noted in the Bank of...
-
Question 7 (1 point) Given the following box plot: .... 2 10 12 13 Which quarter has the largest spread of data? second quarter with a spread of 8
-
CdF2 (s) Cd+ (aq) + 2 F- (aq) 1. A saturated solution of CdF2 is prepared. The equilibrium in the solution is represented above. In the solution [Cd+] eq = 0.0585 M and [F-] eq = 0.117 M. a....
-
Denver Hardware Company has a giant paint mixer that cost $\$ 31,500$ plus $\$ 400$ to install. The estimated salvage value of the paint mixer at the end of its useful life in 15 years is estimated...
-
Durham Company often purchases common stocks of other companies as long-term investments. At the end of 1999, Durham held the common stocks listed. (Assume that Durham Company exercises no...
-
On January 1, VICOM Company purchased a $\$ 68,000$ machine. The estimated life of the machine was five years, and the estimated salvage value was $\$ 5,000$. The machine had an estimated useful life...
Study smarter with the SolutionInn App