Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Unit Sales Dollar Sales 32,500 S 975,000 July August September October 33,700 1,061,550 38,000 36,000 1,197,000 1,141,200 Company policy requires that ending inventories for each month be 25 percent of next month's sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.

Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Unit Sales Dollar Sales 32,500 S 975,000 July August September October 33,700 1,061,550 38,000 36,000 1,197,000 1,141,200 Company policy requires that ending inventories for each month be 25 percent of next month's sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.

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

Walker Company prepares monthly budgets. Company policy is to end each month with merchandise inventory equal to 15% of budgeted unit sales for the following month. Budgeted sales and merchandise purchases for the next three months follow. Beginning inventory on July 1 is 27,000 units. The company budgets sales of 200,000 units in October. The merchandise cost per unit is $2. Budgeted sales units. Units to purchase July 180,000 200,250 August 315,000 308,250 September 270,000 259,500 Prepare the merchandise purchases budgets for the months of July, August, and September. WALKER COMPANY Merchandise Purchases Budget July August September Next period budgeted sales units Ratio of inventory to future sales 0 0 0 Total required units Units to purchase Cost per unit Cost of merchandise purchases
Tasty Foods expects to have 20,000 units of finished goods inventory on hand on March 31 and reports the following expected sales (in units) for the months of April through July: April 120,000 May June July 130,000 140,000 120,000 At the end of each month the company desires its ending finished goods inventory to be 20% of the next month's projected sales (in units). The budgeted production (in units) for Tasty Foods for May should be: A. 104,000. B. 128,000. C. 130,000. D. 132,000. E. 138,000. A O B C D E
Omega DB Company has a sales budget for next month of P150,000. Cost of goods sold is expected to be 40 percent of sales. All goods are purchased in the month used and paid for in the month following purchase. The beginning inventory of merchandise is P5,000, and an ending inventory of P6,000 is desired. Beginning accounts payable is P38,000.For Omega DB Company, the ending accounts payable should be
Neon Inc. has a finished goods inventory of 20,000 units on July 1. The projected sales for July, August and September are 80,000 units, 90,000 units and 100,000 units, respectively. Its desired ending inventory is estimated as 20% of the current month’s budgeted sales. Determine the budgeted production for July. Group of answer choices 116,000 units 16,000 units 96,000 units 76,000 units
Metro, Incorporated sells backpacks. The Company's accountant is preparing the purchases budget for the first quarter operations. Metro maintains ending inventory at 15% of the following month's expected cost of goods sold. Expected cost of goods sold for April is $78,000. All purchases are made on account with 30% of accounts paid in the month of purchase and the remaining 70% paid in the month following the month of purchase. Sales January $ 44,000 February $ 58,000 Budgeted cost of goods sold Plus: Desired ending inventory Inventory needed Less: Beginning inventory March $ 64,000 8,700 52,700 (6,600) Required purchases $ 43,900 Based on this information the amount of accounts payable appearing on the March 31 pro forma balance sheet is Multiple Choice $19,830. $46,270. $66,100. None of the answers is correct.
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 %
Komodo Supply Company's monthly sales budget is as follows: April $160,000, May $130,000, and June $120,000. The company's policy is to set selling prices to earn a 30% gross profit on sales revenue and to maintain an ending inventory balance equal to 40% of the next month's cost of goods sold. What is the dollar amount of inventory purchases that is budgeted for the month of May? O $87,800 $88.200 O $89.600 $93,800 O None of the above
The following information applies to questions 25 and 26 The sales budget for Fred Limited contains the following information: October November December Units 300 550 700 $ (thousands) 75,000 165,000 210,000 Sales are all on credit, with 30% collected in the month of sale and 70% in the following month. Finished goods inventory at the end of each month should be 58% of the following month's sales requirements. Prepare a finished goods inventory budget and use it to answer Following Calculate the closing finished goods inventory, in units, for October. Calculate the required production, in units, for October.
Tyler Company budgets the following unit sales for the next four months: April, 3,800 units; May, 4,600 units; June, 6,900 units; and July, 2,800 units. The company's policy is to maintain finished goods inventory equal to 30% of the next month's unit sales. At the end of March, the company had 1,140 finished units in inventory. Prepare a production budget for each of the months of April, May, and June. Next period budgeted sales units Desired ending inventory units Total required units Units to produce TYLER COMPANY Production Budget April % May % June %
COVID19Co produces hand tools. A sales budget for the next four months is as follows March10.700 units, April 13.600, May 16,200, and June 21.200 COVID19Co's ending finished goods inventory policy is 10% of the following month's sales. What is budgeted ending finished goods inventory for March?
Lexi Company budgets unit sales of 1,510,000 in April, 1,210,000 in May, 320,000 in June, and 1,940,000 in July. Beginning inventory on April 1 is 604,000 units, and the company wants to have 40% of next month's unit sales in inventory at the end of each month. The merchandise cost per unit is $0.50. Prepare a merchandise purchases budget for the months of April, May, and June. LEXI COMPANY Merchandise Purchases Budget April May June Next period budgeted sales units Ratio of inventory to future sales Total required units Units to purchase Cost per unit Cost of merchandise purchases $ $ $