Problem 1 Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of material costs $8 in June, $9 in July and $10 in August. Inventory levels for materials are equal to 30% of the needs for the next month. Materials inventory on June 1 was 15,000 pounds. Required: a. Prepare a Production Budgets in units for July and August. b. Prepare a Direct Material Usage Budget for July and August. c. Prepare a Direct Material Purchases Budget for July and August. a. Production Budget (in units) for the month of July August Budgeted sales Add: Required ending inventory Total inventory requirements Less: Beginning inventory Budgeted production 138,000 198,000 Cont'd Problem 1 July Pro b. Direct Material Usage Budget in Quantity and Dollars August Pounds Pounds Ani plas Is 3 Physical Units Budget Direct materials required for production Total quantity of direct material to be used Cost Budget Available from beginning direct materials inventory (under a FIFO cost-flow assumption) To be purchased this period Direct materials to be used this period $6,003,000 $9,603,000 C. Direct Material Purchases Budget July August AL Pounds Pounds Physical Units Budget To be used in production Add target ending inventory Total requirements Deduct beginning inventory Purchases to be made Cost Budget Direct materials Total cost of Purchase $7,020,000 $9,270,00