how to comprehend the balance sheet. The common stock amount is 1,075,676. Reference the given schedules as the formats
\f1. From previous experience; management has determined that finished goods ending inventory equal to 20% ofthe next month's unit sal are required to fit the buyer's demands. 2. 'I1'ie Brass Instruments 5tand requires one types of raw materials: Plastic I Each Brass Instruments Stand requires 1.4 kilograms of Plastic. at the cost of 51.5 per kilogram. I The supplier of Plastic tends to be somewhat erratic, so Brass Instruments Inc nds it necessary to maintain an inventory balance equal to 2096 of the material needed for the nerrt month as a precaution against stock-outs. The direct material on June 30 is 3?,140 Itg. 3. The beginning acmunts pays ble will consist of $116,293. 4. Brass lnstmments Inc pays for 5056 of a month's purchases in the month of purchase and 50% in the following month. 5. The manuhctu ring overhead is based on direct labour hours. The workers receive an average of $16.00 per hou r, including employee benets. Each Brass Instruments Stand takes LB minutes to complete. I5. Brass lnstmments Inc allocate the manufacturing overhead based on directinhour hours; The variable manufacturing overhead is as follow: Maintenance $0.40: Utilities $0.60; Indirect Labor 50.50; Indirect materials 50.40 I. The Muddy Fixed rnenufeu ring overhed costs- are as follows: Janitorial 51,200 Insurance 31,450 Depreciation $14300 Propertyr Taxes $2,000 salaries 34mm 3. Brass Instruments Inc allocate the selling and administration expenses based on units sales; The variable selling and administration rate is $1.5 per unit sales. 5. The Monthly Selling and administrative expemes are Salaries 552,000 Other fixed cost 53,-500 Insurance 51,100 Depreciation 52,800 Advertising 512,000 10. Sales are on account [credit]: 5056 ufthe sales are collected during the month of sales and 5056 the following month. This was the same collection pattern as in previous years. 11. The companyr wants to maintain at the end of each month a minimum bank balance of $500J0EI]. In use the companyr has a deficiency of money or is not able to reach this minimum bank balance, the company can borrow from a line of credit at the rate of 3% per annum. All borrowing is considered to happen on the first dair of the month, and repayments are on the last day:r of the month. All borrowings and repayments from the bank should be in multiples of $1,DDD. It pays interest monthlyr. The cash balance on June 3-3 is 51134.net}. 12. In August. $SSU,DDG 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 first day of the first month of the quarter. 14- The wmpanir has a Common Stock beginning balance of 511050.125 5mm .{ 0-. E [:I 1 6 Required: Prepare the budget for 11021, the third quarter. for Brass Instruments Inc for the including the following schedules: Prepare the following Schedules {in the same order} at Prepare the Sales Budget for the third quarter {textbook Illustration 10.31 bl Prepare the Schedule of Expected Collection from Customers for the third quarter {Illustration 1D.1?} c] Prepare the Production Budget for the third quarter {Illustration 1D.S:I dl Prepare the Direct Materials Budget for the third quarter {Illustration 10.9} e] Prepare the Expected Direct Material Cash Disbursements forthe third quarter {Illustration 1D.1B:I f] Prepare the Direct Labour Budget for the third quarter {Illustration 1D.11]I gl Prepare the Manufacturing Dverhead Budget forthe third quarter {Illustration 1D.12] hl Prepare the Unit cost {Illustration 1D.14l i} Prepare the Selling and Administrative Expenses Budget forthe third quarter {Illustration 1D.1Sl j] Prepare the Cash Budget forthe third quarter {Illustration 1D.19:I k} Prepare the income statement {illustration 1D.1S] ll Prepare the statement of financial position {Illustration 1-121} Hayes Company Budgeted Balance Sheet December 31, 2020 Assets Cash $ 37.900 Accounts receivable 108,000 Finished goods inventory 44.000 Raw materials inventory 4.080 Total current assets 193.980 Buildings and equipment $192,000 Less: Accumulated depreciation 48.000 144.000 Total assets $337.980 Liabilities and Shareholders' Equity Accounts payable $ 18.600 Common shares 225.000 Retained earnings 94.380 Total shareholders' equity 319.380 Total liabilities and shareholders' equity $337.980
