Cook Book in excel

[Steve]

Hey!

I do not know if it exists yet, but it can be helpful. It's a simple excel document which contains useful informations.
(Profits at eash dish or the profit/mins etc. :)
I know it's a little bit crazy, but I hit the bottle yesterday so I was that drunk to make this :D

Regards,
SteveOO7

Link: http://rapidshare.com/files/449087445/Bakery_Story.xls

[logon2k]

The link no longer works, but here is what I could put together:

I have prepared a spreadsheet comparing different items to determine which items produce the greatest income and XP points. Unfortunately this forum does not allow the import of Excel spreadsheets. I also found that it also depends on how much time you have to wait for the product to be ready to serve. I believe that double the preparation time will cause the food to spoil, so consider the amount of time you have to get back to the game and serve your items.

So, here is what I found for each time limit for the greatest number of coins:

Item.........................Category............. ...Cost............Yield.............XP..........S ell................Time...........Net @
Brownies...................Cookies................ ...30..............110...............4..........11 0.................0.06...............80
Chocolate Cookies......Cookies...................40......... .....140...............5..........140............. ....0.08..............100
Coffee.......................Drink................ .......30..............110...............6........ ..110.................0.08...............80
Blueberry Muffins........Bread....................110....... .......130...............7..........390........... ......0.25..............280
Mocha.......................Drink................. .....400..............300.............10........1, 200................1.00..............800
Fruitcake...................Cake.................. .....750..............575.............26........2, 300................1.00...........1,500
Raspberry Macaroons.Cookies...................520........... ...400.............22........1,600................ 1.00...........1,080
Chamomile Tea..........Drink.......................370...... ........275............20........1,100............ .....1.00.............730
Chocolate Cake..........Cake........................190..... .........350............15..........700........... .......1.00.............510
Croissant...................Bread................. ......590..............525............29.......2,1 00..................2.00..........1,510
Chai Tea....................Drink...................... .780...............500............55.......2,500.. ................3.00..........1,720
Peach Cobbler............Pie..........................37 0...............300............27.......1,200..... .............3.00.............830
Vanilla Cupcake..........Cake.....................1,400... ..........1,175...........57.......4,700.......... ........4.00..........3,300
Valentine Cupcake......Cake........................660...... ..........575...........40.......2,300............ ......4.00..........1,640
Strawberry Cake........Cake........................700....... ..........575...........57......2,300............. ......4.00..........1,600
Espresso...................Drink.................. ......250.................450...........51........ .900...................4.00.............650
Gingerbread Cookies..Cookies..................1,710........... ......750...........50......6,000................. ..6.00..........4,290
Sparkling Cider..........Drink........................970... ...............850..........57.......3,400........ ..........6.00...........2,430
Fruit Tart..................Pie......................... ..750..................650..........67.......2,600 ..................6.00...........1,850
Strawberry Cheesecake.Pie.....................1,400.......... .....1,275..........70.......5,100................ ..8.00...........3,700
Egg Nog....................Drink...................... ..580..................580..........77.......2,900 ..................8.00...........2,110
Cinnamon Rolls..........Bread....................2,070..... .............830..........97.......8,300.......... .......12.00...........6,230
Cappuccino................Drink................... ..1,820..................730........105.......7,30 0.................12.00...........5,480
Carrot Cake...............Cake.........................80 0..................850.........98.......3,400..... ............12.00...........2,600
Hot Apple Cider..........Drink......................3,330... ............1,440........100.....14,400........... .....16.00..........11,070
Lemon Meringue Pie...Pie.........................3,160........... .....3,425........138....13,700.................16 .00..........10,540
Banana Bread............Bread.....................1,890.. ..............1,025........110......8,200......... ........16.00...........6,310
Hot Chocolate............Drink........................ .750...................825..........76.....3,300.. ...............16.00...........2,550
Earl Grey Tea............Drink.......................3,120.. ..............1,510........148....15,100.......... .......24.00.........11,980
Red Velvet Cake........Cake........................3,050..... ...........1,225........158....14,700............. ....24.00.........11,650
Sugar Cookies...........Cookies....................2,620 ................1,270........110....12,700........ .........24.00.........10,080
Valentine Cookies......Cookies....................2,520..... ............1,525........146....12,200............ ....24.00...........9,680
Love Potion...............Drink........................ 2,320.................1,120........142....11,200.. ..............24.00...........8,880
Holiday Donut............Bread.......................1,560 .................1,875........130.....7,500....... ..........24.00...........5,940
Latte........................Drink................ .........1,510...................730.........101.. ...7,300................24.00...........5,790
Chocolate Tart..........Pie............................1,240 .................1,500..........99.....6,000...... ..........24.00...........4,760
Pumpkin Pie..............Pie............................2, 670.................1,750..........57....14,000... ............48.00.........11,330

The items closest to the top of the list within the same time frame are the items that provide the greatest (ROI) Return on Investment. You should realize that some items are not worth preparing since there is another items that provides a greater ROI in the same time.

If you have just 4 hours, why make valentine cupcakes or strawberry cake since vanilla cupcakes make more coins in the same as the others?

Vanilla cupcakes and strawberry cake both provide 57 XP points, so vanilla cupcakes is the best thing to bake in 4 hours.

Espresso is the only 4 hour drink, so that is simple.

[Tea For Two]

Thanks for posting! It's great to see other people's strategies. My goal is to bake the things that will give the fastest profit, as I'm trying to expand the bakery without using gems. So I express the time in minutes, and calculate the profit per minute of baking time.

Profit = (Sell - Cost) / Time

Item......................Category....Yield...Cost .....Sell...Time....Profit per min
Brownies.................Cookies.....110......30.. ....110.......1.....80
Chocolate Cookies....Cookies.....140......40......140....... 5.....20
Coffee.....................Coffee......110......30 ......110.......5.....16
Blueberry Muffins......Bread......130.....110......390.....1 5.....18.67
Mocha.....................Coffee......300.....300. ...1200.....30.....26.67
Fruitcake.................Cake........575.....575. ...2300.....60.....25.83
Raspberry Macarons..Cookies...400.....400....1600.....60.... .18
Chamomile Tea.........Tea........275.....275....1100.....60. ....12.17

Brownies are the most profitable, if you have time to sit at the iPhone and keep baking it every minute. After 1 minute you'll have a pile of cookies worth 80 coins, after 2 minutes of cooking its worth 160, etc.
If you order the list by time, you can choose the most profitable dish based on how much time you have available.
Good luck!

[Unregistered]

Thats too funny! I'm glad Im not the only one obsessed with this game. I also made my own food chart. I also made a neighbor chart as well. So I know who has tipped me and sent gifts. This way you know who your good neighbors are, and I make sure I take care of them. If they dont do anything for you in a week or two, and you tip and gift daily I delete them. (sorry). I also do this with Restaurant story and Farm story.