Keg Productivity

Revision as of 20:10, 15 August 2016 by Wetjen (talk | contribs) (Added gold formatting to individual cells to adhere to wiki standards / Added formatting to formula)
Robin building.png
“I still have a lot of work to do”
— Robin

Under Construction

This article or section is under construction. It may be in the process of an expansion or major restructuring.

Last edited by Wetjen on 2016-08-15 20:10:17.

The Keg produces drinks from Crops. Wheat produces Beer and Hops produce Pale Ale in approximately one day. Juice is produced from vegetables in about four days, and fruits produce wine in about six days. The actual time required to produce a product and their values are:

Image Name Description Ingredient Time Sell Price Restores
Beer.png Beer Drink in moderation. Wheat.png Wheat

2250 mins[1] (1~2 Days)

Beer.png 200g

Energy.png50 Health.png20

Pale Ale.png Pale Ale Drink in moderation. Hops.png Hops

2360 mins[1] (1~2 Days)

Pale Ale.png 300g

Energy.png50 Health.png20

Wine.png Wine Drink in moderation.

Any fruit

10000 mins[1] (around 7 Days)

Wine.png 3 * Fruit Value

Energy.png50 Health.png20

Juice.png Juice A sweet, nutritious beverage.

Any vegetable

6000 mins[1] (around 4 Days)

Juice.png 2.25 * Vegetable Value

Energy.png75 Health.png30

Raw Materials tagged with [2] needs to be Confirmed.

Keg Productivity

Until the very late game, most farmers will have far fewer kegs than available crops, so the most pertinent question is: what crop should be put into the keg to generate the greatest possible profit? (Money gained/time)

Artisan Goods produced by a keg will always be more valuable than the input materials. Their final value is not affected by the quality of the ingredient. So, compared to selling the raw crops, a keg will produce profit faster if normal quality (not silver or gold) crops are processed. However, sometimes a keg will still produce profit faster if processing an expensive gold quality crop than it would processing a less expensive normal quality crop.

For example, processing a silver quality Pumpkin is more profitable (per time spent) than processing a normal quality Melon, but processing a gold quality pumpkin is less profitable then either. Processing Starfruit always generates profit faster than Hops, regardless of crop quality, but normal or silver quality hops generate profit faster than gold quality Ancient Fruit. All cases are considered below.

The rate of productivity of a keg is: ([Sell Price of Artisan Good] - [Sell Price of Input Produce]) / [Processing Time][3]

These values do not take into account the effects of Tiller or Artisan professions, which reduce and increase the profit from a keg, respectively.

Raw Material Product Input Crop

Value

Sell Price Increase

in Value

Time to

Process (minutes)

Productivity

(g/minute)

Approximate

g/day[4]

  Ancient Fruit[2] Wine data-sort-value="750"> 750g data-sort-value="2250"> 2,250g data-sort-value="1500"> 1,500g 10000 0.150 252
 
 
Ancient Fruit[2] data-sort-value="937"> 937g data-sort-value="1313"> 1,313g 0.131 221
 
 
Ancient Fruit[2] data-sort-value="1125"> 1,125g data-sort-value="1125"> 1,125g 0.113 189
  Apple Wine data-sort-value="100"> 100g data-sort-value="300"> 300g data-sort-value="200"> 200g 10000 0.020 34
 
 
Apple data-sort-value="125"> 125g data-sort-value="175"> 175g 0.018 29
 
 
Apple data-sort-value="150"> 150g data-sort-value="150"> 150g 0.015 25
  Apricot Wine data-sort-value="50"> 50g data-sort-value="150"> 150g data-sort-value="100"> 100g 10000 0.010 17
 
 
Apricot data-sort-value="62"> 62g data-sort-value="88"> 88g 0.009 15
 
 
Apricot data-sort-value="75"> 75g data-sort-value="75"> 75g 0.008 13
  Artichoke[2] Juice data-sort-value="160"> 160g data-sort-value="360"> 360g data-sort-value="200"> 200g 6000 0.033 56
 
 
Artichoke[2] data-sort-value="200"> 200g data-sort-value="160"> 160g 0.027 45
 
 
Artichoke[2] data-sort-value="240"> 240g data-sort-value="120"> 120g 0.020 34
  Beet Juice data-sort-value="100"> 100g data-sort-value="225"> 225g data-sort-value="125"> 125g 6000 0.021 35
 
 
Beet data-sort-value="125"> 125g data-sort-value="100"> 100g 0.017 28
 
 
Beet data-sort-value="150"> 150g data-sort-value="75"> 75g 0.013 21
  Blackberry Wine data-sort-value="20"> 20g data-sort-value="60"> 60g data-sort-value="40"> 40g 10000 0.004 7
 
 
Blackberry data-sort-value="25"> 25g data-sort-value="35"> 35g 0.004 6
 
 
Blackberry data-sort-value="30"> 30g data-sort-value="30"> 30g 0.003 5
  Blueberry Wine data-sort-value="80"> 80g data-sort-value="240"> 240g data-sort-value="160"> 160g 10000 0.016 27
 
 
Blueberry data-sort-value="100"> 100g data-sort-value="140"> 140g 0.014 24
 
 
Blueberry data-sort-value="120"> 120g data-sort-value="120"> 120g 0.012 20
  Bok Choy[2] Juice data-sort-value="80"> 80g data-sort-value="180"> 180g data-sort-value="100"> 100g 6000 0.017 28
 
 
Bok Choy[2] data-sort-value="110"> 110g data-sort-value="70"> 70g 0.012 20
 
 
Bok Choy[2] data-sort-value="132"> 132g data-sort-value="48"> 48g 0.008 13
  Cactus Fruit Wine data-sort-value="75"> 75g data-sort-value="225"> 225g data-sort-value="150"> 150g 10000 0.015 25
 
 
Cactus Fruit data-sort-value="93"> 93g data-sort-value="132"> 132g 0.013 22
 
 
Cactus Fruit data-sort-value="112"> 112g data-sort-value="113"> 113g 0.011 19
  Cauliflower Juice data-sort-value="175"> 175g data-sort-value="394"> 394g data-sort-value="219"> 219g 6000 0.037 61
 
 
Cauliflower data-sort-value="218"> 218g data-sort-value="176"> 176g 0.029 49
 
 
Cauliflower data-sort-value="262"> 262g data-sort-value="132"> 132g 0.022 37
  Cherry Wine data-sort-value="80"> 80g data-sort-value="240"> 240g data-sort-value="160"> 160g 10000 0.016 27
 
 
Cherry data-sort-value="100"> 100g data-sort-value="140"> 140g 0.014 24
 
 
Cherry data-sort-value="120"> 120g data-sort-value="120"> 120g 0.012 20
  Coconut Wine data-sort-value="100"> 100g data-sort-value="300"> 300g data-sort-value="200"> 200g 10000 0.020 34
 
 
Coconut data-sort-value="125"> 125g data-sort-value="175"> 175g 0.018 29
 
 
Coconut data-sort-value="150"> 150g data-sort-value="150"> 150g 0.015 25
  Corn Juice data-sort-value="50"> 50g data-sort-value="113"> 113g data-sort-value="63"> 63g 6000 0.011 18
 
 
Corn data-sort-value="62"> 62g data-sort-value="51"> 51g 0.009 14
 
 
Corn data-sort-value="75"> 75g data-sort-value="38"> 38g 0.006 11
  Cranberries Wine data-sort-value="130"> 130g data-sort-value="390"> 390g data-sort-value="260"> 260g 10000 0.026 44
 
 
Cranberries data-sort-value="162"> 162g data-sort-value="228"> 228g 0.023 38
 
 
Cranberries data-sort-value="195"> 195g data-sort-value="195"> 195g 0.020 33
  Crystal Fruit Wine data-sort-value="150"> 150g data-sort-value="450"> 450g data-sort-value="300"> 300g 10000 0.030 50
 
 
Crystal Fruit data-sort-value="187"> 187g data-sort-value="263"> 263g 0.026 44
 
 
Crystal Fruit data-sort-value="225"> 225g data-sort-value="225"> 225g 0.023 38
  Eggplant Juice data-sort-value="60"> 60g data-sort-value="135"> 135g data-sort-value="75"> 75g 6000 0.013 21
 
 
Eggplant data-sort-value="75"> 75g data-sort-value="60"> 60g 0.010 17
 
 
Eggplant data-sort-value="90"> 90g data-sort-value="45"> 45g 0.008 13
  Fiddlehead Fern Juice data-sort-value="90"> 90g data-sort-value="202"> 202g data-sort-value="112"> 112g 6000 0.019 31
 
 
Fiddlehead Fern data-sort-value="112"> 112g data-sort-value="90"> 90g 0.015 25
 
 
Fiddlehead Fern data-sort-value="135"> 135g data-sort-value="67"> 67g 0.011 19
  Garlic Juice data-sort-value="60"> 60g data-sort-value="135"> 135g data-sort-value="75"> 75g 6000 0.013 21
 
 
Garlic data-sort-value="75"> 75g data-sort-value="60"> 60g 0.010 17
 
 
Garlic data-sort-value="90"> 90g data-sort-value="45"> 45g 0.008 13
  Grape Wine data-sort-value="80"> 80g data-sort-value="240"> 240g data-sort-value="160"> 160g 10000 0.016 27
 
 
Grape data-sort-value="100"> 100g data-sort-value="140"> 140g 0.014 24
 
 
Grape data-sort-value="120"> 120g data-sort-value="120"> 120g 0.012 20
  Green Bean Juice data-sort-value="40"> 40g data-sort-value="90"> 90g data-sort-value="50"> 50g 6000 0.008 14
 
 
Green Bean data-sort-value="50"> 50g data-sort-value="40"> 40g 0.007 11
 
 
Green Bean data-sort-value="60"> 60g data-sort-value="30"> 30g 0.005 8
  Hops Pale Ale data-sort-value="25"> 25g data-sort-value="300"> 300g data-sort-value="275"> 275g 2360 0.117 196
 
 
Hops data-sort-value="31"> 31g data-sort-value="269"> 269g 0.114 191
 
 
Hops data-sort-value="37"> 37g data-sort-value="263"> 263g 0.111 187
  Hot Pepper Wine data-sort-value="40"> 40g data-sort-value="120"> 120g data-sort-value="80"> 80g 10000 0.008 13
 
 
Hot Pepper data-sort-value="50"> 50g data-sort-value="70"> 70g 0.007 12
 
 
Hot Pepper data-sort-value="60"> 60g data-sort-value="60"> 60g 0.006 10
  Kale[2] Juice data-sort-value="110"> 110g data-sort-value="248"> 248g data-sort-value="138"> 138g 6000 0.023 39
 
 
Kale[2] data-sort-value="137"> 137g data-sort-value="111"> 111g 0.019 31
 
 
Kale[2] data-sort-value="165"> 165g data-sort-value="83"> 83g 0.014 23
  Melon Wine data-sort-value="250"> 250g data-sort-value="750"> 750g data-sort-value="500"> 500g 10000 0.050 84
 
 
Melon data-sort-value="312"> 312g data-sort-value="438"> 438g 0.044 74
 
 
Melon data-sort-value="375"> 375g data-sort-value="375"> 375g 0.038 63
  Orange Wine data-sort-value="100"> 100g data-sort-value="300"> 300g data-sort-value="200"> 200g 10000 0.020 34
 
 
Orange data-sort-value="125"> 125g data-sort-value="175"> 175g 0.018 29
 
 
Orange data-sort-value="150"> 150g data-sort-value="150"> 150g 0.015 25
  Parsnip Juice data-sort-value="35"> 35g data-sort-value="79"> 79g data-sort-value="44"> 44g 6000 0.007 12
 
 
Parsnip data-sort-value="43"> 43g data-sort-value="36"> 36g 0.006 10
 
 
Parsnip data-sort-value="52"> 52g data-sort-value="27"> 27g 0.005 8
  Peach Wine data-sort-value="140"> 140g data-sort-value="420"> 420g data-sort-value="280"> 280g 10000 0.028 47
 
 
Peach data-sort-value="175"> 175g data-sort-value="245"> 245g 0.025 41
 
 
Peach data-sort-value="210"> 210g data-sort-value="210"> 210g 0.021 35
  Pomegranate Wine data-sort-value="140"> 140g data-sort-value="420"> 420g data-sort-value="280"> 280g 10000 0.028 47
 
 
Pomegranate data-sort-value="175"> 175g data-sort-value="245"> 245g 0.025 41
 
 
Pomegranate data-sort-value="210"> 210g data-sort-value="210"> 210g 0.021 35
  Potato Juice data-sort-value="80"> 80g data-sort-value="180"> 180g data-sort-value="100"> 100g 6000 0.017 28
 
 
Potato data-sort-value="100"> 100g data-sort-value="80"> 80g 0.013 22
 
 
Potato data-sort-value="120"> 120g data-sort-value="60"> 60g 0.010 17
  Pumpkin Juice data-sort-value="320"> 320g data-sort-value="720"> 720g data-sort-value="400"> 400g 6000 0.067 112
 
 
Pumpkin data-sort-value="400"> 400g data-sort-value="320"> 320g 0.053 90
 
 
Pumpkin data-sort-value="480"> 480g data-sort-value="240"> 240g 0.040 67
  Radish Juice data-sort-value="90"> 90g data-sort-value="203"> 203g data-sort-value="113"> 113g 6000 0.019 32
 
 
Radish data-sort-value="112"> 112g data-sort-value="91"> 91g 0.015 25
 
 
Radish data-sort-value="135"> 135g data-sort-value="68"> 68g 0.011 19
  Red Cabbage Juice data-sort-value="260"> 260g data-sort-value="585"> 585g data-sort-value="325"> 325g 6000 0.054 91
 
 
Red Cabbage data-sort-value="325"> 325g data-sort-value="260"> 260g 0.043 73
 
 
Red Cabbage data-sort-value="390"> 390g data-sort-value="195"> 195g 0.033 55
  Rhubarb[5] Wine data-sort-value="220"> 220g data-sort-value="495"> 495g data-sort-value="275"> 275g 6000 0.046 77
 
 
Rhubarb[5] data-sort-value="275"> 275g data-sort-value="220"> 220g 0.037 62
 
 
Rhubarb[5] data-sort-value="330"> 330g data-sort-value="165"> 165g 0.028 46
  Salmonberry Wine data-sort-value="5"> 5g data-sort-value="15"> 15g data-sort-value="10"> 10g 10000 0.001 2
 
 
Salmonberry data-sort-value="6"> 6g data-sort-value="9"> 9g 0.001 2
 
 
Salmonberry data-sort-value="7"> 7g data-sort-value="8"> 8g 0.001 1
  Spice Berry Wine data-sort-value="80"> 80g data-sort-value="240"> 240g data-sort-value="160"> 160g 10000 0.016 27
 
 
Spice Berry data-sort-value="100"> 100g data-sort-value="140"> 140g 0.014 24
 
 
Spice Berry data-sort-value="120"> 120g data-sort-value="120"> 120g 0.012 20
  Starfruit Wine data-sort-value="800"> 800g data-sort-value="2400"> 2,400g data-sort-value="1600"> 1,600g 10000 0.160 269
 
 
Starfruit data-sort-value="1000"> 1,000g data-sort-value="1400"> 1,400g 0.140 235
 
 
Starfruit data-sort-value="1200"> 1,200g data-sort-value="1200"> 1,200g 0.120 202
  Strawberry Wine data-sort-value="120"> 120g data-sort-value="360"> 360g data-sort-value="240"> 240g 10000 0.024 40
 
 
Strawberry data-sort-value="150"> 150g data-sort-value="210"> 210g 0.021 35
 
 
Strawberry data-sort-value="180"> 180g data-sort-value="180"> 180g 0.018 30
  Tomato Juice data-sort-value="60"> 60g data-sort-value="135"> 135g data-sort-value="75"> 75g 6000 0.013 21
 
 
Tomato data-sort-value="75"> 75g data-sort-value="60"> 60g 0.010 17
 
 
Tomato data-sort-value="90"> 90g data-sort-value="45"> 45g 0.008 13
  Wheat Beer data-sort-value="27"> 27g data-sort-value="200"> 200g data-sort-value="173"> 173g 2250 0.077 129
 
 
Wheat data-sort-value="34"> 34g data-sort-value="166"> 166g 0.074 124
 
 
Wheat data-sort-value="40"> 40g data-sort-value="160"> 160g 0.071 119
  Yam Juice data-sort-value="160"> 160g data-sort-value="360"> 360g data-sort-value="200"> 200g 6000 0.033 56
 
 
Yam data-sort-value="200"> 200g data-sort-value="160"> 160g 0.027 45
 
 
Yam data-sort-value="240"> 240g data-sort-value="120"> 120g 0.020 34

Keg Productivity (Alternate Calculation)

This list was generated using this Spreadsheet
Raw Material Product Harvests

per Seed

Sellprice Profit

per Day[6]

Increase Sellprice Profit

per Day[7]

  Ancient Fruit[2] Wine 8 750 60.71 1500 2250 190
  Apple Wine 100 200 300 50
  Apricot Wine 50 100 150 25
  Artichoke[2] Juice 1 160 16.25 200 360 23.57
  Beet[2] Juice 1 100 13.33 125 225 17.08
  Blackberry Wine 20 40 60 10
  Blueberry Wine 4 80 35.2 160 240 34.57
  Bok Choy[2] Juice 1 80 07.50 100 180 13
  Cactus Fruit Wine 75 150 225
  Cauliflower Juice 1 175 07.92 219 394 17.43
  Cherry Wine 80 160 240 40
  Coconut Wine 100 200 300
  Corn[2] Juice 11 50 7.41 63 113 18.13
  Cranberries Wine 5 130 39.26 260 390 61
  Crystal Fruit Wine 150 300 450 64.29
  Eggplant Juice 1 60 08.00 75 135 10.45
  Fiddlehead Fern Juice 99 103 202
  Garlic Juice 1 60 15 75 135 18.75
  Grape Wine 7 80 17.86 160 240 47.65
  Green Bean Juice 7 40 07.86 50 90 16.76
  Hops Pale Ale 18 25 13.93 275 300 116.08
  Hot Pepper Wine 8 40 10.77 80 120 23.59
  Kale[2] Juice 1 110 06.67 138 248 14.79
  Melon Wine 1 250 14.17 500 750 37.22
  Orange Wine 100 200 300 50
  Parsnip Juice 1 35 3.75 44 79 05.88
  Peach Wine 140 280 420 70
  Pomegranate Wine 140 280 420 70
  Potato Juice 1 80 5 100 180 10.83
  Pumpkin Juice 1 320 16.92 400 720 32.63
  Radish[2] Juice 1 90 08.33 113 203 13.54
  Red Cabbage[2] Juice 1 260 17.78 325 585 32.33
  Rhubarb[2] Juice 1 220 09.23 275 495 20.79
  Salmonberry Wine 5 10 15 2.5
  Spice Berry Wine 80 160 240 40
  Starfruit Wine 1 800 30.77 1600 2400 105.26
  Strawberry Wine 6 120 22.14 240 360 60.59
  Tomato Juice 5 60 09.26 75 135 18.94
  Wheat Beer 1 25 03.75 175 200 38
  Yam Juice 1 160 10 200 360 18.75

[5]

  1. 1.0 1.1 1.2 1.3 For whatever reason, processing time calculates differently while sleeping versus being awake. 1 hour equals 60 minutes when awake but, equals 100 minutes when sleeping. So if you sleep a whole day, the machine would process 2400 mins. (100 x 24) If you work from 6:00AM till 12:00AM., and sleep 6 hours, the machine will process 1680 mins a day. (60 x 18 + 100 x 6) If you work from 6:00AM. till 2:00AM, and faint 4 hours, the machine will process 1600 mins a day. (60 x 20 + 100 x 4) For example, Preserves Jars need 4000 mins to work. If you sleep the whole process, you need to sleep 40 hours, less than 2 days. If you work 18 hours a day, it takes 2 days, 10 hours and 40 minutes.
  2. 2.00 2.01 2.02 2.03 2.04 2.05 2.06 2.07 2.08 2.09 2.10 2.11 2.12 2.13 2.14 2.15 2.16 2.17 2.18 2.19 2.20 2.21 Product or Raw Material needs confirmation
  3. Caveat: presumably, Artisan Goods that complete processing during the night incur "wasted" time until morning, when the player can refill the Keg. This potentially undermines the practical productivity rates of Beer and Pale Ale, which require more frequent refills and are more likely to be delayed by finishing at night.
  4. Assuming an effectively 1680 minute day, sleeping midnight - 6:00AM
  5. 5.0 5.1 5.2 5.3 While rhubarb is considered a vegetable in the game and should thus make juice in a keg, it instead makes wine. Rhubarb wine sells for 495 gold, which is 2.25x the sell price of rhubarb, meaning that it still carries the same markup as all juices and not the larger (3.00x) markup of wine.
  6. Calculated: (Sellprice*Crops per Harvest-Seedprice)/(Days to Mature)
  7. Calculated: (Sellprice*Crops per Harvest-Seedprice)/(Days to Mature*Crops per Harvest + Days in Barrel)