1 Getting Started With Excel 2 Formatting Workbook Text And Data 3 Performing Calculations With Formulas And Functions 4 Analyzing And Charting Financial Data 5 Working With Excel Tables, Pivottables, And Pivotcharts 6 Managing Multiple Worksheets And Workbooks 7 Developing An Excel Application 8 Working With Advanced Functions 9 Working With Text Functions And Creating Custom Formats Chapter7: Developing An Excel Application
7.1 Excel Application And Defined Names 7.2 Data Validation And Protection 7.3 Working With Macros Chapter Questions Section7.1: Excel Application And Defined Names
Problem 1QC Problem 2QC Problem 3QC Problem 4QC Problem 5QC Problem 6QC Problem 7QC Problem 8QC Problem 7QC
Related questions
in C++ language, program , and include the flowchart and pseudo code using the nested while loops. Thank you
Transcribed Image Text: -Use constant variables to hold room rates, max and min # of floors and rooms.
-The program should continuously ask for the correct floor number if it is not within the
range of 1 and 5.
-The program should continuously ask for the correct number of rooms for each floor if it
is not within the range of 1 and 30.
-The program should repeat the process of asking the number of rooms on the floor and
number of occupied rooms if the total number of occupied rooms exceeds the total
number of rooms on the floor.
Sample output#1
BlueMont Hotel
Enter the location for this hotel chain: Washington
Enter the total number of floors in this hotel: 0
Number of floors should be between 1 and 5. Please try again!!
Enter the total number of floors in this hotel: 6
Number of floors should be between 1 and 5. Please try again!!
Enter the total number of floors in this hotel: 1
Enter the total number of rooms on floor 1 : 0
Number of rooms should be between 1 and 30. Please try again!!
Enter the total number of rooms on floor 1 : 31
Number of rooms should be between 1 and 30. Please try again!!
Enter the total number of rooms on floor 1 : 30
How many SINGLE rooms are occupied on floor 1 ? 10
How many DOUBLE rooms are occupied on floor 1 ? 0
How many KING rooms are occupied on floor 1 ? 0
How many SUITES are occupied on floor 1 ? 0
====== =================
BlueMont Hotel located at Washington
Today's Room Rates (Us$/night)
Double Room
King Room
100
Single Room
Suite Room
60
75
150
Hotel Income :
Total # of Rooms :
$600
30
Occupied Rooms :
Total # of Unoccupied Rooms:
Occupancy Rate :
otal
10
20
33.33%
floor 1 with 30 rooms has the least # of rooms.
Need to improve Hotel occupancy rate!!
Thank you for testing my program!
PROGRAMMER : insert your name here
CMSC140 Common Project 3
Due Date: April 9, 2021
Transcribed Image Text: Project Description
The BlueMont chain hotels have 4 different types of rooms:
Single room: $60/night
Double room: $75/night
King room:
Suite room: $150/night
$100/night
The size of the hotel chains in different locations may be different in terms of the number
of floors and the type and the number of rooms on each floor.
You are required to write a program that calculates the occupancy rate and the total hotel
income for one night and displays this information as well as some other information
described below.
The program starts by asking the location where this hotel chain is located and the
number of floors in the hotel. The number of floors may not exceed 5. The User then
enters the total number of rooms for each floor. The program then asks specifically for the
number of occupied rooms for each room type on this floor. The total number of rooms on
each floor may not exceed 30 and the program should check that the total number of
occupied rooms on each floor does not exceed the total of rooms on that floor.
After the information is entered for each floor, the program calculates the following:
- Hotel income (based on the room type and its rate),
- The total number of occupied rooms,
- Total number of the uncopied rooms,
- The rate of occupancy,
- Floor number with the minimum number of rooms. (Assume no two floors have the
same number of rooms).
- A message to improve the occupancy rate for the occupancy rate of less than 60%.
- Programmer's full name
- Project number
- Project due date
Project Specifications
Process by which instructions are given to a computer, software program, or application using code.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 6 images