Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Unit Sales Dollar Sales July 30,000 $985,000 August 34,000 1,062,800 September 38,000 1,200,000 October 37,000 1,142,100 Company policy requires that ending inventories for each month be 25 percent of next month's sales. At the begini 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 month as well as for the quarter in total. Palmgren Company Production Budget For the Third Quarter July August September Total Unit sales 30,000 V 34,000 V 38,000 102,000 Desired ending inventory 8,500 9,500 9,250 27,250 X Total needed 38,500 43,500 47,250 129,250 X Less: Beginning inventory 7,500 8,500 9,500 25,500 X

Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Unit Sales Dollar Sales July 30,000 $985,000 August 34,000 1,062,800 September 38,000 1,200,000 October 37,000 1,142,100 Company policy requires that ending inventories for each month be 25 percent of next month's sales. At the begini 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 month as well as for the quarter in total. Palmgren Company Production Budget For the Third Quarter July August September Total Unit sales 30,000 V 34,000 V 38,000 102,000 Desired ending inventory 8,500 9,500 9,250 27,250 X Total needed 38,500 43,500 47,250 129,250 X Less: Beginning inventory 7,500 8,500 9,500 25,500 X

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

Yummy Foods expects to have 43,000 pounds of raw materials inventory on hand on March 31, the end of the current year. The company budgets the following production (in units) for April through July, inclusive: April 127,000 May 137,000 June 153,000 July 127,000 At the end of each month the firm desires its ending raw material inventory to be 10% of the next month's production needs. Each finished unit requires three pounds of raw materials.Yummy Foods’ budgeted purchases for raw materials (in pounds) during April should be:
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
Bodin Company budgets on an annual basis. The following beginning and ending inventory levels (in units) are plannned for the year 20x1. Five units of raw material are required to produce each unit of finished product. Raw material Work in process Finished goods January 1 December 31 36,000 17,000 98,000 51,000 17,000 62,000 Required: 1. If Bodin Company plans to sell 472,000 units during the year, compute the number of units the firm would have to manufacture during the year. 2. If 509,000 finished units were to be manufactured by Bodin Company during the year, determine the amount of raw material to be purchased. 1. Required production in units 2. Raw material purchases in units cBook Pro 6) U G K C V. N
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.
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.
GIVEN: Below is a Production Budget for the third quarter of a company's fiscal year that includes forecasted monthly unit sales. Additionally, management wishes to have 20% of the following month's unit sales as Desired Ending Inventory. July Aug Sep Q3 Oct Unit Sales: 30,000 32,000 34,000 38,000 Desired Ending Inventory: Total Required Units: Beginning Inventory: No. of Units to be Produced: 6,000 22) The Desired Beginning Inventory for August is: A) 6,000 B) 6,400 C) 6,800 D) 7,000 23) The number of units to be produced in September is: A) 34,800 B) 38,800 C) 41,600 D) 46,400
Stuart Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Stuart's policy is to maintain an ending inventory balance equal to 15 percent of the following month's cost of sold. April's budgeted cost of goods sold is $80,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quar Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget Budgeted cost of goods sold Plus: Desired ending inventory Inventory needed Less: Beginning inventory Required purchases (on account) January February March $ 57,000 $…
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 $ $ $
Atlantic Surf manufactures surfboards. The company's budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods Inventory equal (in units) to 40% of the next month's unit sales. As of June 30, the company has 1,600 finished surfboards In Inventory. Budgeted sales units July 4,000 August 5,500 September 4,200 Prepare the production budget for the months of July and August. ATLANTIC SURF Production Budget Desired ending inventory units Total required units Units to be produced July August