ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Account Level PerformanceOct 2025Nov 2025Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026May 2026June 2026July 2026Aug 2026Sep 2026Oct 2026Nov 2026Dec 2026Jan 2027
3
Actual Total Sales$53,012$46,845$41,325$16,792$16,111$24,539$42,495$68,136$74,119$76,814$86,678$0$0$0$0$0
4
Expected Total Sales$54,463$47,986$51,179$52,310$20,655$18,420$45,830$86,268$81,924$82,829$82,373$85,013$95,556$100,231$104,907$110,359
5
Total Sales Difference▼ 2.66%▼ 2.38%▼ 19.25%▼ 67.90%▼ 22.00%▲ 33.22%▼ 7.28%▼ 21.02%▼ 8.72%▼ 7.26%▲ 5.23%
6
Total CoGS$18,032$16,984$14,869$6,383$6,432$9,196$14,914$21,489$24,519$23,419$28,086$29,109$32,324$33,908$35,491$37,358
7
Total Ad Cost-$5,837.28-$2,094.04-$1,418.02-$2,893.66-$4,170.61-$7,742.84-$6,243.87-$13,339.39-$17,197.10$0.00$0.00$0.00$0.00$0.00
8
Expected Net Profit-$3,865-$1,266$2,644$2,497$1,618$1,851$1,099$1,775$10,268$13,917$11,245$11,918$14,629$16,885$17,665$18,808
9
Actual Net Profit-$2,317-$42$4,088$1,365$2,289$3,559$6,917$13,559$15,307$7,913$6,923$0$0$0$0$0
10
Expected Net Margin-7%-3%5%5%8%10%2%2%13%17%14%14%15%17%17%17%
11
Actual Net Margin-4.37%-0.09%9.89%8.13%14.21%14.50%16.28%19.90%20.65%10.30%7.99%
12
Net Margin Difference▲ 38.40%▲ 96.64%▲ 91.48%▲ 70.23%▲ 81.32%▲ 44.32%▲ 578.86%▲ 867.36%▲ 63.33%▼ 38.69%▼ 41.49%
13
Expected Amazon Payout$15,240$16,524$18,348$7,573$8,680$12,461$21,359$34,879$39,946$30,310$35,885$41,027$46,953$50,792$53,156$56,166
14
15
Oct 2025Nov 2025Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026May 2026June 2026July 2026Aug 2026Sep 2026Oct 2026Nov 2026Dec 2026Jan 2027
16
FFMST1Actual Core Units Sold533467282152028637470071161691600000
17
Add Estimations Manually (Monthly)Expected Core Units Sold500450300300150160350600800600600550950100010501100
18
Core Units Sold Difference▲ 6.60%▲ 3.78%▼ 6.00%▼ 49.33%▲ 12.00%▲ 78.75%▲ 6.86%▲ 16.67%▼ 11.13%▲ 2.67%▲ 52.67%
19
Average Price Core Unit$35.30$32.88$33.36$32.46$32.94$31.79$32.80$32.97$14.84$15.94$14.65$14.65$14.65$14.65$14.65$14.65
20
CoGS per Core Unit$13.7$13.9$13.8$14.4$14.1$13.8$14.0$12.1$4.8$4.9$4.7$4.7$4.7$4.7$4.7$4.7
21
Total CoGS$7,328$6,471$3,899$2,187$2,367$3,945$5,222$8,471$3,386$3,048$4,270$2,564$4,429$4,662$4,895$5,128
22
Total Ad Cost-$1,601.85-$444.29-$236.08-$472.92-$239.73-$595.91-$1,071.04-$1,362.10-$2,702.97$0.00$0.00$0.00$0.00$0.00
23
Expected Net Profit$882.50$1,331.61$1,000.75$973.91$494.14$762.86$918.48$1,582.54$1,781.15$1,913.24$1,318.11$1,208.27$2,087.01$2,636.22$2,768.03$2,899.84
24
Actual Net Profit$2,185.95$750.15$287.57$521.65$1,092.47$1,517.48$1,131.72$6,493.99$2,508.15$1,487.23$1,259.31$0.00$0.00$0.00$0.00$0.00
25
Add Estimations Manually (Monthly)Expected Net Margin5%9%10%10%10%15%8%8%15%20%15%15%15%18%18%18%
26
Actual Net Margin11.62%4.89%3.06%10.57%19.74%16.69%9.22%28.14%23.77%15.14%9.39%
27
Net Margin Difference▲ 132.36%▼ 45.72%▼ 69.43%▲ 5.72%▲ 97.40%▲ 11.28%▲ 15.31%▲ 251.73%▲ 58.44%▼ 24.29%▼ 37.42%
28
Lead TIme with Buffer (Days)Expected Amazon Payout$9,285.65$7,023.83$3,850.17$2,708.95$3,403.30$5,355.14$6,354.02$14,733.63$5,901.97$4,428.59$5,809.47$3,772.18$6,515.58$7,297.88$7,662.77$8,027.67
29
150Check Every MonthCore Units Available1140220210551055892.0742.09,582.009,232.008,632.007,832.007,232.006,632.0015,682.0014,732.0013,732.0012,682.00
30
Core Units Forecast1140175210721072742.09,582.09,232.008,632.007,832.007,232.006,632.0015,682.0014,732.0013,732.0012,682.0011,582.00
31
Double Check the Sales VelocityDays of Stock Forecast68147106106178139821462324392362362495442392346
32
Check Every Month and Replace with real numbersNew Supply0000090000000096000000
33
Comments
34
35
Oct 2025Nov 2025Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026May 2026June 2026July 2026Aug 2026Sep 2026Oct 2026Nov 2026Dec 2026Jan 2027
36
FFMDL1Actual Core Units Sold272221120694916124428725336529900000
37
Add Estimations Manually (Monthly)Expected Core Units Sold26030032034010050250320340300400420440460480500
38
Core Units Sold Difference▲ 4.62%▼ 26.33%▼ 62.50%▼ 79.71%▼ 51.00%▲ 222.00%▼ 2.40%▼ 10.31%▼ 25.59%▲ 21.67%▼ 25.25%
39
Average Price Core Unit$31.81$30.84$30.83$31.50$32.54$31.35$31.69$31.85$40.62$25.98$25.92$25.92$25.92$25.92$25.92$25.92
40
CoGS per Core Unit$12.0$12.6$12.7$12.3$11.6$12.1$11.9$10.2$13.4$8.2$8.4$8.4$8.4$8.4$8.4$8.4
41
Total CoGS$3,267$2,784$1,528$846$566$1,949$2,900$2,936$3,395$3,007$2,504$3,517$3,684$3,852$4,019$4,187
42
Total Ad Cost-$446.18-$155.94-$173.60-$344.59-$414.22-$506.25-$704.27-$1,933.61-$2,761.96$0.00$0.00$0.00$0.00$0.00
43
Expected Net Profit$413.49$647.63-$1,479.66-$1,606.63$227.81$0.00$475.29$611.43$2,071.71$1,558.92$1,243.97$1,306.17$1,368.37$2,145.85$2,239.15$2,332.45
44
Actual Net Profit$797.27$65.33-$316.82$194.88-$70.28$1,134.17$1,820.75$2,366.47$2,238.47$618.62-$1,066.35$0.00$0.00$0.00$0.00$0.00
45
Add Estimations Manually (Monthly)Expected Net Margin5%7%-15%-15%7%0%6%6%15%20%12%12%12%18%18%18%
46
Actual Net Margin9.22%0.96%-8.56%8.97%-4.41%22.47%23.55%25.89%21.78%6.52%-13.76%
47
Net Margin Difference▲ 84.31%▼ 86.31%▲ 42.90%▲ 159.77%▼ 162.96%#DIV/0!▲ 292.50%▲ 331.54%▲ 45.20%▼ 67.38%▼ 214.68%
48
Lead TIme with Buffer (Days)Expected Amazon Payout$4,023.35$2,745.33$1,155.90$1,030.16$484.60$3,059.37$4,711.07$5,213.51$5,502.94$3,601.34$1,476.49$4,823.17$5,052.85$5,997.81$6,258.58$6,519.35
49
120Check Every MonthCore Units Available12992208248221812,145.02,045.06,995.006,745.006,425.006,085.005,785.005,385.0015,965.0015,525.0015,065.0014,585.00
50
Core Units Forecast10391908248724872,045.06,995.06,745.006,425.006,085.005,785.005,385.0015,965.0015,525.0015,065.0014,585.0014,085.00
51
Double Check the Sales VelocityDays of Stock Forecast150221233192644122783963256760943438510891013942875
52
Check Every Month and Replace with real numbersNew Supply00000500000000110000000
53
Comments
54
55
Oct 2025Nov 2025Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026May 2026June 2026July 2026Aug 2026Sep 2026Oct 2026Nov 2026Dec 2026Jan 2027
56
FFBT1Actual Core Units Sold40772282133507512919212111200000
57
Add Estimations Manually (Monthly)Expected Core Units Sold50801501504050100250175220230240250260270280
58
Core Units Sold Difference▼ 20.00%▼ 3.75%▲ 52.00%▼ 86.00%▼ 17.50%-▼ 25.00%▼ 48.40%▲ 9.71%▼ 45.00%▼ 51.30%
59
Average Price Core Unit$32.99$32.88$32.96$32.91$32.99$32.96$32.95$32.94$28.68$30.52$31.47$31.47$31.47$31.47$31.47$31.47
60
CoGS per Core Unit$11.1$11.1$11.1$14.3$26.0$11.1$10.8$9.0$10.0$9.5$8.9$8.9$8.9$8.9$8.9$8.9
61
Total CoGS$445$857$2,538$301$857$557$813$1,155$1,916$1,153$997$2,136$2,225$2,314$2,403$2,492
62
Total Ad Cost-$519.91-$60.12-$60.36-$126.88-$136.94-$166.58-$588.28-$667.80-$761.12$0.00$0.00$0.00$0.00$0.00
63
Expected Net Profit-$494.85-$526.15$741.62$740.50$0.00$32.96$0.00$0.00$752.80$1,007.00$1,302.80$1,359.44$1,416.08$1,472.72$1,529.37$1,586.01
64
Actual Net Profit-$402.46$38.67$1,795.50-$161.07-$81.37$501.93$698.21$1,244.92$859.41$484.36$423.54$0.00$0.00$0.00$0.00$0.00
65
Add Estimations Manually (Monthly)Expected Net Margin-30%-20%15%15%0%2%0%0%15%15%18%18%18%18%18%18%
66
Actual Net Margin-30.50%1.53%23.89%-23.31%-7.47%30.46%28.26%29.30%15.61%13.12%12.02%
67
Net Margin Difference▼ 1.66%▲ 107.64%▲ 59.28%▼ 255.37%#DIV/0!▲ 1422.99%#DIV/0!-▲ 4.05%▼ 12.55%▼ 33.24%
68
Lead TIme with Buffer (Days)Expected Amazon Payout$31.61$884.55$4,277.49$128.31$786.77$1,058.43$1,488.90$2,352.54$2,789.62$1,598.48$1,434.11$3,495.59$3,641.24$3,786.89$3,932.54$4,078.19
69
120Check Every MonthCore Units Available308742126391360.0320.02702,170.001,920.001,745.001,525.001,295.004,043.003,793.003,533.003,263.00
70
Core Units Forecast308742284284320.0270.02,170.001,920.001,745.001,525.001,295.004,043.003,793.003,533.003,263.002,983.00
71
Double Check the Sales VelocityDays of Stock Forecast185278257827019281260329238199162485438393350
72
Check Every Month and Replace with real numbersNew Supply0000002000000029880000
73
Comments
74
75
Oct 2025Nov 2025Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026May 2026June 2026July 2026Aug 2026Sep 2026Oct 2026Nov 2026Dec 2026Jan 2027
76
FFBT1BActual Core Units Sold47852283337415712621818713700000
77
Add Estimations Manually (Monthly)Expected Core Units Sold50801501504050100250175250260270280290300320
78
Core Units Sold Difference▼ 6.00%▲ 6.25%▲ 52.00%▼ 78.00%▼ 7.50%▼ 18.00%▼ 43.00%▼ 49.60%▲ 24.57%▼ 25.20%▼ 47.31%
79
Average Price Core Unit$35.99$35.91$35.88$35.99$35.02$35.73$35.33$35.86$41.68$30.39$41.85$41.85$41.85$41.85$41.85$41.85
80
CoGS per Core Unit$12.3$12.3$12.3$12.7$12.6$12.3$12.0$11.0$14.6$9.5$14.0$14.0$14.0$14.0$14.0$14.0
81
Total CoGS$578$1,046$2,804$418$467$504$684$1,380$3,187$1,769$1,916$3,776$3,916$4,055$4,195$4,475
82
Total Ad Cost-$1,480.46-$379.42-$328.34-$596.34-$727.05-$1,135.66-$243.55-$644.89-$605.93$0.00$0.00$0.00$0.00$0.00
83
Expected Net Profit-$539.85-$574.51$538.22$539.85$0.00$89.33$0.00$0.00$1,094.09$1,519.65$1,958.59$2,033.92$2,109.25$2,184.58$2,259.91$2,410.57
84
Actual Net Profit-$604.47-$633.79$1,289.99-$97.87$111.47-$102.23-$31.04$553.25$2,713.75$1,124.71$1,067.33$0.00$0.00$0.00$0.00$0.00
85
Add Estimations Manually (Monthly)Expected Net Margin-30%-20%10%10%0%5%0%0%15%20%18%18%18%18%18%18%
86
Actual Net Margin-35.74%-20.77%15.77%-8.24%8.60%-6.98%-1.54%12.24%29.87%19.79%18.62%
87
Net Margin Difference▼ 19.12%▼ 3.83%▲ 57.68%▼ 182.41%#DIV/0!▼ 239.56%#DIV/0!#DIV/0!▲ 99.11%▼ 1.05%▲ 3.42%
88
Lead TIme with Buffer (Days)Expected Amazon Payout-$26.37$350.21$4,082.09$344.93$578.87$389.77$664.81$1,911.05$5,818.13$2,844.07$3,065.79$5,809.66$6,024.84$6,240.01$6,455.18$6,885.53
89
120Check Every MonthCore Units Available16382957745.05.0-451,855.001,605.001,430.001,180.00920.003,638.003,358.003,068.002,768.00
90
Core Units Forecast163021141145.0-45.01,855.001,605.001,430.001,180.00920.003,638.003,358.003,068.002,768.002,448.00
91
Double Check the Sales VelocityDays of Stock Forecast103021915343-14223275172136102390347307260
92
Check Every Month and Replace with real numbersNew Supply0000002000000029880000
93
Comments
94
95
Oct 2025Nov 2025Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026May 2026June 2026July 2026Aug 2026Sep 2026Oct 2026Nov 2026Dec 2026Jan 2027
96
FFMLB1Actual Core Units Sold266469227127621273412582861118800000
97
Add Estimations Manually (Monthly)Expected Core Units Sold20045015015013080150530500650680710750790830870
98
Core Units Sold Difference▲ 33.00%▲ 4.22%▲ 51.33%▼ 15.33%▼ 52.31%▼ 85.00%▼ 51.33%▼ 22.26%▲ 16.40%▲ 32.46%▲ 74.71%
99
Average Price Core Unit$9.20$9.54$9.53$9.53$9.45$9.50$9.02$9.33$19.90$19.10$19.32$19.32$19.32$19.32$19.32$19.32
100
CoGS per Core Unit$2.7$2.8$2.8$2.8$2.8$3.4$2.7$2.7$6.5$6.0$6.5$6.5$6.5$6.5$6.5$6.5