Esplanade Company's credit sales have the following historical pattern

Esplanade Company's credit sales have the following historical pattern:
70% Collected in the month of sale
15% Collected in the first month after sale
10% Collected in the second month after sale
4% Collected in the third month after sale
1% Uncollectible

These sales on open account (credit sales) have been budgeted for the last six months in 2010:
July $60,000
August $70,000
September $80,000
October $90,000
November $100,000
December $85,000

1) Determine the estimated total cash collections from accounts receivable during October 2010.
2) Compute the estimated total cash collections during the fourth quarter from credit sales of the fourth quarter.

Click here for the solution: Esplanade Company's credit sales have the following historical pattern

Spirit Company sells three products with the following seasonal sales pattern

Spirit Company sells three products with the following seasonal sales pattern:

Products
Quarter A B C
1 40% 30% 10%
2 30% 20% 40%
3 20% 20% 40%
4 10% 30% 10%

The annual sales budget shows forecasts for the different products and their expected selling price per unit as follows:

Product Units Selling Price
A 50,000 $4
B 125,000 10
C 62,500 6

Required:
Prepare a sales budget, in units and dollars, by quarters for the company for the coming year.

Click here for the solution: Spirit Company sells three products with the following seasonal sales pattern