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
Easy Refresher: Sales and Cost of Sales Forecasting
Sales forecasting is basic to any business plan or budget and to some investment analysis. Essentially, you need to collect information for, or make forecasts concerning, as many as five related variables. For example, you typically need to collect the units and dollars of inventory that you … [Read more...] about Easy Refresher: Sales and Cost of Sales Forecasting
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