Bid Price Simulator (Operations and Management Bids) (Excel XLSM)

Bid Price Simulator (Operations and Management Bids)

Bid Pricing Simulator (BPS) is an excel based Bid Modeling Tool developed by Fin-wiser Advisory which helps organizations to prepare a commercial output for a Bid/Tender.

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

Salient Feature:
1. Sector Applicability: Operations and Management, Hard & Soft Facility Management,
2. Pricing Methodology Used: Suit for Bids priced using Cost + Markup methodology
3. Contract Life: Suitable for Contract Life up to 10 years/120 months
4. Cost Calculations Time frame: 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 the user 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 Build using Best Modeling Practice
8. Re-useability: This tool can be used for multiple Bids through the year hence saving a great deal of time and money.

BPS Includes following 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 divided into 8 categories
7. I_Capex- Capex related inputs divided into 4 categories

BPS Includes following 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

BPS Includes following 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 project title & Logo
2. Model Structure- Flow chart to understand the Model Flow
3. Read Me- User Guide on Model
4. Price Tracker- Keeps a track of model changes


Important Technical Specifications:

The following are important technical specifications that you need to keep in mind before purchasing this model template:

1. Model is built using Microsoft Excel 2010 version.

2. Model uses Cell Styles

3. File type is .xlsx