Question

Brooks/Neff, Ltd. personalizes scrapbooks for customers, using their digital photographs. Each scrapbook sells for $50. Brooks/Neff collects cash at the time of sale from 30% of customers. Of the remaining sales, 75% are collected in the month of sale and 25% are collected in the month following the sale. The sales budget for the first six months of the year is as follows:

January February March April May June
Budgeted sales $120,000 $110,000 $110,000 $112,000 $115,000 $125,000

Prepare Brooks/Neff's cash receipts budget for the second quarter. (Round answers to 0 decimal places, e.g. 5,275. Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)

Answer 1

Total cash 2nd Quarter= $343,250

Step-by-step explanation:

Giving the following information:

Each scrapbook sells for $50.

Brooks/Neff collects cash at the time of sale from 30% of customers. Of the remaining sales, 75% are collected in the month of sale and 25% are collected in the month following the sale.

Budgeted sales:

January= $120,000

February= $110,000

March= $110,000

April= $112,000

May= $115,000

June= $125,000

We need to calculate the cash collection for each month, and then determine the total cash for the quarter:

April:

From April= 112,000*0.3= 33,600

From March= (115,000*0.7)*0.75= 60,375

From Frebruary= (110,000*0.7)*0.25= 19,250

Total cash= $113,225

May:

From May= 115,000*0.3= 34,500

From April= (112,000*0.7)*0.75= 58,800

From March= (110,000*0.7)*0.25= 19,250

Total cash= $112,550

June:

From June= 125,000*0.3= 37,500

From May= (115,000*0.7)*0.75= 60,375

From April= (112,000*0.7)*0.25= 19,600

Total cash= $117,475

Total cash 2nd Quarter= $343,250