Chapter 4 Case 1 The following information has been gathered for the four types of products that your company sells. The overhead and cost allocation basis are included in the following table. Requirements: a. Create a computer spreadsheet to calculate the Cost Allocation Rate using the above table. b. Create a computer spreadsheet to calculate the profitability for each product line. Use the following template. (Selected check figures have been provided.)