The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year: 1st 2nd 3rd 4th Quarter 9,600 Quarter 11,600 Quarter Quarter 12,600 Budgeted sales (units) 13,600 The selling price of the company's product is $36 per unit. Management expects to collect 55% of sales in the quarter in which the sales are made and 40% in the following quarter; 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which are expected to be collected in the first quarter, is $96,500. The company expects to start the first quarter with 2,800 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 3,050 units. Required: 1-a. Prepare the company's sales budget. JESSI CORPORATION Sales Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Total sales

The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year: 1st 2nd 3rd 4th Quarter 9,600 Quarter 11,600 Quarter Quarter 12,600 Budgeted sales (units) 13,600 The selling price of the company's product is $36 per unit. Management expects to collect 55% of sales in the quarter in which the sales are made and 40% in the following quarter; 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which are expected to be collected in the first quarter, is $96,500. The company expects to start the first quarter with 2,800 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 3,050 units. Required: 1-a. Prepare the company's sales budget. JESSI CORPORATION Sales Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Total sales

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

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
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.
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.
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 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 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 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.…
Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter. The sales forecasts for the next five quarters are as follows: Following Year First Quarter Quarter in Coming Year First Second Third Fourth Sales forecast $385 $365 $341 $389 $389 Calculate Paymore's cash payments to its suppliers assuming that two-thirds of the purchases are paid for in the quarter that they are purchased and one-third are paid in the following quarter. (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Quarter Payment 1 2 3 4
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?
Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter which has been provided in the below table. Sales forecast (figures in $ millions) A. Cash requirements First $372 Paymore's labor and administrative expenses are $65 per quarter and interest on long-term debt is $40 per quarter. Paymore's cash balance at the start of the first quarter is $40 and its minimum acceptable cash balance is $30. Assume that Paymore can borrow up to $100 from a line of credit at an interest rate of 2% per quarter. On average, one-third of sales are collected in the quarter that they are sold, and two-thirds are collected in the following quarter. Assume that sales in the last quarter of the previous year were $336. On average, two-thirds of purchases are paid for in the quarter that they are purchased, and one-third are paid in the following quarter. Prepare a short-term financing plan using the above table. (Leave no cells blank. Enter 'O' when necessary. Negative…