cocheese46
New Member
- Joined
- Jan 25, 2014
- Messages
- 1
Hello everyone. I am a medium skill peel user with Excel and having an incredibly hard time creating from scratch a labor savings calculator for a product that I sell.
The product has a premium price vs, its competition, but is 2-8 times faster which results in a labor savings. I am trying to break down the labor savings into terms of hours and as well as square feet. Here are some of the details I have been playing around with. As I want this to be customizable to incorporate different labor rates, different production speeds, etc I want to lock some cells, but leave others open for modification in the future as well.
Cost per bulk screw-x
Cost per collated screw-x
Cost per my product-x
Labor rate hour-x
Number of laborers-x
Number if hours worked per day-x
Rate of speed
Bulk-60 screws in 451 seconds
Collated screws-60 in 115 seconds
my product-60 in 51 seconds
(I want the production rates to be variable as well)
I then want to calculate at what point do they achieve an ROI for paying for the more expensive fastener.
In advance your help is appreciated.
The product has a premium price vs, its competition, but is 2-8 times faster which results in a labor savings. I am trying to break down the labor savings into terms of hours and as well as square feet. Here are some of the details I have been playing around with. As I want this to be customizable to incorporate different labor rates, different production speeds, etc I want to lock some cells, but leave others open for modification in the future as well.
Cost per bulk screw-x
Cost per collated screw-x
Cost per my product-x
Labor rate hour-x
Number of laborers-x
Number if hours worked per day-x
Rate of speed
Bulk-60 screws in 451 seconds
Collated screws-60 in 115 seconds
my product-60 in 51 seconds
(I want the production rates to be variable as well)
I then want to calculate at what point do they achieve an ROI for paying for the more expensive fastener.
In advance your help is appreciated.