Calculating Model Horse Body Costs

Because I use project costing to calculate COGS (Cost of Goods Sold) for the model horse customs, my micro-business is responsible for keeping track of the cost of the individual finished and average unfinished inventory costs.

Now that my first ‘body order’ has come in, it’s on to the fun part of breaking out how much of the invoice total is associated with each of the model horse bodies. For molds that have multiple base costs, I average them together instead of going through the headache of labeling each body.

January Body Box Order

The Order

This first order was a random collection of products that was based on a) what the vendor was looking to get rid of and b) what would fit in a $10 S&H box.

I normally do this to start out the year because it gives me an idea of what molds other buyers don’t want—and thus what molds other customers probably aren’t using.

Never hurts to stand out from the crowd! (Assuming the molds aren’t horrible to work with.)

The Breakdown

Prices are per item | per body and please remember that these were one-time-only discounted prices because the vendor was doing some early spring cleaning. If you are looking for current prices per mold, check out my January Replacement Cost post.

# $$ Item Name Bodies
3 1.67 | 0.42 Minnie Whinnie Painting Kits Sitting Foal, Playful Foal, Reining Stock Mare, Running Walk Tennessee Walking Horse Mare
3 8.75 | 1.46 Colorful Breeds Painting Kits G2: Saddlebred, Scrambling Foal, Trotting Foal, Quarter Horse, Andalusian, Thoroughbred
2 4.50 | 1.50 Holiday Ornament Craft Kit (from 2003!) G2: Warmblood, Morgan, Trotting Foal
6 1.50 | 1.50 2010 Games Stablemates G2: Thoroughbred (4), G3: Jumper (1), G4: Endurance (1)
7 1.50 | 1.50 Graceland Stablemates G3: Warmblood (5), G4: Driving (2)
13 1.50 | 1.50 Stablemate Singles G3: Arabian (1), Peruvian Paso (1), Highland Pony (3), Andalusian (2), Belgian (3), Stock Horse (1), Mustang (2)
4 1.00 | 0.50 Mini Whinnie Canadian Rockies Jumping Morgan Mare, Jumping Thoroughbred Stallion
2 2.50 | 0.42 Mini Whinnie Mustang Cutting Stock Mare, Galloping Mustang Stallion, Rearing Andalusian Stallion, Reining Stock Mare, Running Thoroughbred Stallion, Sliding Stop Quarter Horse Stallion
1 2.50 | 0.42 Mini Whinnie Gaited Big Lick, Cantering Morgan Mare, Cantering Tennessee Walking Horse Gelding, Cantering Thoroughbred Mare, High Stepping Saddlebred Mare, Trotting Morgan Stallion
1 2.50 | 0.42 Mini Whinnie Drafters High Stepping Draft Horse (2), Pulling Draft Horse (2), Show Pose Draft Horse (2)
1 5.00 | 5.00 Rodeo Play Set (Collectibulls) Night Life
1 5.00 | 1.67 My Dream Horse Stablemate Painting Kit G2: Warmblood, Scrambling Foal, G3: Warmblood
1 5.00 | 2.50 My Dream Horse Paddock Pals Painting Kit Adult, Foal
1 10.00 | 0.23 Shipping Costs Divided evenly across the bodies
January Body Box Order Unpacked

Costs Per Mold

So now I have the cost per item and the cost per body, but what happens when I have more than one cost per mold?

I average them together using the following formula: [(number of bodies * price one) + (number of bodies * price two)] / (price one + price two).

Below is the average cost per mold for all of the bodies in this order. A bit repetitive in places, but I only have to calculate it once! *grin*

And now I have to start painting…

# $$ Mold Prices
3 1.50 G2 Warmblood 2 @ 1.50, 1 @ 1.50
2 1.50 G2 Morgan 2 @ 1.50
5 1.42 G2 Trotting Foal 2 @ 1.50, 3 @ 1.46
3 1.46 G2 Saddlebred 3 @ 1.46
4 1.51 G2 Scrambling Foal 3 @ 1.46, 1 @ 1.67
7 1.48 G2 Thoroughbred 3 @ 1.46, 4 @ 1.50
3 1.46 G2 Quarter Horse 3 @ 1.46
3 1.46 G2 Andalusian 3 @ 1.46
3 1.50 G3 Highland Pony 3 @ 1.50
6 1.53 G3 Warmblood 5 @ 1.50, 1 @ 1.67
2 1.50 G3 Andalusian 2 @ 1.50
1 1.50 G3 Jumper 1 @ 1.50
1 1.50 G3 Arabian 1 @ 1.50
2 1.50 G3 Mustang 2 @ 1.50
1 1.50 G3 Stock Horse 1 @ 1.50
1 1.50 G3 Peruvian Paso 1 @ 1.50
3 1.50 G3 Belgian 3 @ 1.50
2 1.50 G4 Driving 2 @ 1.50
1 1.50 G4 Endurance 1 @ 1.50
1 5.00 Night Life 1 @ 5.00
1 2.50 Paddock Pal Mare 1 @ 2.50
1 2.50 Paddock Pal Foal 1 @ 2.50
4 0.50 Jumping Morgan Mare 4 @ 0.50
4 0.50 Jumping Thoroughbred Stallion 4 @ 0.50
3 0.42 Sitting Foal 3 @ 0.42
3 0.42 Playful Foal 3 @ 0.42
5 0.42 Reining Stock Mare 3 @ 0.42, 2 @ 0.42
3 0.42 Running Walk Tennessee Walking Horse Mare 3 @ 0.42
2 0.42 Cutting Stock Mare 2 @ 0.42
2 0.42 Galloping Mustang Stallion 2 @ 0.42
2 0.42 Rearing Andalusian 2 @ 0.42
2 0.42 Running Thoroughbred Stallion 2 @ 0.42
2 0.42 Sliding Stop Quarter Horse Stallion 2 @ 0.42
1 0.42 Big Lick 1 @ 0.42
1 0.42 Cantering Morgan Mare 1 @ 0.42
1 0.42 Cantering Tennessee Walking Horse Gelding 1 @ 0.42
1 0.42 Cantering Thoroughbred Mare 1 @ 0.42
1 0.42 High Stepping Saddlebred Mare 1 @ 0.42
1 0.42 Trotting Morgan Stallion 1 @ 0.42
2 0.42 High Stepping Draft Horse 2 @ 0.42
2 0.42 Pulling Draft Horse 2 @ 0.42
2 0.42 Show Pose Draft Horse 2 @ 0.42

Note: Sales Body Cost =/= Actual Cost

I got significantly reduced prices on many of the models in the current order. Since these are a one-time ‘get it off my shelves!’ price, the numbers do not reflect Replacement Price that I will use to calculate the final sales price.

Why? Because it allows for consistency in pricing, which is what I am going for with the store. This way I could list as many bay ponies as I wanted without variations in price due to their body sources.



Leave a Reply