Question

L M N O P Q R S at 10 at A1 ✓ fx Part 2 C D E F G H I J K 7 The budget director for Bird House Unlimited, Inc., has gathered the following data for use in developing the budgeted income statement for January 2020. Estimated sales for January Bird House 34,000 units $42 per unit Bird Feeder 25,000 units $70 per unit Direct materials Estimated inventories at January 1(beginning) Wood 2600 feet Plastic 3200 pounds Estimated inventories at January 31st(ending) Wood 3500 feet Plastic 2800 pounds Direct materials used in production: In the manufacture of a Bird House: Wood Plastic 0.80 feet per unit of product 0.50 pounds per unit of product In the manufacture of a Bird Feeder: Wood Plastic 1.20 feet per unit of product 0.75 pounds per unit of product Estimated cost of direct materials Wood Plastic $6.50 per feet $0.90 per pound Work in process-given in total of the 2 products Estimated inventories at January 1(beginning) Estimated inventories at January 31st(ending) $27,000 $32,400 36 37 38 Finished Goods Estimated inventories at January 1(beginning) Bird House Project 3 Part 1 Part 2 Budget Template 4900 units at $25 per unit Ready 0 -
Apologies for the long question!

Answer 1

1.

Sales Budget
January
	Birdhouse	Birdfeeder	Total
Unit Sales Volume	34000	25000	59000
Unit Selling Price	$                            42	$                            70
Total Revenue from sales	$             1,428,000	$             1,750,000	$                    3,178,000

2.

Production Budget
January
	Birdhouse	Birdfeeder	Total
Expected Unit Sales	34000	25000	59000
Add : Desired Ending Finished Good Units	5300	2100
Total Required Units	39300	27100	66400
Less : Beginning Finished Good units	4900	2500
Required Production units	34400	24600	59000

3.

Direct Materials Budget
January
	Wood		Plastic		Total
Required Units for production
Birdhouse	27520	=34400*0.8	17200	=34400*0.5	44720
Birdfeeder	29520	=24600*1.2	18450	=24600*0.75	47970
Add : Desired Ending inventory	3500		2800
Total Required Units	60540		38450		98990
Less : Beginning inventory	2600		3200
Total Units to be Purchased	57940		35250		93190
Unit Price	$                        6.50		$                               0.90
Total costs for direct materials	$                 376,610		$                          31,725		$    408,335

4.

Direct Labor Budget
January
	Fabrication Department		Assembly Department		Total
Hours Required for Production
Birdhouse	8600	=34400*0.25	10320	=34400*0.3	18920
Birdfeeder	11070	=24600*0.45	8610	=24600*0.35	19680
Total hours	19670		18930		38600
Hourly Rate	$                            14		$                                  10
Total cost of direct labor	$                 275,380		$                        189,300		$    464,680

As per HOMEWORKLIB RULES we are supposed to answer 4 parts, i have answered 4, so kindly post other parts separately