Prepare a schedule of expected cash collections

Reference no: EM13131014

July August September Total
Budgeted sales (all on account) $600,000 $900,000 $500,000 $2,000,000

From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled $430,000, and June sales totaled $540,000.

Required:

1. Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter.
2. Assume that the company will prepare a budgeted balance sheet as of September 30. Compute the accounts receivable as of that date.

Reference no: EM13131014

Questions Cloud

Predominant organic acids present in softwoods : Predominant Organic Acids Present in Softwoods such as Pine, A wood chemistry course in which we are asked to explain the hierarchy of the organic wood acids present in softwood species like pine or spruce.

Depreciation expense using straight-line method : Mendenhall Corporation constructed a building at a cost of $10,000,000. Average accumulated expenditures were $4,000,000, actual interest was $800,000, and the usefull life is 40 years, depreciation expense for the first full year using the straig..

Conduct second study to reduce the maximum error : If he were to conduct a second study to reduce the maximum error of estimate to 7, about how many hard drives should he include in his new sample?

What are company’s departmental overhead rates if assemble : What are company’s departmental overhead rates if the assembly department assigns overhead based on direct labor hours and the finishing department assigns overhead based on machine hours?

Prepare a schedule of expected cash collections : From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts ..

Opposing negotiating strategies meet to negotiate a deal : What techniques need to be employed by both parties when these two opposing negotiating strategies meet to negotiate a deal?

Explain reaction of methanoic and ethanoic acids : Reaction of methanoic and ethanoic acids with CaCO3, If I have a 1 liter aqueous solution that contains 15 mg/L methanoic acid and 15 mg/L ethanoic acid

What amount of dividends will a shareholder owning share : What amount of dividends will a shareholder owning 100 shares receive in 2011 if Emily pays $1,000,000 in dividends?

What percent of the tires are likely to wear out : The "average" (mean) tire wore out at 41,000 miles, and the standard deviation was 4000 miles. Approximately what percent of the tires are likely to wear out before 40,200 miles?

User Account

All Pages