ComputerScienceExpert
$18/per page/
*Build the spreadsheet above and save file as Quarterly_Budget_ YourFirstName_YourLastName.xlsx. Enter all formulas first then format.
(1) Quarter total is the sum of January through March.
(2) Write formula for B11 so it can be copied: Total Revenue is the sum of Sales and Other Revenue.
(3) Write formula for B14 so it can be copied: Expenses are a percentage of total revenue. The budget percent values are located in rows 25‐29. Be sure your formula uses these cell addresses.
(4)Write formula for B20 so it can be copied: Total expenses are the sum of the department expenses.
(5) Write formula for B22 so it can be copied: Net Income is total revenue minus total expenses.
(6) Quaterly Total is a sum of January, February , and March for that row.
*Format all currency amounts with 2 decimals.
*Create an embedded pie chart ( as an object in this spreadsheet) which shows contribution of each type of an expense into total expenses.
*Create a column chart as a new sheet to show first quarter expenses by the type of expenses. Name the chart "First Quarter Expenses by the Expense Type" On the next line of the chart title in smaller font put "Prepared by YourFirstName YourLastName".
*Create a column chart as a new sheet to show first quarter expenses by month. Name the chart "First Quarter Expenses by Month" On the next line of the chart title in smaller font put "Prepared by YourFirstName YourLastName".
*Insert right section footer with your name, date and file name, each on a separate line. Use font size 8. See sample at the right bottom corner of this page.
*Make sure that entire content of cells is visible and spreadsheet fits on a single page. Modify margins and/or layout if needed.
*Print the worksheet, formulas and two charts.
ABCDE1Quarterly BudgetJanuary through March‐Prepared by (your name here )(today's date here )2345ItemJanuaryFebruaryMarchQuarter Total67REVENUE8Sales Revenue$232,897.95$432,989.76$765,998.61(1)9Other Revenue$1,232.93$3,265.81$2,145.99(1)1011Total Revenue(2)(2)(2)(2)1213EXPENSES14 Manufacturing(3)(3)(3)(6)15 Research(3)(3)(3)(6)16 MarkeTng(3)(3)(3)(6)17 AdministraTve(3)(3)(3)(6)18 Ful±llment(3)(3)(3)(6)1920Total Expenses(4)(4)(4)(4)2122Net Income(5)(5)(5)(5)2324Budget % Values:25 Manufacturing38%26 Research11%27 MarkeTng16%28 AdministraTve17%29 Ful±llment8%30Build the spreadsheet above and save ±le as Quarterly_Budget_ YourFirstName_YourLastName.xlsx. Enterall formulas ±rst then format.(1)Quarter total is the sum of January through March.(2)Write formula for B11 so it can be copied: ²otal Revenue is the sum of Sales and Other Revenue.(3)Write formula for B14 so it can be copied: Expenses are a percentage of total revenue. ²he budget percentvalues are located in rows 25 29. Be sure your formula uses these cell addresses.‐(4)Write formula for B20 so it can be copied: ²otal expenses are the sum of the department expenses.(5)Write formula for B22 so it can be copied: Net Income is total revenue minus total expenses.(6)Quaterly ²otal is a sum of January, February , and March for that row.Format all currency amounts with 2 decimals.Create an embedded pie chart ( as an object in this spreadsheet)which shows contribuTon of each type of anexpense into total expenses.Create a column chart as a new sheet to show ±rst quarter expenses by the type of expenses. Name the chart "FirstQuarter Expenses by the Expense ²ype" On the next line of the chart Ttle in smaller font put "Prepared byYourFirstName YourLastName".Create a column chart as a new sheet to show ±rst quarter expenses by month.Name the chart "First QuarterExpenses by Month" On the next line of the chart Ttle in smaller font put "Prepared by YourFirstName YourLastName".Insert right secTon footer with your name, date and ±le name, each on a separate line. Use font size 8. See sample atthe right bo³om corner of this page.Make sure that enTre content of cells is visible and spreadsheet ±ts on a single page.Modify margins and/or layout ifneeded.313233343536373839404142434445464748495051525354555657
Attachments: