View Single Post
Old 06-09-2018, 12:13 PM   #8
ak_aramis
 
ak_aramis's Avatar
 
Join Date: May 2010
Location: Alsea, OR
Default Re: Slower fuel-efficient jump drive implications?

Quote:
Originally Posted by Fred Brackin View Post
Yes, to be even vaguely competitive if you reduce the number of trips per year by a factor of 4 you have to reduce the cost of both building and operating ships by the same number.

there's a little of that to be made back by the increased cargo capacity but probably not as much as you might have hoped.
More correctly, you have to up the costs.

I am working in CT because I have the spreadsheet built and know the numbers better.
Here's the basics for a 400Td J1 CT Bk5 design, crew only, rest pure cargo. B5 is Bk 5 costs; Alt is otherwise identical, but using 1/5 j-fuel, and rigged for 5 weeks, rather than 4.

Code:
J                 Bk5          Alt
J1 P1 TL15 HG                           
Jn/Pn               1          1
Tons              400        400
TL                 15         15
DesTL              15         15
Comp Model          1          1                     
Tonnages
Bridge             20         20
Computer            1          1
JD                  8          8
MD 1G               8          8
PP                  4          4
Turret (1x1)        1          1
Fuel, Jump         40          8
Fuel, PP            4          5
SR                 16         16
Cargo             298        329
MCrCosts
Hull 6 SL          32         32
Bridge              2          2
Computer            2          2
JD                 32         32
MD 1G               1.6        1.6
PP                 12         12
Turret (1x1)        0.2        0.2
SR                  2          2
MCr Total          83.8       83.8
                                  
Command             0          0
Plt                 1          1
Nav                 1          1
Engr                1          1
Gnny                           
Medic               1          1
Service             0          0
                                  
MoPymt         349167     349167
AM Share         6984       6984
Salaries        17000      17000
Fuel, Jump      40000       8000
Fuel, PP         2000       2500
LS, Mo          16000      16000
                         
Monthly Cr     431151     399651
Per Jump       215575.5   499563.75
                         
Per Ton           724       1519
                         
Per Mo Cr/Td     1312.59    1190.43
per J Cr/Td       723.41    1518.43
                         
Per Ton-Parsec    724       1519
Now, we can refactor this into passengers, assuming 13 mo/year, with one month down for maintenance, and no payments and unpaid leave in month 13... so we use 12 months.

Cargo profit ratio = 1000/724 = 1.38
Alt version at same ratio: 1518.43=2094.84, round up to Cr2100 per jump

a stateroom costs KCr500
monthly Maintenance and mortgage payment 2500/mo, 3125/5wk
LS per 2 weeks KCr2, for 4K/month or 5k/5wk
Cargo space lost 4td
A mid passage under CT needs is thus Cr1250 + Cr2893.64 + Cr2000 = 6143.64
[stateroom cost per jump + cost of cargo space replaced + LS]
refactoring for the alt: Cr(3125 + 6076 + 5000)=14201.
Keeping the CT profit ratio (KCr8 / 6143)=1.3021596317492563, MP should cost Cr18491.97 for J1 Round up to Cr18,500

HP: costs are 1 SR for passenger, and 1/8 of a steward and his SR per passenger.
So BK2+BK5 gives 1406.25 + 3255.345 + 2250 + 125 = 7036.6
[(stateroom cost per 2 weeks for 1.125 SR)+(cargo cost for 4.5 td)+(2.125 weeks LS)+(steward salary/(2 jumps @ 8 passengers))]
Profit rate for HP is about 1.42
the alt version (3125 * 1.125) + (1518.43 * 4.5) +(1000 * 5 * 1.125) + (2000 * 1.25 /8) = 3515.625 + 6832.935 + 5625 + 312.5 = 16286.06
keeping same profit ratio 16286.06 * 1.42 = 23126.2052
Rounding up to next 500 = 23,500.
ak_aramis is offline   Reply With Quote