Please us excel spreadsheet for question:

Mordica Company identifies three activities in its manufacturing process: machine setups, machining, and inspections. Estimated annual overhead cost for each activity is $150,000, $325,000, and $87,500, respectively. The cost driver for each activity and the expected annual usage are number of setups 2,500, machine hours 25,000, and number of inspections 1,750.