Author Question: Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month ... (Read 188 times)

natalie2426 · **on:** Jul 5, 2018

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 · **Reply #1 on:** Jul 5, 2018

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