Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Unit Sales Dollar Sales July 32,500 $990,000 August 34,000 1,065,000 September 38,500 1,202,000 October 35,500 1,141,800 Company policy requires that ending inventories for each month be 20 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 Production Budget For the Third Quarter July August September Totalr Unit sales Total needed Units produced

Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Unit Sales Dollar Sales July 32,500 $990,000 August 34,000 1,065,000 September 38,500 1,202,000 October 35,500 1,141,800 Company policy requires that ending inventories for each month be 20 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 Production Budget For the Third Quarter July August September Totalr Unit sales Total needed Units produced

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

Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. May (Actual) June (Budget) July (Budget) August (Budget) 6,000 4,100 $ 900,000 2,400 5,000 $360,000 $750,000 $ 615,000 Sales units Sales dollars. All sales are on credit. Collections are as follows: 24% is collected in the month of the sale, and the remaining 76% is collected in the month following the sale. Merchandise purchases cost $110 per unit. For those purchases, 60% is paid in the month of purchase and the other 40% is paid in the month following purchase. The company has a policy to maintain an ending monthly inventory of 22% of the next month's unit sales. The May 31 actual inventory level of 1,320 units is consistent with this policy. Selling and administrative expenses of $114,000 per month are paid in cash. The company's minimum cash balance at month-end is $140,000. Loans are obtained at the end of any month when the preliminary cash balance is below $140,000. Any preliminary cash…
Micro Corporation has budgeted sales of its microchips for the next four-month as follows: Units Sold April 20,000 May 25,000 June35,000 July 40,000 The company is preparing a production budget for the third quarter. Ending inventory level must equal 20% of the next month's sales. Calculate the ending inventory as of March 31.
Breaded Oak, Inc. has a policy that requires 20 percent of the expected sales of its product to be on hand at the end of the prior month. Forecasted sales, in units, for the months of January through April are as follows: January 36,000 units February 42,000 units March 58,000 units April 52,000 units a) Calculate the number of units planned for ending inventory for January, February, and March. b) Calculate the number of units budgeted to be produced in January, February, and March.
The Cardinal Company had a finished goods inventory of 55,000 units on January 1. Its projected sales for the next four months were: January - 200,000 units; February - 180,000 units; March - 210,000 units; and April - 230,000 units. The Cardinal Company wishes to maintain a desired ending finished goods inventory of 20% of the following months sales. What is the budgeted units of inventory for March 31? a. 46,000 b. 42,000 c. cannot be determined from the data given d. 36,000
Cardinal Company has finished goods inventory of 55,000 units on January 1. Its projected sales for the next four months are: January, 200,000 units; February, 180,000 units; March, 210,000 units; and April, 230,000 units. Cardinal Company wishes to maintain a desired ending finished goods inventory of 20% of the following month's sales. The budgeted units of inventory for March 31 a.would be 46,000 units b.would be 42,000 units c.cannot be determined from the data given d.would be 36,000 units
Thornton Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Thornton's policy is to maintain an ending inventory balance equal to 15 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $84,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 quarter. 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 January February March Budgeted cost of goods sold $ 59,000 $ 63,000 $ 69,000 Plus: Desired ending inventory 9,450 Inventory needed 68,450 Less: Beginning…
Rooney Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Rooney’s policy is to maintain an ending inventory balance equal to 15 percent of the following month’s cost of goods sold. April’s budgeted cost of goods sold is $82,000. Required Complete the inventory purchases budget by filling in the missing amounts. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.
Bodin Company budgets on an annual basis. The following beginning and ending inventory levels (in units) are plannned for the year 20x1. Four units of raw material are required to produce each unit of finished product. Raw material Work in process Finished goods January 11 December 31 35,000 19,000 97,000 48,000 19,000 74,000 Required: 1. If Bodin Company plans to sell 450,000 units during the year, compute the number of units the firm would have to manufacture during the year. 1. Required production in units 2. Raw material purchases in units 2. If 508,000 finished units were to be manufactured by Bodin Company during the year, determine the amount of raw material to be purchased.
Required information [The following information applies to the questions displayed below.] Shadee Corporation expects to sell 540 sun shades in May and 310 in June. Each shade sells for $156. Shadee's beginning and ending finished goods inventories for May are 65 and 55 shades, respectively. Ending finished goods inventory for June will be 50 shades. Required: 1. Prepare Shadee's sales budget for May and June. 2. Prepare Shadee's production budget for May and June. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required 1equired 2 Prepare Shadee's sales budget for May and June. May June Budgeted Total Sales $ 54,210 x $ 48,360 Required 1 Required 2 >