1 / 63

Break-even Analysis Part 3 Constructing Graphs

Break-even Analysis Part 3 Constructing Graphs. To publish or not to publish...

lilka
Download Presentation

Break-even Analysis Part 3 Constructing Graphs

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Break-even Analysis Part 3 Constructing Graphs

  2. To publish or not to publish... The Babson Press must decide whether or not to publish a book. The estimated costs of publishing this book include a fixed cost (in leased equipment, rent, …) of $3,000 plus a variable cost (in materials, labor, …) of $10 for each copy printed. Projected sales figure suggest that the book can be sold at $16 per copy.Under what condition should they publish this book? Start with a problem to be formulated

  3. Using Chart Wizard start with a prepared worksheet NOTE: Refer to the Power Point Presentation Break Even Analysis - Part 1 - Constructing a Spreadsheet

  4. Using Chart Wizard select functions to be graphed NOTE: From this point on, the Excel window and only part of the spreadsheet will be displayed Highlight the cells E2:H23

  5. Using Chart Wizard initiate Chart Wizard Click on the Chart Wizard icon

  6. Using Chart Wizard initiate Chart Wizard NOTE: From this point on, only the Chart Wizard window will be displayed

  7. Using Chart Wizard Step 1: select chart’s type Make sure that the Standard Types tab is being displayed

  8. Using Chart Wizard Step 1: select chart’s type In the Chart type: box, click on XY (Scatter)

  9. Using Chart Wizard Step 1: select chart’s type On the Chart sub-type: area, click on the box displaying smooth curves

  10. Using Chart Wizard Step 1: select chart’s type Click on Next >

  11. Using Chart Wizard Step 2: set chart’s source data Accept the defaults by clicking on Next >

  12. Using Chart Wizard Step 3: set chart’s options Make sure that the Titles tab is being displayed

  13. Using Chart Wizard Step 3: set chart’s options Click on Chart title: box and type Break Even Analysis

  14. Using Chart Wizard Step 3: set chart’s options NOTE: The title is displayed on the chart

  15. Using Chart Wizard Step 3: set chart’s options Click on Value (X) Axis box and type quantity

  16. Using Chart Wizard Step 3: set chart’s options NOTE: The horizontal axis is labeled

  17. Using Chart Wizard Step 3: set chart’s options Click on Next >

  18. Using Chart Wizard Step 4: set chart’s location Accept the default (the chart will appear on your worksheet) and click on Finish

  19. Using Chart Wizard format the legend Right-click on the legend box

  20. Using Chart Wizard format the legend Click on Format Legend...

  21. Using Chart Wizard format the legend Click on the Placement tab

  22. Using Chart Wizard format the legend Click on the Top option

  23. Using Chart Wizard format the legend Click OK

  24. Using Chart Wizard format the legend NOTE: The legend now appears at the top

  25. Using Chart Wizard format the horizontal axis Click anywhere on the gray area, on or below the horizontal axis

  26. Using Chart Wizard format the horizontal axis Click on Format Axis...

  27. Using Chart Wizard format the horizontal axis Click on the Font tab

  28. Using Chart Wizard format the horizontal axis Highlight the Size: box

  29. Using Chart Wizard format the horizontal axis Type 7

  30. Using Chart Wizard format the horizontal axis Click OK

  31. Using Chart Wizard format the horizontal axis NOTE: The font for the horizontal axis now appears smaller (7pt)

  32. Using Chart Wizard format the vertical axis Right-click anywhere on the white area, on or to the left of the vertical axis

  33. Using Chart Wizard format the vertical axis Click on Format Axis...

  34. Using Chart Wizard format the vertical axis NOTE: Make sure that the Font tab is being displayed

  35. Using Chart Wizard format the vertical axis Highlight the Size: box

  36. Using Chart Wizard format the vertical axis Type 7

  37. Using Chart Wizard format the vertical axis Click on the Number tab

  38. Using Chart Wizard format the vertical axis Click on the Currency option

  39. Using Chart Wizard format the vertical axis Click on  twice to bring the number of decimal places to 0

  40. Using Chart Wizard format the vertical axis Click OK

  41. Using Chart Wizard format the vertical axis NOTE: The font for the vertical axis now appears smaller (7pt) with $ signs

  42. Using Chart Wizard change the color of profit function graph Right-click anywhere on yellow line

  43. Using Chart Wizard change the color of profit function graph Click on Format Data Series...

  44. Using Chart Wizard change the color of profit function graph NOTE: Make sure that the Patterns tab is being displayed

  45. Using Chart Wizard change the color of profit function graph Click on the in the Color: option

  46. Using Chart Wizard change the color of profit function graph Click on the selected color

  47. Using Chart Wizard change the color of profit function graph Click on OK

  48. Using Chart Wizard change the color of profit function graph NOTE: The profit function line is now colored green

  49. Using Chart Wizard change background color Right-click anywhere on the gray area, above the horizontal axis

  50. Using Chart Wizard change background color Click on Format Plot Area...

More Related