Monthly FF&P Shop Report

Report for February 2015

Overall Results - Current Month

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
$231,922 $199,910 $71,896 $12,273 $115,741 $32,012 $50,863 $110,889 $70,170

Overall Results - Year-to-Date

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
$488,457 $349,306 $150,419 $24,239 $174,648 $139,151 $64,497 $311,325 $112,634

Top Performing Products by Profit

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🧇 waffle $2,722 $966 $294 $121 $551 $1,756 $574 $334 $1,813
🧃 beverage box $1,722 $361 $283 $27 $50 $1,362 $0 $68 $1,655
🍿 popcorn $1,536 $176 $125 $13 $39 $1,360 $0 $142 $1,395
🍊 tangerine $3,040 $1,743 $535 $145 $1,063 $1,297 $393 $1,186 $1,460
🫐 blueberries $1,495 $226 $140 $67 $19 $1,269 $180 $5 $1,310
😌 relieved face $2,160 $974 $966 $4 $4 $1,186 $689 $2 $1,470
😘 face blowing a kiss $1,818 $664 $630 $1 $33 $1,154 $0 $23 $1,795
🥩 cut of meat $1,353 $255 $203 $32 $20 $1,098 $0 $17 $1,336
🧑‍🚀 astronaut $1,114 $57 $50 $6 $0 $1,058 $59 $1 $1,055
☺️ smiling face $1,714 $770 $724 $1 $45 $943 $0 $45 $1,668

Worst Performing Products by Profit

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🤬 face with symbols on mouth $6,359 $9,273 $2,116 $3 $7,155 −$2,914 $1,142 $2,150 $3,067
🍚 cooked rice $1,500 $2,954 $198 $34 $2,722 −$1,454 $0 $2,221 −$721
😠 angry face $927 $2,085 $178 $2 $1,905 −$1,158 $120 $783 $24
💌 love letter $570 $1,564 $276 $1 $1,286 −$994 $0 $453 $117
😮 face with open mouth $460 $1,351 $123 $1 $1,227 −$891 $0 $975 −$514
🙊 speak-no-evil monkey $893 $1,751 $228 $1 $1,521 −$858 $0 $904 −$10
☹️ frowning face $707 $1,464 $286 $1 $1,177 −$757 $0 $1,376 −$669
🍺 beer mug $1,266 $1,847 $112 $21 $1,715 −$581 $0 $3,307 −$2,041
❤️‍🔥 heart on fire $378 $912 $58 $1 $852 −$533 $0 $356 $22
🖤 black heart $1,662 $2,196 $942 $2 $1,252 −$533 $559 $434 $669

Top Performing Products by Cashflow

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🤬 face with symbols on mouth $6,359 $9,273 $2,116 $3 $7,155 −$2,914 $1,142 $2,150 $3,067
🧇 waffle $2,722 $966 $294 $121 $551 $1,756 $574 $334 $1,813
😘 face blowing a kiss $1,818 $664 $630 $1 $33 $1,154 $0 $23 $1,795
☺️ smiling face $1,714 $770 $724 $1 $45 $943 $0 $45 $1,668
🧃 beverage box $1,722 $361 $283 $27 $50 $1,362 $0 $68 $1,655
😌 relieved face $2,160 $974 $966 $4 $4 $1,186 $689 $2 $1,470
🍊 tangerine $3,040 $1,743 $535 $145 $1,063 $1,297 $393 $1,186 $1,460
🍿 popcorn $1,536 $176 $125 $13 $39 $1,360 $0 $142 $1,395
🥩 cut of meat $1,353 $255 $203 $32 $20 $1,098 $0 $17 $1,336
🫐 blueberries $1,495 $226 $140 $67 $19 $1,269 $180 $5 $1,310

Top Performing Private-Brand Products by Profit

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🧇 waffle $2,722 $966 $294 $121 $551 $1,756 $574 $334 $1,813
🧃 beverage box $1,722 $361 $283 $27 $50 $1,362 $0 $68 $1,655
🍿 popcorn $1,536 $176 $125 $13 $39 $1,360 $0 $142 $1,395
🍊 tangerine $3,040 $1,743 $535 $145 $1,063 $1,297 $393 $1,186 $1,460
🫐 blueberries $1,495 $226 $140 $67 $19 $1,269 $180 $5 $1,310
🥩 cut of meat $1,353 $255 $203 $32 $20 $1,098 $0 $17 $1,336
🥬 leafy green $927 $187 $133 $40 $14 $740 $0 $7 $920
🥖 baguette bread $915 $209 $73 $131 $4 $706 $136 $1 $778
🍹 tropical drink $1,625 $924 $147 $36 $741 $701 $0 $592 $1,033
🍲 pot of food $673 $99 $61 $23 $15 $574 $0 $22 $651

Worst Performing Private-Brand Products by Profit

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🍚 cooked rice $1,500 $2,954 $198 $34 $2,722 −$1,454 $0 $2,221 −$721
🍺 beer mug $1,266 $1,847 $112 $21 $1,715 −$581 $0 $3,307 −$2,041
🥕 carrot $758 $1,067 $103 $63 $901 −$309 $185 $307 $265
🥒 cucumber $740 $1,038 $138 $42 $859 −$298 $0 $630 $110
🥮 moon cake $1,937 $2,199 $233 $21 $1,945 −$261 $0 $3,456 −$1,518
🧂 salt $281 $506 $30 $42 $433 −$225 $117 $174 −$10
🥠 fortune cookie $275 $488 $36 $29 $422 −$212 $0 $475 −$199
🐥 front-facing baby chick $490 $701 $86 $68 $546 −$211 $0 $161 $328
🍴 fork and knife $461 $660 $57 $31 $571 −$199 $0 $692 −$231
🌶️ hot pepper $446 $619 $55 $27 $537 −$173 $0 $770 −$324

Top Performing New Products

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🧎‍♀️‍➡️ woman kneeling facing right $12 $5 $4 $0 $0 $7 $30 $0 −$18
🧎‍➡️ person kneeling facing right $27 $7 $6 $1 $0 $19 $47 $0 −$20
🚶‍♂️‍➡️ man walking facing right $290 $136 $67 $3 $66 $153 $186 $199 −$95

Products Discontinued This Month

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🐠 tropical fish $12 $12 $2 $10 $0 −$0 $0 $1 $11

Lost Sales due to Out-of-Stock

Overall lost revenue and gross profit in current month due to out-of-stock periods.
# SKUs OOS # SKUs with Lost Sales Avg. Days OOS Avg. Days with Lost Sales Max. Days with Lost Sales Lost Revenue Lost Gross Profit
292 202 1.5 2.2 15 $4,015.48 $2,786.19
Products with largest lost gross profit due to out-of-stock periods in current month.
Currently OOS Days OOS Lost Sales Lost Revenue Lost Gross Profit
🧇 waffle no 4 67 $434.16 $385.25
🫐 blueberries no 4 90 $225.00 $202.50
🐨 koala no 15 38 $151.24 $136.04
🪿 goose no 13 30 $119.40 $108.00
🧍 person standing no 2 5 $89.85 $68.00
🌵 cactus no 5 33 $65.01 $58.08
🍏 green apple no 7 56 $54.32 $46.48
😯 hushed face no 4 25 $82.00 $46.25
👳‍♂️ man wearing turban no 8 14 $69.16 $40.88
🫎 moose no 7 9 $44.46 $39.33

Environment

 packageVersion("shopr")
[1] '0.1.0'