Question
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1 st Quarter
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): |
1stQuarter | 2ndQuarter | 3rdQuarter | 4thQuarter | ||
Budgeted unit sales | 13,000 | 13,000 | 15,000 | 15,000 | |
|
The selling price of the company's product is $18 per unit. Management expects to collect 62% of sales in the quarter in which the sales are made, 29% in the following quarter, and 9% 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 $61,200. |
The company expects to start the first quarter with 1,550 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,870 units. |
Requirement 1: | |
(a) | Prepare the company's sales budget.(Omit the "$" sign in your response.) |
1stQuarter | 2ndQuarter | 3rdQuarter | 4thQuarter | Year | |
Total sales | $ | $ | $ | $ | $ |
|
(b) | Prepare the schedule of expected cash collections.(Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.) |
Jessi Corporation Schedule of Expected Cash Collections | |||||
1stQuarter | 2ndQuarter | 3rdQuarter | 4thQuarter | Year | |
Accounts receivable, beginning balance | $ | $ | $ | $ | $ |
1stQuarter sales | |||||
2ndQuarter sales | |||||
3rdQuarter sales | |||||
4thQuarter sales | |||||
Total cash collections | $ | $ | $ | $ | $ |
|
Requirement 2: |
Prepare the company's production budget for the upcoming fiscal year.(Input all amounts as positive values.) |
Jessi Corporation Production Budget | |||||
1stQuarter | 2ndQuarter | 3rdQuarter | 4thQuarter | Year | |
Budgeted unit sales | |||||
Add desired ending inventory |
|
|
|
|
|
Total units needed | |||||
Less beginning inventory | |||||
Required production |
|
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started