I need to know what the formula is for the adjusted warranty expense and warranty liability.

Eor the current year, a company provides the following information related to the sale of products that come Requirement 2: Estimated Warranty Costs (Use cells A2 to B7 from the given information above to complete this question.) Total estimated warranty costs: Requirement 3: Year-End Adjusting Entry for Future Warranty Costs, assuming portion repaired this year in cell F13