HomeОбразованиеRelated VideosMore From: Ian Johnson

Manufacturer Price Sheet: Material, Labor, Overhead & Profit

192 ratings | 33767 views
The following video breaks down how a manufacturer should come up with a price for industrial finished goods. First, the company must account for its material costs and apply a 5 percent indirect cost to that portion of the manufacturer's price sheet. This 5 percent is meant to offset overruns in production and or additional costs of financing inventory and material purchases. Second, the company must account for its labor relative to each operation performed to turn a raw material into a finished good. The calculation involves defining the operation and applying the labor cost to both the setup time in manufacturing and the actual run time. Third, all labor costs are added in order to come up with a complete total for all the costs of manufacturing a given product. Those costs are then followed up by the company's overhead, which is calculated by taking its indirect expenses divided by its direct expenses. Indirect expenses are those expenses that are in addition to the the costs needed to produce a part. Direct expenses are exactly that. These include the costs involved or expenses involved in manufacturing the part. Finally, the company adds its mark-up in order to secure a profit on the sale. Profit is critical because it helps to fund the company's pursuit of new product introductions and secure its long-term future. Here is a sample of the Manufacturer Price Sheet in Excel Format http://www.driveyoursuccess.com Video explains how to price a product with direct material, labor, overhead and profit
Html code for embedding videos on your blog
Text Comments (11)
Zulqarnain yousuf (2 months ago)
Sir by the increment in factory overhead does inventory turn over ratio increase??? In one of the case it is increasing can you explain me how it is increasing?
Andres Giron (3 months ago)
Thank you Ian for the clear explanation, really good video - The material cost is $768.6 = (732*1.05) - The formula for Labor cost in the spreadsheet is multiplying setup and run time cost (it should be added), that's why the cost of 45 mins is higher than 1 hour. (=($C17/60)*($E17)+($D17/60*$E17))
Ian Johnson (2 months ago)
Great Point Andres. Take care
Jonathan Miranda (10 months ago)
Where can I find the example sheet. Did he take it down?
Ian Johnson (10 months ago)
Hi Jonathan - go to http://www.driveyoursuccess.com/2011/07/determining-hourly-rates-for-a-contractor-or-small-business.html
My calcs show... 1. Total Material = $732 + 5% = $768.60...? 2. Labour times - how does 45 minutes of labour - (set up of 10 mins and run time of 35 = total 45 mins...) at $20 per hour equal $38.89...? Should be $15.00...???
toh04 (10 months ago)
I’m in the same boat I’m so confused how he got $38.89 when it should be $15.00 for 45 mins of work at $20.00 an hour. I’m not great at math but his calculations are confusing me even more.
Tyra Daley (1 year ago)
It is incorrect
Ali Akl (2 years ago)
very useful
Ian Johnson (2 years ago)
Thank you Ali.
Manoj kumar (4 years ago)
Mr. Ian Johnson. Really appreciate your effort! Thanks a lot.  Setup Cost and Run Cost should be added or multiplied? (In your example sheet, you have multiplied)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.