Operated Departments Rooms Food Telecommunications Rentals Other Income Total Operated departments Undistributed Operating Expenses 1 Administrative...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 B Income after undistributed operating expenses no Net Revenue Cost of Sales Payroll & Related Expenses Other Expenses Income (Loss) 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 Marketing-other expenses Property operations and maintenance-payroll Property operations and maintenance- other expertses Utility costs Accumulated depreciation Investments Store rontals Interest expense Other income Booms-naych Depreciation Prepaid insurance Land $ 120,000 155,000 Building 50,000 Furniture and equipment 97,000 Cash Loss on sale of land 20,500 780,000 Income tax expense 550,000 Insurance 43,000 Real estate taxes 50,000 40.000 Income taxes payable Bonds payable Bad debt expense Accrued expenses 20,000 40,000 Inventories 350.000 Common stock-400,000 shares 30.000 outstanding $1 par value Dividends payable (representing 20,000 110,000 the only dividerias declamat 40,000 ended 150.000 during the s Dec. 31.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 50.000 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 Land 155,000 Building 50,000 97,000 Cash 20,500 Loss on sale of land 780,000 Income tax expense 550,000 Insurance 43,000 Real estate taxes $ 120,000 50,000 40,000 Furniture and equipment Income taxes payable Bonds payable Bad debt expense Accrued expenses 20,000 40,000 Inventories 30,000 20,000 110,000 40,000 150,000 15,000 50,000 350,000 Common stock-400,000 shares outstanding $1 par value Dividends payable (representing the only dividends declared during the year ended Dec. 31, 2010) Retained earnings-balance Jan 1, 2010 Food-cost of sales 28,000 2,500 Food payroll 2,000 Food-other 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 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 B Income after undistributed operating expenses no Net Revenue Cost of Sales Payroll & Related Expenses Other Expenses Income (Loss) 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 Marketing-other expenses Property operations and maintenance-payroll Property operations and maintenance- other expertses Utility costs Accumulated depreciation Investments Store rontals Interest expense Other income Booms-naych Depreciation Prepaid insurance Land $ 120,000 155,000 Building 50,000 Furniture and equipment 97,000 Cash Loss on sale of land 20,500 780,000 Income tax expense 550,000 Insurance 43,000 Real estate taxes 50,000 40.000 Income taxes payable Bonds payable Bad debt expense Accrued expenses 20,000 40,000 Inventories 350.000 Common stock-400,000 shares 30.000 outstanding $1 par value Dividends payable (representing 20,000 110,000 the only dividerias declamat 40,000 ended 150.000 during the s Dec. 31.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 50.000 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 Land 155,000 Building 50,000 97,000 Cash 20,500 Loss on sale of land 780,000 Income tax expense 550,000 Insurance 43,000 Real estate taxes $ 120,000 50,000 40,000 Furniture and equipment Income taxes payable Bonds payable Bad debt expense Accrued expenses 20,000 40,000 Inventories 30,000 20,000 110,000 40,000 150,000 15,000 50,000 350,000 Common stock-400,000 shares outstanding $1 par value Dividends payable (representing the only dividends declared during the year ended Dec. 31, 2010) Retained earnings-balance Jan 1, 2010 Food-cost of sales 28,000 2,500 Food payroll 2,000 Food-other 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
Expert Answer:
Answer rating: 100% (QA)
Spread sheet 4 5 Operated departments 6 Rooms B 7 Food 8 Telecom 9 Rentals 10 Other Income 11 12 13 ... View the full answer
Related Book For
College Accounting
ISBN: 978-1111528126
11th edition
Authors: Tracie Nobles, Cathy Scott, Douglas McQuaig, Patricia Bille
Posted Date:
Students also viewed these accounting questions
-
Misstatement of financial statements threatens the foundation of financial reporting process and jeopardizes the integrity of the auditing function. These misstatements can result from errors or...
-
Here are simplified financial statements for Phone Corporation in a recent year: INCOME STATEMENT (Figures in 5 millions) Net sales Cost of goods sold Other expenses Depreciation Earnings before...
-
The class excel model includes cost of goods sold but not sold, general, and administrative (SG&A) expenses. Suppose that the firm has $200 of these expenses each year, irrespective of level of...
-
a) Assuming that your capital is constrained, what is the fifth project that you should invest in? Please show work. b) Assuming that your capital is constrained so that you only have $600,000...
-
Hillman Pizza is a restaurant specializing in the sale of pizza by the slice. The store employs 7 full-time and 13 part-time workers. The store's weekly payroll averages $3,800 for all 20 workers....
-
A unit step input is applied to a second-order measurement system with effective mass of \(40 \mathrm{~g}\) and spring constant \(2 \mathrm{kN} / \mathrm{m}\). Find the damping constant for \(40 \%\)...
-
The balance sheet of Morrisey Management Consulting, Inc., at December 31, 2007, reported the following stockholders' equity: During 2008, Morrisey completed the following selected transactions:...
-
If you were in Alexs position, 1. What type of coaching style would you choose when working with James? 2. What behaviors would you engage in while coaching James in order to ensure that he is...
-
Please give a personal example of each heuristic (it has to be the example from yourself) 1. The Availability Heuristic: 2. Representativeness Heuristic: 3. Affect Heuristic: 4. Anchoring Heuristic:...
-
Identify at least one researchable question for each of the following issues (in questions 612). 6. A cable network has just entered into an agreement granting it the right to show reruns of a hit TV...
-
I feel like you should still be able to vote even if you are a felon it shouldn't matter about your background you still should be able to base your opinion just because you did something shouldn't...
-
Discuss the traditional family structure and then the nontraditional family structure. How do todays nontraditional families influence sports participation? Is this for the better or the worse?
-
Explain how reference groups play a role in sports participation.
-
Define social class and explain the characteristics of individuals at each level of the seven- tiered structure.
-
Define culture and explain the process of sports socialization. Describe the core American values.
-
Ask three males and three females about the benefits they seek when participating in sports. What conclusions can you draw regarding motivation? Are there large gender differences in the benefits...
-
Question 3 Company Background: GAP Ltd. is considering a new project that requires a large initial cost, and it needs to calculate its weighted average cost of capital (WACC) to decide whether to...
-
When a company has a contract involving multiple performance obligations, how must the company recognize revenue?
-
You are the new bookkeeper for a small business. The bookkeeper whose job you are taking is training you on the businesss manual system. As he journalizes, he writes the account number in the Post....
-
Franklin Plumbing purchases land and building for a combined price of $ 525,000. The assessor valued this property for tax purposes at $ 410,000: $ 195,000 for the land and $ 215,000 for the...
-
Determine the gross pay for each employee listed below. a. Clay Jones is paid time- and- a- half for all hours over 40. He worked 45 hours during the week. His regular pay rate is $ 25 per hour. b....
-
Use data from Appendix \(C\) to choose points from the performance curves for a Peerless horizontal split case Type 16A18B pump at 705 and 880 nominal rpm. Obtain and plot curve-fits of total head...
-
An axial-flow fan operates in sea-level air at \(1350 \mathrm{rpm}\) and has a blade tip diameter of \(3 \mathrm{ft}\) and a root diameter of \(2.5 \mathrm{ft}\). The inlet angles are...
-
Data from tests of a water suction pump operated at \(2000 \mathrm{rpm}\) with a 12 -in.-diameter impeller are Plot the performance curves for this pump; include a curve of efficiency versus volume...
Study smarter with the SolutionInn App