Megan Eberhardt Email & Phone Number

Saint Paul, MN, US

Bayport, Minnesota, US

Financial support for 400S Windows -annual order budgeting for Andersen Division products including windows, doors and specialty by utilizing demand plan, market outlook, and historical trends -volume forecasting for 400S product line to support business cases, as well as strategic operations-month end reporting

St Paul, MN, US

Supported the Post-it® business portfolio in the Stationary and Office Supplies Division and the Safety and HEM business portfolios in the Construction & Home Improvement Markets Division within CBG

St Paul, MN, US

Supported the Post-it® business portfolio, R&D, AdMerch, and CBG Business Operations

St Paul, MN, US

• Prepared, consolidated, and analyzed financial data for presentations for QFR, QOR and Operating Plan for the COC, as well as monthly MOC presentations
• Collaborated with Area and Division Finance Managers, Strategy, or BG Ops in requesting data for executive reports
• Prepared weekly sales update for CBG finance VP including the use of POS data and weekly sales data
• Implemented a new reporting process for the Weekly Sales Calls to allow for a more streamlined process and improved flow during meetings, as well as increased functionality by utilizing PowerBI
• Created custom reporting templates to support QFR, QOR, MRE, or OP requests for target setting spend guidance and initiative tracking
• Streamlined central CBG processes (I.e. templates for sales walks, price walks, and sales ranges)

St. Paul, Minnesota, US

• Managed annual budgeting process for the classified advertising department, digital COGS, and other expenses, as well as performing weekly and monthly forecasts.
• Worked directly with upper management to build budgeting tools in Excel and maintain deadlines.
• Completed revenue reconciliations between the general ledger and Qlikview database for classified advertising segments.
• Prepared month-end close journal entries and provided analysis for variance to budget, forecast, and prior year by advertiser and trend
• Calculated sales representative and manager commissions on a monthly, quarterly and annual basis, as well as forecasting future commission expense.
• Performed COGS analysis on digital products sold to determine profitability of each product.

Bloomington, Minnesota, US

• Analyzed community bank financial statements to identify historical trends, as well as year-over-year variances
• Compiled and analyzed financial industry statistics to identify trends to support UBB's strategic planning
• Built spreadsheet templates to streamline processes in pulling important data to improve efficiency and accuracy
• Conducted bank stock valuations for a variety of purposes (ESOP, Buy/Sell, Gifting, Estate Planning/Settlements, etc.)

Eagan, MN, US

• Maintained production quotas and met customer deadlines as assigned per department schedule
• Processed various documents following departmental and project-specific work instruction
• Edited comments on paper and web-based surveys to reflect customer requirements and feedback
• Interpreted Spanish language comments
• Coded project comments using various coding lists as provided
• Provided input for continuous improvement of departmental processes and procedures

Bachelor Of Science (B.S.), Business Administration: Finance

Accounting And Business/Management