Kamron's Supply, Inc. provides cleaning supplies to the automobile detailing industry. It has two support departments providing support and operating functions. Support functions departments are engineering and materials management. Operating departments are machining and assembly.

Required information:

1. Compute the single-rate method.
2. Compute the dual-rate method.
3. Compute the supply-of-capacity method.

Follow the instructions you see on the Data tab of the worksheet. Show all calculations within the cells of the Excel spreadsheet (located in Module 2 or by clicking "Next" at the bottom of this page). This means that you must use formulas and links so that your thought process can be examined.

Kamron's Supply, Inc.: Material Management Department Practical capacity Fixed costs of the materials services department 4,000 labor hours to 5,000 labor hours range Budgeted usage (qty) of materials management labor hours required to support the departments: Machining Department Assembly Department Total Budgeted variable cost per materials handling labor hours in the 4,000 labor-hour to 5,000 labor-hour range 4,500 hours 500,000 1,800 hours 2,200 hours $4,000.00 hours 35 per hour used Actual usage (qty) of materials management labor hours required to support Machining Department Assembly Department Total 1,400 hours 2,300 hours 3,700 hours Information Single Rate Answer Dual Rate Answer Based on Supply Capacity Sheet1 +