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 11,100 12,100 14,100 13,100 Budgeted unit sales. The selling price of the company's product is $10 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 balance of accounts receivable, all of which is expected to be collected in the first quarter, is $70,400. The company expects to start the first quarter with 1,665 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,865 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.

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 11,100 12,100 14,100 13,100 Budgeted unit sales. The selling price of the company's product is $10 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 balance of accounts receivable, all of which is expected to be collected in the first quarter, is $70,400. The company expects to start the first quarter with 1,665 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,865 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.

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter15: Managing Short-term Assets

Section: Chapter Questions

Problem 1PROB

See similar textbooks

Similar questions

If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.
A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
The data shown were obtained from the financial records of Italian Exports, Inc., for March: Sales are expected to increase each month by 10%. Prepare a budgeted income statement.
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 QuarterBudgeted unit sales ............................ 11,000 12,000 14,000 13,000The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of salesin the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to beuncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in thefi rst 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. Prepare the company’s sales budget and schedule of expected cash…
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, 600 2nd Quarter 12,600 3rd Quarter 14, 600 4th Quarter 13, 600 Budgeted unit sales 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% 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,400. The company expects to start the first quarter with 1,740 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,940 units. Required: 1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole. 2.…
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, 600 2nd Quarter 12,600 3rd Quarter 14,600 4th Quarter 13, 600 Budgeted unit sales 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% 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,400. The company expects to start the first quarter with 1,740 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,940 units. Required: 1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole. 2.…
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,000 2nd Quarter 12,000 3rd Quarter 4th Quarter 13,000 Budgeted unit sales 14,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. 2.…
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 11, 600 3rd Quarter 14, 600 4th Quarter 13, 600 Budgeted unit sales 12, 600 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% 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,400. The company expects to start the first quarter with 1,740 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,940 units. Required: 1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole.…
The marketing department of Jessi Corporation submitted the following sales forecast for next year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12,900 13,900 15,900 14,900 Budgeted unit sales The selling price of the company's product is $28 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made and 20% in the following quarter; 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 $74,000. The company expects to start the first quarter with 2,580 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,780 units. Required: 1. alculate the estimated sales for each quarter and for the year as a whole. 2. Calculate the expected cash collections…
Bortle Manufacturing Group estimates that sales for the coming year will be 576,000 units. Company policy is to maintain a finished goods inventory of one and one-half month's unit sales. Beginning inventory is 75,000 units. Assume sales occur uniformly throughout the year. Required: Estimate the production level for the coming year for Bortle to meet these objectives Production in units =
Grey Manufacturing Company expects sales to total 18,600 units in the first quarter, 16,000 units in the second quarter, and 23,000 units in the third quarter of the current fiscal year. Company policy is to have on hand at the end of each quarter an amount of inventory equal to 10% of the following quarter’s sales. Given this information, how many units should be scheduled for production in the second quarter?