Project #105766 - Buisness Budget

Create a business budget sheet using Microsoft® Excel®. NO TEMPLATES ALLOWED!  Please develop the spreadsheet yourself from scratch.  In the budget sheet do the following:

  • Create a label called "Income" and add your monthly business income in the next cell: $42000.
  • Add a label called "Rent" and enter the amount in the next cell: -$2000.
  • Add a label called "Product Spending" and enter the amount in the next cell: -$20000.
  • Add a label called "Gas" and add the amount in the next cell: -$250.
  • Add a label called "Car Payment" and add the amount in the next cell: -$500.
  • Add a label called "Electric" and add the amount in the next cell: -$600.
  • Add a label called "Insurance" and add the amount in the next cell: -$500.

Use the SUM function to calculate the total for all the cells. This cell MUST contain a formula, not a typed-in number.

Something like the following sample (feel free to "pretty it up" as needed, so it has a good, clear design):

Income

$42,000

Rent

-$2,000

Product Spending

-$20,000

Gas

-$250

Car Payment

-$500

Electric

-$600

Insurance

-$500

 

-------

TOTAL

$xx,xxx

Use the Freeze option to freeze the top panes.

Create a pie chart for your business income and spending, together.

Save this document as Lastname_BusinessBudget_W3.xls (or .xlsx)

Click the Assignment Files tab to submit your assignment.

Grading rubric. Your work will be evaluated through the following rubric (I reserve the right to make some minor adjustments to it.)

Detailed Evaluation Max
Correct data (as indicated in the requirements) 0.5
SUM function is applied correctly ($18150) 3.0
Freeze option applied correctly to top panes 2.0
Pie chart for the income and spending 3.0
Good spreadsheet design 1.5
Sub-Total: 10.0
 

Subject Business
Due By (Pacific Time) 02/08/2016 02:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy