# 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.

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
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews