Tuesday, 2 February 2016

Labour Efficiency Formula

Labour Efficiency Formula

Labour efficiency formula is given below. Labour efficiency formula has been explained with a simple example.

Labour Efficiency Ratio =   Expected Labour Time.   X 100
                                             Actual Labour Time


Labour Efficiency Formula Example


Unit Labour Hours = 10 Hours
Total unit produced =500 units
Actual Hours Spent = 4000 Hour

Solution

In first place, Standard hour is to be calculated and then with help of standard hours, we would calculate labour efficiency

1.    Standard Hours Calculation


Standard hours = 500 unit x 10 hr= 5,000 hrs

2.    Labour Efficiency Calculation


Labour Efficiency Ratio =   Expected Time.   X 100
                                        Actual Time
5000/4800 x 100
= 125% (Labour efficiency)

Technically 125% efficiency ratio means that efficiency has been 25% above the standard efficiency.

Significance of Labour Efficiency


Labour efficiency ratio information shows employee performance or efficiency during the production process. If expected time is more than actual time, it means Labour performance has been better than standard, otherwise performance is regarded below expectation. Labour efficiency information can be used by the management for employee’s performance evaluation and reward announcement.

Relationship between Labour Time and Efficiency Ratio


The relationship between expected time and actual for efficiency calculation has been shown mathematically.

Expected Time > Actual Time (Efficiency would be more than 100%)
Expected Time < Actual Time (Efficiency would be less than 100%)


Monday, 1 February 2016

Overtime Premium Rate Formula

Overtime Premium Rate Formula


Formula for overtime premium rate has been given below. This formula has been elaborated with different examples.

Overtime Premium Rate =Basic Rate (1+ % of basic Rate)


Overtime Premium Rate Formula Example


Basic Rate= 12 $
Premium Rate @ 60% of basic Rate
Calculate overtime premium rate & amount for 10 Hours

Solution

Overtime Premium Rate=Basic Rate (1+ % of basic Rate)

 12 (1+ 60%)
= 19.2 $ (Rate of overtime Premium)

Amount of overtime = Hr x overtime rate

= 10 Hrs x 19.2
=192 (Amount of overtime)


Overtime Premium Rate (Based on Labour Hour Rate)

Overtime premium rate may be calculated on the bases of basic hour rate of labour, alternatively premium rate can be calculated on the basic rate offered on output or unit produced. Concept of Overtime rate based on basic labour hour has been explained with an example (Above).

Overtime Premium Rate (Based on Unit Produced)

Overtime premium rate may also be calculated on the bases of unit produced. Concept is same as explained above; however, this time premium rate is calculated on the bases of basic rate of unit produced. Concept of overtime premium rate bases on unit produced has been explained with below example.

Example


Unit Produced = 100
Rate = $ 5
More than 100 unit rate is 40% of basic rate

Solution


Premium Rate= $ 5 (1+40%)
=7
Basic 100 units @ 5= 500
Premium Rate 20 @ 7 = 140
Total Labour cost (500+140) = 640

Reason for using Overtime Premium Rate

Reason for using premium rate for overtime is very logical, because labour would only work for more hours, if labour is offered some lucrative rate i.e. (Premium Rate), otherwise labour would prefer to utilize his time in other activities. (Rest, social engagements, playing games)

Overtime Premium Rate Considerations

Premium rate should be clearly define and offered for the labour, labour cost should remain within range, and similarly premium rate should be acceptable for labour to work more. Therefore a well calculated and balanced rate should be offered.


Labour Efficiency Formula
Labour Rate Variance Formula
Labour Piecework Payment Formula
Unit Labour Hours Formula 
Labour Saved Formula
Labour Capacity Utilization Formula

    Unit Labour Rate Formula

    Unit Labour Rate Formula

    Formula for unit labour hours is given below. Unit labour Hours can be calculated with simple equation. This formula or equation has been explained with two simple examples


    Unit Labour Rate Formula   =  Number of Labour Hours  
                                                  Number of Unit Produced


    Sometime this simple formula becomes huge problem in exam or otherwise. Unit labour hour simply means the labour hour taken to produce single unit. This equation is quite straight forward , when one unit take more than one hour. However, in case of more unit produced by the labour in one hour, then unit labour hour calculation may be tricky.

    Unit Labour Rate Formula Example (More units in one Hour)


    Unit produced in one Hour = 4
    Calculate unit labour hour?

    Solution


    = ¼
    = .25 Hours

    It is to be noted that, when more unit are being produced in one hour, it means the unit labour hour would be less than one. We can check the unit labour hour in above example i.e. .25 Hours.

    Unit Labour Rate Formula Example ( More Hours for Single unit)


    5 hour Taken for single unit
    Calculate unit labour hour?

    Solution

    5/1

    Labour Hours Saved Formula

    Labour Hours Saved Formula


    Formula for labour hours saved has been shown below. This formula has been explained with different simple examples. 
                                 

    Expected Hours > Actual Hours

    Labour Hours Saved is a situation, where total labour hour spent is less than standard hour allocated for a work.  This concept has been explained by simple example below;

    Labour Hours Saved Formula Example


    Single Unit Production Hours = 6 Hrs
    Total Unit Produced             = 4000
    Total Actual Labour Hours    = 20,000

    Calculate Labour Hours Saved?

    Solution

    In first step, we would calculate the expected hours and then we would calculate the labour hours saved.

    1.    Expected Hours Calculation

    Expected Hours (Standard Hours) = Units Produced x Hour required per unit

    =4000 x6
    = 24,000

    2.    Labour Hours Saved Calculation


    Actual Labour Hours Taken or Spent= 20,000
    Hour saved= Standard Hours – Actual Hours
    = 24,000-20,000
    =4000 Hours Saved

    Significance of Labour Hours Saved Calculation


    Labour hour saved provides useful information to the management about the labour efficiency or performance. Such information can be used by the management for performance evaluation and reward announcement.

    Labour Hour Saved and Cost Reduction


    Labour hour saved technically means the labour cost saved. This explanation stands correct both for a single project or multiple projects undertaken by the company. Cost saving concept has been explained with two examples.

    Example 2 (Labour Cost Saved for Single Project)


    A project expected labour utilization 20 hours and actually labour taken 15 hour. Standard Labour rate was $ 10. Calculate labour hour and cost saved.

    Solution


    Expected Cost 20 Hr x 10 Rate = 200
    Actual Cost 15 Hrs x 10 Rate = 150
    Labour Hours Saved (Expected hour-Actual Hrs) = 20-15 = 5 Hrs
    Labour cost Saved = 5 Hrs x 10 Rate = 50

    Example 3 (Labour Cost Saved for Multiple Projects)


    Company has two projects A and B. Labour required for each project is 20 hours. Rate is 10. First project actually took 10 hour, while second project took 20 hr. Calculate the Labour hour & cost saved by the company.

    Solution

    1.    Expected Cost


    Standard Cost of Project A = 20 x 10 = 200
    Standard Cost of Project B= 20 x 10 = 200

    Total Standard cost or expected cost = 400

    2.    Actual Cost

    Actual Cost = 10 x10 = 100
    Actual Cost = 20 x10 = 200

    Total cost = 300
    Total Saved Cost = 400-300

    Labour Capacity Utilization Formula

    Labour Capacity Utilization Formula

    Labour Capacity Utilization formula has been shown below. Labour capacity utilization formula has been further explained with simple example. Labour Capacity utilization ratio mainly focuses on the actual utilization of available resources.


    Labour Capacity Formula =   Labour Hour Spent    x 100
                                              Total Available Hour
                             


    Labour Capacity Utilization Formula Example

    Total Labour Hours available = 1500
    Actual Hour utilized or spent = 1200
    Calculate Labour Capacity

    Solution


    Labour Capacity utilized =   Hour Spent by Labour   x 100
                                             Total Available hour
    = (1200/1500) x 100
    =  80%

      80% of total capacity utilized, it means that 20% capacity is idle.

    Significance of Capacity Utilization Calculation

    One of the main reasons for calculating labour capacity utilization is to get information about the capacity utilized and idle Capacity or extra Labour resources. This information can be utilized for the following purposes;

    1.   Resource Allocation

    Idle resources or capacity can be utilized in another project or activity. Effective utilization will improve the profitability of the organization. Thus capacity utilization information may be used to improve the profitability of the organization.

    2.   Cost Reduction

    Idle labour resources or capacity may be terminated, if there is no alternate use or immediate future need of such resource. This will reduce labour cost of the company and this reduction in labour cost will improve the profitability of the organization.

    3.   Future Resource Planning

    Capacity utilization ratio information can be utilized by the management for future resource planning. Management can plan and budget the resource more effectively.


    Capacity Utilization and Efficiency

    It is important to mention that capacity utilization and labour efficiency has no relationship, it means that capacity utilization ratio does not tell anything about the labor efficiency or performance; rather capacity utilization just focuses on utilization of resources or capacity.

    Labour Capacity Utilization Formula Practice Question


    Total Labour Hours available = 1800
    Actual Hour utilized or spent = 1600
    Calculate Labour Capacity

    Friday, 22 January 2016

    Tableau Desktop 9.3 Version Highlights and Features


    Tableau Desktop 9.3 Highlights
    • Unions: For Excel and text-based data sources, you can now combine tables of data by appending values (rows) from one table to another.
    • Updates to level of detail expressions and forecasting make it easier for you to answer more questions and explore new scenarios.
    • New maps data, including postal codes for 42 European countries, helps you conduct your geographical analysis with less effort and the most current information.
    • Tableau Desktop stays connected to the last server you were signed into. This feature makes it easier for you to share and collaborate when you’re working with Tableau Desktop and Tableau Server or Tableau Online.
    • Find the right content more quickly now that content analytics and enhanced search capabilities are available in Tableau Server and Tableau Online.
    • Use revision history to restore previous versions of a published workbook.
    • Ensure server availability and optimize performance with new server monitoring and configuration features.
    • Experience faster viz and dashboard load times with 9.3 performance enhancements.

    Tuesday, 5 January 2016

    It’s happening again: Big Manufacturers Tightening Up their Supply Chain

    It’s happening again:  Big Manufacturers Tightening Up their Supply Chain

    Over the past several years Mega-Manufacturers have settled on a strategy to sustain
    profitability in a slow growth economy: Tighten up their supply chain.  To the unaware, this sounds like a solid strategy.  Improving the flow of goods, creating more symbiotic relationships with those providing services, eliminating waste, streamlining, re-engineering and a tassel of other business buzz words, all resonate with Wall Street types. 

    Distributors have been through this a couple of times before, but unfortunately a good many sales managers have forgotten the lessons.  Many of our Millennial-generation sellers were still in school.  But, this is another page from the playbook of previous recessions.  Recalling the pain of the mid-90s, 2001-2002 and the Great Recession, allow me to review.

    Our largest customers jauntily inform us they “love” doing business with us.  They want to formalize our partnership and do more to strengthen the ties.  Mostly, it’s a love-fest.   Midway through the conversation, the kind words turn sour.  Being a partner requires efficiency, effectiveness and lower supply costs for the customer.  If you worked with anyone in the Automotive sector back in the 90s, you heard the pitch followed by a directive to immediately drop prices by five percent.

    After a three-year reprieve, the practice is back in play.  Here are a couple of examples:

    In April 2015, Business Day ran an article outlining the new strategy of delayed payment.  Here’s a juicy tidbit: 
    “Adopting a tactic widely used by 3G Capital, the Brazilian private investment group behind the recent merger of Heinz and Kraft Foods, a growing number of the world’s largest food and packaged goods companies are asking their suppliers to give them as much as four months to pay their bills — even though they typically require payment from their own customers in 30 days.”

    That’s right, suppliers to these very large companies now get to provide banking services.  Typically, distributors expect payment in 30 days.  Part of the wholesale distribution model takes advantage of a “float” period; the time between when the distributor sells the product and when the distributor must pay their supplier.  Getting paid in 120 days interferes with the balance.

    In December (2015), The Wall Street Journal ran an article which was later picked up by other publications.  Quoting from “The StrategicSourceror” a blog dedicated to “articles in business topics surrounding strategic sourcing, supply chain, procurement, purchasing and spend management:”
    “Due to a slow economic growth, manufacturers are tasked with re-strategizing supply chain operations to increase profit margins and reduce costs, the Wall Street Journal indicated.”

    And this little gem…
    "The weak link in our whole manufacturing process remains the supply chain… As good as our factories can be, if you have a crappy supplier, it doesn't matter. You need all the parts."

    Distributors and the Purchasing Teams face off
    Distributors will find themselves facing off in negotiations with some of their largest customers.  In many ways this is a combination of the strategies carried out during previous downturns.  Strangely, very few distributors have equipped their sales teams for the battle.

    Negotiations are going to be tricky and mean.  In some instance, the Purchasing Dude (or Dudette) will imply there is no option, our way or the highway.  Procurement teams will practice their lines.  Implications will be made:  Everybody provides the same stuff and exactly the same service as you.  Or my perennial favorite, suppliers like you are a dime a dozen, say no and we’ll just go down to the mission and pick up another. 

    What should you be doing?
    Don’t wait till you hear the message from the customer.  Practice your value pitch now.  Train your salespeople on the unique stuff you provide and why it would be darned hard to replace at the customer.  Teach them to make conditional price concessions.  Stuff like, “I will give you a discount but if I do you will need to begin paying for my specialist’s time” or “If we provide you with the additional payment terms, what added business will you provide to me?” 

    At the very least, you need to get your team some negotiations training.   Last month we said, “Don’t send your sellers into a knife fight armed with a fingernail clipper.”  Read the article here.  In my opinion, this is not an optional investment. 

    Invest in a pricing process.  David Bauders and his team at Strategic Pricing Associates has a number of tools which will allow you to boost your margin.  Knowing what to negotiate on is critical.  Understanding which products have price sensitivity is golden.

    Finally….

    If you are running into some of these situations, shoot us an email.  You are not alone.  We will be happy to share some of our experiences in other industries and other parts of the country. 

    I recommend you look at this (just click):

    Strategic Pricing Associates Negotiation Workshop and Pricing Strategy Seminar