can someone solve number 1 with cell reference please

Solution 1. As one 9 2 Congratulations, you have accepted a new position as the assistant 3. controller with Buzz manufacturing! The controller. Tanya McDougall, has 4 recently taken a 6 week medical leave. In her absence, Ben Hur, the financial 5 accounting clerk, who has little experience in manufacturing accounting, prepared 6 the following draft income statement for August. 7 Buzz Company 8 Income Statement For the month ended August 31 10 Sales $1,694,000 11 Less: Operating expenses 12 Advertising $188,000 13 Depreciation, factory equipment 113,000 14 Depreciation, sales equipment 111.000 15 Direct labour 199,000 16 Indirect labour 219.000 Insurance 110,000 Maintenance, factory 18,000 Purchases of raw materials 309,000 Rent on facilities 140,000 21 Selling and administrative salaries 139,000 22 Utilities costs 155,000 1.701.000 23 Operating income (loss) $ (7,000) 25 Knowing that you have recently completed a managerial accounting course at 26 Algonquin college, the president of Buzz manufacturing has asked you the review 27 the accuracy of their draft income statement. 28 Additional information about the company follows: 29 a. Only 90% of the rent on facilities applies to factory operations: the remain- 30 der applies to selling and administrative activities. 21 h Some 85% of the insurance and 75% of the utilities.cost M 17 18 19 20 24 Tot Cos 2. As a second