Commercial Model – Operation and Management (Bidding Excel Model)

$149.00

Description

Bid Pricing Simulator (BPS) is an excel based bidding model/ commercial model developed by Fin-wiser Advisory which helps organizations to prepare commercials for a bid/tender and can be used in the operations and maintenance industry.

Bidding is a time-bound activity and BPS can provide impetus to your efforts of delivering a quality output by saving crucial time of the commercial team to the tune of 120-150 hours.

Salient Feature:
1. Sector Applicability: Operations and Management, Hard & Soft Facility Management, Operations and Maintainance
2. Pricing Methodology Used: Suit for Bids priced using Cost + Markup methodology
3. Contract Life: Suitable for a Contract Life of up to 10 years/120 months
4. Cost Calculations Time frame: The user can populate and review cost elements on a monthly basis and better understand cost trend
5. Scenario Management: BPS can incorporate 10 different scenarios at a time providing users with greater flexibility to analyze results
6. Multiple Redesigned Outputs: Fully Integrated Monthly & Annual Financial Statements, Cash Waterfall, NPV- IRR Analysis & more
7. Modeling Practice: BPS is designed and Built using the Best Modeling Practice
8. Re-Use ability: This tool can be used for multiple Bids throughout the year hence saving a great deal of time and money.

List of Input Tabs:
1. I_General_Assm.- Includes General Assumptions Like Start Date, Inflation & More
2. I_Staff_Salary- Inputs Related to Staff to be hired for the project
3. I_Staff_Phasing- Inputs Related to Staff Phasing during the project life
4. I_Mobilisation- Staff & Non-Staff Cost during Mobilisation Period
5. I_Subcontractor- Inputs Related to subcontractors to be hired for specialist services
5. I_Opex- Opex-related inputs are divided into 8 categories
7. I_Capex- Capex-related inputs divided into 4 categories

List of calculation Tabs:
1.C_Staff_Salary_Cost- Calculates Staff Cost by Each Role and Salary Cost Component
2.C_Mobilisation_Cost- Calculates both Staff & Non Staff Related Mobilisation Cost incurred
3.C_Subcontractor_Cost- Calculates subcontractors-related cost
4.C_Opex_Cost- Calculates Opex cost to be incurred during the bid
5. C_Capex_Cost- Calculates Capex & depreciation cost to be incurred during the bid
6. C_Working_Capital- Calculates Receivables and Payable for each cost account
7. C_Price_Calc- Calculates TCV of the contract using a Cost + Markup approach

List of Output Tabs:
1. O_Financial_Statements- Includes Financial Statements i.e. IS, BS & CF on Monthly & Annual Basis
2. O_NPV-IRR- Includes NPV and IRR Analysis
3. O_Graphs- Graphical presentation of data points
4. Check- Includes a list of Arithmetical & Logical Checks

Additional Tabs:
1. Cover- This is the cover sheet & includes the project title & Logo
2. Model Structure- Flow chart to understand the Model Flow
3. Read Me- User Guide on Model
4. Price Tracker- Keeps track of model changes