Net Revenue Cost of Sales Payroll & Related Expenses Other Expenses Income (Loss) Operated Departments Rooms Food Telecommunications Rentals Other Income Total Operated departments Undistributed Operating Expenses 1 Administrative and General 2. Marketing 3 Transportation 4 Property operation & maintenance 5 Utility costs 16 Total Undistributed operating expenses 17 18 Income after undistributed operating expenses For the income statement, complete the following in the spreadsheet above: (a) Rooms department income (loss)-year 2010 (b) Food department income (loss) - year 2010 (c) Telecommunications department income (loss) - year 2010 (d) Rentals and other income-year 2010 (e) Total operated departments income (loss)-year 2010 (f) Total undistributed operating expenses...--year 2010 (g) Income after Undistributed Operating Expenses-year 2010 Accounts receivable-net of allowance for doubtful accounts of $3.000 Accounts payable General and Adm.-payroll and related expenses General other expenses Telecommunications-cost of sales Room sales Food sales Telecommunications sales Markoting other expenses Property operations and maintenance--payroll Property operations and mantenendo other expertsos Utility costs Accumulated depreciation Investments Store contais Interest expense Other como Bom - Depreciation Prepaid insurance $ 120.000 Land 155,000 Building 50.000 Furniture and equipment 97.000 Cash 20,500 Loss on sale of land 780,000 income tax expense 550,000 Insurance 43,000 Real estate taxes 50.000 Income taxes payablo 40.000 Bonds payable Bad dobl expense 20.000 Accrudos 40.000 Inventories 350,000 Common stock 400.000 shares 30.000 outstanding. Si par vale 20,000 Didends payahin representing 110.000 the only dividends deco 40,000 during the ended 18.00 2010 $ 80.000 6,000 300,000 1.500,000 100.000 65,000 30,000 70.000 10.000 45,000 14.000 1.000.000 3,000 55,000 105.000 400,000 5000 Accounts receivable-net of allowance for doubtful accounts of $3,000 Accounts payable General and Adm.-payroll and related expenses General other expenses Telecommunications-cost of sales Room sales Food sales Telecommunications sales Marketing-other expenses Property operations and maintenance-payroll Property operations and maintenance other expenses Utility costs Accumulated depreciation Investments Store rentals Interest expense Other income Rooms-payroll Rooms-guest supplies Rooms-linen and laundry Telecommunications-payroll Telecommunications-other expenses Transportation-other Depreciation Prepaid insurance $ 120,000 Land 155,000 Building 50,000 Furniture and equipment 97,000 Cash 20,500 Loss on sale of land 780,000 Income tax expense 550,000 Insurance 43,000 Real estate taxes 50,000 Income taxes payable 40,000 Bonds payable Bad debt expense 20,000 Accrued expenses 40,000 Inventories 350,000 Common stock-400,000 shares 30,000 outstanding-$1 par value 20,000 Dividends payable (representing 110,000 the only dividends declared 40,000 during the year ended 150,000 Dec. 31, 2010) 15,000 Retained earnings-balance 50,000 Jan 1, 2010 28,000 Food-cost of sales 2,500 Food-payroll 2,000 Foodother expenses $ 80,000 6,000 300,000 1,500,000 100,000 65,000 30,000 70,000 10,000 45,000 14,000 1,000,000 3,000 55,000 105,000 400,000 50,000 202,000 200,000 180,000 70,000
