A chair furniture manufacturer makes 21 different types of chairs, which are categorize into single-seat chairs or multiple seat chairs. The manufacturer can make at most three times as many single set chairs as multiple seat chairs. There are 5000 machine hours and $15000 production budget available each month. The manufacturer has recorded data for 12 months regarding its production quantities, raw materials costs; total machine hours used, and total sales for each week for each chair. This data is stored in the Excel file named ch3_P1chairproduction and can be downloaded from the companion website at.

a.Use a pivot table to process the operational data and calculate:

The average cost of raw materials for a single chair and a multiple chair

The average machine time for a single chair and a multiple chair

The average sales price for a single chair and a multiple chair