Field Legend

Input Cell Modifiable Input

Drop Down▾ Input Selection

Output Fixed Output

Calculation Fixed Calcualtion

Drop-Down▾ Menu Selection

Top Down Planning
Scenario: Budget▾
Year: 2023▾
Period: Mar▾

Product Actuals
Product Manager
Tier Jan-2022

Growth Limit %
25%
979377
979377 AAC (Can,Aaron) 1 1,975
979377 AAC (Can,Aaron) 2
979377 MAB (Beasley,Mary) 1 1,975
979377 MAB (Beasley,Mary) 2
979377 TFM (McCoy,Tate) 1 2,040
979377 MW2 (Mountain West 2 House) 1 1,975

7,966

1808913
1808913 AAC (Can,Aaron) 1 3,456
1808913 AAC (Can,Aaron) 2 2,342
1808913 AAF (Forsell,Andy) 1 3,456
1808913 AAF (Forsell,Andy) 2 3,041
1808913 GTW (Winter,Greg) 1 3,315

15,610

1805985
1805985 AAC (Can,Aaron) 1 2,000
1805985 AAC (Can,Aaron) 2 785
1805985 AAC (Can,Aaron) 3 2,040
1805985 DWW (Wood,Daniel W) 1 1,540
1805985 DWW (Wood,Daniel W) 2 1,020
1805985 DWW (Wood,Daniel W) 3 2,040
1805985 MAB (Beasley,Mary) 1 2,000
1805985 MAB (Beasley,Mary) 2 785
1805985 MAB (Beasley,Mary) 3 2,040

14,251

1806894
1806894 AAF (Forsell,Andy) 1 1,579
1806894 AAF (Forsell,Andy) 2 1,500
1806894 AAF (Forsell,Andy) 3 1,500
1806894 ECP (Pierce,Eliot) 1 2,050
1806894 ECP (Pierce,Eliot) 2 1,500
1806894 ECP (Pierce,Eliot) 3 1,155

9,284

1807425
1807425 HS (Homs,Sei) 1 1,559
1807425 HS (Homs,Sei) 2 2,025
1807425 HS (Homs,Sei) 3 1,020

4,604
 PY Actuals

Actuals Actuals Actuals Actuals Actuals Actuals Actuals Actuals Actuals

Feb-2022 Mar-2022 Apr-2022 May-2022 Jun-2022 Jul-2022 Aug-2022 Sep-2022 Oct-2022

2,900 12,877 1,599 11,782 13,198 9,932 7,677 3,591 1,545

1,873 11,377 99 10,280 11,697 8,386 6,132 1,964 0
2,900 12,877 1,599 11,782 13,198 9,932 7,677 3,591 1,545
1,873 11,377 99 10,280 11,697 8,386 6,132 1,964 0
2,142 2,244 2,346 2,850 2,850 81
1,026 1,500 1,500 1,500 1,500 1,099 1,001 903 806

12,715 52,250 7,242 45,624 51,290 40,584 31,470 12,095 3,897

2,300 3,500 2,410 3,151 3,173 2,876 2,896 2,915 2,935

2,071 3,154 2,864 2,246 2,971 2,265 2,161 2,529 3,092
1,771 2,695 3,129 3,151 2,443 2,876 2,230 2,245 2,935
2,071 2,429 2,864 2,246 2,971 2,941 2,806 3,284 2,381
1,962 3,682 3,323 3,206 3,430 2,140 2,855 2,942 2,944

10,176 15,460 14,589 14,001 14,989 13,098 12,947 13,916 14,288

1,500 1,000 500 13,198 4,500 3,465 4,500 4,500

1,224 1,428 1,632 1,414 2,040 1,694 1,099 1,001 2,156
1,649 2,244 2,346 2,448 1,964 2,600 2,700 2,156 2,900
1,500 770 385 13,198 4,500 4,500 4,500 4,500
1,224 1,428 1,632 1,836 1,571 1,694 846 1,001 2,800
2,142 1,728 2,346 2,448 2,550 2,600 2,079 2,800 2,900
1,500 1,000 500 13,198 4,500 4,500 4,500 3,465
1,224 1,428 1,257 1,414 2,040 1,694 1,099 1,001 2,800
2,142 2,244 2,346 2,448 2,550 2,600 2,700 2,800 2,900

14,105 13,270 12,944 12,007 52,308 26,382 22,987 24,259 28,921

1,538 1,025 513 13,528 3,235 3,402 3,569 2,316
99 7,916 11,697 8,141 13,941 3,235 3,235 9,263 12,030
76 10,280 9,007 8,141 10,734 2,105 1,853 2,707 3,008
1,538 789 513 - 13,528 3,235 3,402 3,569 2,316
99 10,280 9,007 6,269 13,941 2,491 3,235 9,263 12,030
99 10,280 11,697 8,141 13,941 2,105 2,406 2,707 3,008

3,448 40,570 42,433 30,693 79,611 16,406 17,533 31,078 34,707

2,973 10,163 1,639 12,076 10,416 7,134 10,195 11,125 9,282

2,289 13,199 1,262 12,076 10,416 3,008
1,071 1,122 1,173 942 1,275 1,300 1,040 1,400 1,450

6,332 24,483 4,074 25,095 22,108 11,442 11,235 12,525 10,732

 Forecast

Actuals Actuals Total Forecast Forecast Forecast Forecast Forecast Forecast

Nov-2022 Dec-2022 FY 2022 Jan-2022 Feb-2022 Mar-2022 Apr-2022 May-2022 Jun-2022

18,045 5,257 90,378 978 2,175 9,657 1,199 8,836 9,898

15,996 3,530 71,335 - 1,405 5,631 74 7,710 8,773
18,045 5,257 90,378 1,482 2,175 9,657 1,199 5,832 9,898
15,996 3,530 71,335 - 927 8,532 49 7,710 8,773
1,424 15,977 1,530 1,607 1,111 1,161 - -
708 611 14,129 1,482 769 743 1,125 1,125 743

70,215 18,185 353,532 5,471 9,058 35,332 4,808 31,213 38,085

2,955 2,909 35,476 2,262 1,505 2,291 2,048 2,063 2,077

2,505 3,040 31,240 1,991 1,356 2,064 1,874 1,909 1,944
2,275 2,909 32,116 2,262 1,505 2,291 2,048 2,063 2,077
3,253 2,341 32,629 1,991 1,356 2,064 1,874 1,909 1,944
3,247 2,911 35,958 2,170 1,668 2,410 2,175 2,099 2,245

14,236 14,109 167,418 10,675 7,390 11,120 10,020 10,042 10,288

4,500 6,000 45,663 1,309 982 655 327 - 8,638

3,000 3,200 20,673 668 801 935 1,068 1,202 1,335
3,000 3,100 29,147 1,335 1,402 1,469 1,535 1,602 1,669
4,500 6,000 45,893 1,309 982 655 327 - 8,638
2,310 2,464 19,826 668 801 935 1,068 1,202 1,335
2,310 2,387 28,330 1,335 1,402 1,469 1,535 1,602 1,669
3,465 4,620 43,248 1,309 982 655 327 - 8,638
3,000 3,200 20,941 668 801 935 1,068 1,202 1,335
3,000 3,100 30,870 1,335 1,402 1,469 1,535 1,602 1,669

29,085 34,071 284,590 9,935 9,554 9,173 8,793 8,412 34,927

 3,308 3,134 37,145 1,736 1,302 868 434 - 11,458
12,030 12,030 95,117 1,271 84 8,707 9,908 6,896 11,808
49,411 1,271 84 8,707 9,908 6,896 11,808
3,308 3,134 37,381 1,736 1,302 868 434 - 11,458
9,263 12,030 89,407 1,271 84 8,707 9,908 6,896 11,808
55,539 1,271 84 8,707 9,908 6,896 11,808

27,910 30,328 364,000 8,555 2,940 36,565 40,498 27,583 70,147

12,984 13,913 103,459 1,372 2,014 8,943 1,111 8,183 9,166

44,275 1,372 2,014 8,943 1,111 8,183 9,166
1,500 1,550 14,843 691 726 760 795 829 864

14,484 15,463 162,577 3,435 4,754 18,647 3,016 17,195 19,197

Forecast

Forecast Forecast Forecast Forecast Forecast Forecast Total Actuals Actuals

Jul-2022 Aug-2022 Sep-2022 Oct-2022 Nov-2022 Dec-2022 FY 2022 Jan-2022 Feb-2022

7,449 5,758 2,693 1,159 13,534 3,943 67,280 1,975 2,900

4,151 3,035 1,473 0 7,918 2,648 42,819 - 1,873
7,449 5,758 1,778 765 13,534 3,943 63,470 1,975 2,900
6,289 4,599 1,473 0 11,997 1,747 52,098 - 1,873
1,411 2,138 60 - 1,068 - 10,086 2,040 2,142
824 751 447 604 531 302 9,446 1,975 1,026

27,573 22,039 7,925 2,529 48,582 12,583 245,198 7,966 12,715

1,882 1,895 1,908 1,921 1,934 1,904 23,690 3,456 2,300

1,925 1,837 2,150 2,024 2,129 1,990 23,193 2,342 2,071
1,882 1,895 1,908 1,921 1,934 1,904 23,690 3,456 1,771
1,925 1,837 2,150 2,024 2,129 1,990 23,193 3,041 2,071
1,819 1,868 1,926 1,927 2,125 1,905 24,337 3,315 1,962

9,434 9,332 10,041 9,817 10,252 9,692 118,102 15,610 10,176

2,945 2,945 2,945 2,945 2,945 3,927 30,564 2,000 1,500

1,440 719 655 1,833 1,964 2,094 14,713 785 1,224
1,702 1,767 1,833 1,898 1,964 2,029 20,204 2,040 1,649
2,945 2,945 2,945 2,945 2,945 3,927 30,564 1,540 1,500
1,440 719 655 1,833 1,964 2,094 14,713 1,020 1,224
1,702 1,767 1,833 1,898 1,964 2,029 20,204 2,040 2,142
2,945 2,945 2,945 2,945 2,945 3,927 30,564 2,000 1,500
1,440 719 655 1,833 1,964 2,094 14,713 785 1,224
1,702 1,767 1,833 1,898 1,964 2,029 20,204 2,040 2,142

18,261 16,294 16,299 20,028 20,617 24,151 196,443 14,251 14,105

 2,740 2,881 3,023 2,547 2,802 3,447 33,240 1,579 1,538
2,740 2,740 10,189 10,189 10,189 10,189 84,910 1,500 99
1,783 2,038 2,293 2,547 - - 47,333 1,500 76
2,740 2,881 3,023 2,547 2,802 3,447 33,240 2,050 1,538
2,740 2,740 10,189 10,189 10,189 10,189 84,910 1,500 99
1,783 2,038 2,293 2,547 - - 47,333 1,155 99

14,526 15,319 31,010 30,568 25,983 27,273 330,968 9,284 3,448

6,278 6,908 7,538 8,168 8,798 9,428 77,907 1,559 2,973

2,038 - - - - - 32,827 2,025 2,289
881 915 949 983 1,016 1,050 10,459 1,020 1,071

9,197 7,823 8,487 9,150 9,814 10,478 121,194 4,604 6,332

 PY Actuals+Forecast

Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast

Mar-2022 Apr-2022 May-2022 Jun-2022 Jul-2022 Aug-2022 Sep-2022 Oct-2022 Nov-2022

9,657 1,199 8,836 9,898 7,449 5,758 2,693 1,159 13,534

5,631 74 7,710 8,773 4,151 3,035 1,473 0 7,918
9,657 1,199 5,832 9,898 7,449 5,758 1,778 765 13,534
8,532 49 7,710 8,773 6,289 4,599 1,473 0 11,997
1,111 1,161 - - 1,411 2,138 60 - 1,068
743 1,125 1,125 743 824 751 447 604 531

35,332 4,808 31,213 38,085 27,573 22,039 7,925 2,529 48,582

2,291 2,048 2,063 2,077 1,882 1,895 1,908 1,921 1,934

2,064 1,874 1,909 1,944 1,925 1,837 2,150 2,024 2,129
2,291 2,048 2,063 2,077 1,882 1,895 1,908 1,921 1,934
2,064 1,874 1,909 1,944 1,925 1,837 2,150 2,024 2,129
2,410 2,175 2,099 2,245 1,819 1,868 1,926 1,927 2,125

11,120 10,020 10,042 10,288 9,434 9,332 10,041 9,817 10,252

655 327 - 8,638 2,945 2,945 2,945 2,945 2,945

935 1,068 1,202 1,335 1,440 719 655 1,833 1,964
1,469 1,535 1,602 1,669 1,702 1,767 1,833 1,898 1,964
655 327 - 8,638 2,945 2,945 2,945 2,945 2,945
935 1,068 1,202 1,335 1,440 719 655 1,833 1,964
1,469 1,535 1,602 1,669 1,702 1,767 1,833 1,898 1,964
655 327 - 8,638 2,945 2,945 2,945 2,945 2,945
935 1,068 1,202 1,335 1,440 719 655 1,833 1,964
1,469 1,535 1,602 1,669 1,702 1,767 1,833 1,898 1,964

9,173 8,793 8,412 34,927 18,261 16,294 16,299 20,028 20,617

 868 434 - 11,458 2,740 2,881 3,023 2,547 2,802
8,707 9,908 6,896 11,808 2,740 2,740 10,189 10,189 10,189
8,707 9,908 6,896 11,808 1,783 2,038 2,293 2,547 -
868 434 - 11,458 2,740 2,881 3,023 2,547 2,802
8,707 9,908 6,896 11,808 2,740 2,740 10,189 10,189 10,189
8,707 9,908 6,896 11,808 1,783 2,038 2,293 2,547 -

36,565 40,498 27,583 70,147 14,526 15,319 31,010 30,568 25,983

8,943 1,111 8,183 9,166 6,278 6,908 7,538 8,168 8,798

8,943 1,111 8,183 9,166 2,038 - - - -
760 795 829 864 881 915 949 983 1,016

18,647 3,016 17,195 19,197 9,197 7,823 8,487 9,150 9,814

 Forecast Total < Budget Budget Budget
Driver
Dec-2022 FY 2022 25% Jan-2023 Feb-2023 Mar-2023

3,943 69,003 ✓ 6,199 17,106 7,107

2,648 43,287 ✓ - 11,050 4,144
3,943 64,688 ✓ 6,199 17,106 7,107
1,747 53,044 ✓ - 11,050 6,279
- 11,131 ✗ 6,402 12,635 817
302 10,196 ✗ 6,199 6,052 546

12,583 251,350 Actuals + Forecast▾ 25,000 75,000 26,000

1,904 25,679 ✓ 2,087 2,176 2,156

1,990 24,260 ✓ 1,414 1,959 1,943
1,904 25,150 ✓ 2,087 1,675 1,660
1,990 24,959 ✓ 1,836 1,959 1,496
1,905 25,776 ✓ 2,002 1,856 2,269

9,692 125,824 PY Actuals▾ 9,425 9,625 9,525

3,927 31,773 ✓ 2,080 1,537 668

2,094 15,254 ✓ 817 1,255 953
2,029 21,157 ✓ 2,122 1,691 1,498
3,927 31,313 ✓ 1,602 1,537 668
2,094 15,488 ✓ 1,061 1,255 953
2,029 21,649 ✓ 2,122 2,196 1,498
3,927 31,773 ✓ 2,080 1,537 668
2,094 15,254 ✓ 817 1,255 953
2,029 21,649 ✓ 2,122 2,196 1,498

24,151 205,310 % Change of Actuals + Forecast▾ 4.00% 2.50% 2.00%

 3,447 33,318 ✓ 2,030 3,721 796
10,189 85,155 ✓ 1,485 240 7,980
- 47,555 ✓ 1,485 240 7,980
3,447 33,789 ✓ 2,030 3,721 796
10,189 85,155 ✓ 1,485 240 7,980
- 47,233 ✓ 1,485 240 7,980

27,273 332,205 Forecast▾ 10,000 8,400 33,511

9,428 79,053 ✓ 1,621 3,047 9,122

- 33,755 ✓ 2,106 2,346 9,122
1,050 11,133 ✓ 1,061 1,098 775

10,478 123,941 % Change of Actuals + Forecast▾ 4.00% 2.50% 2.00%

 Current Year

Budget Budget Budget Budget Budget Budget Budget Budget Budget

Apr-2023 May-2023 Jun-2023 Jul-2023 Aug-2023 Sep-2023 Oct-2023 Nov-2023 Dec-2023

2,134 7,523 7,643 6,809 5,401 3,246 2,458 10,916 3,888

132 6,564 6,774 3,794 2,847 1,776 1 6,386 2,611
2,134 4,965 7,643 6,809 5,401 2,142 1,622 10,916 3,888
87 6,564 6,774 5,749 4,314 1,776 1 9,676 1,723
2,066 - - 1,289 2,005 73 - 862 -
2,002 958 573 753 704 539 1,282 428 298

8,556 26,573 29,407 25,203 20,672 9,551 5,363 39,185 12,409

2,477 2,178 2,059 2,146 2,197 2,069 2,039 2,071 2,067

2,944 1,552 1,928 1,690 1,640 1,795 2,148 1,755 2,160
3,217 2,178 1,585 2,146 1,692 1,593 2,039 1,594 2,067
2,944 1,552 1,928 2,195 2,130 2,331 1,654 2,280 1,663
3,417 2,216 2,226 1,597 2,166 2,088 2,045 2,275 2,068

15,000 9,675 9,725 9,775 9,825 9,875 9,925 9,975 10,025

301 - 9,135 3,084 3,053 3,022 2,991 2,960 3,905

983 1,250 1,412 1,508 745 672 1,861 1,973 2,083
1,413 1,666 1,765 1,782 1,832 1,880 1,927 1,973 2,018
301 - 9,135 3,084 3,053 3,022 2,991 2,960 3,905
983 1,250 1,412 1,508 745 672 1,861 1,973 2,083
1,413 1,666 1,765 1,782 1,832 1,880 1,927 1,973 2,018
301 - 9,135 3,084 3,053 3,022 2,991 2,960 3,905
983 1,250 1,412 1,508 745 672 1,861 1,973 2,083
1,413 1,666 1,765 1,782 1,832 1,880 1,927 1,973 2,018

-8.00% 4.00% 5.75% 4.70% 3.65% 2.60% 1.55% 0.50% -0.55%

 531 - 6,771 2,024 3,402 3,569 3,008 3,308 4,070
12,130 10,260 6,978 2,024 3,235 12,030 12,030 12,030 12,030
12,130 10,260 6,978 1,317 2,406 2,707 3,008 - -
531 - 6,771 2,024 3,402 3,569 3,008 3,308 4,070
12,130 10,260 6,978 2,024 3,235 12,030 12,030 12,030 12,030
12,130 10,260 6,978 1,317 2,406 2,707 3,008 - -

49,584 41,041 41,455 10,731 18,086 36,612 36,090 30,677 32,200

1,022 8,510 9,694 6,573 7,160 7,734 8,294 8,842 9,376

1,022 8,510 9,694 2,134 - - - - -
731 863 914 922 948 973 998 1,021 1,045

-8.00% 4.00% 5.75% 4.70% 3.65% 2.60% 1.55% 0.50% -0.55%

 Total wth % by Driver Comments
FY 2023 FY 2023 FY 2023

80,430 17%
46,079 6%
75,933 17%
53,993 2%
26,150 135%
20,334 99%

302,918 21%

25,721 0%
22,928 (5%)
23,534 (6%) aggressive growth
23,968 (4%)
26,224 2%

122,375 (3%)

32,735 3%
15,511 2% expansion
21,566 2%
32,257 3%
15,755 2%
22,071 2%
32,735 3%
15,511 2%
22,071 2%

210,215 2%
33,230 (0%)
92,452 9%
48,511 2%
33,230 (2%)
92,452 9%
48,511 3%

348,385 5%

80,996 2% aggressive growth

34,933 3%
11,349 2%

127,278 3%
Bottom Up Planning
Scenario: Budget▾
Year: 2023▾
Period: Oct▾
PY Actuals+Forec CY Budget
Product Total Driver Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Total Growth % Comments
Product Manager Driver
Tier FY 2022 Value Jan-2023 Feb-2023 Mar-2023 Apr-2023 May-2023 Jun-2023 Jul-2023 Aug-2023 Sep-2023 Oct-2023 Nov-2023 Dec-2023 FY 2023 FY 2023 FY 2023

979377
979377 AAC (Can,Aaron) 1 90,378 Seasonal Spread▾ 113,499 5,674 5,674 11,349 5,674 5,674 11,349 11,349 11,349 11,349 11,349 11,349 11,349 113,488 25.57%
979377 AAC (Can,Aaron) 2 71,335 Manual Spread▾ 84,931 16,986 25,479 - - - - 16,986 25,479 - - - - 84,930 19.06%
979377 MAB (Beasley,Mary) 1 90,378 Manual Spread▾ 111,178 22,235 33,353 - - - - 22,235 33,353 - - - - 111,176 23.01%
979377 MAB (Beasley,Mary) 2 71,335 Actuals + Forecast▾ 83,277 - 2,186 13,281 115 12,000 13,655 9,789 7,158 2,293 - 18,673 4,121 83,271 16.73%
979377 MW2 (Mountain West 2 House) 1 15,977 Actuals + Forecast▾ 39,000 4,979 5,228 5,477 5,726 - - 6,956 6,956 196 - 3,477 - 38,995 144.07%
979377 TFM (McCoy,Tate) 1 14,129 Actuals + Forecast▾ 15,977 2,233 1,160 1,696 1,696 1,696 1,696 1,242 1,131 1,021 911 800 690 15,972 13.05%

Total 353,532 52,107 73,080 31,803 13,211 19,370 26,700 68,557 85,426 14,859 12,260 34,299 16,160 447,832

1808913
1808913 AAC (Can,Aaron) 1 36,196 Seasonal Spread▾ 30,915 1,545 1,545 3,091 1,545 1,545 3,091 3,091 3,091 3,091 3,091 3,091 3,091 30,908 (14.61%)
1808913 AAC (Can,Aaron) 2 35,436 Manual Spread▾ 29,085 5,816 8,725 - - - - 5,816 8,725 - - - - 29,082 (17.93%)
1808913 AAF (Forsell,Andy) 1 36,196 % Change of Actuals + Forecast▾ 10.0% 3,801 2,530 3,850 3,442 3,466 3,490 3,163 3,185 3,206 3,228 3,250 3,199 39,810 9.99% aggressive growth
1808913 AAF (Forsell,Andy) 2 35,436 % Change of Actuals + Forecast▾ (10.0%) 2,737 1,864 2,838 2,577 2,625 2,673 2,647 2,525 2,955 2,783 2,928 2,736 31,888 (10.01%)
1808913 GTW (Winter,Greg) 1 37,184 Actuals + Forecast▾ 37,184 3,315 2,548 3,682 3,323 3,206 3,430 2,779 2,854 2,942 2,944 3,247 2,910 37,180 (0.01%)

Total 180,446 17,214 17,212 13,461 10,887 10,842 12,684 17,496 20,380 12,194 12,046 12,516 11,936 168,868

1805985
1805985 AAC (Can,Aaron) 1 46,698 Seasonal Spread▾ 33,880 1,693 1,693 3,387 1,693 1,693 3,387 3,387 3,387 3,387 3,387 3,387 3,387 33,868 (27.47%)
1805985 AAC (Can,Aaron) 2 22,480 Manual Spread▾ 19,176 3,835 5,752 - - - - 3,835 5,752 - - - - 19,174 (14.70%) expansion
1805985 AAC (Can,Aaron) 3 30,870 Seasonal Spread▾ 26,944 1,347 1,347 2,694 1,347 1,347 2,694 2,694 2,694 2,694 2,694 2,694 2,694 26,940 (12.73%)
1805985 DWW (Wood,Daniel W) 1 46,698 % Change of Actuals + Forecast▾ 2.0% 2,040 1,530 1,020 510 - 13,461 4,590 4,590 4,590 4,590 4,590 6,120 47,631 2.00%
1805985 DWW (Wood,Daniel W) 2 22,480 Actuals + Forecast▾ 35,000 1,588 1,905 2,223 2,540 2,858 3,176 3,425 1,710 1,558 4,359 4,670 4,982 34,994 55.67%
1805985 DWW (Wood,Daniel W) 3 30,870 Actuals + Forecast▾ 30,870 2,040 2,142 2,244 2,346 2,448 2,550 2,600 2,700 2,800 2,900 3,000 3,100 30,870 -
1805985 MAB (Beasley,Mary) 1 46,698 Equal Spread▾ 48,407 4,033 4,033 4,033 4,033 4,033 4,033 4,033 4,033 4,033 4,033 4,033 4,033 48,396 3.64%
1805985 MAB (Beasley,Mary) 2 22,480 Seasonal Spread▾ 19,516 975 975 1,951 975 975 1,951 1,951 1,951 1,951 1,951 1,951 1,951 19,508 (13.22%)
1805985 MAB (Beasley,Mary) 3 30,870 Seasonal Spread▾ 28,078 1,403 1,403 2,807 1,403 1,403 2,807 2,807 2,807 2,807 2,807 2,807 2,807 28,068 (9.08%)

Total 300,142 18,954 20,780 20,359 14,847 14,757 34,059 29,322 29,624 23,820 26,721 27,132 29,074 289,449

1806894
1806894 AAF (Forsell,Andy) 1 39,245 % Change of Actuals + Forecast▾ 22.0% 2,501 1,875 1,250 625 - 16,503 3,946 4,150 4,354 3,669 4,036 4,965 47,874 21.99%
1806894 AAF (Forsell,Andy) 2 100,248 % Change of Actuals + Forecast▾ 22.0% 1,830 120 12,541 14,270 9,932 17,007 3,946 3,946 14,676 14,676 14,676 14,676 122,296 21.99%
1806894 AAF (Forsell,Andy) 3 55,884 % Change of Actuals + Forecast▾ (13.0%) 1,305 86 8,943 10,176 7,083 12,128 1,831 2,093 2,354 2,616 - - 48,615 (13.01%)
1806894 ECP (Pierce,Eliot) 1 39,245 % Change of Actuals + Forecast▾ (15.0%) 1,742 1,306 871 435 - 11,498 2,749 2,891 3,033 2,556 2,812 3,459 33,352 (15.02%)
1806894 ECP (Pierce,Eliot) 2 100,248 Actuals + Forecast▾ 105,500 1,578 104 10,818 12,309 8,567 14,670 3,404 3,404 12,660 12,660 12,660 12,660 105,494 5.23%
1806894 ECP (Pierce,Eliot) 3 55,884 Actuals + Forecast▾ 55,884 1,500 99 10,279 11,697 8,141 13,940 2,105 2,406 2,706 3,007 - - 55,880 (0.01%)

Total 390,753 - 10,456 3,590 44,702 49,512 33,723 85,746 17,981 18,890 39,783 39,184 34,184 35,760 413,511

Drivers
Equal Spread 1 1 1 1 1 1 1 1 1 1 1 1 12
Seasonal Spread 1 1 2 1 1 2 2 2 2 2 2 2 20
Manual Spread 2.00 3.00 2.00 3.00 10.00
Variance Report
2023

250,000

200,000

150,000

100,000

Budget 50,000
PY Actuals+Forecast
Variance
-
Jan-2023 Feb-2023 Mar-2023 Apr-2023 May-2023 Jun-2023 Jul-2023 Aug-2023 Sep-2023 Oct-2023 Nov-2023 Dec-2023

(50,000)

(100,000)

(150,000)

Total
Scenario Client Jan-2023 Feb-2023 Mar-2023 Apr-2023 May-2023 Jun-2023 Jul-2023 Aug-2023 Sep-2023 Oct-2023 Nov-2023 Dec-2023 Trendline
2023

Budget 979377 52,107 73,080 31,803 13,211 19,370 26,700 68,557 85,426 14,859 12,260 34,299 16,160 447,832
Budget 1808913 17,214 17,212 13,461 10,887 10,842 12,684 17,496 20,380 12,194 12,046 12,516 11,936 168,868
Budget 1805985 18,954 20,780 20,359 14,847 14,757 34,059 29,322 29,624 23,820 26,721 27,132 29,074 289,449
Budget 1806894 10,456 3,590 44,702 49,512 33,723 85,746 17,981 18,890 39,783 39,184 34,184 35,760 413,511

98,731 114,662 110,325 88,457 78,692 159,189 133,356 154,320 90,656 90,211 108,131 92,930 1,319,660

PY Actuals+Forecast 979377 7,966 12,715 52,250 7,242 45,624 51,290 40,584 31,470 12,095 3,897 70,215 18,185 353,532
PY Actuals+Forecast 1808913 16,310 11,291 16,990 15,309 15,343 15,719 14,414 14,258 15,342 14,999 15,664 14,808 180,446
PY Actuals+Forecast 1805985 15,180 14,598 14,016 13,434 12,852 53,364 27,900 24,896 24,903 30,600 31,500 36,900 300,142
PY Actuals+Forecast 1806894 10,100 3,471 43,170 47,814 32,566 82,818 17,151 18,086 36,612 36,090 30,677 32,200 390,753

49,556 42,074 126,426 83,799 106,384 203,190 100,048 88,710 88,951 85,586 148,055 102,093 1,224,874

Variance 979377 44,141 60,365 (20,447) 5,969 (26,254) (24,590) 27,973 53,956 2,764 8,363 (35,916) (2,025) 94,300
Variance 1808913 904 5,921 (3,529) (4,422) (4,501) (3,035) 3,082 6,122 (3,148) (2,953) (3,148) (2,872) (11,578)
Variance 1805985 3,774 6,182 6,343 1,413 1,905 (19,305) 1,422 4,728 (1,083) (3,879) (4,368) (7,826) (10,693)
Variance 1806894 8,854 17,309 (22,811) (32,967) (17,809) (48,759) 12,172 11,538 (12,792) (9,369) (3,545) (3,126) (101,304)

57,673 89,778 (40,444) (30,007) (46,658) (95,688) 44,649 76,344 (14,258) (7,838) (46,976) (15,849) (29,276)

2022 2022 2022 2022 2022 2022 2022 2022 2023 2023 2023 2023
Value Value Value Value Value Value Value Value Value Value Value Value

-
-
Budget All Clients 8445.83 8823.17 14475.91 24664.6 21097.64 26258.04 25516.89 21404.65 23180.83 23329.05 22740.54857 22991.64429 242,929
Budget All Clients 49768.88 43932.78 71517.04 87137.6 68432.94 77746.3 64203.44 61522.07 94085.37 94786.8 90122.95286 93882.86643 897,139
Budget All Clients 43421.82 38945.22 194846.73 133134.57 174360.9 233217.72 114336.39 101508.83 133191.39 97421.05 221033.6643 129933.9621 1,615,352
Budget All Clients 0 0 0 0 0 0 0 0 0 0 0 0 -