FAQ: Analyzing Financial Burn Rates
Published on April 23, 2026 QuoteX
Learn how QuoteX calculates Cost Burn for selected timeline periods, how the SUMPRODUCT calculation works, and how to use timeline cell selection to analyze costs.
Quick Overview
QuoteX calculates Cost Burn for the selected timeline cells by multiplying the hours by the applicable cost rate and then summing the resulting values. The calculated total is displayed in the status bar.
Cost Burn Calculation
Q1: How does the Cost Burn calculation work for a timeline period?
To calculate Cost Burn for a timeline period, select the relevant cells within the timeline or matrix.
QuoteX uses the SUMPRODUCT formula to multiply the hours by the cost rate and displays the resulting total cost in the status bar.
Example: Selected timeline cells are used to calculate Cost Burn, with the resulting cost displayed in the status bar.
Calculation:
Cost Burn = SUM of (Hours × Cost Rate) for the selected timeline cells.
Understanding SUMPRODUCT
Q2: What is SUMPRODUCT and how is it applied in calculating Cost Burn?
SUMPRODUCT is a formula that multiplies the hours worked by the cost rate for each selected cell and then sums the resulting values.
This provides the total cost burn for the selected timeline period.
| Component | Used For |
| Hours | The hours represented by the selected timeline cells. |
| Cost Rate | The applicable cost rate for the selected cells. |
| SUMPRODUCT | Multiplies each hours value by its corresponding cost rate and sums the results. |
| Status Bar | Displays the calculated total cost. |
In simple terms: Select the cells you want to analyze, and QuoteX calculates the corresponding cost by applying the cost rate to the hours in those cells.
Cost Rate vs. Adjusted Rate (Price)
Q3: Is it possible to see the adjusted rate (Price) along with the cost rate in the burn calculation?
Currently, the status bar displays only the total cost using the cost rate.
QuoteX is considering adding an option to display Price, using the adjusted rate, alongside Cost in a future update.
Current Limitation:
The current status bar shows the total Cost based on the cost rate. Price based on the adjusted rate is not currently displayed as part of the burn calculation.
Selecting Cells for Burn Analysis
Q4: How does cell selection work for calculating Cost Burn?
Cell selection works similarly to spreadsheets. You can highlight multiple cells within the timeline.
Once the cells are selected, QuoteX automatically calculates the burn for those selected periods based on the hours and cost rate.
- Select the relevant cells in the timeline or matrix.
- Highlight multiple cells when you want to analyze more than one period or resource allocation.
- Review the calculated Cost Burn in the status bar.
Quick Tip: Select only the timeline cells you want to analyze. The status bar calculation updates based on the selected cells.
Quick Reference
| Question | Answer |
| How is Cost Burn calculated? | QuoteX multiplies hours by the cost rate for each selected cell and sums the results using SUMPRODUCT. |
| Where is the result displayed? | The total cost is displayed in the status bar. |
| Can I calculate burn for multiple cells? | Yes. Highlight multiple cells in the timeline or matrix. |
| Does the current burn calculation show Price? | No. The current status bar displays total Cost using the cost rate. |
| Is Price planned for a future update? | The article states that QuoteX is considering an option to show Price using the adjusted rate alongside Cost. |
Key Takeaway
QuoteX calculates Cost Burn from the selected timeline cells using the hours and cost rate. The calculation uses SUMPRODUCT, and the resulting total Cost is displayed in the status bar. The current implementation does not display Price based on the adjusted rate.
Knowledge Article Number: KA-00044