Jpl, inc. has provided its sales and expense data for the most recent period. the controller has asked you prepare a spreadsheet that shows the related cvp analysis computations. use the information included in the excel simulation and the excel functions described below to complete the task.

Mordica company identifies three activities in its manufacturing process: machine setups, machining, and inspections. estimated annual overhead cost for each activity is $156,960, $382,800, and $84,640, respectively. the cost driver for each activity and the expected annual usage are number of setups 2,180, machine hours 25,520, and number of inspections 1,840. compute the overhead rate for each activity. machine setups $ per setup machining $ per machine hour inspections $ per inspection