Skip to content
Gallery
BidTracker AI at Work Challenge
About this template
Bid Doc and Tracker with AI template
Challenge Checklist
Draft a Bid Doc and Tracker with AI
More
Share
Explore

icon picker
Bid Doc and Tracker with AI template

Create a draft of a Bid Doc by answering a few short questions
here
⁠
.
Create a table with 10 items (replace items in BidTable as needed)
Bid Starter
Question
Question 1
Question 2
Question 3
Question 4
1
Who is the lowest bidder?
Which price is out of whack by section (rows) therefore skewing the total price of the contractor?
What is the lowest possible price to buy this project out at? In other words, for each section of the project, take the lowest price, and give the total lowest price.
What is the 2nd lowest price to buy it out at?
What is the 3rd lowest price to buy it out at?
There are no rows in this table
⁠
Sum of Bidder 1:
11450
⁠
⁠
Sum of Bidder 2:
12450
⁠
⁠
Sum of Bidder 3:
240
⁠
⁠

Max of Price Skew:
12050
⁠
⁠
Sum of Lowest Bid(buyout):
300
⁠
⁠
BidTable 2
Item
Bidder 1
Bidder 2
Bidder 3
Lowest Bid
Lowest Bidder
Price Skew
Column Sort
1
Paint
11100
12100
50
50
Bidder 3
12050
​
2
Valves
50
50
0
0
Bidder 3
50
​
3
Fans
50
50
0
0
Bidder 3
50
​
4
Ducts
30
30
60
30
Bidder 1
30
​
5
Radiation
60
60
70
60
Bidder 1
10
​
6
Piping
50
50
60
50
Bidder 1
10
​
7
Coils
60
60
​
60
Bidder 1
0
​
8
Finish trim
50
50
​
50
Bidder 1
0
​
There are no rows in this table
11450
Sum
⁠

Write a bid doc based on Bid Starter

Bid Document

Project Overview

We are submitting this bid for the project as outlined in the Bid Starter document. Our team is experienced in providing high-quality services for similar projects and we are confident that we can deliver the results you are looking for.

Scope of Work

Our proposed scope of work for this project includes the following:
Task 1: [Description of Task 1]
Task 2: [Description of Task 2]
Task 3: [Description of Task 3]

Deliverables

Our proposed deliverables for this project include the following:
(Copy/Paste BidTable 1 Items)
Deliverable 1: [Description of Deliverable 1]
Deliverable 2: [Description of Deliverable 2]
Deliverable 3: [Description of Deliverable 3]

Timeline

Our proposed timeline for this project is as follows:
Month 1: [Description of Month 1 tasks]
Month 2: [Description of Month 2 tasks]
Month 3: [Description of Month 3 tasks]

Budget

Our proposed budget for this project is [insert amount see BidTable 1]. This includes all costs associated with the project, including materials, labor, and any other expenses.

Conclusion

Thank you for considering our bid for this project. We are confident that we can provide the high-quality services you require and we look forward to the opportunity to work with you.
⁠

PriceTable
Action
Description
1
Make a column
In
BidTable 2
⁠
, create a new column with the name "Lowest Bid".
2
Formula
In the "Lowest Bid" column, use the following formula: Min([Bidder 1 Price], [Bidder 2 Price], [Bidder 3 Price]).
There are no rows in this table
⁠

Results Table 2
Question
answer
Result
1
Who is the lowest bidder?
Contact potential vendors for bids
Evaluate bids based on factors such as cost, quality, and reputation
Determine the lowest bidder based on the evaluation results
This is easy See Bidtable low bid total = 180
2
Which price is out of whack by section (rows) therefore skewing the total price of the contractor?
​
see Bidtable Price skew =12050
There are no rows in this table
⁠
Buyout Table 2
Question
Answer
Buyout
Notes
Image 5
1
What is the lowest possible price to buy this project out at? In other words, for each section of the project, take the lowest price, and give me the total lowest price.
Identify sections of the project
Find lowest price for each section
Add up lowest prices to get total lowest pric
Lowest Buyout = 300
Open
2
What is the 2nd lowest price to buy it out at?
​
see Bidtable 2nd Lowest =
Open
3
What is the 3rd lowest price to buy it out at?
​
see Bidtable 2nd Lowest =
Open
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.