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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!