2. Construct an Excel spreadsheet to solve the preceding requirement. Show how the solution will change if the following information changes the sales revenues were $950,000 and $815,000 for Metro and Suburban, respectively.

If a retail store has a current ratio of 3.7 and working capital of $205, 200. What are the total of the current assets? Select one: a. $55, 500. b. $205, 200. c. $759, 240. d. $281, 200.

You have been asked to make a presentation about an entertainment company. In your research, you locate the accompanying pie chart, which shows the company's revenue by segment expressed in millions of dollars. To enhance your presentation, you have decided to convert the dollar amounts to percents and display both numbers. 2.5 Segment Revenue ($ millions) 6.8 16.3 10.6 (a) What is the total revenue (in millions of dollars)? million % Media Networks Resorts Financial Products Retail Sales (b) What percent (rounded to the nearest tenth percent) does each segment contribute to the total revenue? media networks 45.4 X % resorts 29.9 X % retail sales 6.9 % financial products 18.84

PRINTER VERSION CALCULATOR 1 BACK NEX Problem 3-35 (Part Level Submission) Sandhill Company produces a molded briefcase that is distributed to luggage stores. The following operating data for the current year has been accumulated for planning purposes. $41.17 Sales price Variable cost of goods sold Variable selling expenses Variable administrative expenses 13.17 11.77 4.17 Annual fixed expenses $15,600,000 3,100,000 6,500,000 Overhead Selling expenses Administrative expenses Sandhill can produce 3,000,000 cases a year. The projected net income for the coming year is expected to be $3,600,000. Sandhill is subject to a 40% income tax rate. During the planning sessions, Sandhill's managers have been reviewing costs and expenses. They estimate that the company's variable cost of goods sold will increase 15% in the coming year and that fixed administrative expenses will increase by $300,000. All other costs and expenses are expected to remain the same.

Social Media, Inc. (SMI) has two services for users. Toot!, which connects tutors with students who are looking for tutoring services, and TiX, which can be used to buy, sell, or exchange event tickets. For the following year, SMI expects the following results.     Toot! TiX Total Users   10,700   18,100   28,800 Revenues $ 1,600,000 $ 1,440,000 $ 3,040,000 Engineering hours   8,200   6,200   14,400 Engineering cost $ 516,500 $ 635,500 $ 1,152,000 Administrative costs         $ 921,600                              Required: Compute the predetermined overhead rate used to apply administrative costs to the two services assuming SMI uses the number of usersto allocate administrative costs. Based on the rates computed in requirement (a), what is the profit for each service?

This is currently a single-step Income Statement. Add/adjust/remove as needed to convert this to a multi-step Income Statement.  2. The formatting here needs your help! You are presenting this to important external stakeholders. Apply required (andadditional formatting to make it professional in appearance) formatting.

Saved AAA Travel Agency Riser Group Casto Travel Balboa Travel Hunter Travel Managers $87,700, 000 68, 900, 000 63,050, 000 45, 940, 000 36, 000, 000 a. What would be the mean and the median? Mean $ 272,790,000 Median $ 63,050,000 b. What is the total revenue percent of each agency? (Round your answers to the nearest hundredth percent.) AAA Riser Group % Casto % Balboa % Hunter Mc Graw Hill

Blue Jay Way Travel Agency is a profit centre within a large tourism company. The following is the financial information for the agency for 2015 and 2016. Review the table and answer the related questions. 2016 2015 Tour Revenue $600,000 $700,000 Distributed Operating Expenses Payroll and Related Expenses $157,000 $250,000 Booking Fees $43,000 $50,000 A) Calculate the departmental income and departmental income margin for 2015 and 2016. Round to two decimal places. b) Comment on the change in departmental income and departmental income margin from 2015 to 2016. C) Calculate booking fees as a percentage of tour revenue for 2015 and 2016 and comment on the change, if any. In addition, calculate labour cost margin for 2015 and 2016 and comment on the change, if any. Use this information to give a possible reason for the change in departmental income margin from 2015 to 2016.