Hello I am in need of assistance on this group question, organized work in charts would be very appreciated, thank you!

Ice Cool produces two different models of air conditioners. The activities, costs, and cost drivers associated with the production processes follow. Process Activity Machining Setups Assembly Budgeted Activity Usage 7,800 180 Activity Cost Driver Machine hours (MH) Setups Budgeted Cost $ 311,200 26.000 $ 337,200 $ 228,000 $ 136,000 780 Finishing Support Inspecting Purchasing Inspections Purchase orders 510 Additional production Information concerning its two models follows. Units and Activities Units produced Machine hours Setups Inspections Purchase orders Model X 1,600 2,200 60 480 340 Model z 3,200 5,600 120 300 170 Per Unit Selling price per unit Direct materials cost per unit Direct labor cost per unit Model X $ 420 145 140 Model z $400 105 160 1. Compute the activity rate for each activity using activity based costing. 2. Using activity based costing, compute the overhead cost per unit for each model 3. Compute the total product cost per unit for each model. 4. For each model, compute the gross profit per unit (selling price per unit minus product cost per unit). Complete this question by entering your answers in the tabs below. Inspections Purchase orders 480 340 300 170 Model X $ 420 145 140 Model z $ 400 les 160 Per Unit Selling price per unit Direct materials cost per unit Direct labor cost per unit 1. Compute the activity rate for each activity using activity-based costing. 2. Using activity-based costing, compute the overhead cost per unit for each model. 3. Compute the total product cost per unit for each model. 4. For each model, compute the gross profit per unit (selling price per unit minus product cost per unit). Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Compute the activity rate for each activity using activity-based costing. (Round "Activity rate" to 2 decimal places.) Budgeted Cost Budgeted Activity Usage Activity Rato Activity Machining Setups Inspecting Purchasing Rogue Required 2 > Saved Requirea Requirea 2 Requirea 3 Requirea 4 Using activity-based costing, compute the overhead cost per unit for each model. (Round "Activity Rate" to 2 decir other answers to the nearest whole dollar amount.) Overhead cost per unit-Model X Activity Activity Usage Activity Rate Allocated Cost Machining Setups Inspection Purchasing Total allocated cost Units produced Overhead cost per unit Activity Usage Activity Rate Allocated Cost Overhead cost per unit-Model Z Activity Machining Setups Inspection Purchasing Total allocated cost Units produced Overhead cost per unit Required 1 Required 3 > labor cost per unit 140 160 1. Compute the activity rate for each activity using activity-based costing. 2. Using activity-based costing, compute the overhead cost per unit for each model. 3. Compute the total product cost per unit for each model. 4. For each model, compute the gross profit per unit (selling price per unit minus product cost per unit Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Compute the total product cost per unit for each model. (Round "Activity Rate" to 2 decimal places and oth calculations to the nearest whole dollar amount. Round your final answers to 2 decimal places.) Direct Materials Direct Labor Overhead Product Cost per Unit Per Unit Model X Model Z 1. Compute the activity rate for each activity using activity-based costing. 2. Using activity-based costing, compute the overhead cost per unit for each model. 3. Compute the total product cost per unit for each model. 4. For each model, compute the gross profit per unit (selling price per unit minus product Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required For each model, compute the gross profit per unit (selling price per unit minus product cost per unit" and "Gross Profit" to 2 decimal places and other intermediate calculations to the n Negative amounts should be indicated with a minus sign.) Per Unit Selling Price Product cost per unit Gross Profit Model X Model Z