MGM272

Business Applications of Technology

Assignment / Project   Number  08

Graphing: Line Graphs and Formulas 

How is this project graded?

This project, like the others, is graded on the basis of a maximum ten points.    

Remember that there are several goals for the project, including working with formulas, working with line graphs, and working with drawing objects.  

If you did not use formulas to create the table of data for the revenue, cost, and profit, or if there was no evidence that you did, or if your table was not sufficient, then you probably lost about four points.

If your graph was not present you probably lost about five points.  If the graph was present, but faulty, then you probably lost less.  In particular, if you did not have quantity amounts on the X-axes, you lost two points. 

If you did not indicate the Breakeven Point with a both textbox and an arrow, you lost one point each. 

You needed to turn in the following to the instructor on the date this assignment was due (check the class schedule):
  1) PRINTOUT #1:  A printed copy of your spreadsheet, showing
      (A) the data: revenue, cost, and profit for various production levels (you pick the appropriate levels),
      (B) a single graph showing lines for the total revenue and total cost for various production levels, and
      (C) an arrow pointing to the breakeven point on the graph and a textbox which labels it.
  2) PRINTOUT #2:  A printed copy of your spreadsheet, showing showing the formulas on your sheet.
  3) DISK FILE:  A copy of the disk file on which you have saved your spreadsheet. 
       The name of the file on the disk should be "breakeven.xls"
       The label on the disk should have YOUR NAME, and the words:
       ASSIGNMENT #08 -- LINE GRAPH
  4) OTHER:  The above items are all that is required for this assignment.