After watching my Sims become millionaires pretty quickly with a dog hunting for them, and with a note in the guide currently saying dogs are not a primary moneymaking method, I thought I'd try an experiment in the vein of the painting / sculpting / inventing comparison on the guide.
Cat:
Traits - Genius, neat, playful, Independent, non-destructive, hunter, adventurous
Rewards - Alpha pet, best behaviour, never nauseous, steel bladder
Skills - Hunting (max)
Challenges completed = all
Dog:
Traits - Genius, Hunter, Non-destructive, playful, loyal
Rewards - Alpha pet (+ others I'd have to check and edit in as I didn't note them down, but I don't think they will make any difference)
Skills - Hunting (max)
Challenges completed = Metal collector, gem collector
One cat and one dog took part.
As with the sim skill ones, needs were static and the length of the test was 100 sim hours.
The owner sim had all the basic cuts opened up for gems and had the metal collector challenge completed.
Cat prey was sold as it was caught and the amount recorded.
Items collected by the dog were cut/smelted but not transfigured. The cost of cutting and smelting has been deducted from the total given below. Any gnomes returned in the mail were added at 1000 each and any completed special items that were assembled also counted for 1000 on the total. Gems were cut to maximise return using the info in the guide. The single tiberium collected (much less than in my normal gameplay so far, mood seems to have to be high for these to be collected regularly) was cut and allowed to grow before its price was recorded.
All actions were the basic Sniff for Collectable/Stalk for Prey and all were performed on the home lot.
Results of hunting for 100 hours:
The cat earned a total of 21,656.
The dog (with a sim as posting slave, of course) earned a total of: 376,506.