Documents related to 'pareto analysis spreadsheet'
Order by:
Project reportMost businesses have a number of projects in progress at any time. When any project is large or important enough to have a major effect on the business's performance (profit or cash), there should be a separate report presented with the ... Read more
02 Jan 2013
Sales mix calculatorWhether your company sells products or provides services, your sales are unlikely to be comprised of a single line. It's more likely that the company sells a range of products or services and it's equally likely that the gross profi... Read more
02 Jan 2013
Evaluating the finance functionIf you've been asked to justify the number of staff in your accounts department and want to understand how much value they're adding, you'll need to record the time spent by your team on the different finance functions and... Read more
02 Jan 2013
Corporation Tax computationMost businesses show a monthly provision for Corporation Tax (CT). Usually this is calculated as a percentage of profit before tax (PBT). If you want a figure closer to what the actual tax charge might be, you'll need to mir... Read more
02 Jan 2013
Bank charges calculatorAs you don't get a bill from the bank manager for bank charges, they are often overlooked as a cost. What can you do to make sure you pay less?Carry out an annual bank charges audit You can carry out an annual bank charges aud... Read more
10 Dec 2012
Variance reportIf the financial results differ from that which was expected, it's important to present explanations as to why this has happened. However, it's often easy to assume a glib and sometimes convenient reason for these variances instead of re... Read more
02 Jan 2013
Scenario planning templatePredicting the future is never easy, and that's particularly the case when developing business plans. Budgets can become outdated or even an impediment to financial decision-making. How can you rise above this problem?Key var... Read more
10 Dec 2012
Premises move budgeting toolIf you've been asked to come up with a budget for the cost of physically moving the company, what should you include in it?Associated costsThe key to a successful move is meticulous planning and good communication with ever... Read more
02 Jan 2013
Target costing templateIn tough times, calculating your prices by adding a profit margin to cost can result in your products becoming uncompetitive. However, you might be able to beat your competition by using target costing to help set prices. What ... Read more
10 Dec 2012
Employee loan recordA taxable benefit may arise where a director or employee is provided with a loan, either interest free or at a favourable rate of interest. Use this document to calculate what, if anything, you need to declare to HMRC.Important to... Read more
29 Mar 2016
