SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 20 Dec 2017 My Price 10.00

Total Revenue is the sum of Sales and Other Revenue.

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.

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 20 Dec 2017 12:12 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)