(925) 484-0620 | (617) 325-2600 info@franklinmgmt.com

A great way to start the new year is to get clear on exactly how you can make your revenue goal number. A revenue plan is the perfect tool. You’ll need to be proficient in Excel, and if not, you can work with your accountant on this very important and enlightening spreadsheet.

Start by listing all of your products and services, listing one product or service in each row of a blank spreadsheet.  Enter the description in the first column and use the second column for price. You may be able to export an item list from your accounting system, which will save a lot of time if you have a lot of products and services that you sell.

Use column three to enter the number of items you want to sell for the year. Column four should contain formulas to multiply the price by the volume to get revenue for each service and product you sell.

You can then sum the numbers in column four to generate your projected revenue for the year.

Getting Industry-Specific

Depending on what industry you’re in, you may need to make some adjustments to the above simplified revenue plan. If you work in construction, you’ll need to list your projects instead of products and services, and you’ll need to make adjustments if your project will go longer than one year. You’ll need to add a couple of extra column to determine the percentage of the project that will be complete and billable in 2015.

If you bill by the hour, you’ll need to calculate how many hours of service you’ll be able to charge for and factor that into the equation.

If you have sales, you’ll need to figure a discounted price. I recommend you have an extra line for each product that sells at a discount and allocate the total amount you plan to sell at each price. If that’s too much work, you can calculate an overall discount rate and apply it to total revenue at the bottom of the worksheet.

Use the 80-20 Rule

If you sell a lot of products and services, consider bundling them into subgroups to keep your plan cleaner and at a higher level. Spend only the amount of time that’s worth the insights you’ll gain from doing an exercise like this.

A Prosperous New Year

Once you’ve created the plan, you can now take action based on insights you’ve gained. Perhaps you’ve got a whole new set of revenue resolutions to accomplish in 2015. If you need help constructing or analyzing this plan, feel free to reach out to us and let us know how we can help.