The CarMin dealership has approached you to write a program to keep track of the sales commissions paid to the sales team each time they sell a used car. The amount of the commission that a salesperson earns is based on the type of vehicle sold. Currently CarMin is trying to incentivize it salesforce to try and sell Hybrids and SUVs because these vehicles generate the most profit within the dealership. vehicle types have the highest commissions. These Vehicle Type Bonus Commission Hybrid 4.0% of Selling Price Coupe 1.5% of Selling Price Sedan 1.5% of Selling Price SUV 3.0% of Selling Price Minivan 2.5% of Selling Price Create a program for use by the sales manager to track commissions by vehicle type. It is unknown how many cars the dealership will sell in a given month. The program should allow the manager to continuously enter a vehicle type and selling price each time a vehicle is sold. You must validate the vehicle type and selling price using appropriate validation. If any validations fails you should provide an error message and re-prompt the manager. Once the manager has indicated they are finished entering sales, display a well-formatted report containing a list of each vehicle type along with: total sold total sales total commissions earned average commission earned.
Max Function
Statistical function is of many categories. One of them is a MAX function. The MAX function returns the largest value from the list of arguments passed to it. MAX function always ignores the empty cells when performing the calculation.
Power Function
A power function is a type of single-term function. Its definition states that it is a variable containing a base value raised to a constant value acting as an exponent. This variable may also have a coefficient. For instance, the area of a circle can be given as:
The CarMin dealership has approached you to write a
and sell Hybrids and SUVs because these vehicles generate the most profit within the dealership. vehicle types have the highest commissions.
These
|
Vehicle Type |
Bonus Commission |
Hybrid 4.0% of Selling Price
Coupe 1.5% of Selling Price
Sedan 1.5% of Selling Price
SUV 3.0% of Selling Price
Minivan 2.5% of Selling Price
Create a program for use by the sales manager to track commissions by vehicle type. It is unknown how many cars the dealership will sell in a given month. The program should allow the manager to continuously enter a vehicle type and selling price each time a vehicle is sold. You must validate the vehicle type and selling price using appropriate validation. If any validations fails you should provide an error message and re-prompt the manager.
Once the manager has indicated they are finished entering sales, display a well-formatted report containing a list of each vehicle type along with:
-
total sold
-
total sales
-
total commissions earned
-
average commission earned.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
