Administrative expenses associated for car rental

Assignment Help Operation Management

Reference no: EM132255225

In the Profit Analysis worksheet:

Expenses costs include maintenance, cleaning, and administrative expenses associated for a car rental. The Expenses for one rental transaction will be determined from the values specified in the worksheet. DO NOT enter the values in this column on a cell by cell basis.

a. In the first cell directly under the Expenses label, calculate the total Expenses that corresponds to the number of cars rented IN THAT ROW (NumCars) using an "IF" statement to as part of the formula to determine the value of Expenses for one vehicle.

b. First, use the "IF" statement to determine the single vehicle Expenses and second, edit the cell contents to multiply it by the NumCars so that the Expenses value represents the total Expenses costs for the Number of Cars (NumCars) rented in a given row.

c. Use the absolute cell address for the numerical Expenses value for ONE vehicle which should then be multiplied by the number of cars in each row. d. Adjust column width as needed to eliminate truncation after format adjustments.. Note: the use of absolute addresses allows those Expenses values to be changed and then by recalculation, update the entire Excel table.

Reference no: EM132255225

Questions Cloud

There are several office furniture companies thriving : It seems like there are several office furniture companies thriving, but not as many custom furniture manufacturers,”

Firewalls effective is making sure your firewall : What is meant by "firewalls effective is making sure your firewall is "future ready."?

Determining the incremental development : Section 6.2 of your textbook describes incremental development. Do the exercise at the end of that section:

Evaluation of a current state health initiative : You will conduct an assessment and evaluation of a current state health initiative or legislation (Gun Regulations) - explore your role as a political advocate

Administrative expenses associated for car rental : Expenses costs include maintenance, cleaning, and administrative expenses associated for a car rental.

What is quality and its importance to project success : What is quality and its importance to project success

Main reasons for evaluating of construction project : What are the main reasons for evaluating of a construction project?

What is the difference between dff and d-latch : What is the difference between DFF and D-Latch? Can one chip be used for constructing the other? Explain.

Syntax of the sql select statement : Describe the six clauses that can be used in the syntax of the SQL SELECT statement. Which two clauses must be part of each SELECT statement?

User Account

All Pages