Monthly FF&P Shop Report

Report for January 2015

Overall Results - Current Month

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
$256,535 $149,396 $78,523 $11,966 $58,907 $107,138 $13,635 $200,436 $42,464

Overall Results - Year-to-Date

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
$256,535 $149,396 $78,523 $11,966 $58,907 $107,138 $13,634 $200,436 $42,464

Top Performing Products by Profit

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🍿 popcorn $3,302 $336 $268 $27 $41 $2,966 $0 $222 $3,080
🧇 waffle $3,862 $1,431 $435 $85 $911 $2,431 $0 $1,176 $2,686
🫐 blueberries $1,635 $232 $164 $58 $10 $1,403 $0 $25 $1,610
🥮 moon cake $2,560 $1,186 $307 $28 $851 $1,374 $0 $5,278 −$2,718
🥩 cut of meat $1,614 $289 $242 $38 $9 $1,325 $0 $35 $1,579
🧃 beverage box $1,580 $301 $260 $25 $16 $1,279 $0 $107 $1,473
🍊 tangerine $4,122 $2,857 $714 $113 $2,030 $1,266 $524 $2,124 $1,475
😘 face blowing a kiss $1,902 $672 $660 $1 $11 $1,230 $0 $48 $1,854
🧑‍🚀 astronaut $1,222 $62 $57 $4 $1 $1,160 $33 $1 $1,188
☺️ smiling face $1,974 $853 $834 $1 $18 $1,121 $0 $85 $1,889

Worst Performing Products by Profit

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
😠 angry face $812 $1,048 $160 $2 $886 −$236 $0 $2,210 −$1,398
💌 love letter $582 $724 $282 $1 $441 −$142 $0 $1,382 −$800
😒 unamused face $552 $658 $265 $2 $391 −$106 $0 $713 −$160
😮 face with open mouth $462 $558 $124 $1 $433 −$96 $0 $1,946 −$1,484
👁️‍🗨️ eye in speech bubble $340 $408 $28 $1 $379 −$68 $0 $1,200 −$859
❣️ heart exclamation $432 $483 $256 $3 $224 −$50 $166 $231 $35
🪽 wing $18 $68 $1 $67 $0 −$49 $102 $0 −$83
🐍 snake $63 $111 $7 $104 $0 −$48 $229 $1 −$167
🫡 saluting face $96 $143 $31 $1 $111 −$47 $0 $424 −$327
🐦‍⬛ black bird $37 $80 $5 $75 $0 −$42 $106 $0 −$69

Top Performing Products by Cashflow

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🍿 popcorn $3,302 $336 $268 $27 $41 $2,966 $0 $222 $3,080
🧇 waffle $3,862 $1,431 $435 $85 $911 $2,431 $0 $1,176 $2,686
☺️ smiling face $1,974 $853 $834 $1 $18 $1,121 $0 $85 $1,889
😘 face blowing a kiss $1,902 $672 $660 $1 $11 $1,230 $0 $48 $1,854
🫐 blueberries $1,635 $232 $164 $58 $10 $1,403 $0 $25 $1,610
🥩 cut of meat $1,614 $289 $242 $38 $9 $1,325 $0 $35 $1,579
🍊 tangerine $4,122 $2,857 $714 $113 $2,030 $1,266 $524 $2,124 $1,475
🧃 beverage box $1,580 $301 $260 $25 $16 $1,279 $0 $107 $1,473
💟 heart decoration $1,222 $439 $430 $2 $6 $784 $0 $12 $1,211
🧑‍🚀 astronaut $1,222 $62 $57 $4 $1 $1,160 $33 $1 $1,188

Top Performing Private-Brand Products by Profit

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🍿 popcorn $3,302 $336 $268 $27 $41 $2,966 $0 $222 $3,080
🧇 waffle $3,862 $1,431 $435 $85 $911 $2,431 $0 $1,176 $2,686
🫐 blueberries $1,635 $232 $164 $58 $10 $1,403 $0 $25 $1,610
🥮 moon cake $2,560 $1,186 $307 $28 $851 $1,374 $0 $5,278 −$2,718
🥩 cut of meat $1,614 $289 $242 $38 $9 $1,325 $0 $35 $1,579
🧃 beverage box $1,580 $301 $260 $25 $16 $1,279 $0 $107 $1,473
🍊 tangerine $4,122 $2,857 $714 $113 $2,030 $1,266 $524 $2,124 $1,475
🍹 tropical drink $1,545 $446 $140 $34 $272 $1,100 $0 $1,174 $371
🍋 lemon $1,092 $175 $109 $55 $11 $917 $0 $29 $1,063
🥬 leafy green $990 $190 $142 $43 $5 $800 $0 $19 $971

Worst Performing Private-Brand Products by Profit

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🪽 wing $18 $68 $1 $67 $0 −$49 $102 $0 −$83
🐍 snake $63 $111 $7 $104 $0 −$48 $229 $1 −$167
🐦‍⬛ black bird $37 $80 $5 $75 $0 −$42 $106 $0 −$69
🪿 goose $72 $101 $6 $94 $0 −$29 $107 $0 −$35
🥀 wilted flower $29 $57 $3 $54 $0 −$28 $0 $1 $28
🪼 jellyfish $14 $40 $1 $38 $0 −$26 $103 $0 −$89
🪻 hyacinth $42 $67 $3 $64 $0 −$25 $105 $0 −$63
🍁 maple leaf $35 $55 $4 $50 $0 −$20 $0 $1 $34
🐱 cat face $25 $44 $2 $42 $1 −$20 $102 $2 −$79
💐 bouquet $44 $59 $6 $52 $0 −$15 $0 $1 $42

Top Performing New Products

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🩵 light blue heart $224 $88 $86 $3 $0 $135 $105 $0 $119
🎵 musical note $255 $165 $99 $5 $61 $90 $128 $74 $53
🩷 pink heart $89 $34 $29 $5 $0 $55 $43 $0 $45
🟰 heavy equals sign $54 $29 $21 $7 $0 $26 $37 $1 $16
🪈 flute $45 $19 $13 $2 $4 $26 $24 $5 $16
🪪 identification card $47 $21 $5 $3 $13 $26 $22 $19 $6
🛜 wireless $24 $8 $6 $1 $0 $16 $19 $0 $5
🙂‍↕️ head shaking vertically $8 $4 $2 $2 $0 $4 $6 $0 $2
🫨 shaking face $23 $8 $6 $2 $0 $14 $22 $0 $1
🫎 moose $114 $108 $13 $96 $0 $5 $113 $0 $0

Products Discontinued This Month

Revenue CoGS CoGS - Purchase CoGS - Order CoGS - Holding Profit Order Cost Inventory Cost Cashflow
🤟 love-you gesture $13 $12 $9 $0 $3 $1 $0 $46 −$33

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
93 57 1.6 2.6 17 $1,238.41 $861.93
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
🐯 tiger face no 17 59 $175.82 $152.81
🐄 cow no 12 25 $156.00 $139.25
🫘 beans yes 6 14 $78.82 $71.26
🚶‍♀️ woman walking yes 9 39 $108.42 $59.28
🇹🇬 flag Togo no 4 9 $98.82 $53.28
🐍 snake no 7 22 $43.12 $37.62
☢️ radioactive no 8 10 $39.80 $30.10
👨‍🌾 man farmer no 7 21 $75.18 $27.93
🍏 green apple yes 6 27 $26.19 $22.41
🏨 hotel no 4 8 $28.64 $20.00

Environment

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