Part 4  - Determine your Forecasted Monthly Sales in Units and in Dollars

The fourth part of the Sales Budget is to calculate your Unit Sales per Month and your Dollar Sales per Month. To determine the monthly unit sales, simply multiply your forecasted monthly sales percentages by your forecasted yearly unit sales. To determine the dollar sales per month, simply multiply your monthly unit sales by your selling price per unit (or weighted average selling price if you are selling more than one type of product). Murray would calculate his 200X monthly unit sales and monthly dollar sales in the following manner:

As shown in the above chart, Murray estimates to sell 720 diskettes in July (18% x 4000 units = 720 unit sales). As a result, Murray expects to have dollar sales of $18,720 in July ( 720 estimated unit sales in July x $26.00 selling price = $18,720). Also shown in the above chart, Murray estimates to sell 920 diskettes in August (23% x 4000 units = 920 unit sales). As a result, Murray expects to have dollar sales of $23,920 in August ( 920 estimated unit sales in July x $26.00 selling price = $23,920). And so on...

Now lets calculate Murray's 200Y Monthly Unit Sales and Monthly Dollar Sales. Recall from above, Murray expects his 200Y Forecasted Units Sales will be 8,000 diskettes and expects his 200Y Selling Price will be $24.00.

As shown in the above chart, Murray estimates to sell 960 diskettes in January, 200Y (12% x 8000 units = 960 unit sales). As a result, Murray expects to have dollar sales of $23,040 in January, 200Y (960 estimated unit sales in January x $24.00 forecasted selling price = $23,040). Also shown in the above chart, Murray estimates to sell 880 diskettes in February of 200Y (11% x 8000 units = 880 unit sales). As a result, Murray expects to have dollar sales of $21,120 in February (880 estimated unit sales in February x $24.00 selling price = $21,120).