You can use the sales forecasting starter workbook, as shown in Figures 12-1 and 12-2, to construct sales forecast schedules for each product or service for which you want to estimate sales and production activity separately. This starter workbook provides a framework for the development of your own … [Read more...] about Using the Sales Forecasting Starter Workbook

# Using Excel

## Charting Profit Volume Analysis Data

Two charts are included with the starter workbook let you look at the results of your profit volume analysis graphically. The first chart shows the revenues, costs, and profits at various revenue levels. The second shows the revenues plotted against the total fixed and variable costs; the point at … [Read more...] about Charting Profit Volume Analysis Data

## Customizing the Profit Volume Starter Workbook

You can use the profit volume and break-even analysis starter workbook for testing the sensitivity of your costs and profits to changes in revenues and for calculating your break-even point. However, you probably want to change the workbook so that it more closely matches your requirements. For … [Read more...] about Customizing the Profit Volume Starter Workbook

## Understanding the Profit Volume Analysis Starter Workbook’s Calculations

The profit volume and break-even analysis starter workbook has six parts: the Profit Vol- ume Inputs box and the Break-Even Analysis Forecast (shown in Figure 11-1), the Profit Volume Forecast (shown in Figure 11-2), the Common Size Profit Volume Forecast (shown in Figure 11-3), and the Profit … [Read more...] about Understanding the Profit Volume Analysis Starter Workbook’s Calculations

## Using the Profit Volume and Break-Even Analysis Starter Workbook

You can use the profit volume and break-even analysis starter workbook (PROFITVOL), shown in Figures 11-1 through 11-4, to test the effect of changing revenues on business profits. To complete the schedule, you define the following: Revenue variables, including the unit sales price, the low … [Read more...] about Using the Profit Volume and Break-Even Analysis Starter Workbook

## Easy Refresher: Profit Volume and Break-Even Analysis

Profit volume analysis, sometimes called cost-profit-volume analysis, is the process of calcu- lating the profits of a business at different volumes, or revenue levels. Break-even analysis, a component of profit volume analysis, is simply the calculation of the revenue level at which a business … [Read more...] about Easy Refresher: Profit Volume and Break-Even Analysis