Spell Availability & Costs

Is there a formula or basis for the Arcane and Divine spell costs on p.54 (Spell Availability by Market chart)?

In my home campaign, I've adjusted the Divine Spell Progressions, which changes the level at which some spells become available.

If the costs are a function of required caster level, would this imply different costs for Clerics (Divine 2) vs. Priestesses (Divine 4)?

1. Find the lowest level caster who can cast the spell

2. Determine his monthly wage

3. Determine his billable rate, as monthly wage x 12 x 3 x 8 / 2080

4. Determine the number of times per day he can cast the spell

5. Cost of the spell is equal to billable rate / number of times per day he can cast the spell

If you wish to be precise, it's true that the existence of Priestesses would reduce the cost of spells, but I decided to keep them as-is. 

For monthly fees, do you mean the Henchmen Monthly Fee (ACKS p.51)? I can't derive the by-the-book values using these numbers.

(Perhaps the 'standard' published rates are inflated by spellcasters to ensure their profits?)

You probably won't get the exact values that appeared in the rulebook as I used an un-rounded wage value from a back-end economic formula, and I rounded the outcomes. Here's the actual data from my spreadsheet. 

Cost Per Spells  - Divine          
Level Monthly Wage Billable Rate Highest Level Spell Spells/Day Cost per Spell Game Cost
0 $2 $0 0 0 $0  
1 $23 $3 0 0 $0  
2 $70 $10 1 1 $10 $10
3 $140 $19 1 2 $10 $10
4 $280 $39 2 1 $39 $40
5 $582 $81 2 2 $40 $40
6 $1,171 $162 4 1 $162 $150
7 $2,327 $322 5 1 $322 $325
8 $4,655 $644 5 1 $644 $645
9 $13,304 $1,842 5 2 $921 $645
10 $19,057 $2,639 5 2 $1,319 $900
11 $44,215 $6,122 5 3 $2,041 $900
12 $69,373 $9,605 5 3 $3,202 $900
13 $209,771 $29,045 5 4 $7,261 $900
14 $934,534 $129,397 5 4 $32,349 $900
             
Cost Per Spells - Arcane          
Level Monthly Wage Billable Rate Highest Level Spell Spells/Day Cost per Spell Game Cost
0 $2 $0 0 0 $0  
1 $23 $3 1 1 $0  
2 $70 $10 1 2 $5 $5
3 $140 $19 2 1 $19 $20
4 $280 $39 2 2 $19 $20
5 $582 $81 3 1 $81 $75
6 $1,171 $162 3 2 $81 $75
7 $2,327 $322 4 1 $322 $325
8 $4,655 $644 4 2 $322 $325
9 $13,304 $1,842 5 1 $1,842 $1,250
10 $19,057 $2,639 5 2 $1,319 $900
11 $44,215 $6,122 6 1 $6,122 $4,500
12 $69,373 $9,605 6 2 $4,803 $4,500
13 $209,771 $29,045 6 3 $9,682 $4,500
14 $934,534 $129,397 6 3 $43,132 $4,500

Thank you very much Alex, that's super helpful for the setting I'm working on.

Same! It had not yet occurred to me that I’d need to change the cost of spells, but it’s definitely a valuable thing to do.

Is there a way to use this cost directly to calculate how many are available in a given market class? (That might be derivable with things already around, but I thought I’d ask just in case it’s a simple conversion.)

In anticipation of some "Restore Life & Limb", I've adopted the following for my home campaign:

https://mutantsmagic.wordpress.com/astonishing-acks/acks-house-rules/#comment-1025

If anyone's interested, here's my worksheet:

https://docs.google.com/spreadsheets/d/1NOqe0ZlTX7NMEtW9vVhqMm1gWj6vSsgy3XCJjTJkXXY/edit?usp=sharing