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

Sector Applicability: Operations and Management, Hard & Soft Facility Management,
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
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 35 documents)

$150.00

ALL FEES INCLUDED

Add to Cart

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

Operations Strategy, Marketing, & Sales

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

"As a young consulting firm, requests for input from clients vary and it's sometimes impossible to provide expert solutions across a broad spectrum of requirements. That was before I discovered Flevy.com.

Through subscription to this invaluable site of a plethora of topics that are key and crucial to consulting, I have been able to exceed expectations and deliver quality advice and solutions to my clients. The quality and expertise of the authors are exemplary and gives me great confidence to use as part of my service offerings.

I highly recommend this company for any consultant wanting to apply international best practice standards in their service offerings. "

– Nishi Singh, Strategist and MD at NSP Consultants

"Flevy is now a part of my business routine. I visit Flevy at least 3 times each month.

Flevy has become my preferred learning source, because what it provides is practical, current, and useful in this era where the business world is being rewritten.

In today's environment where there are so many challenges and there is the need to make the right decisions in a short time, with so much scattered information, we are fortunate to have Flevy. Flevy investigates, selects, and puts at our disposal the best of the best to help us be successful in our work."

– Omar Hernán Montes Parra, CEO at Quantum SFE

"I like your product. I'm frequently designing PowerPoint presentations for my company and your product has given me so many great ideas on the use of charts, layouts, tools, and frameworks. I really think the templates are a valuable asset to the job."

– Roberto Fuentes Martinez, Manager at Technology Transformation Advisory

"The wide selection of frameworks is very useful to me as an independent consultant. In fact, it rivals what I had at my disposal at Big 4 Consulting firms in terms of efficacy and organization."

– Julia T., Consulting Firm Owner (Former Manager at Deloitte and Capgemini)

"FlevyPro has been a brilliant resource for me, as an independent growth consultant, to access a vast knowledge bank of presentations to support my work with clients. In terms of RoI, the value I received from the very first presentation I downloaded paid for my subscription many times over! The quality of the decks available allows me to punch way above my weight – it's like having the resources of a Big 4 consultancy at your fingertips at a microscopic fraction of the overhead."

– Roderick Cameron, Founding Partner at SGFE Ltd

"My FlevyPro subscription provides me with the most popular frameworks and decks in demand in today’s market. They not only augment my existing consulting and coaching offerings and delivery, but also keep me abreast of the latest trends, inspire new products and service offerings for my practice, and educate me in a fraction of the time and money of other solutions. I strongly recommend FlevyPro to any consultant serious about success."

– Bill Branson, Founder at Strategic Business Architects

"As an Independent Management Consultant, I find Flevy to add great value as a source of best practices, templates and information on new trends. Flevy has matured and the quality and quantity of the library is excellent. Lastly the price charged is reasonable, creating a win-win value for the customer, Flevy and the various authors. This is truly a service that benefits the consulting industry and associated clients. Thanks for providing this service. "

– Jim Schoen, Principal at FRC Group

"If you are looking for great resources to save time with your business presentations, Flevy is truly a value-added resource. Flevy has done all the work for you and we will continue to utilize Flevy as a source to extract up-to-date information and data for our virtual and onsite presentations!"

– Debbi Saffo, President at The NiKhar Group

"I have used FlevyPro for several business applications. It is a great complement to working with expensive consultants. The quality and effectiveness of the tools are of the highest standards."

– Moritz Bernhoerster, Global Sourcing Director at Fortune 500

"One of the great discoveries that I have made for my business is the Flevy library of training materials.

As a Lean Transformation Expert, I am always making presentations to clients on a variety of topics: Training, Transformation, Total Productive Maintenance, Culture, Coaching, Tools, Leadership Behavior, etc. Flevy usually has just what I need to make my point.

It is well worth the money to purchase these presentations. Sure, I have the knowledge and information to make my point. It is another thing to create a presentation that captures what I want to say. Flevy has saved me countless hours of preparation time that is much better spent with implementation that will actually save money for my clients."

– Ed Kemmerling, Senior Lean Transformation Expert at PMG

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

Cost Reduction Opportunities (across Value Chain) 24-slide PowerPoint deck $39.00 Author: LearnPPT Cost Reduction Assessment Value Chain Analysis	Complete Business Frameworks Reference Guide 407-slide PowerPoint deck $199.00 Author: LearnPPT Strategy Frameworks Consulting Frameworks Consulting Training	Organization Design Toolkit 102-slide PowerPoint deck and supporting Excel workbook $69.00 Author: Corporate Finance 101 Organizational Design	Healthcare Business Capability Model 1-page PDF document $30.00 Author: R Bradley Consulting Healthcare
Digital Transformation Strategy 118-slide PowerPoint deck $89.00 Author: LearnPPT Digital Transformation Customer Experience Business Transformation	M&A Process Letter - Phase I and Phase II 5-page Word document and supporting Word $29.00 Author: Corporate Finance 101 M&A (Mergers & Acquisitions)	Lean Six Sigma - Bundle of 50 Tools & Templates 32-page PDF document and supporting ZIP $179.00 Author: QMaxima Inc. - Simplifying Excellence Lean Management/Enterprise Six Sigma Project	How to Build a Target Operating Model (TOM) 35-slide PowerPoint deck $49.00 Author: R Bradley Consulting Target Operating Model
Strategic Planning: Process, Key Frameworks, and Tools 79-slide PowerPoint deck $99.00 Author: ILMAM - Strategy & Management Consulting Strategic Planning Strategy Frameworks Consulting Frameworks	Design Thinking 249-slide PowerPoint deck $89.00 Author: Operational Excellence Consulting Innovation Management Customer Experience Ideation	Strategic Planning: Hoshin Kanri Strategy Deployment 128-slide PowerPoint deck and supporting ZIP $79.00 Author: Operational Excellence Consulting Strategic Planning Strategy Development Strategy Deployment & Exe ...	Post Merger Integration (PMI) Best Practice Framework 28-slide PowerPoint deck $79.00 Author: STRATICX PMI (Post-merger Integration)