Question: 2. Create a two-variable data table to calculate the gross profit based on the hours of management consulting contracted and the hourly rate charged as
2. Create a two-variable data table to calculate the gross profit based on the hours of management consulting contracted and the hourly rate charged as follows: a. For the Management Gross Profit Analysis section, create a two-variable data table using the price per hour in the Sales section as the row input cell. b. Use the hours sold in the Sales section as the column input cell. c. Apply a custom format to cell D14 to display the text Hours/Price in place of the cell value
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
