Project Details
Burlington- Land/ Lot/ Snow 2023
RFP
Completed
Lost
Green
90%
12-15-2022
01-24-2023
Project Log Items
 
Date
Type of Note
Type of Service
Due Date
Status
Note
Resolution
 
01-12-2023 Key Assumption     Open Land    
Used a minimum of 1hr for LMow and PMow where applicable    
    Priced land seasonal contracts on a seven month season as specified in SOW    
    Irrigation startup rate of $250, shutdown rate of $350, and monitoring $100 where applicable    
    Included tax on all contracts where applicable    
Lot   
 Priced lot sweeping based on state average with an all-inclusive bid    
    Gave 2% discount on margin for every additional sweep per week    
PW    
Used 800sqft for surface area for PW across the board    
Snow    
Priced snow seasonal contracts on a five month season as specified in SOW    
    Put a price of $0 for all locations with a historical snow average of less than 2in    
    Increased efficiency and equipment used in for northern states		  
01-12-2023 Meeting     Open - spring/ fall clean-ups required in scope. 
- 25% margin across the board
- 20% margin on sweeps- go down 2% for each additional sweep
- pw twice a year
ACTION: Call Jim on his sites for PW- pricing looks too high
- 25% margin on snow
  
Postmortems
 
Date Modified
Question
Answer
Action to What We Learned
 
03-03-2023 08:16 AM Internal feedback   Over-scoped resulting in higher price to the customer. We should have engaged the field and reconciled the scope to something similar to Dollar General.
03-03-2023 08:16 AM Internal feedback   Snow could have been more sharp. We found out the client only plows half their lot. Seasonal numbers were potentially high on analysis.
03-03-2023 08:16 AM Internal feedback   Land frequencies were too high. This goes back to reconciling the scope and getting the field involved.
Show fields from Show fields from Show fields from a related table
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:
Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.