I can't figure out how to write the formula for bonuses. Can someone help me? File Home Insert Page Layout FormulasX2.eLBAutoSave On F Excel Question . Saved ✓UndoPasteClipboard G✓ X ✓ fx4 Revenue5 Sales6 Consulting7 Total Net Revenue89 Expenditures10 Administrative11 Bonus12 Equipment13 Marketing14 Payroll15 Production16 Total ExpendituresBIUU17 Operating Income1819 What-If Data20 Administrative21 Bonus22 Equipment23 Marketing424 Payroll25 ProductionEdit26 Revenue for Bonus2728293031C2 Annual Operating income Projection by Quarter3Qtr 1Qtr 2Qtr 3HAccessibility: InvestigateFontFinancial Projection10=IF(B7>B21)=0B122479991678153139261521462245.96Data Review ViewΑ Α΄A0.105250000]0.17750.1350.2250.063140000005==E ESheet2 Sheet315234813590198821136801===D+Help=IF(B7>B21)=0IF(logical test, [value_if_true], [value_if_false]) 78146.6081880030.522853468.135 2873519.9553133384.2877347.5764755780.225 4789199.9251331618.4631340975.9792219364.105 2234959.965Alignment16567102471823121285333■Qtr 4aWrap TextMerge & CenterESearch (Alt+Q)106192011569378121885791279800.7952163472.7731645458.1652742430.275767880.477TotalGGeneral$ % 9% 95.00NumberF6/27/20135466911513867750685368657196370.82512165293.549252476.77515420794.634317822.495G5H▬▬▬▬Conditional Format as CellFormatting Table StylesStylesamazon—IJ-KW24TX ▬▬▬▬TA ▬▬▬▬▬Insert Delete FormatL-CellsMSchneider, Kaylee M SKΣ AutoSumFill✓ClearNAYSort & Find &Filter SelectEditingOPBCommentsMAnalyze SensitivityDataAnalysisQDShareSensitivityRS+12:08 PM12/14/2022x▲100% O Mail - Schneider, Kaylee M - OurX w ExcelW←FileDVnWordExcel - Saved ✓Home InsertO8 https://mnscu-my.sharepoint.com/:w:/r/personal/gv5575wl_go_minnstate_edu/_layouts/15/Doc.aspx?sourcedoc={25F4DFC0-486D-4FFD-886F-016A382 words English (U.S.)X b Home | bartlebyO Search (Alt + Q)Layout References ReviewTotal Net RevenueAdministrative ExpenditureBonusEquipment ExpenditureMarketing ExpenditurePayroll ExpenditureProduction ExpenditureTotal ExpendituresOperating IncomeACalibri (Body) ✓11BI U描く叩くE● Use formulas wherever possible. Use the IF function to calculate the bonus). Please note following formulas touse:===Sales + ConsultingTotal Net Revenue * Administrative cost (B20)= If Total Net Revenue > Revenue for Bonus (B26) then Bonus (B21) otherwise 0Total 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 expendituresTotal Net Revenue - Total Expenditures=x +===View HelpB1Notable Web Site Design2 Annual Operating Income Projection by QuarterText Predictions: On Editor Suggestions: ShowingCPage Breaktr 2DEditingQtr 3amazonEQtr 4-OWCommentsF6/27/2013Total150%+100%Catch upaOXKSFit Give Feedback to Microsoft12:09 PM12/14/2022Share ✓

The solution is given in the below step with explanation

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

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers

Section: Chapter Questions

Problem 8EYW

See similar textbooks

Similar questions

Drop down box method works well for small Excel data validation lists that are unlikely to ever change. TRUE OR FALSE
The file FDICBankFailures contains data on failures of federally insured banks between 2000 and 2012. Create a PivotTable in Excel to answer the following questions. The PivotTable should group the closing dates of the banks into yearly bins and display the counts of bank closures each year in columns of Excel. Row labels should include the bank locations and allow for grouping the locations into states or viewing by city. You should also sort the PivotTable so that the states with the greatest number of total bank failures between 2000 and 2012 appear at the top of the PivotTable. Click on the datafile logo to reference the data. (a) Which state had the greatest number of federally insured bank closings between 2000 and 2012? - Select your answer -(b) How many bank closings occurred in the state of Nevada (NV) in 2010?In what cities did these bank closings occur? - Select your answer -(c) Use the PivotTable’s filter capability to view only bank closings in California (CA),…
you are supposed to create an excel sheet for student grade sheet. There must be at least 10 records. Following columns will be needed for the sheet. Also add summary of the grades as follows. Grade Count A 6 B 4 C 8 D 2 F 10 TOTAL 30 Grading Criteria to calculate grades is as follows: Marks Grade 90-100 A 80-89 A- 75-79 B+ 70-74 B 65-69 C+ 60-64 C 50-59 D Less than 50 F
Create a mailing list from the CUSTOMERS table. The mailing list should display the name, address, city, state, and zip code for each customer. Each customer’s name should be listed in order of last name followed by first name, separated with a comma, and have the column header “Name.” The city and state should be listed as one column of output, with the values separated by a comma and the column header “Location.”
Open the Excel file Student_Excel_Intro_Cap1_Year_End_Report.xlsx downloaded with this project. On the Net Sales worksheet, calculate totals in the ranges F4:F8 and B9:F9. Apply the Total cell style to the range B9:F9. Using absolute cell references as necessary, in cell G4, construct a formula to calculate the percent that the Colorado Total is of Total Sales, and then apply Percent Style with zero decimals. Fill the formula down through the range G5:G8. In the range H4:H8, insert Line sparklines to represent the trend of each state across the four quarters. Do not include the totals. Display Markers. Select the range A3:E8, and then use the Recommended Charts command to suggest an appropriate chart. Click the first Clustered Column chart that uses the state names as the category axis. Align the upper left corner of the chart inside the upper left corner of cell A11, and then size the chart so that its lower right corner is slightly inside cell H24. Apply chart Style…
Using the “Green Savings” worksheet, provide the formulas to calculate the savings for each computer type usage, and corresponding totals. Using the auto-format feature format range A3:D12 in the “Green Savings” worksheet. note that values are to be formatted with the thousands separator, ZERO decimal places with “$” signs on the final values.
Microsoft Excel Formula assignment: The objective of this assignment is to create 20 [5x5] tables and each 5 by 5 table will have mix of numbers from 1 to 100. (NOTE: There can't be ANY duplicate numbers in the 25 cells). The numbers placed in the 5x5 table cannot match with any other table AND again, each table cannot repeat the same number. I need to create this without having to manually type numbers and create the 5 by 5 tables.What is the fastest way to create these tables using formulas? This assignment demonstates the examples for formulas on excel. Here is two examples for 2 tables.TABLE 1:1 2 3 4 56 7 8 9 1011 12 13 14 1516 17 18 19 2021 22 23 24 25TABLE 2:59 2 3 4 133 72 8 9 6611 22 13 88 1516 17 18 19 529 40 99 30 21Here is an example that will NOT work.1 2 66 4 216 7 8 7 910 11 12 39 4182 88 88 88 29100 33 35 32 51
Submit a single Excel file with formulas within answer cells. Show the formulas for how to get the answer. County Hospital contracts for an anesthesiologist’s services for a guaranteed cost of $15,000 a month. For every service the anesthesiologist provides on a procedure, the hospital budgets an incremental $200 toward the anesthesiologist’s salary. Every time the anesthesiologist provides a service, the hospital gains revenue of $1200, which is a sixth of the overall procedure’s revenue. Be sure to make excel do the calculations and indicate any units for the answer. The revenue for the anesthesiologist’s portion of the procedure is only a fifth of the overall procedure revenue. What would the hospital’s monthly total revenue be for the BE procedures?
V5. min jee wants to combine the sales data from each of the art fairs. switch to the combined sales worksheet and then update the worksheet as follows. in cell A5 enter a formula without using a function that references cell a5 in the Madison worksheet. copy the formula from cell a5 to the range a6:a8 without copying the formatting. in cell b5, enter a formula using the sum function, 3d references, grouped worksheets that totals the values from cell b:5 in the chicago: madison worksheets.
can you help me with this assignment? *This is the last page (#3 page) INSERT INTO position VALUES (2, 'Manager'); INSERT INTO position VALUES (3, 'Programmer'); INSERT INTO position VALUES (4, 'Accountant'); INSERT INTO position VALUES (5, 'Salesman'); INSERT INTO emplevel VALUES (1, 1, 25000); INSERT INTO emplevel VALUES (2, 25001, 50000); INSERT INTO emplevel VALUES (3, 50001, 100000); INSERT INTO emplevel VALUES (4, 100001, 500000); INSERT INTO qualification VALUES (1, 'Doctorate'); INSERT INTO qualification VALUES (2, 'Masters'); INSERT INTO qualification VALUES (3, 'Bachelors'); INSERT INTO qualification VALUES (4, 'Associates'); INSERT INTO qualification VALUES (5, 'High School'); INSERT INTO dept VALUES (10, 'Finance', 'Charlotte', 123); INSERT INTO dept VALUES (20, 'InfoSys', 'New York', 543); INSERT INTO dept VALUES (30, 'Sales', 'Woodbridge', 135); INSERT INTO dept VALUES (40, 'Marketing', 'Los Angeles', 246); INSERT INTO employee VALUES (111, 'Smith', 'John', 1, NULL,…
1. Use the VLOOKUP function in MS Excel application to enter the miles flown column by looking up the frequent-flier number. (Hint: If done correctly with absolute references, you should be able to enter the VLOOKUP formula in the first cell in the “miles flown” column and copy it down for all the cells.) 2. Create another VLOOKUP function to fill in the phone number for Mark Dumont automatically in Cell G3. 3. Create any logical function by using one of the following logical operators: AND, OR, NOT. Highlight the data in standard yellow color where this logical function is used on the spreadsheet. 4. Create any “IF” function that uses a simple “named range” in calculation based on the example we covered in class. Please highlight the data in standard blue color on the spreadsheet that uses this “IF” function. 5. Use conditional formatting to highlight top 10 highest-earning frequent fliers with an orange color. 6. Use conditional formatting to highlight all frequent fliers who have…
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.