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. i have most of the problem completed just need the the units to use to get the finished good inventory. I know I use the $166.06 but don't know what the finished goods. Please help. If you ahve completed spreadsheet that would be great. Thanks