Exercise 7-11 Clifton Informatics provides data processing services to small businesses in the Northeast. For years, the company has allocated the cost of the data storage department using the number of tape mounts (how many times a data tape is loaded onto the computer's tape drive). This rate was tied closely to direct labor usage, since the more tapes that were mounted, the more operators that were needed to mount them. Under the current system, a customer is charged $1.50 each time a tape is mounted. Three months ago the company implemented a new data storage system that uses an automated tape library. As a result, operators are no longer needed to mount the tapes. So temporarily is stored on a computer disk and never transferred to tape. With the new system, the department's payroll has dropped from 20 operators to 3. data that is used only Emma Davis, manager of the data center, believes that the new system's costs are more the result of data storage than of number of tape mounts. She has gathered the following information on the operation of the storage system, which is expected to cost $340,818 per year to operate. Gigabytes of Storage Dale Matthews Johnson Flowers Daniel Number of Tape Mounts 69,388 142,392 5,072 1,972 8,388 227,212 36,254 75,236 830 19,762 132,100 Total Calculate the activity cost rate for the data storage department using the number of tape mounts as the activity driver. (Round answer to 2 decimal places, e.g. 15.25.) Activity cost rate $ per tape mount Using this rate, determine the data storage costs that should be allocated to each customer. (Round answers to 2 decimal places, e.g. 15.25. Using this rate, determine the data storage costs that should be allocated to each customer. (Round answers to 2 decimal places, e.g. 15.25.) Customer Dale Matthews Johnson Flowers Daniel Allocated Storage Cost Total Calculate the activity cost rate for the data storage department using gigabytes of data storage as the activity driver.(Round answer to 2 decimal places, e.g. 15.25.) Activity cost rate per gigabyte Using this rate, determine the data storage costs that should be allocated to each customer. (Round answers to 2 decimal places, e.g. 15.25.) Customer Allocated Storage Cost Dale Total Calculate the activity cost rate for the data storage department using gigabytes of data storage as the activity driver. (Round answer to 2 decimal places, e.g. 15.25.) per gigabyte Using this rate, determinethe data storage costs that should be allocated to each customer. (Round answers to 2 decimal places, e.g. 15.25) Customer Allocated Storage Cost Dale ohnson Flowers Daniel Total Click if you would like to Show Work for this question: Open Show Work
