Business Budget

Business Budget Grading Guide BIS/221 Version 3

1

Copyright © 2015 by University of Phoenix. All rights reserved.

Individual Assignment: Business Budget

Assignment Description

The Business Budget assignment is designed to you the opportunity to use Microsoft ® Excel® by providing a

scenario that illustrates specific and realistic uses for the information such as the SUM function, cells, and freezing. Create a business budget sheet using Microsoft® Excel®. In the budget sheet, do the following:

 Create a label called "Income" and add your monthly business income in the next cell: $25,000.

 Add a label called "Rent" and enter the amount in the next cell: -$4,000.

 Add a label called "Utilities" and add the amount in the next cell: -$2,000.

 Add a label called "Insurance" and add the amount in the next cell: -$500.

 Add a label called "Product Development" and add the amount in the next cell: -$6,000.

 Add a label called "Advertising" and add the amount in the next cell: -$2,000.

 Add a label called "Customer Support" and add the amount in the next cell -$3,000

 Use the SUM function to calculate the total for all the cells.

 Use the Freeze option to freeze the top panes. Create a pie chart for your business income and spending. Save this document as Lastname_BusinessBudget_W3.xls

Grading Rubric

Content 70 Percent

Points Available

Points Earned

Comments:

The spreadsheet includes a cell labeled “Income” and a cell next to it with the amount: $25000.

5

The spreadsheet includes a cell labeled “Rent” and a cell next to it with the amount: -$4000.

5

The spreadsheet includes a cell labeled “Utilities” and a cell next to it with the amount: -$2000.

5

The spreadsheet includes a cell labeled “Insurance” and a cell next to it with the amount: -$500.

5

The spreadsheet includes a cell labeled “Product Development” and a cell next to it with the amount: -$6000.

5

The spreadsheet includes a cell labeled “Advertising” and a cell next to it with the amount: -$2000.

5

The spreadsheet includes a cell labeled “Customer Support” and a cell next to it with the amount: -$3000.

5

Business Budget Grading Guide BIS/221 Version 3

2

Copyright © 2015 by University of Phoenix. All rights reserved.

The SUM function is applied correctly and the amount reflected should be $7500. 15

The spreadsheet has the Freeze option applied correctly to the top panes. 5

The spreadsheet includes a pie chart for the income and spending that correctly reflects the figures entered.

15

The spreadsheet is saved using the following naming format: Lastname_BusinessBudget_W3.xls

3

The spreadsheet is created using Microsoft® Excel® in the correct format. 2

Total Available

Total Earned

75

Assignment Total 75