Interested in Digital Strategy in Q4 2020? Download our FREE whitepaper on this topic. This is an exclusive promotion being run on LinkedIn.

  Please register (it's free!) or login to view the remaining preview.
If you are logged in, your referral link [?] is automatically included below.
EMBED CODE (Copy and Paste)


BENEFITS OF DOCUMENT

  1. Sector Applicability: Operations and Management, Hard & Soft Facility Management,
  2. Pricing Methodology Used: Suit for Bids priced using Cost + Markup methodology. Cost Calculations Time frame: User can populate and review cost elements on a monthly basis and better understand cost trend
  3. Contract Life: Suitable for Contract Life up to 10 years/120 months. Scenario Management: BPS can incorporate 10 different scenarios at a time providing the user with greater flexibility to analyze results

DOCUMENT DESCRIPTION

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

Got a question about the product? Email us at [email protected] or ask the author directly by using the form to the right. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Bid Price Simulator (Operations and Management Bids) Excel document

 

Bid Price Simulator (Operations and Management Bids)

Sold by Fin-Wiser Advisory (this author has 31 documents)

$150.00

ALL FEES INCLUDED
Add to Cart
  

This business document is categorized under the function(s):

It applies to All Industries

File Type: Excel (xlsm)

File Size: 5.2 MB

Purchase includes lifetime product updates. After your purchase, you will receive an email to download this document.

This product contains a supplemental PDF document.

Initial upload date (first version): Oct 27, 2020
Most recent version published: Oct 27, 2020

Ask the Author a Question

Must be logged in Click here to log in






CUSTOMER TESTIMONIALS




SELECT CUSTOMERS

Since 2012, we have provided best practices to over 5,000 businesses and organizations of all sizes across the world—in over 130 countries. Below is just a very small sample of our customer base.



Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.



CUSTOMERS ALSO BOUGHT THESE DOCUMENTS

41-slide PowerPoint deck
$49.00
Author: LearnPPT
Excel workbook
$49.95
5-page Word document and supporting Word
$29.00
147-slide PowerPoint deck and supporting Excel workbook
$69.00
47-slide PowerPoint deck
$69.00
56-slide PowerPoint deck
$65.00
32-slide PowerPoint deck and supporting Excel workbook
$49.00
Author: LearnPPT
63-slide PowerPoint deck
$49.00
Author: LearnPPT
35-slide PowerPoint deck
$49.00
1-page PDF document
$30.00

 
RELATED TOPICS

TOP 10 TOPICS

Become your organization's resident expert on...

Digital Transformation
 
Strategy Development
 
Organizational Design (OD)
 
Performance Management
 
Post-merger Integration (PMI)
 
Organizational Culture (OC)
 
Business Transformation
 
Innovation Management
Interested in something else? Browse our 350+ Business Toolkits of best practices, each focused on a specific management topic.