Create a schedule of expected cash collections from sales

Reference no: EM131976863

Problem

Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below:

April May June Total
Budgeted sales (all on account) $310,000 $510,000 $160,000 $980,000

From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $240,000, and March sales totaled $270,000.

Required:

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

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

Reference no: EM131976863

Questions Cloud

Osmotic pressure of the solution : If the osmotic pressure of the solution is found to be 576.8 mm Hg at 29°C, the molar mass in g/mol of the protein will be (enter to 0 decimal places)

What is effective rate on the bank loan : What is the effective rate on the bank loan? Should the firm borrow with the 20 percent compensating balance requirement?

What is the vapor pressure of an aqueous solution : What is the vapor pressure of an aqueous solution containing 12% (by weight) ethylene glycol (62 g/mol) at 25oC. PH2O= 24.3 torr at 25oC.

Consequences of a significant oxidizer related incident : Identify PSM requirements that would be useful for preventing or minimizing the consequences of a significant oxidizer related incident.

Create a schedule of expected cash collections from sales : Silver Company makes a product that is very popular. Create a schedule of expected cash collections from sales, by month and in total, for the second quarter.

Find its molar mass : A sample of gas has a mass of 0.331g. Its volume is 0.225 L at a temperature of 55C and a pressure of 886 mmHg. Find its molar mass.

Estimate of the one-year forward exchange premium : What is the best estimate of the one-year forward exchange premium (discount) on the yen against dollar?

Necessarily represented in the equilibrium expression : Are all reactants and/or products in a chemical reaction necessarily represented in the equilibrium expression? Why or why not?

Determine the amount of money in savings account : Determine the amount of money in a savings account at the end of 3 years, given an initial deposit of $11,500 and an annual interest rate of 12 percent

User Account

All Pages