Lab_Assign_1_A You are thinking of starting a small express oil change service center. Before you begin, you need to evaluate what you think your monthly expenses will be. You've started av complete the entries and add formulas. A. Create a formula in cell C5 that calculates the annual expenses B. Copy the formula in cell C5 to the range C6:C11 C. Create formulas in cells B12 and C12 that total (subtotal) the monthly and annual expenses D. Create a formula in cell C3 that calculates annual sales E. Create a formula in cell B14 that determines whether you will make a profit or loss, then copy the formula into cell C14 F. Copy the labels in cells B2:C2 to cells E2:F2 G. Type Projected Increase in cell G1, then type 2 in cell H2 (Format as Percentage) H. Create a formula in cell D5 that calculates an increase in the monthly rent by the amount in cell H2, using an absolute reference. (New amount should show original + in I. Copy the formulas in cells D5 into cells D6:D11 to calculate the remaining monthly and annual expenses. (New amount should show original + increase) J. Create a formula in cell D12 that calculates the total monthly expenses, K. Create a formula in cell E5 that calculates the annual expenses L. Copy the formula in cell E5 to the range E6:E11 M. Create formulas in cells D14 and E14 that calculate profit/loss based on the projected increase in monthly and annual expenses N. Save Lab Assign (0).XISX B 1 2 3 Estimated Express Oil Change profit with increases in expense Monthly Annual Sales 23,000 4 5 Rent 750 3 Supplies 7,500 7 Oil 50 Fan Belts 8,000 Oil Filters 2,000 Coffee 200 Utilities 1,250 Subtotal 0 1 2 3 14 15 16 17 Profit/Loss 18 19 20 Md Habibur Rai Reply No recent chats Lab_Assign_1_A You are thinking of starting a small express oil change service center. Before you begin, you need to evaluate what you think your monthly expenses will be. You've started av complete the entries and add formulas. A. Create a formula in cell C5 that calculates the annual expenses B. Copy the formula in cell C5 to the range C6:C11 C. Create formulas in cells B12 and C12 that total (subtotal) the monthly and annual expenses D. Create a formula in cell C3 that calculates annual sales E. Create a formula in cell B14 that determines whether you will make a profit or loss, then copy the formula into cell C14 F. Copy the labels in cells B2:C2 to cells E2:F2 G. Type Projected Increase in cell G1, then type 2 in cell H2 (Format as Percentage) H. Create a formula in cell D5 that calculates an increase in the monthly rent by the amount in cell H2, using an absolute reference. (New amount should show original + in I. Copy the formulas in cells D5 into cells D6:D11 to calculate the remaining monthly and annual expenses. (New amount should show original + increase) J. Create a formula in cell D12 that calculates the total monthly expenses, K. Create a formula in cell E5 that calculates the annual expenses L. Copy the formula in cell E5 to the range E6:E11 M. Create formulas in cells D14 and E14 that calculate profit/loss based on the projected increase in monthly and annual expenses N. Save Lab Assign (0).XISX B 1 2 3 Estimated Express Oil Change profit with increases in expense Monthly Annual Sales 23,000 4 5 Rent 750 3 Supplies 7,500 7 Oil 50 Fan Belts 8,000 Oil Filters 2,000 Coffee 200 Utilities 1,250 Subtotal 0 1 2 3 14 15 16 17 Profit/Loss 18 19 20 Md Habibur Rai Reply No recent chats