Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

VISUAL BASIC ONLY You have been asked to write a program for a hotel resort, Ouiwantewetostay Resort that will show the prices of 1 bedroom

VISUAL BASIC ONLY

You have been asked to write a program for a hotel resort, Ouiwantewetostay Resort that will show the prices of 1 bedroom and 2 bedroom rooms based on a base price for the room and other criteria including room level, season, and amount of people staying in room.

Prices are also discounted based on various criteria including AAA, AARP, and CSS. Also a discount will apply if a returning customer. An additional discount will be based on amount of days previously spent at resort and also if a customer has a special promo code.

Certain discounts cannot be applied together, but the best discount will apply.

Once calculated, provide the room description (double or single, level chosen, with price per night including 8% tax) on the form next to corresponding checkbox. Allow user to reserve room.

INPUT

The application must be able to collect the following required information for each employee:

Customer name (required)

Season of required reservation (Normal, Off-Season, Peak)

Room level (Standard, Supreme, Luxury)

Number of nights (required, numeric, > 0)

Number of people staying (required, numeric, > 0)

Number of previous days stayed at resort (required, numeric, > = 0)

Promo Code (only BN0122 accepted)

Discount Code (AARP, AAA, CSS)

OUTPUT

There are two distinct areas required for output:

For each customer display the following:

Checkboxes for a 1 bedroom and 2 bedroom room stating room description, level chosen, daily price of room based on criteria, total costs with tax for all days of reservation.

Calculate the total for all reservations for todays date. These totals must be shown on the form in a group box. Additions to amounts will be based on checking room and clicking a Reserve Button.

Total amount of days booked

Total gross revenue

Total discounts applied

Total net revenue

Requirements to determine room rates.

Base Rate for 1 bedroom is $150.00 a night for normal season for a standard room.

Base Rate for 1 bedroom is $160.00 a night for normal season for a supreme room.

Base Rate for 1 bedroom is $175.00 a night for normal season for a luxury room.

Base Rate for 2 bedrooms is $225.00 a night for normal season for a standard room.

Base Rate for 2 bedrooms is $235.00 a night for normal season for a supreme room.

Base Rate for 2 bedrooms is $250.00 a night for normal season for a luxury room.

For offseason, deduct 17% per night off the base rate.

For Peak season, increase base rate 25%.

Rate is for up to 2 people per room for 1 bedroom and up to 4 people per room for 2 bedroom. Any additional people, add $15.00 per person to the base rate after seasonal adjustments.

Discount codes.the customer can choose any or all available discount criteria that pertains to them. However, the customer will only receive one discount from the following. Whichever is greater.

AAA receives 4% discount off base rates after seasonal adjustments during Normal and Peak seasons. During offseason, AAA receives 6% discount.

AARP receives 5% discount off base rates after seasonal adjustments during all seasons.

CSS receives 7% discount off base rates after seasonal adjustments only during normal season. During off season CSS receives 5% discount off base rates after seasonal adjustments. During Peak season CSS receives 3% discount off base rates after seasonal adjustments.

Returning customer discount. The following discount is also applied to the base rates after seasonal adjustments based on previous days stayed and if the customer has an additional valid promo code. Note, this discount can be added on to the above discount. However, read NOTE below.

Days Previously Stayed

With Promo Code

Without Promo Code

1 10 Days

1%

.5%

11- 25 Days

2%

1%

26 50 Days

3%

1.5%

51 100 Days

4%

2%

More than 100 Days

5%

2.5%

NOTE: Total discount per reservation cannot exceed 10.5% after all discounts have been applied.

COMMAND BUTTONS

Find Rooms Finds rooms and costs based on cost and discount criteria entered.

Reserve Once rooms are found, this button will become visible. Once clicked, rooms will be reserved (only if a room is checked) and accumulation to daily totals will be completed.

Clear - Clears the customer input so the next customer can be entered to find room.

Exit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Explain min-max normalisation and z-normalisation.

Answered: 1 week ago

Question

Did the team members feel that their work mattered

Answered: 1 week ago

Question

2. What process will you put in place to address conflicts?

Answered: 1 week ago