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.) For the current year, a company provides the following information related to the sale of products that come with a 2-year warranty against manufacturer's defects. Required: 1. Calculate the total number of units expected to require warranty repairs. 2. Calculate total estimated warranty costs. 3. Prepare the adjusting journal entry for estimated future warranty costs, assuming that the portion of units requiring repairs in the current year was: 0% 4. Prepare the adjusting journal entry for estimated future warranty costs, assuming that the portion of units requiring repairs in the current year was: 20% 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. 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.) For the current year, a company provides the following information related to the sale of products that come with a 2-year warranty against manufacturer's defects. Required: 1. Calculate the total number of units expected to require warranty repairs. 2. Calculate total estimated warranty costs. 3. Prepare the adjusting journal entry for estimated future warranty costs, assuming that the portion of units requiring repairs in the current year was: 0% 4. Prepare the adjusting journal entry for estimated future warranty costs, assuming that the portion of units requiring repairs in the current year was: 20% 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect