1.
Sales Budget | |||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total | |
Sales units | 12600 | 13600 | 15600 | 14600 | 56400 |
Sales price per unit | $ 25.00 | $ 25.00 | $ 25.00 | $ 25.00 | |
Sales amount | $ 3,15,000 | $ 3,40,000 | $ 3,90,000 | $ 3,65,000 | $ 14,10,000 |
2.
Cash Collections | ||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
Sales | $ 3,15,000 | $ 3,40,000 | $ 3,90,000 | $ 3,65,000 |
Cash Collections | ||||
Accounts Receivable | $ 73,400 | |||
From Current Quarter Sales (65%) | $ 2,04,750 | $ 2,21,000 | $ 2,53,500 | $ 2,37,250 |
From Previous Quarter Sales (30%) | $ 94,500 | $ 1,02,000 | $ 1,17,000 | |
Total Cash Collections | $ 2,78,150 | $ 3,15,500 | $ 3,55,500 | $ 3,54,250 |
3.
Production Budget | ||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
Sales units | 12600 | 13600 | 15600 | 14600 |
Add : Closing Stock Required | 2720 | 3120 | 2920 | 2720 |
Total Goods Required | 15320 | 16720 | 18520 | 17320 |
Less : Opening Stock | 2520 | 2720 | 3120 | 2920 |
Production Required | 12800 | 14000 | 15400 | 14400 |
Desired Ending Inventory = 20% of next quarter sales
Exercise 8-14 Sales and Production Budgets [L08-2, LO8-3] The marketing department of Jessi Corporation has submitted...
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 (Algo) 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) 2nd Quarter 3rd Quarter 1st Quarter 12,400 4th Quarter 14.40 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...
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%...
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...
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): 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 13,000 Budgeted unit sales 2nd Quarter 3rd Quarter 4th Quarter 14,000 16,000 15.000 The selling price of the company's product is $29 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): 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...
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 11,800 2nd Quarter 12,800 3rd Quarter 14,800 4th Quarter 13,800 The selling price of the company's product is $17 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...