the ones in blue are correct and finished, I need 6,7,8,and 9
Thompson Inc. makes snowboards. The company has provided the following information. Please complete the mater budget using the information provided. Expected Sales for January 2,900 units Expected Selling Price 650 units Beginning Finished Goods Inventory 500 units $ 374.80 per unit Desired Ending Finished Goods Inventor 200 units $ 607.00 per unit Materials Requirements Wood 9 board feet per snowboard Fiberglass 10 yards per snowboard Direct Materials Inventory Wood 01/01/2018 2.040 board feet S 32.00 per board feet Fiberglass 01/01/2018 1,040 yards S 8.00 per yard Wood 01/31/2018 1,540 board feet S 34.00 per board feet Fiberglass 01/31/2018 2.040 yards S 9.00 per yard Direct Manufacturing Labor 5 hours per unit S 29.00 per hour Variable Manufacturing Overhead S 7.00 per direct labor hour Fixed Manufacturing Costs $ 81,000 Budgeted Total Manufacturing Cost Per Unit S 66.00 Variable Marketing Costs 38 visits $ 250.00 per visit Fixed Selling and Administrative Costs S 35,000 Requirement 1 Revenue Budget For the Month of January Units Selling Price Total Revenue 2,900 $ 650 $ 1,885,000 Snowboards Requirement 2 Production Budget For the Month of January Budgeted units sales Add target ending finished goods inventory Tota required units Deduct beginning finished goods inventory Units to be produced 2,900 200 3,100 500 2,600 Requirement 3 Direct Material Usage Budget in Quantity and Dollars For the Month of January Material Wood Fiberglass Physical Units Budget Wood (2,600 units * 9 b.f) 23,400 b.f. Snowboards (2,600 units * 10 yards) 26,000 yards To be used in Production 23,400 b.f. 26,000 yards Cost Budget Available from beginning inventory Wood (2,040 b.f. * $32 per b.f) $ 65,280 Fiberglass (1,040 yards * $8 per yard) $ 8,320 To be used from purchases this period Wood (23,400 - 2,040) b.f* $34.00 per b.f $ 726,240 Fabric (26,000 - 1,040) yards * $9.00 per yard $ 224,640 Total Cost of Direct materials to be used $ 791,520 $ 232,960 Requirement 4 Direct Materials Purchases Budget For the Month of January Material Wood Fiberglass Production Usage 23,400 b.f. 26,000 yards Add target ending inventory 1,540 b.f. 2,040 yards Total requirement 24,940 b.f. 28,040 yards Deduct beginning inventory 2,040 b.f. 1,040 yards Purchases to be made 22,900 b.f. 27,000 yards Cost Budget Wood (22,900 b.f. * $34 per b.f) $ 778,600 Fiberglass (27,000 yards * $9 per yard) $ 243,000 Purchases $ 778,600 $ 243,000 Requirement 5 Direct Manufacturing Labor Costs Budget For the Month of January DL Hours per Units produced Wage rate Total unit 2,600 5$ 29.00 $ 377,000 Manuf. Labor Part 6: Prepare a Manufacturing Overhead Budget Thompson Inc. Manufacturing Overhead Budget For the Month of January Variable Manufacturing Overhead Costs Fixed Manufacturing Overhead Costs Total Manufacturing Overhead Costs Part 7: Prepare an Ending Inventories Budget Thompson Inc. Ending Inventories Budget For the Month of January Units Cost per Unit Total Direct Materials Wood Fiberglass Finished Goods Total Ending Inventory Part 8: Prepare a COGS Budget Thompson Inc. COGS Budget For the Month of January Beginning Finished Goods Inventory 01/01/2018 Direct Materials Used Direct Manufacturing Labor Manufacturing Overhead Cost of Goods Available Deduct Ending Inventory COGS Part 9: Prepare a Budgeted Income Statement. Thompson Inc. Budgeted Income Statement For the Month of January Revenues COGS Gross Margin Variable Marketing Costs Fixed Selling and Administrative Costs Net Operating Income
