Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assuming the work i have done is correct, please do part 7, 8 and 9. thank you! B C 1 Part 1: Prepare a Revenue
Assuming the work i have done is correct, please do part 7, 8 and 9.
B C 1 Part 1: Prepare a Revenue Budget. D 2 4 au w 3 Thompson Inc. Revenues Budget For the Month of January Units Selling Price Total Revenues 7 2.900 $ 650 $ 1,885,000 8 9 Part 2: Prepare a Production Budget in (units). 10 11 Thompson Inc. 12 Production Budget (units) 13 For the Month of January 14 Units 15 Budgeted Unit Sales 2,900 16 Add: Desired Ending Finished Goods Inventory 200 17 Total Requirements 3,100 18 Deduct: Beginning Finished Goods Inventory 500 19 Units to Be Produced 2,600 20 21 Part 3: Prepare a Direct Materials Usage budget. 22 23 Thompson Inc. 24 Direct Materials Usage Budget 25 For the Month of January 26 Wood Fiberglass 27 Physical Units Budget 28 Wood 23,400 Template Data 16 22 26 Fiberglass 26,000 26 000 8,320 23 Thompson Inc. 24 Direct Materials Usage Budget 25 For the Month of January Wood 27 Physical Units Budget 28 Wood 23,400 29 Fiberglass 30 To Be Used in Production 23,400 31 32 Cost Budget 33 Available from Beginning Inventory 34 Wood 65 280 35 Fiberglass $ 36 To Be Used From Purchases this Period 37 Wood 726,240 38 Fiberglass 39 Total Cost of Direct Materials to be Used S 791,520 $ 40 41 Part 4: Prepare a Direct Materials Purchases Budget 42 43 Thompson Inc. Direct Materials Purchases Budget For the Month of January 46 Wood 47 Production Usage 23.400 48 Add: Target Ending Inventory 1.540 49 Total Requirements 24 940 can Template Data + Ready 224,640 232,960 44 45 Fiberglass 26,000 2,040 28.040 LA Type here to search o O Font 12 Alignment 20 X fx D E B Direct Materials Purchases Budget For the Month of January Wood Production Usage 23 400 Add. Target Ending Inventory 1,540 Total Requirements 24 940 Deduct: Beginning Inventory 2,040 Purchases 22.900 Fiberglass 26,000 2,040 28 040 1,040 27,000 Cost Budget Wood $ 778,600 Fiberglass S 243,000 5 Purchases $ 778,600 $ 243 000 7 3 Part 5: Prepare a Direct Manufacturing Labor Budget 9 0 Thompson Inc. 1 Direct Manufacturing Labor Budget 2 For the Mouth of January -3 -4 Labor Category Units Produced DL Hours Per Unit Wage Rate Total - Manufacturing Labor 2.600 5 5$ 29 $ 377.000 6 7 Part 6: Prepare a Manufacturing Overhead Budget 58 59 Thompson Inc. TO Manufacturing Overhead Budget 21 For the Month of January Template Data Ready Type here to search o Prepare a Manufacturing Overhead Budget 68 69 Thompson Inc. 70 Manufacturing Overhead Budget 71 For the Month of January 72 73 Variable Manufacturing Overhead Costs 74 Fixed Manufacturing Overhead Costs 75 Total Manufacturing Overhead Costs 76 77 Part 7: Prepare an Ending Inventories Budget 78 79 Thompson Inc. 80 Ending Inventories Budget 81 For the Month of January 82 Units 83 Direct Materials 84 Wood 85 Fiberglass B6 Finished Goods 87 Total Ending Inventory 88 Cost per Uni Total D E 91 88 89 Part 8: Prepare a COGS Budget 90 Thompson Inc. 92 COGS Budget 93 For the Month of January 94 95 Beginning Finished Goods Inventory 01/01/2018 96 Direct Materials Used 97 Direct Manufacturing Labor 98 Manufacturing Overhead 99 Cost of Goods Available 100 Deduct Ending Inventory 101 COGS 102 103 Part 9: Prepare a Budgeted Income Statement. 104 Thompson Inc. Budgeted Income Statement For the Month of January 105 106 107 108 109 Revenues 110 COGS 111 Gross Margin 112 Variable Marketing Costs 113 Fixed Selling and Administrative Costs 114 Net Operating Income 115 3 $ 1 Thompson Inc. makes snowboards. The company has provided the following information. 2 Please complete the mater budget using the information provided. 3 4 Expected Sales for January 2.900 units 5 Expected Selling Price 650 units 6 Beginning Finished Goods Inventory 500 units $ 374.80 per unit 7 Desired Ending Finished Goods Inventor 200 units $ 607.00 per unit 8 Materials Requirements 9 Wood 9 board feet per snowboard 10 Fiberglass 10 yards per snowboard 11 Direct Materials Inventory 12 Wood 01/01/2018 2.040 board feet $ 32.00 per board feet 13 Fiberglass 01/01/2018 1,040 yards $ 8.00 per yard 14 Wood 01/31/2018 1.540 board feet 34.00 per board feet 15 Fiberglass 01/31/2018 2,040 yards $ 9.00 per yard 16 Direct Manufacturing Labor 5 hours per units 29.00 per hour 17 Variable Manufacturing Overhead $ 7.00 per direct labor hour 18 Fixed Manufacturing Costs 81,000 19 Budgeted Total Manufacturing Cost Per Unit $ 66.00 20 Variable Marketing Costs 38 visits $ 250.00 per visit 21 Fixed Selling and Administrative Costs $ 35,000 AAAA thank you!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started