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,129$0$0$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,214$85,172$93,266$97,798$102,677$107,556$112,653$118,397
5
Total Sales Difference▼ 2.66%▼ 2.38%▼ 19.25%▼ 67.90%▼ 22.00%▲ 33.22%▼ 7.28%▼ 21.02%▼ 8.72%
6
Total CoGS$18,032$16,984$14,869$6,383$6,432$9,196$14,914$21,489$24,521$28,382$31,040$32,554$34,181$35,808$37,504$39,419
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$0.00$0.00$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$14,215$14,245$15,489$16,371$17,552$18,386$19,321
9
Actual Net Profit-$2,317-$42$4,088$1,365$2,289$3,559$6,917$13,559$15,307$0$0$0$0$0$0$0
10
Expected Net Margin-7%-3%5%5%8%10%2%2%13%17%15%16%16%16%16%16%
11
Actual Net Margin-4.37%-0.09%9.89%8.13%14.21%14.50%16.28%19.90%20.65%
12
Net Margin Difference▲ 38.40%▲ 96.64%▲ 91.48%▲ 70.23%▲ 81.32%▲ 44.32%▲ 578.86%▲ 867.36%▲ 63.33%
13
Expected Amazon Payout$15,240$16,524$18,348$7,573$8,680$12,461$21,359$34,879$39,946$42,597$45,284$48,043$50,552$53,361$55,890$58,740
14
15
Oct 2025Nov 2025Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026May 2026June 2026July 2026Aug 2026Sep 2026Oct 2026Nov 2026Dec 2026Jan 2027
16
FFMST1Actual Core Units Sold53346728215202863747007110000000
17
Add Estimations Manually (Monthly)Expected Core Units Sold500450300300150160350600800600880920970102010701120
18
Core Units Sold Difference▲ 6.60%▲ 3.78%▼ 6.00%▼ 49.33%▲ 12.00%▲ 78.75%▲ 6.86%▲ 16.67%▼ 11.13%
19
Average Price Core Unit$35.30$32.88$33.36$32.46$32.94$31.79$32.80$32.97$14.84$14.84$14.84$14.84$14.84$14.84$14.84$14.84
20
CoGS per Core Unit$13.7$13.9$13.8$14.4$14.1$13.8$14.0$12.1$4.8$4.8$4.8$4.8$4.8$4.8$4.8$4.8
21
Total CoGS$7,328$6,471$3,899$2,187$2,367$3,945$5,222$8,471$3,386$2,857$4,191$4,381$4,619$4,858$5,096$5,334
22
Total Ad Cost-$1,601.85-$444.29-$236.08-$472.92-$239.73-$595.91-$1,071.04$0.00$0.00$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,781.15$2,351.11$2,457.98$2,591.57$2,725.16$2,858.74$2,992.33
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$0.00$0.00$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%18%18%18%18%18%18%
26
Actual Net Margin11.62%4.89%3.06%10.57%19.74%16.69%9.22%28.14%23.77%
27
Net Margin Difference▲ 132.36%▼ 45.72%▼ 69.43%▲ 5.72%▲ 97.40%▲ 11.28%▲ 15.31%▲ 251.73%▲ 58.44%
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,638.57$6,541.99$6,839.36$7,211.06$7,582.77$7,954.47$8,326.17
29
150Check Every MonthCore Units Available1140220210551055892.0742.09,582.009,232.008,632.007,832.007,232.006,352.0015,032.0014,062.0013,042.0011,972.00
30
Core Units Forecast1140175210721072742.09,582.09,232.008,632.007,832.007,232.006,352.0015,032.0014,062.0013,042.0011,972.0010,852.00
31
Double Check the Sales VelocityDays of Stock Forecast68147106106178139821462324392247207465414366321
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 Sold27222112069491612442872530000000
37
Add Estimations Manually (Monthly)Expected Core Units Sold26030032034010050250320340300320340360380400420
38
Core Units Sold Difference▲ 4.62%▼ 26.33%▼ 62.50%▼ 79.71%▼ 51.00%▲ 222.00%▼ 2.40%▼ 10.31%▼ 25.59%
39
Average Price Core Unit$31.81$30.84$30.83$31.50$32.54$31.35$31.69$31.85$40.62$40.62$40.62$40.62$40.62$40.62$40.62$40.62
40
CoGS per Core Unit$12.0$12.6$12.7$12.3$11.6$12.1$11.9$10.2$13.4$13.4$13.4$13.4$13.4$13.4$13.4$13.4
41
Total CoGS$3,267$2,784$1,528$846$566$1,949$2,900$2,936$3,395$4,026$4,295$4,563$4,831$5,100$5,368$5,637
42
Total Ad Cost-$446.18-$155.94-$173.60-$344.59-$414.22-$506.25-$704.27$0.00$0.00$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$2,437.31$2,339.81$2,486.05$2,632.29$2,778.53$2,924.77$3,071.01
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$0.00$0.00$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%18%18%18%18%18%18%
46
Actual Net Margin9.22%0.96%-8.56%8.97%-4.41%22.47%23.55%25.89%21.78%
47
Net Margin Difference▲ 84.31%▼ 86.31%▲ 42.90%▲ 159.77%▼ 162.96%#DIV/0!▲ 292.50%▲ 331.54%▲ 45.20%
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$6,463.54$6,634.47$7,049.12$7,463.78$7,878.43$8,293.08$8,707.74
49
120Check Every MonthCore Units Available12992208248221812,145.02,045.06,995.006,745.006,425.006,085.005,785.005,465.0016,125.0015,765.0015,385.0014,985.00
50
Core Units Forecast10391908248724872,045.06,995.06,745.006,425.006,085.005,785.005,465.0016,125.0015,765.0015,385.0014,985.0014,565.00
51
Double Check the Sales VelocityDays of Stock Forecast15022123319264412278396325676095424821344124511541070
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 Sold4077228213350751291920000000
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%
59
Average Price Core Unit$32.99$32.88$32.96$32.91$32.99$32.96$32.95$32.94$28.68$28.68$28.68$28.68$28.68$28.68$28.68$28.68
60
CoGS per Core Unit$11.1$11.1$11.1$14.3$26.0$11.1$10.8$9.0$10.0$10.0$10.0$10.0$10.0$10.0$10.0$10.0
61
Total CoGS$445$857$2,538$301$857$557$813$1,155$1,916$2,196$2,296$2,395$2,495$2,595$2,695$2,795
62
Total Ad Cost-$519.91-$60.12-$60.36-$126.88-$136.94-$166.58-$588.28$0.00$0.00$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$946.38$1,187.28$1,238.90$1,290.52$1,342.14$1,393.76$1,445.38
64
Actual Net Profit-$402.46$38.67$1,795.50-$161.07-$81.37$501.93$698.21$1,244.92$859.41$0.00$0.00$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%
67
Net Margin Difference▼ 1.66%▲ 107.64%▲ 59.28%▼ 255.37%#DIV/0!▲ 1422.99%#DIV/0!-▲ 4.05%
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$3,142.23$3,482.94$3,634.37$3,785.81$3,937.24$4,088.67$4,240.10
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 Sold4785228333741571262180000000
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%
79
Average Price Core Unit$35.99$35.91$35.88$35.99$35.02$35.73$35.33$35.86$41.68$41.68$41.68$41.68$41.68$41.68$41.68$41.68
80
CoGS per Core Unit$12.3$12.3$12.3$12.7$12.6$12.3$12.0$11.0$14.6$14.6$14.6$14.6$14.6$14.6$14.6$14.6
81
Total CoGS$578$1,046$2,804$418$467$504$684$1,380$3,187$3,655$3,801$3,947$4,094$4,240$4,386$4,678
82
Total Ad Cost-$1,480.46-$379.42-$328.34-$596.34-$727.05-$1,135.66-$243.55$0.00$0.00$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$2,083.97$1,950.60$2,025.62$2,100.64$2,175.67$2,250.69$2,400.74
84
Actual Net Profit-$604.47-$633.79$1,289.99-$97.87$111.47-$102.23-$31.04$553.25$2,713.75$0.00$0.00$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%
87
Net Margin Difference▼ 19.12%▼ 3.83%▲ 57.68%▼ 182.41%#DIV/0!▼ 239.56%#DIV/0!#DIV/0!▲ 99.11%
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$5,738.98$5,751.81$5,973.03$6,194.26$6,415.48$6,636.70$7,079.15
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 Sold2664692271276212734125820000000
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%
99
Average Price Core Unit$9.20$9.54$9.53$9.53$9.45$9.50$9.02$9.33$19.90$19.90$19.90$19.90$19.90$19.90$19.90$19.90
100
CoGS per Core Unit$2.7$2.8$2.8$2.8$2.8$3.4$2.7$2.7$6.5$6.5$6.5$6.5$6.5$6.5$6.5$6.5