a$.$ Set up the iterative formulas to compute the costs allocated to each support department using the reciprocal method.

b$.$ Use formulas to calculate the amount allocated from the three service departments to the two locations, use the reciprocal method.

c$.$ Prepare a clustered column chart showing the allocations of each support department's cost and total support costs allocated to each operating department. Include a descriptive chart title and axes labels, properly formatted amounts on the axes, a legend, and display dollar amounts as data labels on the columns.

d$.$ Examine the chart and discuss the pattern in the consumption of resources.