Berol Company plans to sell 200,000 units of finished product in July and anticipates a growth rate in sales of 5% per month. The desired monthly ending inventory in units of finished product is 80% of the next month's estimated sales. There are 150,000 finished units in inventory on June 30. Berol Company's production requirement in units of finished product for the three-month period ending September 30 is:

Berol Company plans to sell 200,000 units of finished product in July and anticipates a growth rate in sales of 5% per month. The desired monthly ending inventory in units of finished product is 80% of the next month's estimated sales. There are 150,000 finished units in inventory on June 30. Berol Company's production requirement in units of finished product for the three-month period ending September 30 is:

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: 20,000 22,000 19,500 18,000 March April May June Wright maintains an ending inventory for each month in the amount of two and one-half times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $7 per unit and are paid for in the month after production. Labor cost is $11 per unit and is paid for in the month incurred. Fixed overhead is $19,000 per month. Dividends of $21,400 are to be paid in May. The firm produced 19,000 units in February. Complete a production schedule and a summary of cash payments for March, April, and May. Remember that production in any one month is equal to sales plus desired ending inventory minus beginning inventory. Note: Input all amounts as positive values except Beginning inventory values under Production Schedule which should be entered with a minus sign. Leave no cells blank…
New Energy Incorporated has a beginning inventory balance on January 1 of 25,000 units and desires an ending balance of 20% of the next month’s sales. If sales are expected to be 28,000 for January and 35,000 for February, what is the ending balance as of January 31?
GreenThumb Organic Fertilizer Company plans to sell 240,000 units of finished product in July and anticipates a growth rate in sales of 4 percent per month. The desired monthly ending inventory in units of finished product is 90 percent of the next month's estimated sales. There are 216,000 finished units in inventory on June 30. Each unit of finished product requires 4 pounds of raw material at a cost of $1.75 per pound. There are 880,000 pounds of raw material in inventory on June 30. Required: 1. Compute the company's total required production in units of finished product for the entire three-month period ending September 30. Note: Round all intermediate calculations and your final answer to the nearest unit. 2. Independent of your answer to requirement 1, assume the company plans to produce 600,000 units of finished product in the three-month period ending September 30, and to have raw-material inventory on hand at the end of the three-month period equal to 25 percent of the use in…
Blossom Company estimates that unit sales will be 8,000 in quarter 1, 11,200 in quarter 2, 12,000 in quarter 3, and 14,400 in quarter 4. The sales price is $70 per unit. 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 2022. Expected Unit Sales Add V: Desired Ending Finished Goods Inventory Total Required Units Less V: Beginning Finished Goods Inventory Required Production Units BLOSSOM COMPANY Production Budget For the Six Months Ending June 30, 2022 V 1 8000 2800 10800 Quarter D 11200 3000 14200 Six Months
Blue Wave Co. predicts the following unit sales for the coming four months: September, 3,300 units; October, 4,900 units; November, 6,700 units; and December, 7,900 units. The company's policy is to maintain finished goods inventory equal to 50% of the next month's sales. At the end of August, the company had 2,800 finished units on hand. Prepare a production budget for each of the months of September, October, and November. Blue Wave Co. Production Budget September, October and November September Next month's budgeted sales (units) Units to be produced % October % November %
Narai Co. has a desired ending inventory of 30% of the next months forecasted sales. In turn, their cost of goods sold is 60%, and their forecasted sales for the months of March, April, May, June, and July are as follows: $750,000, $880,000, $700,000, $800,000, and $900,000 respectively. Purchases for the months of February and March were $500,000 and $360,000 and their purchases are paid as follows: 10% during the month of the purchase 80% in the next month and the final 10% in the next month. Required: Prepare budget schedules for the months of April, May, and June for required purchases and also for disbursements for purchases.
Shadee Corporation expects to sell 590 sun shades in May and 360 in June. Each shades sells for $15. Shadee's beginning and ending finished goods inventories for May are 80 and 50 shades, respectively. Ending finished goods inventory for June will be 60 shades. It expects the following unit sales for the third quarter. July August September 545 450 430 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale. 40 percent is collected during the following month, and 8 percent is never collected. Required: Calculate Shadee's total cash receipts for August and September Note: Do not round your intermediate calculations. Round your answers to the nearest whole dollar. Total Cash Receipts August September
Shadee Corporation expects to sell 590 sun shades in May and 360 in June. Each shades sells for $15. Shadee's beginning and ending finished goods inventories for May are 60 and 45 shades, respectively. Ending finished goods inventory for June will be 55 shades. It expects the following unit sales for the third quarter: July August September 545 500 470 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale, 38 percent is collected during the following month, and 10 percent is never collected. Required: Calculate Shadee's total cash receipts for August and September. Note: Do not round your intermediate calculations. Round your answers to the nearest whole dollar. August September Total Cash Receipts
Millen’s managers have made the following additional assumptions and estimates: Estimated sales for July and August are $310,000 and $330,000, respectively. Each month’s sales are 20% cash sales and 80% credit sales. Each month’s credit sales are collected 30% in the month of sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. Each month’s ending inventory must equal 20% of the cost of next month’s sales. The cost of goods sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July. Monthly selling and administrative expenses are always $70,000. Each month $10,000 of this total amount is depreciation expense and the remaining $60,000 relates to expenses that are paid in the month they are incurred. The company does not plan to buy or sell any plant and equipment…
Douglas Company plans to sell 24,000 units of Product A during July and 30,000 units during August. Sales of Product A during June were 25,000 units. Past experience has shown that end-of-month inventory should equal 3,000 units plus 30% of the next month's sales. On June 30 this requirement was met. Based on these data, how many units of Product A must be produced during the month of July?
Vaughan company estimates that unit sales will be 10,500 in quarter 1; 11,400 in quarter 2; 13,400 in quarter 3; and 18600 in quarter 4. management wnta to have an ending finished goods inventory equal to 21% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first six months of 2022