a. | ||||||
Calculation of estimated sales for each quarter of fiscal year and for year as a whole is shown below | ||||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total | ||
Budgeted unit sales | 11000 | 12000 | 14000 | 13000 | 50000 | |
Selling price per unit | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | |
Estimated sales | $198,000 | $216,000 | $252,000 | $234,000 | $900,000 | |
b. | ||||||
Calculation of expected cash collection for each quarter of fiscal year and for year as a whole is shown below | ||||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total | ||
Same quarter collection - 65% | $128,700 | $140,400 | $163,800 | $152,100 | $585,000 | |
198000*65% | 216000*65% | 252000*65% | 234000*65% | |||
Selling price per unit | $70,200 | $59,400 | $64,800 | $75,600 | $270,000 | |
Previous quarter collection - 30% | 198000*30% | 216000*30% | 252000*30% | |||
Estimated sales | $198,900 | $199,800 | $228,600 | $227,700 | $855,000 | |
c. | ||||||
Calculation of required production for each quarter and in total is shown below | ||||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total | ||
Budgeted unit sales | 11000 | 12000 | 14000 | 13000 | 50000 | |
Add: Desired ending inventory | 1800 | 2100 | 1950 | 1850 | 1850 | |
12000*15% | 14000*15% | 13000*15% | ||||
Total finished goods required | 12800 | 14100 | 15950 | 14850 | 51850 | |
Less: Beginning inventory | 1650 | 1800 | 2100 | 1950 | 1650 | |
Budgeted production | 11150 | 12300 | 13850 | 12900 | 50200 |
Document1 - Word Mailings Review View Add-ins Help Tell me what you want to do ....
Mailings Review View Add-ins Help Tell me what you want to do .E . A A .A 21 . Аавьсера | Аавьсера АаВЫС Аавьссс Аав аавьс Normal T No Spac... Heading 1 Heading 2 Title Subtitl - - Paragraph The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year. 2nd Quarter 8,000 Quarter 5,000 3rd Quarter 7.000 4th Quarter 6,000 Units to be produced In addition, 6.000...
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%...
Document1 Word es Mailings Review View Add-ins Help Tell me what you want to do A Aa A 2 T AaBbCcDd AaßbCcDd AaBbC AaBbCcl Aa B AaBbCcD 1 Normal 1 No Spac Heading 1 Heading 2 Title Subtitle Paragraph Thalassines Kataskeves, S.A., of Greece makes marine equipment. The company has been experiencing losses on its bilge pump product line for several years. The most recent quarterly contribution format income statement for the bilge pump product line follows: ThalasaineR Kataskeves, s.A....
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 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 13,000 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): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,000 13,000 15,000 14,000 The selling price of the company’s product is $19 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 1st Quarter 11,200 Budgeted unit sales 2nd Quarter 3rd Quarter 4th Quarter 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): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 11,900 12,900 14,900 13,900 The selling price of the company’s product is $18 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 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 Budgeted unit sales 11,800 12,800 14,800 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...
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 11,300 2nd Quarter 12,300 3rd Quarter 14,300 Budgeted unit sales 4th Quarter 13,300 The selling price of the company's product is $12 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 beginning...