Select the drive and folder you want to save your work in by using the pull-down menu at the top of the "Save as" dialog box that appears after you choose "Save as." Enter a file name in the bottom text box. Plan to reduce variable costs such as advertising, or look for less expensive ways to deliver your product to your consumer, if you need to lower your break-even price.Ĭlick the "File" menu at the top of your template, then choose "Save as" from the options to save your work.
Look to reduce your costs if the price you need to charge to cover all expenses is higher than the typical price for similar goods or services. Keep an eye on the results in the shaded boxes and the bars or lines of your graph, which should change. Type the requested data in the unshaded, empty cells next to their descriptions, such as the price you plan to charge for one unit of your product or service in the cell to the right of the cell labeled "Price per unit " the number of units in the cell to the right of the cell labeled "Number of units sold " and your fixed and variable costs in their respective cells. Locate the rows and columns of cells at the top of the template, below the title and instructions. Click on the file icon or launch Excel to open the template. Note that it is saved under a file name that includes a string of letters and numbers such as "TSI01877515" for the chart-only Excel 2007 template. Locate the template in your downloaded files.
Click on "Download" again if prompted to do so in the next window. Note that the Excel 2007 templates are compatible with Excel 2010.Ĭlick the "Agree" button to agree to the terms of use as soon as the agreement window appears. Choose between chart-only and chart-and-analysis versions for either Excel 2003 or Excel 2007. Click the word "download" under the icon that corresponds to the template that best suits you and is compatible with your version of Excel.
0 kommentar(er)
