User Account

All Pages

Calculate the revenue collected from each room type

Assignment Help Accounting Basics
Reference no: EM132467219

The Excel file Graduates' Inn Guest provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn during one month. Room rates are the same for one or two guests; however, additional guests must pay an additional amount (based on the room type as shown in the table below) per person per day for meals and other miscellaneous expenses. Guests staying for seven days or more receive a 10% discount (applied to revenue per party transaction).

Room Type                            Additional cost/person/day

Ocean                                 $35

Bay-Window                         $30

Side                                   $20

Add one additional sheet to the spreadsheet to answer the following questions.

Question (1) Use the SUMIF() function to calculate the revenue collected from each room type for the whole month.

Question (2) Show a pie chart to display the revenue breakdown from the last question. Which room type generated highest revenue and how much revenue?

Reference no: EM132467219

Questions Cloud

Compute the present value of liabilities : Compute the present value of your liabilities. Do you have enough assets to cover those liabilities?
Make contributions to retirement account : Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 70.00. During these years of part-time work, he will neither make
Firm overall operations-tri-global : Tri-Global is evaluating a project that will generate perpetual cash flows of $60,000 per year beginning next year.
What is the market value of the firms equity-cleansweep : CleanSweep has 2 million shares of common stock outstanding at a book value of $2 per share. The stock trades for $4.00 per share. It also has $2 million
Calculate the revenue collected from each room type : Show a pie chart to display the revenue breakdown from the last question. Which room type generated highest revenue and how much revenue?
Explain why you would choose a mutual fund : Explain why you would choose a mutual fund and what are the risks of keeping your money in a mutual fund over a savings account?
Weighted-average cost of capital for the firm : Calculate what the weighted-average cost of capital for the firm is to help evaluate a potential new investment.
Prepare a adjusting entry for blossom on december : Prepare a adjusting entry for blossom on december 31,2021. On January 15, sold 3,200 shares of Anderson's common stock at $22 per share less fees of $2,010.
What is organii-tech wacc : Organii-tech's common stock trades at $15 per share and its most recent dividend was $1.00. Future dividends are expected grow by 4%.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Discuss the type of liquidation that was called for each

A number of companies have gone into liquidation because they have not been able to meet their liabilities when they fell due.

  A company purchased a new truck at a cost of 37900 on july

a company purchased a new truck at a cost of 37900 on july 1. the truck is estimated to have a useful life of 5 years

  What is the total amount invested by all stockholders

Journalize the entries for April 20 and August 7. What is the total amount invested (total paid-in capital) by all stockholders as of August 7?

  What are the eight types of evidence used in auditing

Gathering persuasive evidence is an important element of audit. What are the eight types of evidence used in auditing

  You are a student preparing for a job interview with a

you are a student preparing for a job interview with a fortune 100 consumer products manufacturer. you are applying for

  Problem on the remmers corporation

The following information is available for Remmers Corporation for 2014.

  A company has an average inventory

A company has an average inventory on hand of $75,000 and its average days in inventory is 36.5 days. What is the cost of goods sold?$1,680,000$750,000$876,000$1,752,000

  Prepare the ratio analysis- calculate minimum of five ratios

Using the financial statements that you have prepared for Smith Manufacturing; prepare the following analyses in Excel: Ratio analysis

  Rocket company produces small gasoline-powered engines for

rocket company produces small gasoline-powered engines for model airplanes. mr. clemens rockets cfo has presented you

  A new truck was ordered for the sanitation department at a

a new truck was ordered for the sanitation department at a cost of 122200 on september 3 2011.requiredprepare the

  Distinguish between gross profit as a percentage of cost

Distinguish between gross profit as a percentage of cost and gross profit as a percentage of sales prices.

  How much did Hollie pay in cash dividends

Hollie Company has stockholders' equity of $400,000 and net income of $72,000. It has a payout ratio of 18% and a return on assets of 20%.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd