Brooke,
I'm glad you like the source, it has many great tables to look over. I especially like the one about ordnance per month by theater, very interesting.
Here are a few more source's to give additional background (I believe you have a few of these listed with the rules all ready).
-US Army Air Forces in World War II Combat Chronology 1941-1945 ( I actually have a paper copy but you can download it as a pdf.
http://www.airforcehistory.hq.af.mil/Publications/fulltext/wwii_combat_chronology.pdf-US Army Air Forces in World War II, Volume 2 Europe: Torch to Pointblank August 1942 to December 1943 (large pdf)
http://www.airforcehistory.hq.af.mil/Publications/fulltext/aaf_wwii-v2.pdf-Aerial Interdiction, Air Power and the Land Battle in Three American Wars (Good data on the North Africa campaign)
http://www.airforcehistory.hq.af.mil/Publications/fulltext/aerial_interdiction.pdfTo your other points;
I can understand combining planes like the B-17 and B-24 (or the B-25 and B-26) to a single unit for the sake of squad size in the scenario.
I don't have any definitive data sources for the Luftwaffe or the Italian Air Force, but most documents I have, tend to say the Allies had a 3-1 or 4-1 numerical advantage during this time frame. As a potential Axis pilot in this scenario, I would find that a very daunting prospect! So I can see creating some artificial balance for the benefit of the scenario.
The P-40
Looking at the information for June of 1943 I came up with the following numbers;
Model Number % of total 80 aircraft equivalent #- B-17 269 7.94% 6
- B-24 192 5.67% 5
- B-25 437 12.89% 10
- B-26 278 8.20% 7
- A-20 166 4.90% 4
- P-38 514 15.16% 12
- P-39 347 10.24% 8
- P-40 717 21.15% 17
- P-51 290 8.55% 7
- Other 180 5.31% 4
I still have to disagree with the aircraft distribution within the 12th Air Force. Looking at the data referenced above, it is clear that the P-40 bore the brunt of fighter operations throughout the North Africa campaign. As you can see, there was a very significant build-up in the Mediterranean theater between February 1943 (1,521 1st line combat aircraft) and June 1943 (3,390 1st line combat aircraft). So I can appreciate a reduction to the percentage of P-40's, however it's still the single most numerous fighter within the USAAF in theater. I'd be glad to review any material that has different numbers to see if there's something I've misunderstood.
Baumer