SOLUTION
1. Sales budget
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Year | |
Budgeted unit sales (A) | 12,400 | 13,400 | 15,400 | 14,400 | 55,600 |
Selling price per unit (B) | $23 | $23 | $23 | $23 | $23 |
Total sales (A*B) | 285,200 | 308,200 | 354,200 | 331,200 | 1,278,800 |
2. Schedule of expected cash collection
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Year | |
Beginning accounts receivable | 73,000 | 73,000 | |||
Quarter 1 sales (285,200*65%), (285,200*30%) | 185,380 | 85,560 | 270,940 | ||
Quarter 2 sales (308,200*65%), (308,200*30%) | 200,330 | 92,460 | 292,790 | ||
Quarter 3 sales (354,200*65%), (354,200*30%) | 230,230 | 106,260 | 336,490 | ||
Quarter 4 sales (331,200*65%) | 215,280 | 215,280 | |||
Total cash collection | 258,380 | 285,890 | 322,690 | 321,540 | 1,188,500 |
3. Production budget
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Year | |
Budgeted unit sales | 12,400 | 13,400 | 15,400 | 14,400 | 55,600 |
Add: Desired ending inventory (13,400*20%),(15,400*20%), (14,400*20%) | 2,680 | 3,080 | 2,880 | 2,680 | 2,680 |
Total needs | 15,080 | 16,480 | 18,280 | 17,080 | 58,280 |
Less: Beginning inventory | (2,480) | (2,680) | (3,080) | (2,880) | (2,480) |
Required production in units | 12,600 | 13,800 | 15,200 | 14,200 | 55,800 |
Exercise 8-14 (Algo) Sales and Production Budgets (LO8-2, LO8-3) The marketing department of Jessi Corporation has...
Exercise 8-14 Sales and Production Budgets (LO8-2, LO8-3] The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 11,200 12,200 3rd Quarter 4th Quarter 14,200 13,200 Budgeted unit sales The selling price of the company's product is $11 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of...
Exercise 8-14 Sales and Production Budgets [LO8-2, LO8-3] The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,688 1 3, 15.500 14.5ee The selling price of the company's product is $25 per unit Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5%...
Exercise 8-14 Sales and Production Budgets [L08-2, LO8-3] The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account) 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 13, 600 Budgeted unit sales 12,600 15, 600 14,600 The selling price of the company's product is $25 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and...
Exercise 8-14 Sales and Production Budgets [LO8-2, LO8-3] The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account) Budgeted unit sales ist Quarter i 11, bee nd Quarter 12,6ee 3rd Quarter4th Quarter 14,6ee 13,689 The selling price of the company's product is $15 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5%...
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12,300 13,300 1 5,300 14,300 The selling price of the company's product is $22 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The...
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 12,400 2nd Quarter 13,400 3rd Quarter 15,400 4th Quarter 14,400 Budgeted unit sales The selling price of the company's product is $23 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...
Exercise 7-2 Preparing Sales and Production Budgets (LO2 - CC5, 6) The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year: Budgeted sales (units) 1st Quarter 8,100 2nd Quarter 10,100 3rd Quarter 12,100 4th Quarter 11,100 The selling price of the company's product is $21 per unit. Management expects to collect 55% of sales in the quarter in which the sales are made and 40% in the following quarter; 5% of sales are...
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11,400 12,400 14,400 13,400 The selling price of the company's product is $13 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12,600 Budgeted unit sales 13,600 15,600 14,600 The selling price of the company's product is $25 per unit. Management expects to collect 65 % of sales in the quarter in which the sales are made, 30 % in the following quarter, and 5 % of sales are expected to be...
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11,200 12,200 14,200 13,200 The selling price of the company's product is $11 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...