Question: Question 4: Forecasting using the distribution method A company has used regression analysis based on historical data to estimate the proportion of dollars that will
Question 4: Forecasting using the distribution method
A company has used regression analysis based on historical data to estimate the proportion of dollars that will clear on a given business day. It has determined that this proportion depend on the number of business days since the checks were distributed. The estimate proportions are given below:
| Business Days Since Distribution | % of Dollars Expected to Clear |
| 1 | 12% |
| 2 | 33% |
| 3 | 29% |
| 4 | 17% |
| 5 | 9% |
| Total | 100% |
If $500,000 in checks is distributed on Thursday April 1, can you make a schedule according to which the checks are estimated to clear:
| Date | Business Days After Distribution | Day of the Week | Percentage of Dollars Clearing | Forecast of Dollars Clearing |
| April 2 | 1 | Friday | 12% | $________ |
| April 5 | 2 | Monday | 33% | $_______ |
| April 6 | 3 | Tuesday | 29% | $_______ |
| April 7 | 4 | Wednesday | 17% | $________ |
| April 8 | 5 | Thursday | 9% | $________ |
| Total | 100% | $________ | ||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
