need answers of all yellow cells:)
Done Instructions Assignment 1 Package New.xlsx Week 1 - Income Statement Week 2 - Balance Sheet Activity Week 2 Financial Management - Contributory Income Statements 1. Joe's Bistro has three sales revenue departments with direct costs and the average monthly figures as shown below. Departments Dining Catering Bar Sales Revenue 194.000 102,400 86,000 Dining Catering Cost of Sales 77.600 28,912 27,528 28000 1200 ft Wages and Salaries 64,020 30,700 10,60 Other direct costs 17.460 8,192 6348 Administrative 1.500 Advertising 500 Property Maintenance 11.00 Beverages 600 sq ft TOTAL 4600 Sq.ft Depreciation Insurance 12,500 5.000 A Prepare a consolidated departmental contributory income statement showing each of the divisions side by side for comparison B. Calculate the contributory income percentage for each of the three divisions Done Instructions Assignment 1 Package New.xlsx Week 1 - Income Statement Week 2 - Balance Sheet Activity Week 2 C. Allocate the indirect expenses to the divisions and prepare a departmental income statement. Administrative and advertising expenses are allocated based on Sales Revenue. The remaining indirect expenses are allocated based on Square Footage used by each department Department DINING SSS BAR SSS BAR% OF TOTAL REV TOTAL%O ALL DEPT Totals Sss Sales Revenue Cost of Sales $86,000 DINING % OF CATERING CATERING TOTAL REVsss OF TOTAL REV $102,400 $28,912 $19.000 $77,600 $27,528 Grow Profile Mat Wages & Salaries 564,020 $30,700 S10,60 Other direct costs $17.460 SH.192 56,54 Contributory Income Determine the different area % of sales and square foto is the storming how to divide costs across the different departments. S4 FL. % located above. Use Sales Revenue for the other Done Instructions Assignment 1 Package New.xlsx Week 1 - Income Statement Week 2 - Balance Sheet Activity Week 2 Determine the different areas of sales and square footage. Use these percentages to determine how to divide costs across the different departments. Sa F1 % located above. Use of Sales Revenue for the other DINING ROOM CATERING RAR TOTAL Sales Revenue Square Footage Administrative Expense Advertising Pixpense Property Maintenance Utilities Expense Depreciation Expense Marks out of 40 Insurance Expense Done Utilities Expense Assignment 1 Package New.xlsx Depreciation Expense Insurance Expense Total Expenses Operating Income Name a problem that you can see above and what could be a posible solution? Write the answer in the box provided below. Name another problem that you can see above and what could be a possible solution? Write the answer in the box provided below. Marks
