how to comprehend part g the manufacturing overhead. use the blue pic as the format for part g

\f2. The Brass Instruments Stand requires one types of raw materials: Plastic a Each Brass Instruments Stand requires 1.4 kilograms of Plastic, at the cost of 51.5 per kilogram. e The supplier of Plastic tends to be somewhat erratic, so Brass Instruments Inc nds it necessary to maintain an inventory balance equal to 20% of the material needed for the next month as a precaution against stock-o uts. The direct material on June Si} is 3124!] Itg. S. The beginning accounts payable will oonsist of $115,293. 4. Brass Instruments Inc pays for 50% of a month's purchases in the month of purchase and suits in the following month. 5. The manufacturing overhead is based on direct labour hours. The workers receive an average of $16.00 per hour, including employee benets. Each Brass Instruments Stand takes 13 minutes to complete. 6. Brass Instruments Inc allocate the manufacturing overhead based on direct lot-our hours; The variable manufacturing overhead is as follow: Maintenanoe $0.40,- Utilities $0.6m Indirect Labor $0.50; Indirect materials SBA!) If. The Monthly Fixed manufacturing overhead cools are as follows: lanito rial 32.293 Insurance $1.4\"I Depreciation $14,200 Property Taxes SLDDD Salaries $44.UU 3. Brass Instruments Inc allocate the selling and administration expenses based on units sales; The variable selling and administration rate is 51.5 per unit sales. 5. The Monthly Selling and administrative expenses are Salaries SELDDG Dther fixed cost $3,6DD Insu ranoe $1,1DD Depreciation $2,300 Advertising _ _ _ $12,DDO 1!). Sales are on account (credit); 50% of the sales are collected during the month of sales and 513% the following month. This was the same collection pattern as in previous years. 11. The company wants to maintain at the end of each month a minimum bank balance of $5DB,BGG. In case the company has a deciency of money or is not able to reach this minimum bank balance, the company 3 can borrow from a line of credit at the rate of 3% per annum. All borrowing is considered to happen on the first day of the month, and repayments are on the last day of the month. All borrowings and repayments from the bank should be in multiples of $1,DDB. It pays interest monthly. The cash balance on June so is $134,000 12. In August, $630,000 of new equipment to update operations will be purchased with cash. Please ignore the depreciation of this new asset. 13. Three months' insurance is prepaid on the rst day of the first month of the quarter. 14. The company has a Common Stock beginning balance of 5-1,.05015125511030326. Required: Prepare the budget for 2021, the third quarter, for Brass lnstrum ents Inc for the including the following schedules: Prepare the following Schedules [in the same order} a} Prepare the Sales Budget for the third quarter {textbook Illustration 103:: hi Prepare the Schedule of Expected Collection from Customers for the third quarter [Illustration 1B.1?} cl Prepare the Production Budget for the third quarter {Illustration 10.51 di Prepare the Direct Materials Budget for the third quarter {Illustration ma} e) Prepare the Expected Direct Material Cash Disbursements for the third quarter (Illustration 10.18) Prepare the Direct Labour Budget for the third quarter (Illustration 10.11) g) Prepare the Manufacturing Overhead Budget for the third quarter (Illustration 10.12) h) Prepare the Unit cost (Illustration 10.14)A B C D E F HAYES COMPANY Manufacturing Overhead Budget For the Year Ending December 31, 2020 Quarter 2 3 4 Year Variable costs Indirect materials ($1.(0/hour) $ 6.200 $ 7.200 $ 8.200 $ 9.200 $ 30.800 Indirect labour ($1.40/hour) 8.680 10.080 11.480 12.880 43.120 Utilities (50,40/hour) 2.480 2.880 3.280 3.680 12.320 10 Maintenance ($0.20/hour) 1.240 1,440 1.640 1.840 6.160 11 Total variable costs 18.600 21.600 24.600 27.600 92.400 12 Fixed costs 13 Supervisory salaries 20,000 20.0 00 20,000 20 000 14 Depreciation 3.800 3,800 3800 15,200 15 Property taxes and insurance 9.000 9,000 9.000 9,000 36,000 16 Maintenance 5.700 5.700 5.70 0 5.700 12.800 17 Total fixed costs 38 500 38.500 38,500 38 500 154,000 Total manufacturing overhead $57.100 $60, 100 $66, 100 $246,400 Direct labour hours 19 (Illustration 10-11) 6.200 7,200 8.20-0 9.200 30,800 20 Manufacturing overhead rate per direct labour hour ($246,400 + 30,800) SH