Instructions

Using Vena Excel Templates in 'Basic' Excel

Operating Expense Planning - "Input"

Apply your own colors & branding
• Go to 'Page Layout', then 'Themes' to select from other color formats and fonts.
• Go to 'Home', then 'Cell styles' to reformat the appearance and colors of different included cell types.

Compile Departmental Budget

• Define the year and period, and ensure that your chart of accounts are being used for planning
• For each account, copy and paste a row using the intended planning method
• Make adjustments alongside relevant budget owners

Submit for Approvals

• Leverage the Dashboard as a validation tool
• Submit the budget to executives for approval

Combine with other Entities / Departments / Cost Centers / Profit Centers

• Aggregate sheets together using excel logic
• Contact a Vena rep to learn more about automatically aggregating your Operating Expenses

Manage Driver List

TableDrivers Select Variable
CurrentYear 2022▾ 2022
CurrentPeriod Oct/1/2022 Oct/31/2022
FiscalYearStart 1 Feb/1/2022
PlanScenario Plan Plan
Operating Expense Dashboard
For Entity 100, Department A

Summary

All Operating Expenses Plan Year $3,137k This shape represents a table
slicer. Table slicers are not
300,000 vs Current Year ▴$129k supported in this version of
250,000 Excel.
Prior Year
200,000 If the shape was modified in an
earlier version of Excel, or if
Current Year 150,000 the workbook was saved in
100,000
Excel 2007 or earlier, the slicer
can't be used.
Plan Year
50,000

-
Time P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Full Year
Prior Year 244,550 229,350 239,950 228,100 225,825 232,925 242,355 242,555 246,855 239,655 231,905 228,755 2,832,780
Current Year 243,400 263,300 261,227 244,000 241,411 243,757 248,700 271,003 255,798 251,777 244,132 239,597 3,008,102
Plan Year 252,271 275,632 270,646 254,617 253,230 252,903 259,102 283,903 265,085 264,286 255,038 250,676 3,137,390

Category Breakdown, CY This shape represents a table

slicer. Table slicers are not
280,000
supported in this version of
Category5 Excel.
270,000
Category4 If the shape was modified in an
260,000
earlier version of Excel, or if
Category3
the workbook was saved in
250,000
General Operating Expenses
Excel 2007 or earlier, the slicer
can't be used.
240,000
Salaries, Wages & Benefits

230,000

220,000
Account Categories P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Full Year
Salaries, Wages & Benefits 241,100 261,000 258,927 241,700 239,111 241,457 246,400 268,703 253,498 249,277 241,632 237,097 2,979,902
General Operating Expenses 2,300 2,300 2,300 2,300 2,300 2,300 2,300 2,300 2,300 2,500 2,500 2,500 28,200
Category3 - - - - - - - - - - - - -
Category4 - - - - - - - - - - - - -
Category5 - - - - - - - - - - - - -
Total 243,400 263,300 261,227 244,000 241,411 243,757 248,700 271,003 255,798 251,777 244,132 239,597 3,008,102

Spend by Category

Salaries, Wages & Benefits Plan Year $3,137k This shape represents a table
slicer. Table slicers are not
300,000 vs Current Year ▴$157k supported in this version of
250,000 Excel.
Prior Year
200,000 If the shape was modified in an
earlier version of Excel, or if
Current Year 150,000 the workbook was saved in
100,000
Excel 2007 or earlier, the slicer
can't be used.
Plan Year
50,000

-
Time P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Full Year
Prior Year 242,450 227,250 237,850 226,000 223,625 230,725 240,155 240,255 244,555 237,355 229,605 226,455 2,806,280
Current Year 241,100 261,000 258,927 241,700 239,111 241,457 246,400 268,703 253,498 249,277 241,632 237,097 2,979,902
Plan Year 252,271 275,632 270,646 254,617 253,230 252,903 259,102 283,903 265,085 264,286 255,038 250,676 3,137,390

General Operating Expenses Plan Year $k This shape represents a table

slicer. Table slicers are not
3,000 vs Current Year ▾$28k supported in this version of
2,500 Excel.
Prior Year
2,000 If the shape was modified in an
earlier version of Excel, or if
Current Year 1,500 the workbook was saved in
1,000
Excel 2007 or earlier, the slicer
can't be used.
Plan Year
500

-
Time P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Full Year
Prior Year 2,100 2,100 2,100 2,100 2,200 2,200 2,200 2,300 2,300 2,300 2,300 2,300 26,500
Current Year 2,300 2,300 2,300 2,300 2,300 2,300 2,300 2,300 2,300 2,500 2,500 2,500 28,200
Plan Year - - - - - - - - - - - - -
Operating Expenses
For Entity 100, Department A Current Year *Group and hide overlapping periods
Planning Driver Prior Yr Actual Actual Actual
Actual Actual Actual Actual Actual Actual Plan Plan Plan Current Yr Plan Yr Current Yr Plan Yr
Method Amount 30% Total Feb 22 Mar 22 Apr 22 May 22 Jun 22 Jul 22 Aug 22 Sep 22 Oct 22 Nov 22 Dec 22 Jan 23 Total Total Trend Trend Add Comment

Input New Expenses

Salaries, Wages & Benefits 2,806,280 241,100 261,000 258,927 241,700 239,111 241,457 246,400 268,703 253,498 249,277 241,632 237,097 2,979,902 3,137,390
5000 (Salaries & Wages - 1) % change on PY 5.0 3 ✓ 2,766,800 236,500 257,300 254,000 238,000 235,400 237,000 242,700 265,000 248,500 246,120 237,510 234,675 2,932,705 3,079,340
5001 (Overtime Comp.) Pattern - Work Days 28,000.0 5 ✓ 18,000 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 807 772 772 22,151 28,000
5002 (Sales Commissions - Staff) ✓ 13,850 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,300 1,800 1,300 15,200 17,600
5003 (Fringe Benefits) ✓ 3,180 300 300 327 300 311 357 300 303 298 450 350 350 3,946 4,900
5004 (Emp Retention Programs) ✓ 4,450 900 1,200 700 1,300 600 1,200 - 5,900 7,550
Special Compensation 1,200
Contract Bonuses 600

General Operating Expenses - 26,500 2,300 2,300 2,300 2,300 2,300 2,300 2,300 2,300 2,300 2,500 2,500 2,500 28,200 -
Add Rows… ✓ 26,500 2,300 2,300 2,300 2,300 2,300 2,300 2,300 2,300 2,300 2,500 2,500 2,500 28,200 -

Category3 - - - - - - - - - - - - - - -
Add Rows… ✓ - - -

Category4 - - - - - - - - - - - - - - -
Add Rows… ✓ - - -

Category5 - - - - - - - - - - - - - - -
Add Rows… ✓ - - -

Total Operating Expenses 2,832,780 243,400 263,300 261,227 244,000 241,411 243,757 248,700 271,003 255,798 251,777 244,132 239,597 3,008,102 3,137,390

Examples & Drivers

Examples
Preset Drivers $ even spread 1 ✓ - - - - - -
Read-only ✓ - - -
Direct input ✓ - - -
Sum of Line Items ✓ - - - - - - - - - - - - - - -
Line Item Detail 1
Line Item Detail 2

Drivers & Patterns Index

$ even spread 1
$ spread by PY 2
% change on PY 3
Pattern 4/4/5 4 - 4 4 5 52 52
Pattern - Work Days 5 - 23 22 22 266 261
Pattern - Blank 6 - - -