Allison Manufacturing Ending Finished Goods Inventory Budget (Schedule 7) For March 31 Unit cost computation: Direct materials: Rate x Units or Hours Metal $8.00 10 $ 80.00 Components $5.00 6 30.00 $ 110.00 Direct labor $14.25 3 42.75 Overhead: Variable $2.40 3 7.20 Fixed $ 2.04 3 6.11. I need help with calculating a formula for excel of the following below.

Total unit cost $ 166.06 x Units in finished goods inventory

Finished goods inventory