Category Archives: BIS 122 WEEK 3 Business Budget

BIS 122 WEEK 3 Business Budget

BIS 122 WEEK 3 Business Budget

 

 

Buy Solutions: https://goo.gl/369wfa

BIS 122 WEEK 3 Business Budget

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: $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. Use the Freeze option to freeze the top panes. Create a pie chart for your business income and spending. Provide at least three references, depending how you write your paper, you might require more, which one must be the text and a credible Internet source and a peer reviewed library reference. Format your paper  consistent with the University 6th edition APA guidelines located in the Center For Writing Excellence. Use the APA sample paper as a guide. Be sure to add a separate title and reference page Save this document as Lastname_BusinessBudget_W3.xls Click the Assignment Files tab to submit your assignment.

BIS 122 WEEK 3 Business Budget

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: $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. Use the Freeze option to freeze the top panes. Create a pie chart for your business income and spending. Provide at least three references, depending how you write your paper, you might require more, which one must be the text and a credible Internet source and a peer reviewed library reference. Format your paper  consistent with the University 6th edition APA guidelines located in the Center For Writing Excellence. Use the APA sample paper as a guide. Be sure to add a separate title and reference page Save this document as Lastname_BusinessBudget_W3.xls Click the Assignment Files tab to submit your assignment.

BIS 122 WEEK 3 Business Budget

 

Advertisements