Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help finding the gross profit and net profit. I need the formulas in excel. The second picture includes what is wrong and what

I need help finding the gross profit and net profit. I need the formulas in excel. The second picture includes what is wrong and what needs to be fixed. It says that gross profit should be 8536.585 and net profit is 5000? please help!!! image text in transcribed
image text in transcribed
C14 D B E A Direct Marketing 1 2. 2 3 Inputs 4 Number of Ads 5 Click Rate 10000 7.20% $ 0.02 $ 0.03 $ 0.03 6 7. Parameters 8 Design Fee $ 2,000.00 9 Cost Per Ad $ 2.25 10 Total Clicks 720 11 Profit Per Click $ 12.50 12 Gross Profit 13 Net Profit 14 $ 0.04 $ 0.04 $ 0.05 $ 0.05 $ 0.06 $ 0.06 $ 0.07 15 16 17 18 Direct Marketing Range Names S Ready Use the newly created range names to create a formula to calculate Gross Profit (ell B12) and Net Profit (cell B13). 4.8 8 0 In the Cell 'B12' of Sheet Direct Marketing, the "Formula Result Value' was not set to '8536.585". 0.6 0 0.6 In the Cell 'B13' of Sheet Direct Marketing, the 'Formula Result Value' was not set to "5000". 4.8 8 Other action(s) in this instruction were performed and scored correctly

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Financial Accounting Concepts Paperback By Edmonds Thomas P O

Authors: Thomas P. Edmonds, Christopher Edmonds, Mark A. Edmonds, Jennifer Edmonds, Philip R. Olds

11th Edition

9781264266234, 1264266235

More Books

Students also viewed these Accounting questions