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...
-
InTech, a computer software firm that has never paid dividends before, is considering whether it should start doing so. This firm has a cost of equity of 22% and a cost of debt of 10% (the tax rate...
-
How does a unit trust differ from an investment trust?
-
Market Participants. For each of the foreign exchange market participants, identify their motive for buying or selling foreign exchange.
-
Surfs Up, a manufacturer of surfing supplies and training equipment, has the following selected data ($ in millions): Based on these amounts, calculate the following ratios for 2015: 1. Debt to...
-
For the fiscal year just ended, you have calculated the changes in the asset, liability and equity accounts for Magenta Manufacturing Ltd. (MML). Selected change amounts are: Cash and cash...
-
The information listed below refers to the employees of Lemonica Company for the year ended December 31, 2016. The wages are separated into the quarters in which they were paid to the individual...
-
20.McGlothin Inc. is considering a project that has the following cash flow data. What is the project's payback? Year 0 1 2 3 Cash flows $1,150 $500 $500 $500 a. 1.86 years b. 2.07 years c. 2.30...
-
Auto Mobile Ltd is required to prepare general purpose financial reports for the year ending 30 June 2023. i. What type of entity must Auto Mobile Ltd be?(1 mark) ii. What are the accounting...
-
If F = 425 N instead of 450 N, the 700 N force is changed to 750 N and the magnitude of the angle is 650 instead of 60 and the magnitude of the other angle is 10 instead of 15. |FRI = 4 = Problem 2...
-
Total assets of $9,854,000, current liabilities of $4,132,000 and a quick ratio of 0.79. How much inventory do they have?
-
Price Enterprises invested in the bonds of Greater Gloucester on January 1, 2022. These 60 year, $600000 bonds pay interest of 3% every June 30 and December 31. The effective rate of interest for...
-
= The Generic 501(c)(3) Fund had revenue from contributions = $500,000, administrative expense = $125,000 program service expenses = $360,000 paid interest of $10,000 and had an increase in net...
-
Ena The following data from the just completed year are taken from the accounting records of Mason Company: Sales Direct labor cost Raw material purchases Selling expenses Administrative expenses...
-
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....
-
Vargas Company manufactures its product, Vitadrink, through two manufacturing processes: Mixing and Packaging. All materials are entered at the beginning of each process. On October 1, 2002,...
-
During 2008, the world entered a global recession that resulted in many business failures. Today, companies continue to struggle with a lower degree of consumer confidence and lower levels of...
-
Zion Company manufactures bowling balls through two processes: Molding and Packaging. In the Molding Department, the urethane, rubber, plastics, and other materials are molded into bowling balls. In...
Study smarter with the SolutionInn App