Short Answer: All work should be performed in EXCEL These questions are similar to the homework. Please show all work, you can credit by illustrating how you got the answer and for the answer itself. Even if your ultimate answer is incorrect, by showing your work, Vid-saver, Inc. has five activity cost pools and two products (a budget tape rewinder and a deluxe tape rewinder). Information is presented below: Activity Cost Pool Ordering and Receiving Machine Setup Machining Cost Driver Orders Setups Machine hours Parts Inspections Est. Overhead $120,000 297,000 1,500,000 Cost Drivers by Budget Deluxe 600 400 500 400 150,000 100,000 Assembly Inspection 1,200,000 300,000 1,200,000 550 800,000 450 Instructions Compute the overhead cost per unit for each product Production is 700,000 units of Budget and 200,000 units of Deluxe Round your answer to the nearest cent