Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
venue Consulting Total Net Revenue * Administrative cost (B20) = If Total Net Revenue > Revenue for Bonus (B26) then Bonus (B21) otherwise 0 Total Net Revenue Equipment cost (B22) Total Net Revenue * Marketing cost (B23) Total Net Revenue * Payroll cost (B24) Total Net Revenue * Production cost (B25) Sum of other expenditures Total Net Revenue - Total Expenditures Administrative Expenditure Bonus Equipment Expenditure Marketing Expenditure Payroll Expenditure Production Expenditure Total Expenditures Operating Income

venue Consulting Total Net Revenue * Administrative cost (B20) = If Total Net Revenue > Revenue for Bonus (B26) then Bonus (B21) otherwise 0 Total Net Revenue Equipment cost (B22) Total Net Revenue * Marketing cost (B23) Total Net Revenue * Payroll cost (B24) Total Net Revenue * Production cost (B25) Sum of other expenditures Total Net Revenue - Total Expenditures Administrative Expenditure Bonus Equipment Expenditure Marketing Expenditure Payroll Expenditure Production Expenditure Total Expenditures Operating Income

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

I can't figure out how to write the formula for bonuses. Can someone help me?

File Home Insert Page Layout Formulas X 2. e LB AutoSave On F Excel Question . Saved ✓ Undo Paste Clipboard G ✓ X ✓ fx 4 Revenue 5 Sales 6 Consulting 7 Total Net Revenue 8 9 Expenditures 10 Administrative 11 Bonus 12 Equipment 13 Marketing 14 Payroll 15 Production 16 Total Expenditures BIU U 17 Operating Income 18 19 What-If Data 20 Administrative 21 Bonus 22 Equipment 23 Marketing 4 24 Payroll 25 Production Edit 26 Revenue for Bonus 27 28 29 30 31 C 2 Annual Operating income Projection by Quarter 3 Qtr 1 Qtr 2 Qtr 3 H Accessibility: Investigate Font Financial Projection 10 =IF(B7>B21)=0 B 12247999 1678153 13926152 1462245.96 Data Review View Α Α΄ A 0.105 250000] 0.1775 0.135 0.225 0.063 14000000 5 == E E Sheet2 Sheet3 15234813 5901988 21136801 === D + Help =IF(B7>B21)=0 IF(logical test, [value_if_true], [value_if_false]) 78146.608 1880030.52 2853468.135 2873519.955 3133384.2 877347.576 4755780.225 4789199.925 1331618.463 1340975.979 2219364.105 2234959.965 Alignment 16567102 4718231 21285333 ■ Qtr 4 a Wrap Text Merge & Center E Search (Alt+Q) 10619201 1569378 12188579 1279800.795 2163472.773 1645458.165 2742430.275 767880.477 Total G General $ % 9 % 95.00 Number F 6/27/2013 54669115 13867750 68536865 7196370.825 12165293.54 9252476.775 15420794.63 4317822.495 G 5 H ▬▬▬▬ Conditional Format as Cell Formatting Table Styles Styles amazon — I J - K W 24 TX ▬▬▬▬ TA ▬▬▬▬▬ Insert Delete Format L - Cells M Schneider, Kaylee M SK Σ AutoSum Fill ✓Clear N AY Sort & Find & Filter Select Editing O P B Comments M Analyze Sensitivity Data Analysis Q D Share Sensitivity R S + 12:08 PM 12/14/2022 x ▲ 100%
Transcribed Image Text:File Home Insert Page Layout Formulas X 2. e LB AutoSave On F Excel Question . Saved ✓ Undo Paste Clipboard G ✓ X ✓ fx 4 Revenue 5 Sales 6 Consulting 7 Total Net Revenue 8 9 Expenditures 10 Administrative 11 Bonus 12 Equipment 13 Marketing 14 Payroll 15 Production 16 Total Expenditures BIU U 17 Operating Income 18 19 What-If Data 20 Administrative 21 Bonus 22 Equipment 23 Marketing 4 24 Payroll 25 Production Edit 26 Revenue for Bonus 27 28 29 30 31 C 2 Annual Operating income Projection by Quarter 3 Qtr 1 Qtr 2 Qtr 3 H Accessibility: Investigate Font Financial Projection 10 =IF(B7>B21)=0 B 12247999 1678153 13926152 1462245.96 Data Review View Α Α΄ A 0.105 250000] 0.1775 0.135 0.225 0.063 14000000 5 == E E Sheet2 Sheet3 15234813 5901988 21136801 === D + Help =IF(B7>B21)=0 IF(logical test, [value_if_true], [value_if_false]) 78146.608 1880030.52 2853468.135 2873519.955 3133384.2 877347.576 4755780.225 4789199.925 1331618.463 1340975.979 2219364.105 2234959.965 Alignment 16567102 4718231 21285333 ■ Qtr 4 a Wrap Text Merge & Center E Search (Alt+Q) 10619201 1569378 12188579 1279800.795 2163472.773 1645458.165 2742430.275 767880.477 Total G General $ % 9 % 95.00 Number F 6/27/2013 54669115 13867750 68536865 7196370.825 12165293.54 9252476.775 15420794.63 4317822.495 G 5 H ▬▬▬▬ Conditional Format as Cell Formatting Table Styles Styles amazon — I J - K W 24 TX ▬▬▬▬ TA ▬▬▬▬▬ Insert Delete Format L - Cells M Schneider, Kaylee M SK Σ AutoSum Fill ✓Clear N AY Sort & Find & Filter Select Editing O P B Comments M Analyze Sensitivity Data Analysis Q D Share Sensitivity R S + 12:08 PM 12/14/2022 x ▲ 100%
O Mail - Schneider, Kaylee M - OurX w Excel W ← File D V n Word Excel - Saved ✓ Home Insert O8 https://mnscu-my.sharepoint.com/:w:/r/personal/gv5575wl_go_minnstate_edu/_layouts/15/Doc.aspx?sourcedoc={25F4DFC0-486D-4FFD-886F-016A 382 words English (U.S.) X b Home | bartleby O Search (Alt + Q) Layout References Review Total Net Revenue Administrative Expenditure Bonus Equipment Expenditure Marketing Expenditure Payroll Expenditure Production Expenditure Total Expenditures Operating Income A Calibri (Body) ✓11 BI U 描く叩く E ● Use formulas wherever possible. Use the IF function to calculate the bonus). Please note following formulas to use: = = = Sales + Consulting Total Net Revenue * Administrative cost (B20) = If Total Net Revenue > Revenue for Bonus (B26) then Bonus (B21) otherwise 0 Total Net Revenue * Equipment cost (B22) Total Net Revenue * Marketing cost (B23) Total Net Revenue * Payroll cost (B24) Total Net Revenue * Production cost (B25) Sum of other expenditures Total Net Revenue - Total Expenditures = x + = = = View Help B 1Notable Web Site Design 2 Annual Operating Income Projection by Quarter Text Predictions: On Editor Suggestions: Showing C Page Break tr 2 D Editing Qtr 3 amazon E Qtr 4 - O W Comments F 6/27/2013 Total 150% + 100% Catch up a O X KS Fit Give Feedback to Microsoft 12:09 PM 12/14/2022 Share ✓
Transcribed Image Text:O Mail - Schneider, Kaylee M - OurX w Excel W ← File D V n Word Excel - Saved ✓ Home Insert O8 https://mnscu-my.sharepoint.com/:w:/r/personal/gv5575wl_go_minnstate_edu/_layouts/15/Doc.aspx?sourcedoc={25F4DFC0-486D-4FFD-886F-016A 382 words English (U.S.) X b Home | bartleby O Search (Alt + Q) Layout References Review Total Net Revenue Administrative Expenditure Bonus Equipment Expenditure Marketing Expenditure Payroll Expenditure Production Expenditure Total Expenditures Operating Income A Calibri (Body) ✓11 BI U 描く叩く E ● Use formulas wherever possible. Use the IF function to calculate the bonus). Please note following formulas to use: = = = Sales + Consulting Total Net Revenue * Administrative cost (B20) = If Total Net Revenue > Revenue for Bonus (B26) then Bonus (B21) otherwise 0 Total Net Revenue * Equipment cost (B22) Total Net Revenue * Marketing cost (B23) Total Net Revenue * Payroll cost (B24) Total Net Revenue * Production cost (B25) Sum of other expenditures Total Net Revenue - Total Expenditures = x + = = = View Help B 1Notable Web Site Design 2 Annual Operating Income Projection by Quarter Text Predictions: On Editor Suggestions: Showing C Page Break tr 2 D Editing Qtr 3 amazon E Qtr 4 - O W Comments F 6/27/2013 Total 150% + 100% Catch up a O X KS Fit Give Feedback to Microsoft 12:09 PM 12/14/2022 Share ✓
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Lease Option
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS