Jennifer Omanu | Freelancer Sales/ Revenue Dashboard

Sales/ Revenue dashboard

KPI OVERVIE DASHBOARD DATA MONTHLY REVENUE TOTALS Revenue Stream 41100 Cone Sales MARCH APRIL 3,150,915 2,193,055 41200 E-Commerce Sales 242,827 279,495 41300 Wholesale Sales 337,295 185,470 REVENUE - A/R - COLLECTION TREND MARCH APRIL SALES 3,731,037 2,658,020 A/R BALANCE 7,538,368 7,078,481 COLLECTION 1,630,363 1,923,315 AVERAGE ORDER VALUE Revenue Stream 41100 Cone Sales 41200 E-Commerce Sales 41300 Wholesale Sales MARCH APRIL #REF! #REF! #REF! #REF! #REF! #REF! MARCH APRIL CUSTOMER LIFETIME VALUE Number of Purchases Number of Customers Average Frequency Average Purchase Value (APV) Customer Lifespan (estimate in years) Customer Lifetime Value $ $ -,-,347.36 CONES TOP SELLING SKUs Product Code HS-109-26-NB-800 GTI-109-26-CW-CSTM-800 CC-109-26-NB-800 HS-109-26-CW-800 HS-84-26-NB-900 CC-84-26-NB-900 HS-98-26-NB-800 CC-STIIIZY-109-26-DB-BC-BLUE-2126C OB70CN CC-STIIIZY-109-26-DB-BC-RED-1805C CC-STIIIZY-109-26-DB-BC-GREEN-802C CC-STIIIZY-109-26-DB-BC-YELLOW-106C CC-109-26-CW-800 HPOCB70CLCN HPOCB70BBCN OB14CN JBCN14VR CC-STIIIZY-109-26-DB-BC-PINK-2038C HPOCB14CLCN HPOCB14BBCN MARCH APRIL 145,-,-,-,-,707.60 72,-,-,-,-,-,-,-,469.12 52,-,-,-,-,-,944.64 1,-,-,-,-,865.60 6,-,-,454.40 106,-,-,-,-,-,-,-,-,-,-,372.80 WHOLESALE TOP SELLING SKUs Product Code HMP-QH-POP-FULL $ WP0923 $ WP1122 $ WP0224 $ WP0124 $ WP0521 $ JWP0124 $ SF-CACTUS $ WP0223 $ WP0423 $ JWP0324 $ WP0324 $ JWP0224 $ JWP142 $ JWP0923 $ WP0422 $ DISPLAY-HMP-HITTER-QUICK-GRAPE $ JWP1023 $ WP0122 $ DISPLAY-HMP-HITTER-QUICK-WATERMELON $ MARCH 3,106.19 3,337.93 4,357.46 1,890.00 1,292.12 4,246.56 1,-,532.26 2,-,-,081.19 1,226.18 1,935.89 1,-,149.00 1,500.00 APRIL $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 11,988.00 3,952.60 6,189.00 3,158.57 4,161.19 3,360.02 5,-,814.82 3,585.64 4,368.80 2,109.67 3,588.37 3,808.44 5,131.18 2,597.32 1,248.00 4,142.05 1,559.57 1,248.00 E-COMMERCE TOP SELLING SKUs Product Code PAST-0324-BOX-KIT PAST-0424-BOX-KIT PAST-0624-BOX-KIT PAST-0524-BOX-KIT PAST-0724-BOX-KIT PAST-0824-BOX-KIT HMP-BOX-XL-0424 HMP-BOX-XL-0324 PROTECTPLUS34 HMP-BOX-XL-0524 PIPE-VAPE-WOOD PAST-0224-BOX-KIT HMP-BOX-XL-0624 HMP-BOX-XL-0724 WP0224 HMP-BOX-XL-0824 WP0923 ASH-CATCHER-PLUS-BLACK WP1122 HMP-BOX-XL-0224 MARCH $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 71,-,434.49 5,113.07 2,-,-,238.79 1,839.93 1,-,557.48 APRIL $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 3,-,-,659.98 4,480.00 6,599.05 3,258.39 2,450.02 5,297.85 3,769.29 4,385.80 4,- CONE SALES BY REGION Region MARCH UNITED STATES CANADA FRANCE THAILAND SPAIN BRAZIL SLOVAKIA MOROCCO JAPAN - APRIL $3,019,894 $157,331 $83,685 $9,151 $0 $4,000 $0 $0 $237 -$123,384 $2,008,573 $184,482 $0 $0 $0 $0 $0 $0 $0 $0 WHOLESALE SALES BY REGION Region UNITED STATES SOUTH AFRICA NETHERLANDS SPAIN MARCH $ $ $ $ $ 159,-,432.38 - APRIL $ $ $ $ $ 180,375.88 - CHILE JAPAN TAIWAN MOROCCO MEXICO HONG KONG GERMANY SWITZERLAND THAILAND SLOVAKIA CANADA $ $ $ $ $ $ $ $ $ $ $ 9,493.56 2,- - $ $ $ $ $ $ $ $ $ $ $ 489.13 2,581.39 1,690.16 1,169.76 (836.63) CONES (3/24 - 8/24) $ $ MAY JUNE JULY AUGUST 1,979,512 2,574,918 2,530,571 2,298,591 232,672 209,436 210,391 151,019 211,913 222,211 219,012 200,449 MAY JUNE JULY 2,424,097 3,006,566 2,959,975 2,650,059 6,240,891 6,926,549 6,300,638 5,240,787 1,920,214 1,266,738 2,283,333 2,416,377 MAY JUNE JULY AUGUST #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! MAY JUNE JULY AUGUST -,133.26 $ 5 130,200.56 $ -,193.01 $ 5 101,566.18 $ -,178.23 $ 5 92,196.48 $ AUGUST -,-,608.57 SEPTEMBER OCTOBER SEPTEMBER OCTOBER SEPTEMBER OCTOBER SEPTEMBER OCTOBER MAY JUNE 106,-,-,-,-,-,-,641.48 JULY 223,-,-,-,-,112.64 9,-,-,-,-,-,-,-,568.00 74,649.60 22,-,-,-,961.60 8,985.60 AUGUST 95,-,-,-,-,-,801.40 8,-,324.16 68,-,-,889.28 81,-,-,-,030.00 179,-,-,851.00 9,-,-,-,-,-,-,-,-,835.52 4,145.58 48,107.52 35,-,961.60 8,908.80 SEPTEMBER OCTOBER SEPTEMBER OCTOBER 79,-,971.84 MAY $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 6,901.69 3,091.14 1,983.99 4,695.86 2,124.29 3,014.29 3,040.37 1,608.17 1,600.29 1,170.94 2,865.37 2,651.00 3,705.37 4,082.52 2,932.87 2,696.20 2,847.26 2,449.02 3,447.90 2,877.27 JUNE $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 9,396.00 6,954.82 3,222.37 3,846.87 5,805.31 2,342.50 2,614.93 1,306.42 3,115.00 1,202.32 2,677.43 3,415.00 1,895.67 1,168.14 4,578.12 4,272.00 1,537.36 3,612.00 4,204.26 JULY $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 4,356.00 3,170.00 3,285.00 5,154.00 2,719.32 1,539.00 2,-,246.29 2,030.00 4,025.51 2,230.00 3,253.01 2,643.93 1,650.00 2,-,-,764.00 AUGUST $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 4,320.00 3,728.87 2,079.49 1,806.31 3,884.79 3,-,419.38 1,562.00 3,150.15 1,-,028.49 1,-,024.57 1,- MAY $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 80.01 1,-,614.61 4,190.00 5,-,784.50 2,-,222.64 1,742.71 1,658.48 1,709.72 - JUNE $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ MAY 199,798.02 (14,-,758.40 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 185,420.47 (11,-,441.60 - OCTOBER SEPTEMBER OCTOBER SEPTEMBER OCTOBER $1,943,415 $325,301 $0 $0 $0 $0 $1,314 $0 $0 $28,560 JULY $ $ $ $ $ SEPTEMBER -,069.51 4,-,-,-,461.00 1,-,320.26 - AUGUST $2,245,476 $247,952 $29,030 $0 $0 $0 $0 $0 $0 $8,113 JUNE $ $ $ $ $ 100.00 4,-,-,-,-,-,107.00 2,360.64 2,- - AUGUST JULY $2,281,187 $285,788 $0 -$20 $4,700 $0 $0 $449 $0 $2,814 MAY 202,-,939.72 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ JUNE $1,926,735 $51,021 $0 $0 $1,756 $0 $0 $0 $0 $0 $ $ $ $ $ -,116.60 1,-,285.37 1,812.50 6,-,362.51 1,091.82 2,365.13 1,525.01 1,181.81 - JULY AUGUST $ $ $ $ $ 161,709.12 (9,-,663.30 (996.00) $ $ $ $ $ $ $ $ $ $ $ 1,267.53 1,756.37 - $ $ $ $ $ $ $ $ $ $ $ 1,938.44 9,- (4,629.30) $ $ $ $ $ $ $ $ $ $ $ 1,517.00 2,402.53 2,- - $ $ $ $ $ $ $ $ $ $ $ 11,728.00 1,775.78 1,- - - Revenue ($) - - WHOLESALE (3/24 - 8/24) NOVEMBER DECEMBER JANUARY FEBRUARY MARCH NOVEMBER DECEMBER JANUARY FEBRUARY MARCH NOVEMBER DECEMBER JANUARY FEBRUARY MARCH NOVEMBER DECEMBER JANUARY FEBRUARY MARCH NOVEMBER DECEMBER JANUARY FEBRUARY MARCH Total $823,082.17 $500,016.00 $491,124.60 $423,713.47 $378,796.60 $330,134.70 $316,215.68 $308,244.48 $295,833.60 $289,536.00 $282,408.96 $277,954.56 $246,593.16 $231,137.28 $231,137.28 $230,031.36 $215,654.40 $187,975.68 $187,799.04 $187,799.04 NOVEMBER DECEMBER JANUARY FEBRUARY MARCH Total $40,067.88 $24,235.36 $21,117.31 $20,551.61 $19,987.02 $18,459.73 $15,859.68 $15,843.04 $15,654.37 $15,162.18 $13,804.17 $13,552.47 $13,257.21 $12,818.78 $12,742.73 $12,472.30 $12,451.63 $12,324.18 $12,276.11 $12,133.53 NOVEMBER DECEMBER JANUARY FEBRUARY MARCH Total $75,612.63 $68,413.60 $62,954.66 $54,951.35 $54,043.02 $37,069.51 $36,839.93 $34,914.49 $31,458.94 $24,166.97 $21,829.25 $20,165.21 $20,004.95 $15,107.00 $12,886.63 $12,461.00 $12,452.93 $10,884.77 $10,864.05 $10,682.48 NOVEMBER DECEMBER JANUARY FEBRUARY MARCH Total $13,425,281.43 $1,251,874.67 $112,715.04 $9,131.40 $6,456.00 $4,000.00 $1,314.30 $449.28 $237.00 -$83,897.21 NOVEMBER DECEMBER JANUARY FEBRUARY MARCH Total $1,089,982.87 $129,633.76 $38,441.60 $34,663.30 $34,702.12 $11,728.00 $11,499.69 $9,965.67 $9,671.44 $4,123.00 $2,914.14 $2,842.78 $1,169.76 $403.20 $75.00 -$5,465.93 Enhanced Monthly Revenue Trends MONTHLY REVENUE TOTALS 1 2 3 Month 4