The following information relstes to a company that produces a single product. Esch unit requires four pounds of material. Inventory requirements are as follows: a. The finished goods inventory on hand at the end of each month must be equal to 8,000 units plus 28% of the next month's sales. The finished goods inventory on December 31 is budgeted based on this requirement. b.The raw materials inventory on hand at the end of esch month must be equal to one- half of the following month's production needs for rew materials. The row materials inventory on December 31 is budgeted based on this requirement. c. The company maintains no work in process inventories. A sales budget for the company for the first and second quarters of the upcoming year follows. Budgeted Sales in Units 43,000 53,000 73,000 38,000 23,000 13,000 January February Morch April May June Required: 1. Prepare a production budget for the upcoming year for the months of January. February, March and April. Production Budget January February March April Budgeted sales Total needs Required production 3. Prepare a direct materials budget showing the quantity of material to be purchased for January, February, March and for the quarter in total.

The following information relstes to a company that produces a single product. Esch unit requires four pounds of material. Inventory requirements are as follows: a. The finished goods inventory on hand at the end of each month must be equal to 8,000 units plus 28% of the next month's sales. The finished goods inventory on December 31 is budgeted based on this requirement. b.The raw materials inventory on hand at the end of esch month must be equal to one- half of the following month's production needs for rew materials. The row materials inventory on December 31 is budgeted based on this requirement. c. The company maintains no work in process inventories. A sales budget for the company for the first and second quarters of the upcoming year follows. Budgeted Sales in Units 43,000 53,000 73,000 38,000 23,000 13,000 January February Morch April May June Required: 1. Prepare a production budget for the upcoming year for the months of January. February, March and April. Production Budget January February March April Budgeted sales Total needs Required production 3. Prepare a direct materials budget showing the quantity of material to be purchased for January, February, March and 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

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
The production planner of a company forecasts the sales over the next six months as 180, 220 , 210, 190, 170, and 210 units, respectively. The beginning inventory is 100 units and the last monthly production level was 130 units. The unit costs are given as follows: Inventory holding cost is 90 TL per unit per month; production cost is 1150 TL per unit; production level increasing cost is 300 TL per unit; and production level decreasing cost is 400 TL per unit. The planner decides to use level strategy, where the monthly production level is determined equal to the average of net demand. What is the total cost (in TL) of the resulting plan? O a 1,246,350 O b. 1,347,450 O c. 1,412,850 O d. 1,391,100 O e. 1,278,600
The LFH Corporation makes and sells a single product, Product T. Each unit of Product T requires 1.5 direct labor-hours at a rate of $10.50 per direct labor-hour. The direct labor workforce is fully adjusted each month to the required workload. LFH Corporation needs to prepare a Direct Labor Budget for the second quarter of next year. The company has budgeted to produce 28,000 units of Product T in June. The finished goods inventories on June 1 and June 30 were budgeted at 800 and 600 units, respectively. Budgeted direct labor costs for June would be: Multiple Choice $441,000 $294,000 $437,850 $444,150
D’Lightful Lamp Company manufactures lamps. The estimated number of lamp sales for the last three months of the year are as follows: Month Sales October 10,000 November 14,000 December 13,000 Finished goods inventoryat the end of September was 3,000 units. Ending finished goods inventory is budgeted to equal 25 percent of the next month's sales. The company expects to sell the lamps for $25 each. January 2018 sales is projectedat 16,000 lamps. What is the expected revenue for the three months from October to December? Question 18 options: 1) $250,000 2) $925,000 3) $325,000 4) $343,750
Thunder Creek Company uses 2 pounds of direct materials for each unit it produces, at a cost of $4.00 per pound. The company begins the year with 9,500 pounds of material in Raw Materials Inventory. Management desires an ending inventory of 25% of next month's materials requirements Prepare a Direct Materials Budget. (When entering answers in the direct materials budget, use the production budget for your cell references. Enter all values as positive--without a minus sign--in row 31.) 2018 Jan Feb Q1 Total April Budget #3: Direct Materials Budget Budgeted units to be produced Mar 30,800 25,200 19,200 2.00 Direct materials (pounds) per unit 2.00 Direct materials needed for production 50,400 38,400 12,600 2.00 61,600 8,600 Plus: Desired direct materials in ending inventory (pounds) 15,400 Total direct materials needed 51,000 65,800 70,200 Less: Direct materials in beginning inventory (pounds) 9,500 12,600 15,400 Budgeted purchase of direct materials 41,500 53,200 54,800 Direct material…
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.
Cholin Co. manufactures a single product. It keeps inventory of raw materials at 150% of the coming month's budgeted production needs. Each unit of product requires three pounds of materials. The production budget is in units: May-1,000; June-1,200; July 1,300; August-1,600. Raw material purchases in July should be? a. 5,250 pounds b. 1,950 pounds c. 4,800 pounds d. 3,500 pounds
ABC Company has a policy of maintaining aninventory of finished goods equal to 25% of the following month's sales units. For the forthcoming month of June, the budgeted beginning inventory is at 20,000 units and the ending inventory at 22,000 units. The following are the budgeted sales for the months of August to October October 94,500 August 90,000 September 92,000 The sales price the finished goods per unit is P150 based on gross profit rate (on cost) of 15%. October ending inventory is estimated to be at 20% less than September's. Operating expenses were estimated as follow: Selling expense is at 2.75% of sales Salary expense is at P5,000 + 3% of sales General and Administrative Expense is at P40,000 per month How much is the cost of sales for the month of June?
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 $…
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.
Ajax Manufacturing produces a single product, which takes 8.0 pounds of direct material per unit produced. The company's policy is to maintain an end-of-quarter inventory of materials equal to 25 percent of the following quarter's material requirements for production. At the end of the 4th quarter, there were 72,000 pounds of material on hand. Assume it is currently the end of the first quarter of the new year. a. How many units of product were produced this quarter? b. Under the assumption that production will increase by 10% in the second quarter, what are the direct material requirements (in pounds) for planned production in the second quarter?