The marketing department of Jessi Corporation has submitted the following sales
ID: 2445804 • Letter: T
Question
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account):
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 uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $73,400.
The company expects to start the first quarter with 2,520 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter is 2,720 units.
Compute the company’s total sales.
Complete the schedule of expected cash collections.
Prepare the company’s production budget for the upcoming fiscal year.
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account):
Explanation / Answer
Budgeted Unit Sales of 4 quarters = 12600+ 13600 + 15600 + 14600 = 56400 units
Total Sales = 56400 * 25 = $1410000
Particulars
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Sales Units
12,600.00
13,600.00
15,600.00
14,600.00
Unit Price
25.00
25.00
25.00
25.00
Total Sales
315,000.00
340,000.00
390,000.00
365,000.00
65% Collection
204,750.00
221,000.00
253,500.00
237,250.00
30% Collection in next quarter
-
94,500.00
102,000.00
117,000.00
Opening Balance Collected in 1st Quarter
73,400.00
-
-
-
Total Cash Collection
278,150.00
315,500.00
355,500.00
354,250.00
Particulars
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Sales Units
12,600.00
13,600.00
15,600.00
14,600.00
Opening Balance
2,520.00
2,720.00
3,120.00
2,920.00
Closing Inventoy (20% of Sales of next quarter)
2,720.00
3,120.00
2,920.00
2,720.00
Production (Sales +Closing -opening)
12,800.00
14,000.00
15,400.00
14,400.00
Particulars
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Sales Units
12,600.00
13,600.00
15,600.00
14,600.00
Unit Price
25.00
25.00
25.00
25.00
Total Sales
315,000.00
340,000.00
390,000.00
365,000.00
65% Collection
204,750.00
221,000.00
253,500.00
237,250.00
30% Collection in next quarter
-
94,500.00
102,000.00
117,000.00
Opening Balance Collected in 1st Quarter
73,400.00
-
-
-
Total Cash Collection
278,150.00
315,500.00
355,500.00
354,250.00
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.