how to do part b. Needs to match image 10.17 format. This is all the info provided
\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} ILLUSTRATION 10.17 Collections from customers A B C D E F HAYES COMPANY 2 Schedule of Expected Collections from Customers 3 Collections by Quarter 4 Salesa 1 2 3 4 5 Accounts receivable, December 31, 2019 $ 60,000 6 First quarter $180,000 108,000 $ 72,000 7 Second quarter 210,000 126,000 $ 84,000 8 Third quarter 240,000 144,000 $ 96,000 9 Fourth quarter 270,000 162,000 10 Total collections $168,000 $198,000 $228,000 $258,000 11 12 aPer Illustration 10.3; $180,000 X 0.60; *$180,000 X 0.40 13
