Overhead allocation using ABC

Allocations. Clavier

CIMA Official Terminology describes activity-based costing as an approach to the costing and monitoring of activities, which involves tracing resource consumption and costing final outputs. Resources are assigned to activities and activities to cost objects. The latter use cost drivers to attach activity costs to outputs.

ABC

What are Activity Pools and Cost Drivers?

Activity Pools

  • Purchase Orders
  • Machine Set Ups
  • Packaging

Cost Drivers

  • Number of Purchase Orders
  • Number of Machine Set Ups
  • Number of items to package

What would the traditional methods of allocation have been?

  • Direct Labour Hours
  • Machine Hours
  • Floor Area

Using Activity Based Costing can produce very different results to Traditional Methods, click here for an example

steve@bicknells.net

Sales Forecasting using Weighted Averages

Profitability

For project based businesses you need to understand the sales pipeline inorder to produce a forecast, a typical sales pipeline looks like this:

  1. Prospects and Leads
  2. Qualified Opportunities
  3. Visits/Meetings
  4. Proposals
  5. Revised Proposals
  6. Sales

In many cases larger contracts require a Prequalification Questionnaire (PQQ) and Tender.

If you want to forecast Sales you have to start by recording the volume of activity at each stage of the pipeline and your success rate at each stage.

Sales is all about activity, the more Prospects you can find the more Sales will be achieved.

Finding propects will be different for every organisation but Social Media and Linked In are increasing being used to find Prospects.

To prepare a Weighted Average forecast you simply use you success ratios and apply them to each stage of the process, so for example if you win 1 in 3 proposals that means you need 3 proposals to get one sale.

You can use this approach to set targets for your sales team.

On submitted proposals you can also apply a probability of success assessed by your sales team.

The key to Sales is to Always Be Closing!

steve@bicknells.net