Here would be my suggestion for a 6 month trip, now given you have so many potential dropships, this is do-able on a solo-tour. These are purely suggestions, you can change or modify whatever you want to fit what you think your warship should be able to do.
Changes
1100 Bay personnel -> 7t quarters 7,700
Assumptions
0.5% Cargo for “Wear and Tear”/mo 75,000
ASF – 6 ton Fuel tanks
SC – 15 ton fuel tanks
Dogfighters – 55 tons
Bombers – 90 tons
CAS – 70 tons
ASF Armor – 1/3rd total mass
SC Armor – 1/4th total mass
Consumables (8.685t/day) 1,564
ASF CAP
30 tons fuel per day 5,400
ASF Training Sorties – Weekly
1200 tons fuel/week 31,200
Armor: 1/10th total armor: 7 tons 9,000
Ordinance/Ammo: 0 tons
ASF Training Sorties – Monthly Live Fire
Armor: 1/4th total armor: 1,125 6,750
Ordinance/Ammo: 5 tons/ASF 1,000
Other Repairs: 2 tons/ASF 800
ASF Combat Sorties – 5 total (Reserve amount)
Armor: 3/4th total armor 3,375
Fuel: 30t/ASF 6,000
Ordinance/Ammo: 30t/ASF 6,000
Other Repairs: 25 tons/ASF 5,000
SC Training Sorties – Every other Weekly
Fuel: 1500 ton/week 19,500
Armor: 1/10th total 26,000
Other Repairs: 10t/SC 13,000
SC Combat Sorties – 5 total (Reserve amount)
Fuel: 1500 ton/sortie 7,500
Armor: 1/4th total 5,000
Ordinance/Ammo: 10t/SC/sortie 5,000
Other Repairs: 50t/SC 5,000
Total 239,789
(Non-negotiable) (50,575)
(Negotiable) (31,536/mo)
Ammunition: I personally like having enough ammunition to fire constantly for either 30 minutes, 45 minutes, or an hour. Below are the suggestions for the ammo, keeping with the monthly live Fire exercises, I have a per/load in addition. When it comes to the actual game, I don't think they usually last longer than 20 rounds (20 minutes) so dropping to that amount wouldn't be a horrible idea.
Ammunition Suggestions
Weapon (##) Load Reloads (4x) Total
LRM 20s (15) 450 (75t) 300t 375t
LRM 10s (8 ) 240 (20t) 80t 100t
SRM 4s (6) 200 (8t) 32t 40t
NAC/30s (14) 420 (336t) 1344t 1680t
NAC/40s (2) 60 (72t) 288t 360t
HNG (17) 510 (255t) 1020t 1275t
Minimum Suggested: 3,830t
Per Month Live Fire: 766t
Total 6 Months: 8,426t
Again, all of these are merely suggestions, you can keep/toss out/change whatever you want. In particular the weekly training may be too frequent, but I figured it weekly to keep up levels of training, you could probably get away with a fair bit less (someone actually familiar with a national air force may be able to give more accurate numbers in keeping up one's skills).
I hope this at least gives you a starting point to get what you are wanting.
Edit: I rushed this a bit, I think I'm short on a couple of the calculations, I'll update later, but the Monthly and Weekly exercises for ASF I think are a bit short in some areas.