Purpose a schedule of expected cash collections

Assignment Help Financial Accounting

Reference no: EM1311510

Schedule of Expected Cash Collections

Silver Company sells a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year. These peak sales are shown in the company's sales budget for the second quarter given below (all sales are on account):

	April	May	June	Total
Butgeted sales	$300,000	$500,000	$200,000	$1,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. February sales totaled $230,000, and March sales totaled $260,000.

Required:

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

Assume that the company will prepare a budgeted balance sheet as of June 30. Compute the accounts receivable as of that date.

Reference no: EM1311510

Questions Cloud

What is the magnitude of the magnetic force the proton : A steel beam that is 7.00m long weighs 330N. It rests on two supports, 3.00m apart, with equal amounts of beam extending from each end. Suki, who weighs 505 N, stands on the beam in the center and then walks toward one end. How close to the end can s..

Computation of beta of the firm and market portfolio : Computation of beta of the firm and market portfolio and how does this compare with the stock's actual expected return

Purpose a production budget for the second quarter : Purpose a production budget for the second quarter; in your budget, show the number of units to be produced each month and for the quarter in total.

Simple linear regression : The results of the simple linear regression are provided below.

Purpose a schedule of expected cash collections : Purpose a schedule of expected cash collections from sales, by month and in total, for the second quarter

Change in real gdp per capita : The information below explains the real GDP per capita for the country of Utopia for the period of 1975 to 1991.

What is the skier''s launch speed : While on vacation you rent a moped and go cruising around a tropical island. If you take a 10.0° banked curve with a radius of 15.0 meters at 12.0 m/s, what is the minimum coefficient of static friction between your tires and road to keep the tires f..

Evaluate the net operating income for the month : Evaluate the net operating income for the month under variable costing and evaluate the net operating income for the month under absorption costing?

Draw all the forces on the pilot : Two long, parallel conductors carry currents I1 = 3.10 A and I2 = 5.10 A, both directed into the plane of the computer screen. Find out the magnitude and direction of the resultant magnetic field at a point midway between the wires. (b) Find out the ..

User Account

All Pages