Cost & Savings Progression Model
A scenario model that projects component costs and savings as hardware moves from analog to IP over time. One button recalculates four scenarios using the ramp assumptions for every component.
- Industry
- Telecom / Hardware
- Deliverable
- Cost Savings Model.xlsm
- Built with
- Excel VBA, Scenario modelling
Before
Each cost scenario had to be recalculated separately.
After
One button recalculates all four scenarios from the ramp assumptions for every component.
More like this
Related projects
Timesheet & Billing Dashboard
Legal Services
A timesheet and payout system for a small legal team. Users log in by role, workers record tasks and hours, and the admin dashboard shows billed,…
View project
Property Management Rent Ledger
Property Management
A rent and landlord statement system. Each property has its own ledger of rent, fees, VAT and landlord payments, statements are imported, and the dashboard totals…
View project
Trade Opportunity Finder & Profitability Analysis
International Trade
A database-driven tool for an import and export business. Products, suppliers, clients and prices are added through forms, and sales simulations calculate landed cost, truck loading…
View project