View Single Post
Old July 13, 2013, 04:35 PM   #88
Lost Sheep
Senior Member
 
Join Date: January 24, 2009
Location: Anchorage Alaska
Posts: 2,965
Here's a spreadsheet for you

Kilimanjaro,

Does your spreadsheet allow for the calculation of break-even point and include your time and your time to learn to load? (I have not yet added in a calculation to add the rental value of the space required for the loading room, as I don't have dedicated square footage.) (I also have not added in the cost of the gun required to shoot my loaded ammo, as that seems as silly as putting the cart before the horse.)

What do you think of these formulas?
Copy/paste into a spreadsheet starting at A1.)

350
140
35
28
6
0
20
10
10
0
25
50
<
100
<
=A14*(A2/1000+A3/1000+A4/(7000/(A5/(1-A6)))+A7/100/A8)
=+A16/A14
=+A11/A12-A17
=1000/A9*A18
=(A1+A10*A19)/A18
=+A20/1000*A9

and this at B1


Cost of the loading tools
Bullets (per thousand)
Primers (per thousand)
Powder (per lb)
load (grains per round)
spillage/shrinkage (I guess at 0% unless specified otherwise)
Brass (per hundred)
# of times each case is used (account for loss in this estimate. If Brass cost is zero, use 1)
Time required to load 1000 rounds. Include EVERYTHING. Picking up, cleaning, sorting, inspecting, filling primer tubes, etc.
Initial time learning to load
Cost per box for purchased ammuntion
Rounds per box referred to above
<
Incremental round count (50, 10, 20, 100: your typical production batch)
<
(Calculated) Cost per increment loaded
(Calculated) Cost per round
(Calculated) Savings per round
(Calculated) savings per hour. Your "wage" if you choose to see it that way.
(Calculated) Your breakeven point, in rounds produced
(Calculated) Your breakeven point, in hours


Anyone else with comments, please feel free to weigh in, but please, PLEASE, do not address the wisdom or folly of counting time spent enjoying a hobby. Please start another thread for that discussion.

Lost Sheep

Last edited by Lost Sheep; July 13, 2013 at 04:42 PM.
Lost Sheep is offline  
 
Page generated in 0.04962 seconds with 7 queries