Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you please create a flow chart using these problems? Thank you Project Background: You have just been hired by Olympus Tours (OT), a bus

image text in transcribed

image text in transcribed

Can you please create a flow chart using these problems? Thank you

Project Background: You have just been hired by Olympus Tours (OT), a bus rental company located in Orem, Utah. OT provides buses for groups such as schools, family reunions, and travel clubs. The smallest group OT will bus is 20 people and the largest group is 120 people. Two types of buses are available for use: small buses ( 25 maximum riders per bus) and large buses ( 60 maximum riders per bus). Assume that OT has access to all of the small and large buses it needs. Table 1. Bus Combinations OT's pricing structure is as follows. The base price (BP) is calculated by multiplying the number of people (P) included in the trip by a per-person base rate (PPBR). BP=PPPBR The base price covers trips up to and including five hours in duration. Customers are charged extra for tours that last longer than 5 hours. For example, a bus rented for 6.5 hours would have 1.5 overtime hours (OH). The maximum number of overtime hours per day is four, which means any trip lasting nine hours or more has the same number of overtime hours regardless of the duration of time that exceeds 9 hours. The overtime charge (OC) is calculated by multiplying the base price (BP) by the overtime hours ( OH) multiplied by the extra hourly percentage (EHP) as follows: OC=BPOHEHP Table 2 shows some example price calculations that include partial hours. Table 2 Example Pricing Calculations Note: These numbers are not calculated in your code. Your sub should simply take whatever value for PPBR and EHP that is given in the setup portion of the single estimate and use that in your calculations. These are just example values you can use to test your outputs afterward

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

The Structure Of The Relational Database Model

Authors: Jan Paredaens ,Paul De Bra ,Marc Gyssens ,Dirk Van Gucht

1st Edition

3642699588, 978-3642699580

More Books

Students also viewed these Databases questions