• PROJECT STEPS

1. Dewayne Lipinski works for Cairo Consulting in Albuquerque, New Mexico. As an intern, he is developing a workbook that includes the financial details of the consulting services that the company offers. Dewayne has been asked to analyze the data to find the most profitable mix of offerings using the most cost-effective service providers. Switch to the Management worksheet. Create a one-variable data table to calculate the sales, expenses, and profit based on the hours of management consulting contracted, as follows:
   1. In cell D5, enter a formula without using a function that references cell B4, which is the expected hours of management consulting contracted.
   2. In cell E5, enter a formula without using a function that references cell B19, which is the expected total sales for management consulting.
   3. In cell F5, enter a formula without using a function that references cell B20, which is the expected total expenses for this product.
   4. In cell G5, enter a formula without using a function that references cell B21, which is the expected gross profit for this product.
   5. Select the range D5:G10 and then complete the one-variable data table, using cell B4 as the Column input cell for your data table.

B Blanda, Melane File 2. Share Jx ME_EXP2.38 Melanikel_2- Ence Home Insert Pagelagt formule Data Besse VIFH Help Arrohat Time what you want to do A la JO El Define Meme Trece Precce Show Formula Calculate Now A Users Trace Dependents Emor Checking utobum fecerly Financial Log.ca Text Dste 8 LODU 8 Math & More Name Watch Clusion Calate Sheet Tour Rule Tiig. Function Marage Coute from Selection Remove Alm. Evduate Formula Window Option Functionary Die Nantes Formule Cakuan Insert Function 12 D E E G H K L M N 0 P Q R 5 5 Management - Droit Analysis Total Sales Total penses Heurs Contracte Gross Profit 6,500 2,000 7,500 8,000 8,500 Manasoment Gross Prorit Analysis 290.00 $ 300.00 $ 210.00 $ $ 280.00 $ 320.00 330.00 340.00 B Cairo Consulting Management 2 3 Sales 4 4 Hours Solo 7.500 S Price Der Hour $ 310.00 G Total Sales $ 2.325,000.00 ? a Expenses 9 Variable penses 10 Hours Contracted 7.500 11 Variable Cost Per Hour $ 199.00 12 Total Variable Cusis S 1425,000.00 13 Fixed Expenses 14 Total Fixed Cost $ 770,000.00 15 Expenses - Total $ 2,195,000.00 16 Total Expense Per Hour Contracted $ 292.67 17 10 Pro 19 Total Sales $ 2.325,000.00 20 Total Expenses $ 2.195,000 21 Gross Premit $ 130,000.00 22 23. Besk-Event Analysis 24 Price Per Hour $ 310.00 Cast Der Hour S s 292.67 26 Hours Contracted 7.500 27 Gross Profit $ 120,000.00 20 20 20 33 32 33 34 35 20 37 130,000 $ 6,500 7.000 7,500 8,000 3.300 Documentacion Management Charge Process Process Prouders Al Types Ready + 100% 143 PM 4/14/2008 O 0 W! x