Determine the room rates are the same for one or two guests

Assignment Help Accounting Basics
Reference no: EM132459370

Question 1: 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 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

Guest First NameGuest Last Name         Room       Room Type Arrival Date Departure Date No of Guests Daily Rate

Barry

Lloyd                                    Hayes                         Bay-window            2018/12/1

2018/12/4

2

$150 00

Michael

Lunsford                            Cleveland                Ocean                          2018/12/1

2018/12/9

3

$112 50

Kim

Kyuong                              Coolidge                   Bay-window             2018/12/4

2018/12/7

1

$150 00

Edward

Hoe                                                                                  Washington            Ocean                         2018/12/1

2018/12/3

4

$325 00

Thomas

Collins                                 Lincoln                       Ocean                          2018/12/9

2018/12113

2

$300 00

Paul

Bodkin                                Coolidge                   Bay-window            2018/12/1

2018/12/3

2

$150 00

Randal

Banenburg

Washngton             Ocean                          2018/12/4

2018/12/12

2

$292 50

CaMn

teawotney

Lincoln                        Ocean

2018/12/2

2018/12/4

1

$300 DO

Homer

Gonzalez

Lincoln                        Ocean

2018/12/5

2018/12/7

5

$320 00

David

Sanchez

Jefferson                  Bay-window             2018/12/5

2018/12/7

4

$175 00

Buster

Whsler

Jackson                     Ocean                          2018/12/5

2018/12/8

2

$250 00

Aka

Martins

Reagan

Bay-window         2018112/10

2018/12/15

1

$150 00

Samuel

Ken

Truman

Side                             2018/12/20

2018/12/30

3

$112 50

Arthur

Gottfried                             Garfield                      Side                            2018/12/13

2018/12/15

2

$125 00

Darlene

Shore

Arthur

Ocean                        2018/12/24

2018/12/31

5

$198 00

Carlyle

Charleston

Quncy Adams

Bay-window              2018/12/3

2018/12/6

2

$150 00

Albert

Goldstone                         Johnson                    Ocean                          2018/12/5

2018/12/7

3

$250 00

Charlene

Tgson                                  Van Buren               Bay-window             2018/12/5

2018/12/7

1

$150 00

Everett

Chad

Madison

Ocean                      2018112/10

2018/12/14

2

$27500

Gerald

Pittsfield

Roosevelt

Ocean                           2018/12/5

2018/12/7

2

$275 00

Jamal

Snsth                                   Tyler                             Bay-window          2018/12/20

2018/12/23

2

$150 00

Lous

Paris

Jackson                      Ocean

2018/12/10

2018/12114

1

$250 DO

Nigel

Stratford

Eisenhower             Ocean

2018/12/14

2018/12/16

2

$200 00

Peter

Willington                          Grant                           Ocean                       2018/12/19

2018/12/21

1

$200 00

Ronald

Cartier

Jefferson

Bay-window 2018/12/24

2018/12/28

4

$175 DO

Trista

Leven

Eisenhower

Ocean                        2018/12/17

2018/12/20

1

$200 00

Valene

Snell

Adams

Bay-window              2018/12/3

2018/12/6

1

$150 00

Walter

Acton                                   Polk                              Side                            2018/12/24

2018/12/31

6

$148 50

Xavier

Trezza                                 McKinley                   Side                            2018/12/14

2018/12/17

2

$125 00

Reference no: EM132459370

Questions Cloud

What was the yield to maturity on the day you bought bond : Home Plc issued a nine year bond in November 2011 with a coupon rate of 8% (face value = £100). In November 2016 (just after that year's coupon
What was the yield to maturity on the day : Home Plc issued a nine year bond in November 2011 with a coupon rate of 8% (face value = £100). In November 2016 (just after that year's coupon had been paid)
What is the cobit framework : What is the COBIT Framework and how will I be able to implement such a framework for my own personal company of 2000 employees?
Calculate the actual realized rate of return : An investor pays $800 for a $1000 par bond carrying 5% coupon rate (coupon payments made semi-annually) during a period of economic stress.
Determine the room rates are the same for one or two guests : Determine the Room rates are the same for one or two guests, however, additional guests must pay an additional amount per person per day for meals
What are monthly mortgage payments : You are deciding to purchase a new condo for $250,000. You plan to pay $50,000 down immediately and need to borrow the rest from your bank with quoted
Future value of an ordinary? annuity : What is the future value of ?$490 per year for 8 years compounded annually at 9percent?
Constructing a two stock portfolio based on the information : You are constructing a two stock portfolio based on the information provided below. What dollar amount will you invest in each stock to achieve the desired
What is the accounting break-even level of sales : What is the accounting break-even level of sales if the firm pays no taxes?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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!

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