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,000 11,000 14,000 13,000 The selling price of the company's product is $18.00 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 $70,200. The company expects to start the first quarter with 1,650 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,850 units. Required: 1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole. (Hint: Refer to Schedule 1 for guidance.) 2. Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole. (Hint: Refer to Schedule 1 for guidance.) 3. Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole. (Hint: Refer to Schedule 2 for guidance.)
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
![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
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
11,000 12,000 14,000 13,000
The selling price of the company's product is $18.00 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 $70,200.
The company expects to start the first quarter with 1,650 units in finished goods inventory. Management desires an ending finished goods
inventory in each quarter equal to 15% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth
quarter is 1,850 units.
Required:
1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole. (Hint: Refer to Schedule 1 for guidance.)
2. Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole. (Hint: Refer to Schedule 1 for
guidance.)
3. Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole. (Hint: Refer to
Schedule 2 for guidance.)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fccf8f37e-496d-4d77-859b-4914dd97f3a3%2Fec6dfd6a-51c8-4594-befd-e6bc58ca5407%2Fl1rqxph_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)