Complete Question P6.1 B and P6.2 A

The attached workbook should help you complete the problem:

please I need help with this assignment

BLEMS P6.1 You have the following projections about the costs in a family restaurant for next year. Net income required: 22% after income tax on the owner's present investment of $80,000, income tax rate is 28%. Present book value (consolidated) of furniture and equipment is $76,000, depreciation rate is 20%. Depreciation: Interest: Interest on a loan outstanding of $35,000 is 8%. Known Costs Insurance License Utilities Maintenance Administration Salaries Variable Costs Food cost, 38% of sales revenue Wage cost, 34% of sales revenue Other costs, 12% of sales revenue $ 3.000 2,500 8.400 3,600 9.800 41,600 a. What sales revenue would the restaurant have to achieve next year in order to acquire the desired net income after tax? b. What is the required average check needed to achieve the annual sales revenue objective if the restaurant is open 365 days, had 60 seats, and had an average seat turnover of 2.5 times per day? P6.2 A 23-room budget motel expects its occupancy next year to be 80%. The owners' investment is $402,800. They want an after-tax return on their investment of 15%. Tax rate is 25% Interest on a long-term mortgage is 10%. Present balance outstanding is $806,400. Depreciation rate on the building is 10% of the present book value of $700,200. Depreciation on the furnishings and equipment is at 20% of the consolidated present book value of $150,400. Other known fixed costs total $141,800 a year. At 80% occupancy rate the motel's operating expenses, wages, sup- plies, and laundry, etc. are calculated to be $55,400 a year. The motel has other income from vending machines of $5.210 a year. a. To cover all costs and produce the required net income after tax, what should the motel's average room rate be next year? b. If the motel operates at 30% double occupancy and has an $8.00 spread between its single and double rates, what will the single and double room rates be? Assume only one common room size, all with the same rates. AutoSave Off Week7DB (1) Protected view File Home Insert Page Layout Formulas Review Data PROTECTED VIEW Be careful_files from the Internet can contain viruses. Un D3 V x fx D E 4 Tax Rate Target Net Income Before Tax: $0.00 6 7 8 9 10 $0.00 $0.00 11 12 13 Sales Revenue Calculation: Known Costs Net Income Income Tax Insurnace License Utilities Maintenance Administration Salaries Depreciation Interest Total 14 15 16 17 18 19 20 $0.00 21 22 23 24 Variable Costs Food Wage Other Remaining Margin: Sheet1 25 100% Ready A B C Sales Revenue Calculation: Known Costs Net Income $0.00 $0.00 Income Tax Insurnace License Utilities Maintenance Administration Salaries Depreciation Interest Total $0.00 Variable Costs Food Wage Other Remaining Margin: 100% Target Sales Revenue: $0.00 Sheet1 sy 78F Sunny