For the current year a company provides the following information related to the sales of products that come with a 2-year warranty against manufacturer's defects.

Please include excel formulas, Thank you.

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 (Use cells A2 to B7 from the given information above to complete this question.) Requirement 4: Year-End Adjusting Entry for Future Warranty Costs, assuming portion repaired this year in cell F15 (Use cells A2 to B7 from the given information above to complete this question. Be sure to include a reference to cell F15 in your formula.)