FAQ: Analyzing Financial Burn Rates

Q1: How does the Cost Burn calculation work for a timeline period?

A: To calculate Cost Burn for a timeline period, select the relevant cells within the timeline (or matrix). The system will use the SUMPRODUCT formula to multiply the hours by the cost rate, displaying the total cost in the status bar.

Q2: What is SUMPRODUCT and how is it applied in calculating Cost Burn?

A: SUMPRODUCT is a formula that multiplies the hours worked by the cost rate for each selected cell and then sums the total. This provides an accurate calculation of total cost burn for the selected timeline period.

Q3: Is it possible to see the adjusted rate (Price) along with the cost rate in the burn calculation?

A: Currently, the status bar only displays the total cost using the cost rate. However, we are considering adding the option to show Price (using the adjusted rate) alongside Cost in future updates.

Q4: How does cell selection work for calculating Cost Burn?

A: Cell selection is intuitive and works similarly to Spreadsheets. You can highlight multiple cells in the timeline, and the system will automatically calculate the burn for those selected periods based on the hours and cost rate.