Now you have all the component costs, labor costs, capital costs and indirect costs (non-direct labor and consumables). This provides the cost accounting group with everything they need to produce a simple financial model that will give you a high level picture of the project. It is not the final analysis, but the first analysis that will tell you whether you should look deeper or not. If the analysis looks favorable you will look deeper, if you will look elsewhere for savings.
The financial models we have used are a set of nested spreadsheets. Below is a gross oversimplification of a typical analysis, but demonstrate the principle.
Compound(or formula) cost spreadsheet. The compounding operation takes 2 laborers so you spread those costs across the total product of compound. For example you will produce 1MM kg of compounds with 2 laborers( $100K) so the labor costs are $0.10/kg. This spreadsheet feeds to SKU spreadsheet. Cost accounting should also add anyother know variable overhead.
SKU spreadsheet includes amount of compound needed per SKU, the package and closure, carton, pallet, etc. The remaining 4 laborer cost are spread over the unit volume as appropriate for each package type/size. The $50K is consumables is spread appropriately where it belongs. Every piece that going into the product as a palletized, shrinkwrapped pallet in your warehouse. Again,variable overhead should also be added.You now have a total unit cost to compare to your out-sourced, or purchased complete cost. This will feed the spreadsheet that will generate the cost saving for that particular SKU.
You have a total cost for the SKU both in-sourced and out-sourced and know the volume of that SKU. This generates a savings number for that SKU. You do this for two compounds (formula) and 6 different SKUs of two different package type. Package type A is 7% cheaper to produce in-house, and package type B is 10% cheaper to produce in-house. This feed the spreadsheet for the entire product line.
This is where the assumed proportionality is used.You sell $5MM of package type A and $5MM of package type B for a savings of $350K and $500K respectively for a total on $850K annual savings.
The next part vary depending on how your finance group handles thing, but in general a 2 year or less payback is consider acceptable. So we have $850K savings and $850K capital for a 1 year payback. If it is looked at on an after tax basis and you are in a 50% tax bracket( if there is such a thing), you would have a two year payback.
Looks like any interesting project- requires a more in-depth analysis. This analysis should be able to be completed by an experienced and committed group in 1-2 months. The assumed proportionality takes a huge amount of time and detail out of the process. It is also where the anal retentive will have the most difficulty.The purpose of this analysis is not to provide the last analysis, but a quick and reliable way to get a big picture view of a project.
How detailed the final analysis will be up to the you.
At this point, you will invariably have some SKUs that didn’t fit into the model. Different package type that you will not be capable of filling, or compound (formula) of such low volume that you will not be making them. The next part will try to deal with what is left.