Sales and Budget cash collections

required:

prepare a sales budget schedule

also prepare a cash collections budget schedule for:

April 406,000

May 452,000

June 496,000

Particulars:

total sales for:

Feb 500,000

Mar 450,000

Sales are:

30% credit

70% cash

credit collections:

50% are collected in the month of sale

30% in month following the sale

20% in the following month

its the companys estimated forecasted sales