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): Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 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 balance of accounts receivable, all of which is expected to be collected in the first quarter, is $71,800. The company expects to start the first quarter with 1,770 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,970 units. Required: 1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole. 2. Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole. 3. Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Total sales Required 1 Required 2 Required 3 Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole. Total cash collections 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Required 1 Required 2 Required 3 < Required 1 Required 3> Year Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Required production in units < Required 2 Required 3> Year
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): Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 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 balance of accounts receivable, all of which is expected to be collected in the first quarter, is $71,800. The company expects to start the first quarter with 1,770 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,970 units. Required: 1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole. 2. Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole. 3. Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Total sales Required 1 Required 2 Required 3 Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole. Total cash collections 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Required 1 Required 2 Required 3 < Required 1 Required 3> Year Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Required production in units < Required 2 Required 3> Year
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter9: Profit Planning And Flexible Budgets
Section: Chapter Questions
Problem 51E
Related questions
Question
None
![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):
Budgeted unit sales
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
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 balance of accounts
receivable, all of which is expected to be collected in the first quarter, is $71,800.
The company expects to start the first quarter with 1,770 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,970 units.
Required:
1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole.
2. Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole.
3. Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole.
Complete this question by entering your answers in the tabs below.
Required 1
Required 2 Required 3
Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole.
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Year
Total sales
<Required 1
Required 2 >
Required 1
Required 2
Required 3
Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole.
Total cash collections
1st Quarter 2nd Quarter
3rd Quarter
4th Quarter
Required 1
Required 2 Required 3
< Required 1
Required 3>
Year
Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole.
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Required production in units
< Required 2
Required 3>
Year](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3ebbbff0-a7d0-4f0a-b272-e56b565ff68a%2F655757cf-1770-4539-a41c-0ea00002c49b%2Fu4olzf_processed.jpeg&w=3840&q=75)
Transcribed Image Text: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):
Budgeted unit sales
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
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 balance of accounts
receivable, all of which is expected to be collected in the first quarter, is $71,800.
The company expects to start the first quarter with 1,770 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,970 units.
Required:
1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole.
2. Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole.
3. Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole.
Complete this question by entering your answers in the tabs below.
Required 1
Required 2 Required 3
Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole.
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Year
Total sales
<Required 1
Required 2 >
Required 1
Required 2
Required 3
Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole.
Total cash collections
1st Quarter 2nd Quarter
3rd Quarter
4th Quarter
Required 1
Required 2 Required 3
< Required 1
Required 3>
Year
Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole.
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Required production in units
< Required 2
Required 3>
Year
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 3 images
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College