
Concept explainers
The marketing department of Gaeber Industries has submitted the following sales
upcoming fi scal year:
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Budgeted unit sales . . . . . . . 8,000 7,000 6,000 7,000
The company expects to start the fi rst quarter with 1,600 units in fi nished goods inventory.
Management desires an ending fi nished goods inventory in each quarter equal to 20% of the next
quarter’s budgeted sales. The desired ending fi nished goods inventory for the fourth quarter is
1,700 units.
In addition, the beginning raw materials inventory for the fi rst quarter is budgeted to be
3,120 pounds and the beginning accounts payable for the fi rst quarter is budgeted to be $14,820.
Each unit requires 2 pounds of raw material that costs $4.00 per pound. Management desires
to end each quarter with an inventory of raw materials equal to 20% of the following quarter’s
production needs. The desired ending inventory for the fourth quarter is 3,140 pounds. Management plans to pay for 75% of raw material purchases in the quarter acquired and 25% in the following quarter.
Required:
1. Prepare the company’s production budget for the upcoming fi scal year.
2. Prepare the company’s direct materials budget and schedule of expected cash disbursements
for purchases of materials for the upcoming fi scal year.

Trending nowThis is a popular solution!
Step by stepSolved in 4 steps

- 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 11,800 12,800 14,800 13,800 Budgeted unit sales 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 and 30% 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 $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 and for the year as a whole. 2. Calculate the expected cash collections…arrow_forwardSunland Company estimates its sales at 180000 units in the first quarter and that sales will increase by 17000 units each quarter over the year. They have, and desire, a 25% ending inventory of finished goods. Each unit sells for $25. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. The remainder is received in the quarter following sale. Cash collections for the third quarter are budgeted at O $5273500. O $3026500. O $4387000. O $6057389.arrow_forwardThe marketing department of Teddy Bear Company has submitted the following sales forecast for the upcoming fiscal year. Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted unit sales 120,000 130,000 125,000 125,000 The company expected to start the first quarter with 20,000 units in finished goods in 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 s 25,000 units. Prepare the company’s production budget for the second quarter.arrow_forward
- Austen Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as follows: Austen anticipates selling 222,000 jars with total sales revenue of $267,000 in the first quarter of the year following the year given in the preceding table. Austen has a policy that the ending inventory of jars must be 30% of the following quarter's sales. Total sales Number of jars revenue sold Requirement Prepare a production budget for the year that shows the number of jars to be produced each quarter and for the year in 1st quarter.... $ 185,000 152,500 total. 2nd quarter $ 211,000 180,500 3rd quarter 2$ 257,000 210,000 4th quarter $ 193,000 160,000 ..... Prepare the production budget by first calculating the total units needed, then calculate the units to produce. Austen Foods Production Budget For the Quarters in the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Unit sales Plus: Desired ending inventory Total needed Less:…arrow_forwardBlue Company’s budgeted sales and budgeted cost of goods sold for the coming year are $144,440,000 and $90,720,000, respectively. Short-term interest rates are expected to average 10%. If Blue can increase inventory turnover from its present level of 9 times a year to a level of 10 times per year.Compute its expected cost savings for the coming year. Expected Cost Savingsarrow_forwardSales budget data for Paige Company are given in BE9.2. Management desires to have an ending finished goods inventory equal to 25% of the next quarter’s expected unit sales. Prepare a production budget by quarters for the first 6 months of 2020.arrow_forward
- Please solve all requiremetnsarrow_forwardThe 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…arrow_forwardInfinity Inc. has provided the following projected sales units for the next quarter: Projected Sales Units First month Second month Third month Projected sales units 10,000 12,000 15,000 Desired ending inventory is determined to be 10% of the next month’s projected sales. The expected purchase cost per unit is $50. Compute the budgeted Costs of goods sold for the next quarter. Group of answer choices $1,850,000 $600,000 $500,000 $750,000arrow_forward
- The marketing department of Kyle Corporation has submitted the following sales forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted sales (units) 8,800 10,800 12,800 11,800 The selling price of the company’s product is $28 per unit. Management expects to collect 60% of sales in the quarter in which the sales are made and 35% 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 $88,500. The company expects to start the first quarter with 2,400 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 2,650 units. Required: 1-a. Prepare the company's sales budget. 1-b. Prepare the schedule of expected cash collections. 2.…arrow_forwardThe marketing department of IKEA Inc. has submitted the following sales forecast for the upcoming fiscal year. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 7,000 6,000 10,000 8,000 The company expects to start the first quarter with 1,500 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 1,100 units. Each unit requires 0.75 direct labor-hours, and direct laborers are paid $16.00 per labor hour. The variable portion of its predetermined manufacturing overhead rate is $ 4 per direct labor-hour and its total fixed manufacturing overhead is $35,000 per quarter. The only noncash item included in fixed manufacturing overhead is depreciation, which is $8,000 per quarter. The company’s variable selling and administrative expense per unit is $7.50. Fixed selling and administrative expenses include…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education





