Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started