Creating schedule of expected cash collections


Q1) Silver Company sells a product which is very popular as Mother's Day gift. Hence, peak sales happen in May of each year. These peak sales are shown in company's sales budget for second quarter (all sales are on account) are listed below:

  April May June Total
Butgeted sales $300,000 $500,000 $200,000 $1,000,000

From past experience, company has learned that 20% of month's sales are collected in month of sale, another 70% are accumulated in month following sale, and remaining 10% are collected in second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000.

Questions:

Create schedule of expected cash collections from sales, by month and in total, for second quarter.

Suppose that company will create a budgeted balance sheet as of June 30. Calculate accounts receivable as of that date.

Request for Solution File

Ask an Expert for Answer!!
Accounting Basics: Creating schedule of expected cash collections
Reference No:- TGS018776

Expected delivery within 24 Hours