Red Industries produces computers and goes through two operations, Assembling and Packaging before it is ready to be sold to customers. Next year's expected costs and activities are shown below. 1. Compute Red's departmental overhead rate for the Assembling department based on direct labor hours. 2. Compute Red's departmental overhead rate for the Packaging department based on machine hours. 3. Compute a single plantwide rate based on machine hours. Show your work with an Excel spreadsheet or in a Word file