I can't figure out how to do this assignment. Can someone help me please?

.40 .3540 Name: Course: Date: E5-9 - Compute break-even point. Managerial Accounting, 6th Edition, by Weygandt, Kieso, and Kimmel Primer on Using Microsoft Excel in Accounting by Rex A Schildhouse Exercise E5-9 The Green Acres Inn is trying to determine its break-even point. The inn has rooms that it rents at $60.00 a night. Operating costs are as follows. Salaries $6,200 per month Utilities 1,100 per month Depreciation 1,000 per month Maintenance 100 per month Maid service 11 per room Other costs 28 per room 50 Instructions: (1) Determine the inn's break-even point in number of rented rooms per month. Contribution margin per room: Fixed costs: Room rent Salaries Maid service Utilities Other costs Depreciation Contribution margin per room $0 Maintenance Total fixed costs: Break-even point in rooms = $0 (2) Determine the inn's break-even point in dollars. Break-even point in rooms Room rent Break-even point in dollars Or: Contribution margin ratio = $0 Fixed costs Contribution margin ratio = $0.00 $0 $0 = #DIV/0! rooms = #DIV/0! #DIV/0! = #DIV/0! #DIV/0! #DIV/0! Name: Course: Date: E7-5 - Use incremental analysis for make-or-buy decision Managerial Accounting, 6th Edition, by Weygandt, Kieso, and Kimmel Primer on Using Microsoft Excel in Accounting by Rex A Schildhouse Exercise E7-5 Schopp Inc. has been manufacturing its own shades for its table lamps. The company is currently operating at 100% of capacity, and variable manufacturing overhead is charged to production at the rate of 70% of direct labor cost. The direct materials and direct labor cost per unit to make the lamp shades are $4.00 and $5.00 respectively. Normal production is 30,000 table lamps per year. A supplier offers to make the lamp shades at a price of $12.75 per unit. If Schopp Inc. accepts the $45,000 of fixed manufacturing supplier's offer, all variable manufacturing costs will be eliminated, but the overhead currently being charged to the lamp shades will have to be absorbed by other products. Instructions: (a) Prepare the incremental analysis for the decision to make or buy the lamp shades. Make Net Income Increase (Decrease) Buy Direct materials (30,000 $4.00) Direct labor (30,000 $5.00) Variable manufacturing costs (150,000 70%) Fixed manufacturing costs Purchase price (30,000 $12.75) Total annual cost (b) Should Schopp Inc. buy the lamp shades? (c) Would your answer be different in (b) if the productive capacity released by not making the lamp shades could be used to produce income of ? Make Total annual cost (above) Opportunity cost Total cost Net Income Increase (Decrease) Buy $0 0 $0 $0 0 $0 $0 0 $0