Lubriderm Corporation has the following budgeted unit sales for ...

[natalie2426]

Lubriderm Corporation has the following budgeted unit sales for the next six-month period:
 
  Month Unit Sales
   June 90,000
   July 120,000
   August 210,000
   September 150,000
   October 180,000
   November 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. 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 production budgets in units for July, August, and September.
  b. Prepare a purchases budget in pounds for July, August, and September, and give total purchases in both pounds and dollars for each month.

Question 2

An attribute is equivalent to a field and may also be known as a row.
  Indicate whether the statement is true or false

[jaykayy05]

Answer to Question 1

Answer:
a. July August September
Budgeted sales 120,000 210,000 150,000
Add: Required ending inventory 42,000 30,000 36,000

Total inventory requirements 162,000 240,000 186,000
Less: Beginning inventory 24,000 42,000 30,000

Budgeted production 138,000 198,000 156,000

b. July August September
Production in units 138,000 198,000 156,000

Targeted ending inventory in lbs. 297,000 234,000 252,000
Production needs in lbs. 690,000 990,000 780,000

Total requirements in lbs. 987,000 1,224,000 1,032,000
Less: Beginning inventory in lbs. 207,000 297,000 234,000

Purchases needed in lbs. 780,000 927,000 798,000
Cost (8 per lb.)  8  8  8

Total material purchases 6,240,000 7,416,000 6,384,000
 0.3 times next month's needs
 (180,000 + 24,000 - 36,000) times 5 lbs.  0.3
 5 lbs. times units to be produced, across row
 (690,000  .3) = 207,000 lbs., etc. row across

Answer to Question 2

F

[natalie2426]

Thanks for the timely response, appreciate it

[nanny]

Gracias!