Shade Inc. began operations two years ago in 2023. It produces 12-foot patio umbrellas that are guaranteed for 10-years, a warranty period that exceeds its competitors. Because of a robust year in 2024, all units were completed and shipped out as of December 31, 2024. The production manager is eligible to receive quarterly bonuses based on the company's absorption costing income before taxes. The company has chosen practical capacity to allocate fixed overhead costs. Budgeted production and sales levels, unit selling prices and unit costs of the umbrellas for the upcoming year is provided here. Total Unit Practical capacity production Units sales Selling price Direct materials cost Direct labor cost Variable manufacturing cost Fixed manufacturing costs Variable operating expenses Fixed operating expenses There are three parts to this problem. Use Excel to perform the following. (a) Prepare budgeted comparative absorption income statements at production levels of 6,000 to 7,000 units in increments of 100 units. 6,400 6,635 $189.00 48.56 37.90 12.60 5.37 $211,453 72,141