QUE STION 1 An admission charge for Bandar Orchid WetLands varies according to the age of the customer as in Figure 1. The system will receive the input for the number of persons for each category as in Figure 2. Then, it will calculate and display the total charge (include SST 6%) and the category Figure 3. [Assume all items are required. The process is not involving any decision). Category (Age) 50 and above 13-40 7-12 4-0 Charge (RM) 30.00 35.00 25.00 15.00 Below 4 Figure 1: Charges for Visitors Free The Bold items are the input from the user. KELCOME TO BANDAR ORCHID KETLANDS Enter the number of persons for each categozy Age Over 50 Age 13 - 50: 2 Age 7 - 12 Age 4- 6 Age Below 4 Figure 2: The Input Total for Over 50 (1 Fersons): EM 30.00 Total for 13 - 50 (2 Fersons): BM 70.00 Total for 7 - 12 (4 Fersons): RM 100.00 Total for 4 - 6 O Fersons): RM Total for Below 4 (FREE) 0.00 : RM 0.00 ITEMS RM TOTAL 200.00 33T (E 12.00 SUB-TOTAL = 212.00 THANK YOU.ENJOY YOUR HOLIDAY!! Figure 3: The Output

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 3.5CP
icon
Related questions
Question
QUESTION 1
An admission charge for Bandar Orchid Wetlands varies according to the age of the customer
as in Figure 1. The system will receive the input for the number of persons for each category
as in Figure 2. Then, it will calculate and display the total charge (include SST 8%) and the
category Figure 3. [Assume all items are required. The process is not involving any decision].
Category (Age)
50 and above
13- 49
7-12
4-0
Charge (RM)
30.00
35.00
25.00
15.00
Below 4
Figure 1: Charges for Visitors
Free
The Bold items are the input from the user.
WELCOME TO BANDAR ORCHID WETLANDS
Enter the number of persons for each category
Age Over 50
Age 13 - 50
Age 7 - 12
Age 4 - 6
Age Below 4
1
2
Figure 2: The Input
Total for Over 50 (1 Fersons): BM 30.00
Total for 13 - 50 (2 Persons): RM 70.00
Total for 7 - 12 (4 Persons): RM 100.00
Total for 4 - 6_(O Persons): RM
0.00
Total for Below 4 (FREE)
: RM
0.00
ITEMS
RM
200.00
12.00
TOTAL
3ST (6R)
SUB-TOTAL =
212.00
THANK YOU.ENJOY YOUR HOLIDAY!!
Figure 3: The Output
QUESTION 2
The program will ask the user to enter weight in pounds and height in inches and displays the
Body Mass Index (BMI) status. The status for the BMI is shows in the table below. It then will
display the weight in kg. height in meter, the BMI and the status of the BMI.
[Hint: 1 pound = 0.45359237 kilograms. 1 inch = 0.0254 meters]
BMI = weight in kilogram / (height in meter)
BMI
< 16
< 18
< 24
< 29
<35
2 35
Status / Message
You are seriously underweight
You are underweight
You are normal weight
You are overweight
You are seriously overweight
You are gravely overweight
Figure 4: BMI Status
Transcribed Image Text:QUESTION 1 An admission charge for Bandar Orchid Wetlands varies according to the age of the customer as in Figure 1. The system will receive the input for the number of persons for each category as in Figure 2. Then, it will calculate and display the total charge (include SST 8%) and the category Figure 3. [Assume all items are required. The process is not involving any decision]. Category (Age) 50 and above 13- 49 7-12 4-0 Charge (RM) 30.00 35.00 25.00 15.00 Below 4 Figure 1: Charges for Visitors Free The Bold items are the input from the user. WELCOME TO BANDAR ORCHID WETLANDS Enter the number of persons for each category Age Over 50 Age 13 - 50 Age 7 - 12 Age 4 - 6 Age Below 4 1 2 Figure 2: The Input Total for Over 50 (1 Fersons): BM 30.00 Total for 13 - 50 (2 Persons): RM 70.00 Total for 7 - 12 (4 Persons): RM 100.00 Total for 4 - 6_(O Persons): RM 0.00 Total for Below 4 (FREE) : RM 0.00 ITEMS RM 200.00 12.00 TOTAL 3ST (6R) SUB-TOTAL = 212.00 THANK YOU.ENJOY YOUR HOLIDAY!! Figure 3: The Output QUESTION 2 The program will ask the user to enter weight in pounds and height in inches and displays the Body Mass Index (BMI) status. The status for the BMI is shows in the table below. It then will display the weight in kg. height in meter, the BMI and the status of the BMI. [Hint: 1 pound = 0.45359237 kilograms. 1 inch = 0.0254 meters] BMI = weight in kilogram / (height in meter) BMI < 16 < 18 < 24 < 29 <35 2 35 Status / Message You are seriously underweight You are underweight You are normal weight You are overweight You are seriously overweight You are gravely overweight Figure 4: BMI Status
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Fundamentals of Datawarehouse
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr