Question
1. Quarterly sales will increase 20% after QTR1 and for every following quarter 2. Material Expense will increase 10% after QTR1 and for every following
1. Quarterly sales will increase 20% after QTR1 and for every following quarter
2. Material Expense will increase 10% after QTR1 and for every following quarter
3. Labor Expense will increase 12% after QTR1 and for every following quarter
4. Overhead will increase 13 % after QTR1 and for every following quarter
5. Calculate Charity Deduction (Total NetSales*Charity Contribution) using Absolute Cell Addressing.
6. Calculate Taxes (Total Net Sales * Tax Percent) using Absolute Cell Addressing.
7. Total Operating Expenses is the SUM of all expenses for the quarter
8. Operating Income is NetSales- Total Operating Expenses
9. Yearly Totals is the SUM of each category
10. Use the appropriate functions to find all Averages, Max and Min amounts where appropriate.
11. Make sure to add borders, change fonts and add some cell shading. The font size for the title is up to you. Make sure that the title is centered across the columns and that each column heading is centered in its cell. Format all cells as needed with $, % etc
12. Create a Graph for Net Sales
13. Create a Graph for Quartely Expenses.
This is the spreadsheet I am working with:
0 Excel File Edit View Insert Format Tools Data Window Help 69% (4) Sat 3:54 PM AutoSave OFF HESU Abc Company (2).xls - Compatibility Mode Update Later Home Insert Draw Page Layout Formulas Data Review View Tell me Microsoft AutoUpdate Updates are ready to be installed. Restart Apps X EI Arial 10 = = ab Wrap Text General 37 Delete Paste BI A $ 9 Merge & Center V Ideas % , Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity Format Find & Select B8 Xfx | B C D E F G H J K L M N O P Q R S T U V QTR 1 QTR 2 QTR 3 QTR 4 YEARLY TOTALS 0.03 0.33 A 1 INCOME STATEMENT 2020 2 3 4 5 6 7 8 Net Sales 9 Charity Contribution 10 Tax Percent 11 Cost and Expense: 12 13 Rent 14 Ads 15 COG 16 Material 17 Labor 18 Taxes 19 Overhead 20 Charity Deduction 21 22 Toral Operating Expenses 23 24 Operating Income 600 900 4000 5000 13000 635 2000 4200 350 4000 5000 600 4500 8000 9000 25 26 Average Quarterly Expenses 27 Minimum Quarterly Expenses 28 Maximum Quarterly Expenses 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 ABC Company Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Sheets Sheet10 Sheet11 Sheet12 Sheet13 Sheet14 Sheet15 Sheet16 + Edit P 100% 25 A W P ... 0 Excel File Edit View Insert Format Tools Data Window Help 69% (4) Sat 3:54 PM AutoSave OFF HESU Abc Company (2).xls - Compatibility Mode Update Later Home Insert Draw Page Layout Formulas Data Review View Tell me Microsoft AutoUpdate Updates are ready to be installed. Restart Apps X EI Arial 10 = = ab Wrap Text General 37 Delete Paste BI A $ 9 Merge & Center V Ideas % , Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity Format Find & Select B8 Xfx | B C D E F G H J K L M N O P Q R S T U V QTR 1 QTR 2 QTR 3 QTR 4 YEARLY TOTALS 0.03 0.33 A 1 INCOME STATEMENT 2020 2 3 4 5 6 7 8 Net Sales 9 Charity Contribution 10 Tax Percent 11 Cost and Expense: 12 13 Rent 14 Ads 15 COG 16 Material 17 Labor 18 Taxes 19 Overhead 20 Charity Deduction 21 22 Toral Operating Expenses 23 24 Operating Income 600 900 4000 5000 13000 635 2000 4200 350 4000 5000 600 4500 8000 9000 25 26 Average Quarterly Expenses 27 Minimum Quarterly Expenses 28 Maximum Quarterly Expenses 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 ABC Company Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Sheets Sheet10 Sheet11 Sheet12 Sheet13 Sheet14 Sheet15 Sheet16 + Edit P 100% 25 A W PStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started