Compute estimated cash collections

Reference no: EM13154821

Coyote Loco is a manufacturer of salsa. The follow historical collection pattern cor its credit sales are as follows :

70% colleceted in month of sale
15% collected in first month after sale
10% collected in second month after sale
4% collected in third month after sale
1% uncollectible.

The sales on account have been budgeted for the last seven months as :

June - $122,500
july - 150,000
august - 175,000
sept - 200,000
oct - 225,000
nov - 250,000
dec - 212,500

1. Compute estimated cash collections during october from credit sales.

2. compute the estimated total cash collections during the fourth quarter from sales made on account during the fourth quarter

3. Make a spreadsheet solving the 2 previous requirements.

Reference no: EM13154821

Questions Cloud

Corporation''s benefit : IF JAR Inc's 2008 TAXABLE INCOME WAS $85,000. AND IF 2009 TAXABLE LOSS IS $35,000, the TAX RATE 40% WOULD IT BE POSSIBLE TO UTILIZE THE TAXABLE LOSS FROM 2009 TO THE CORPORATION'S BENEFIT

Particular vintage will result in good bottles : In the wine industry, there is interest in knowing ahead of time if a particular vintage will result in good bottles of wine or bad bottles. There is no way to know if the wine is good until it is finished aging.

What mass (in grams) of ch4 is present : What mass (in grams) of CH4 is contained in a 555 mL volume at a pressure of 760.0 torr, and at a temperature of 400.0 K?

How does this policy affect national saving : How does this policy affect national saving, domestic investment, net capital outflow, the interest rate, the exchange rate, and the trade balance?

Compute estimated cash collections : Compute estimated cash collections during october from credit sales. compute the estimated total cash collections during the fourth quarter from sales made on account during the fourth quarter

Describe the short-run impact of the adverse supply shock : Describe the short-run impact of the adverse supply shock on prices and output in each country. Compare the long-run impact of the adverse supply shock on prices and output in each country.

Interval for the difference between n matched pairs : For the events A and B, if (A∩B)' =S (where S, of course, is the sample space), then the events CANNOT be mutually exclusive.??b. In a confidence interval for the difference between n matched pairs of observations, the t-distribution to use is with 2..

Executive information systems in its business? : How can Harley-Davidson benefit from using decision support systems and executive information systems in its business?

Describe the industry and explain the general pattern : Describe the industry and explain the general pattern of change of the particular market model and hypothesize the basic short-run and long-run behaviors of the model in the industry you have chosen in a "market economy."

User Account

All Pages