Building a Financial Model Based on TBM (Technology Business Management) in Excel

Project Description:
We are looking for an Excel expert with experience in Technology Business Management (TBM) to build a financial model that helps distribute IT costs (Cost Pools) and link them to Towers, Sub-Towers, and Solutions. The goal is to ensure transparency, improve efficiency, and support strategic decision-making related to IT cost management.

Expected Deliverables:
Interactive Financial Model in Excel:

A structured Cost Pools table (e.g., Internal Labor, External Labor, Software, Hardware, etc.).
Distribution of costs to IT Towers and Sub-Towers.
Linking IT Towers to Solutions, such as:
Applications.
Services.
Products.
Reports and Visualizations:

Charts that show cost distribution by Towers and Solutions.
Detailed analysis reflecting percentage allocations for each category.
Flexibility and Modifiability:

A model designed for easy updating of inputs (costs).
Options to adjust percentage allocations dynamically for future modifications.
Scope of Work:
Model Structure:

Design a Cost Pools table with the following fields:

Cost name.
Total allocated amount.
Description of each cost.
Create a Towers and Sub-Towers table that includes:

Tower and Sub-Tower names.
Allocated costs and percentage distributions.
Design a Solutions table that includes:

Solution names.
Costs linked to each solution.
Linking each solution to relevant Towers and Sub-Towers.
Cost Distribution:

Develop dynamic formulas to distribute costs across Sub-Towers and Solutions.
Automatically allocate percentages based on inputs.
Data Analysis:

Add analytical formulas to show:
Total costs for each Tower and Sub-Tower.
Contribution of each Cost Pool to the different Solutions.
Report Design:

Printable reports that display complete cost distribution.
Dynamic charts to visualize:
Cost distribution by Towers.
Cost distribution by Solutions (Applications, Services, Products).
Testing and Validation:

Test the model to ensure calculation accuracy.
Provide a tutorial video demonstrating how to use the model.
Required Skills:
Advanced Excel expertise (e.g., Power Query, Pivot Tables, Dynamic Charts).
Strong understanding of cost management according to the TBM framework.
Skills in designing detailed financial reports.
Acceptance Criteria:
A fully functional financial model ready for immediate use.
A user-friendly interface for updating data and analyzing results.
A user guide or video tutorial explaining how to work with the model.
Project Timeline:
The project is expected to be completed within 7-10 business days from the contract start date.
Deliverables:
Final Excel file with the completed model.
A user guide (PDF or video).
A short online consultation session to address questions.