see attached photos for data tables and all question parts. answer all parts/requirements. i will give like/thumbs up for correct answer! thank you for your help!!

Elegant Doors, Inc, produces two types of doors, interior and exterior. The company's simple costing system has two direct cost categories (materials and labor) and one indirect cost pool. The simple costing system allocates indirect costs on the basis of machine-hours. Recently, the owners of Elegant Doors have been concerned about a decline in the market share for their interior doors, usually their biggest seller. Information related to Elegant Doors production for the most recent year follows: (Click the icon to view the production data.) (Click the icon to vlew additional information.) More info The owners have heard of other companies in the industry that are now using an activity-based costing system and are curious how an ABC system would affect their product costing decisions. After analyzing the indirect cost pool for Elegant Doors, the owners identify six activities as generating indirect costs: production scheduling, material handling. machine setup, assembly, inspection, and marketing. Elegant Doors collected the following data related to the indirect cost activities: Marketing costs were determined to be 4% of the sales revenue for each type of door. Data table Requirement 1. Calculate the cost of an interior door and an exterior door under the existing simple costing system. Before calculating the cost of an interior and exterior door, begin by calculating the overhead rate under the simple costing system. First select the formula, then enter the applicable amounts and calculate the rate. (Round your answer to the nearest cent. Abbreviations used: bgt. = budgeted, qty = quantity.) Now calculate the cost of an interior door and an exterior door under the existing simple costing system. Start by calculating total costs and then calculate the cost per unit for each product. (Round interim calculations to the nearest cent and your final answers to the nearest whole dollar.) Now calculate the cost per unit for each product under the simple costing system. (Round your answers to the nearest cent.) Requirement 2. Calculate the cost of an interior door and an exterior door under an activity-based costing system. Begin by calculating the ABC allocation rate for each activity. First select the formula, then enter the applicable amounts and calculate the rates. (Round your answers to the nearest cent. Abbreviations used: Bgt. = Budgeted, mach = machine, mat. = material, prod = production, sch. = scheduling, qty. = quantity. . Now calculate the cost of an interior door and an exterior door under an activity-based costing system. (Round interim calculations to the nearest cent and your final answers to the nearest whole dollar) Now calculate the cost per unit for each product under ABC. (Round your answers to the nearest cent.)