The data below represent the call volumes over 16 quarters from a call center at a...
The data below represent the call volumes over 16 quarters from a call center at a major financial institution. Develop a forecasting model for the volume of calls (in 000 units).
| 2010 | 2011 | 2012 | 2013 | |
| Q1 | 473 | 544 | 628 | 709 |
| Q2 | 513 | 582 | 707 | 725 |
| Q3 | 582 | 681 | 773 | 854 |
| Q4 | 474 | 557 | 592 |
661 |
| Quarterly Average | Seasonal Index |
| 588.50 | 0.93645 |
| 631.75 | 1.005271 |
| 722.50 | 1.149677 |
| 571.00 | 0.908603 |
| 628.44 |
(a) Create a time series graph showing the: (1) actual data, (2) trend line for the data, and (3) deseasonalized actual data. Label the graph appropriately.
Correct Answer info for a to create graph
| Year | Qtr | t | Actual Volume of Calls | Deseasonalized Actual Volume of Calls | |
| 2010 | 1 | 1 | 473 | 483.18 | |
| 2 | 2 | 513 | 503.68 | ||
| 3 | 3 | 582 | 515.76 | ||
| 4 | 4 | 474 | 542.25 | ||
| 2011 | 1 | 5 | 544 | 555.71 | |
| 2 | 6 | 582 | 571.43 | ||
| 3 | 7 | 681 | 603.49 | ||
| 4 | 8 | 557 | 637.20 | ||
| 2012 | 1 | 9 | 628 | 641.52 | |
| 2 | 10 | 707 | 694.16 | ||
| 3 | 11 | 773 | 685.02 | ||
| 4 | 12 | 592 | 677.23 | ||
| 2013 | 1 | 13 | 709 | 724.27 | |
| 2 | 14 | 725 | 711.83 | ||
| 3 | 15 | 854 | 756.80 | ||
| 4 | 16 | 661 | 756.17 |
(b) Develop the quarterly (Q1, Q2, Q3, Q4) indexes for the volume of calls
Correct Answer for b
| Year | Qtr | t | Volume of Calls | MA4 | MA2 | Y/MA2 |
| 2010 | 1 | 1 | 473 | |||
| 2 | 2 | 513 | 510.5 | |||
| 3 | 3 | 582 | 528.25 | 519.375 | 1.120578 | |
| 4 | 4 | 474 | 545.5 | 536.875 | 0.882887 | |
| 2011 | 1 | 5 | 544 | 570.25 | 557.875 | 0.975129 |
| 2 | 6 | 582 | 591 | 580.625 | 1.002368 | |
| 3 | 7 | 681 | 612 | 601.5 | 1.13217 | |
| 4 | 8 | 557 | 643.25 | 627.625 | 0.887473 | |
| 2012 | 1 | 9 | 628 | 666.25 | 654.75 | 0.959145 |
| 2 | 10 | 707 | 675 | 670.625 | 1.05424 | |
| 3 | 11 | 773 | 695.25 | 685.125 | 1.128261 | |
| 4 | 12 | 592 | 699.75 | 697.5 | 0.848746 | |
| 2013 | 1 | 13 | 709 | 720 | 709.875 | 0.998767 |
| 2 | 14 | 725 | 737.25 | 728.625 | 0.995025 | |
| 3 | 15 | 854 | ||||
| 4 | 16 | 661 |
c) Using the trend line you developed in Part (a), what are your
seasonally unadjusted and seasonally adjusted forecasts for the
four quarters of 2014?
Correct Answer for c(c )
| Year | Qtr | t | Seasonally Unadjusted Forecast | Quarterly Index | Seasonally Adjusted Forecast |
| 2014 | 1 | 17 | 783.200 | 97.9% | 766.69 |
| 2 | 18 | 801.407 | 101.9% | 816.24 | |
| 3 | 19 | 819.615 | 112.8% | 924.88 | |
| 4 | 20 | 837.822 | 87.4% | 732.38 |
Homework Answers
Add Answer to:
The data below represent the call volumes over 16 quarters from
a call center at a...
The data below represent the relative shares (by quarter) of call volumes over 16 quarters from...
The data below represent the relative shares (by quarter) of call volumes over 16 quarters from a call center at a major financial institution Average Qtr Percent Share 2011 2012 2010 23.2% 23.0% 23.3% | 21.9% 25.1% | 24.6% | 26.2% | 25.3% 28.5% 28.8% | 28.6% | 29.8% 23.2% 23.6% 21.9% 100% 100% 2013 Q1 Q2 Q3 Q4 22.8% 25.3% 28.9% 22.9% 100% | 23.1% 100% Total 100% (a) Using the average quarter percent share column (Column G) generate...
Thank you ! If Julius has a 32 percent tax rate and a 10 percent after-tax...
Thank you !
If Julius has a 32 percent tax rate and a 10 percent after-tax rate of return, a $36,000 tax deduction in two years will save how much tax in today's dollars? Use Exhibit 3.1. (Round discount factor(s) to three decimal places.) Multiple Choice Ο Ο s36,000. Ο $9,516. Ο $29,736. Ο $11,520. Ο None of the choices are correct. EXHIBIT 3-1 Present Value of a Single Payment at Various Annual Rates of Return 4% 5% 6% 7%...
Problem 22-06 Management of TSC, Inc. is evaluating a new $97,000 investment with the following estimated...
Problem 22-06 Management of TSC, Inc. is evaluating a new $97,000 investment with the following estimated cash flows: Year Cash Flow $ 7,000 31,000 41,000 55,000 The firm's cost of capital is 12 percent and the project will require that the firm spend $12,000 to terminate the project. Use Appendix B to answer the question. Use a minus sign to enter a negative value, if any. Round your answer to the nearest dollar. The NPV of the investment is $...
Hank, a calendar-year taxpayer, uses the cash method of accounting for his sole proprietorship. In late December, he per...
Hank, a calendar-year taxpayer, uses the cash method of accounting for his sole proprietorship. In late December, he performed $35,000 of legal services for a client. Hank typically requires his clients to pay his bills immediately upon receipt. Assume his marginal tax rate is 32 percent this year and will be 37 percent next year, and that he can earn an after-tax rate of return of 9 percent on his investments. a. What is the after-tax income if Hank sends...
manny, a calendar Maríny, a calendar year taxpayer, uses the cash method of accounting for his...
manny, a calendar
Maríny, a calendar year taxpayer, uses the cash method of accounting for his sole proprietorship in late December he performed $31,000 of legal services for a client. Manny typically requires his clients to pay his bills immediately upon receipt. Assume Manny's marginal tax rate is 40 percent this year and next year and that he can eam an affer-tax rate of return of 5 percent on his investments a. What is the after-tax income if Manny sends...
Firm Q is about to engage in a transaction with the following cash flows over a...
Firm Q is about to engage in a transaction with the following cash flows over a three-year period. Use Appendix A and Appendix B. Taxable revenue Deductible expenses Nondeductible expenses Year0 $14,400 (4,700) (635) Year 1 $16,400 (6,800) (2,100) Year 2 $ 30,900 (11,450) 0 If the firm's marginal tax rate over the three-year period is 30 percent and its discount rate is 6 percent, compute the NPV of the transaction. (Expenses and cash outflows should be indicated by a...
Firm Q is about to engage in a transaction with the following cash flows over a...
Firm Q is about to engage in a transaction with the following cash flows over a three-year period. Use Appendix A and Appendix B. Taxable revenue Deductible expenses Nondeductible expenses Year $14,400 (4,700) (635) Year 1 $16,400 (6,800) (2,100) Year 2 $ 30,900 (11,450) 0 If the firm's marginal tax rate over the three-year period is 30 percent and its discount rate is 6 percent, compute the NPV of the transaction. (Expenses and cash outflows should be indicated by a...
Firm Q is about to engage in a transaction with the following cash flows over a...
Firm Q is about to engage in a transaction with the following cash flows over a three-year period. Use Appendix A and Appendix B. Taxable revenue Deductible expenses Nondeductible expenses Year0 $14,400 (4,700) (635) Year 1 $16,400 (6,800) (2,100) Year 2 $ 30,900 (11,450) 0 If the firm's marginal tax rate over the three-year period is 30 percent and its discount rate is 6 percent, compute the NPV of the transaction. (Expenses and cash outflows should be indicated by a...
Hank, a calendar-year taxpayer, uses the cash method of accounting for his sole proprietorship. In late...
Hank, a calendar-year taxpayer, uses the cash method of
accounting for his sole proprietorship. In late December, he
performed $25,000 of legal services for a client. Hank typically
requires his clients to pay his bills immediately upon receipt.
Assume his marginal tax rate is 30 percent this year and will be 33
percent next year, and that he can earn an after-tax rate of return
of 12 percent on his investments. Use Exhibit 3.1.
a. What is the after-tax income...
Create a program that will use the attached input file and perform the following operations. Read...
Create a program that will use the attached input file and perform the following operations. Read the file into an appropriate JCF data structure. Look up a (list of) names and numbers matching a last name or the first letters of a last name, ignoring case. Look up a (list of) names and numbers matching a number or the first digits of a number. Add a name and number to the list. Sort the list by first name, last name...
The data below represent the relative shares (by quarter) of call volumes over 16 quarters from a call center at a major financial institution Average Qtr Percent Share 2011 2012 2010 23.2% 23.0% 23.3% | 21.9% 25.1% | 24.6% | 26.2% | 25.3% 28.5% 28.8% | 28.6% | 29.8% 23.2% 23.6% 21.9% 100% 100% 2013 Q1 Q2 Q3 Q4 22.8% 25.3% 28.9% 22.9% 100% | 23.1% 100% Total 100% (a) Using the average quarter percent share column (Column G) generate...
Thank you !
If Julius has a 32 percent tax rate and a 10 percent after-tax rate of return, a $36,000 tax deduction in two years will save how much tax in today's dollars? Use Exhibit 3.1. (Round discount factor(s) to three decimal places.) Multiple Choice Ο Ο s36,000. Ο $9,516. Ο $29,736. Ο $11,520. Ο None of the choices are correct. EXHIBIT 3-1 Present Value of a Single Payment at Various Annual Rates of Return 4% 5% 6% 7%...
Problem 22-06 Management of TSC, Inc. is evaluating a new $97,000 investment with the following estimated cash flows: Year Cash Flow $ 7,000 31,000 41,000 55,000 The firm's cost of capital is 12 percent and the project will require that the firm spend $12,000 to terminate the project. Use Appendix B to answer the question. Use a minus sign to enter a negative value, if any. Round your answer to the nearest dollar. The NPV of the investment is $...
manny, a calendar
Maríny, a calendar year taxpayer, uses the cash method of accounting for his sole proprietorship in late December he performed $31,000 of legal services for a client. Manny typically requires his clients to pay his bills immediately upon receipt. Assume Manny's marginal tax rate is 40 percent this year and next year and that he can eam an affer-tax rate of return of 5 percent on his investments a. What is the after-tax income if Manny sends...
Firm Q is about to engage in a transaction with the following cash flows over a three-year period. Use Appendix A and Appendix B. Taxable revenue Deductible expenses Nondeductible expenses Year0 $14,400 (4,700) (635) Year 1 $16,400 (6,800) (2,100) Year 2 $ 30,900 (11,450) 0 If the firm's marginal tax rate over the three-year period is 30 percent and its discount rate is 6 percent, compute the NPV of the transaction. (Expenses and cash outflows should be indicated by a...
Firm Q is about to engage in a transaction with the following cash flows over a three-year period. Use Appendix A and Appendix B. Taxable revenue Deductible expenses Nondeductible expenses Year $14,400 (4,700) (635) Year 1 $16,400 (6,800) (2,100) Year 2 $ 30,900 (11,450) 0 If the firm's marginal tax rate over the three-year period is 30 percent and its discount rate is 6 percent, compute the NPV of the transaction. (Expenses and cash outflows should be indicated by a...
Firm Q is about to engage in a transaction with the following cash flows over a three-year period. Use Appendix A and Appendix B. Taxable revenue Deductible expenses Nondeductible expenses Year0 $14,400 (4,700) (635) Year 1 $16,400 (6,800) (2,100) Year 2 $ 30,900 (11,450) 0 If the firm's marginal tax rate over the three-year period is 30 percent and its discount rate is 6 percent, compute the NPV of the transaction. (Expenses and cash outflows should be indicated by a...
Hank, a calendar-year taxpayer, uses the cash method of
accounting for his sole proprietorship. In late December, he
performed $25,000 of legal services for a client. Hank typically
requires his clients to pay his bills immediately upon receipt.
Assume his marginal tax rate is 30 percent this year and will be 33
percent next year, and that he can earn an after-tax rate of return
of 12 percent on his investments. Use Exhibit 3.1.
a. What is the after-tax income...
Most questions answered within 3 hours.
-
a radio station transmits at 78.1 mhz. a hz is an inverse
second. how far apart...
asked 4 minutes ago -
Write the equilibrium expression for the dissociation in
water for CH5N, C2H5O2COOH, H3AsO4, KClO2, HC2H2ClO2.
asked 9 minutes ago -
In risk management, insurance is an example of:
Select one:
a. Risk avoidance
b. Risk deflection...
asked 11 minutes ago -
Wildhorse Company follows the practice of pricing its inventory
at the lower-of-cost-or-market, on an individual-item
basis....
asked 45 minutes ago -
3. (10 pts) You grow a corn crop that yields 150 bushels ac-1,
with the following...
asked 34 minutes ago -
7. The term Six Sigma refers to:
Select one:
a. The control limits established in a...
asked 44 minutes ago -
For the following reaction: A(g) + 2 B(g) ⇌ 2 C(g) Calculate the
equilibrium constant K...
asked 46 minutes ago -
Which of the following best describes tidal volume? options:
1.The amount of oxygen in the air...
asked 1 hour ago -
1. Smaller cost distortions occur when the traditional systems'
single indirect-cost rate and the activity-cost-driver rates:...
asked 1 hour ago -
Using either a FMECA approach or some other appropriate RCA
tool, identify five risk treatment actions...
asked 1 hour ago -
If for a test the P-value is between 0.0025 and 0.005, what
conclusion can you draw?...
asked 1 hour ago -
Using Python. Write a function clean2(aList) that takes a list
of integers aList as argument, and...
asked 1 hour ago