“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

In the Profit Analysis Worksheet: a. In the first cell directly under the Profit label, calculate total profit by subtracting Expenses from revenue (should be a positive number). (Revenue Expenses). Then repeat the formula for each row below. b. In the first cell directly under the ProfitperCar label, divide Profit by NumCars (Profit/Numcars). Then repeat the formula for each row below. c. Adjust column widths as needed to eliminate truncation after formatting.

Solved by V. C. in 26 mins

In the Profit Analysis worksheet: a. Create a Pivot Table using numeric data from Profit column. b. Display the total profit for each of the four classes of cars. c. Display the total profit for Airport as well as the Downtown location. d. Row and column calculations (sum) are required so that the total profit for EACH location and the total profit for EACH carclass are visible in the pivot table. There must be a grand total (sum) that represents the sum of ALL profit.

Solved by T. D. in 23 mins

How do I find the formula for profit per car to put in the last column?

Solved by S. B. in 29 mins

calculate (using profit calculator) minimum sale price needed to achieve set profit margin for various cost price increments

Solved by S. H. in 23 mins

I need a formula that will generate a percentage based off a chart of numbers. This is for a commission percentage reporting. So basically if the gross profit margin is 60%, the commission will be 15%. If the gross profit margin is 40%, the commission will be 5%. I have a cell that I will manually be entering the gross profit margin, so now I need a function that will generate the commission percentage based off what I type into the gross profit margin cell.

Solved by B. B. in 28 mins