PLEASE!!! PLEASE!!!!

B. Green Mountain Manufacturing has recently installed an a uning has recently installed an activity-based relational data base. Using the information contained in the activity relational table the following pool rates were computed $24 $30 per purchase order per machine hour, Process R per machine hour, Process S per engineering hour per packing order per square foot $80 $200 Two products are produced by Green Mountain: Normal and Excellent. Each product has an area in the plant that is dedicated to its production. The plant has two manufacturing processes, the Normal process (Process R) and the Excellent process (Process S). Other processes include engineering, product handling. and procurement. The product relational table for Green Mountain is as follows: Normal Product: Name Activity Driver # Units Activity Usage 800,000 1,000 Purchase orders Machine hours 320,000 Engineering hours 5.000 Packing orders 400,000 Square footage 6,000 Activity Usage 100,000 500 Excellent Product: Activity Driver # Name Units Purchase orders Machine hours Engineering hours Packing orders Square footage 40,000 6,000 100,000 4,000 Required: a. Identify two different concatenated keys. What is the purpose of concatenated keys? b. Using the pool rates and the information from the product relational table, calculate the unit overhead cost for each product. c. Using the pool rates and the information from the product relational table, calculate the overhead cost for each activity driver. B. Green Mountain Manufacturing has recently installed an a uning has recently installed an activity-based relational data base. Using the information contained in the activity relational table the following pool rates were computed $24 $30 per purchase order per machine hour, Process R per machine hour, Process S per engineering hour per packing order per square foot $80 $200 Two products are produced by Green Mountain: Normal and Excellent. Each product has an area in the plant that is dedicated to its production. The plant has two manufacturing processes, the Normal process (Process R) and the Excellent process (Process S). Other processes include engineering, product handling. and procurement. The product relational table for Green Mountain is as follows: Normal Product: Name Activity Driver # Units Activity Usage 800,000 1,000 Purchase orders Machine hours 320,000 Engineering hours 5.000 Packing orders 400,000 Square footage 6,000 Activity Usage 100,000 500 Excellent Product: Activity Driver # Name Units Purchase orders Machine hours Engineering hours Packing orders Square footage 40,000 6,000 100,000 4,000 Required: a. Identify two different concatenated keys. What is the purpose of concatenated keys? b. Using the pool rates and the information from the product relational table, calculate the unit overhead cost for each product. c. Using the pool rates and the information from the product relational table, calculate the overhead cost for each activity driver