Excel Support Department Allocation Assignment

Use the following data to prepare a model that allocates the support departments using the three methods (direct, sequential, and reciprocal). Pay attention to the following instructions:

1. You should design your model to include an input section, an output section, and user instructions.

2. The output section should have nothing but references and formulas in it.

3. For the sequential method, allocate HR first.

4. Put the reciprocal equations in the input area in a text box. Calculate the reciprocal amounts using a formula in the output area.

	*	*	**	**
Departments	Power	HR	Pottery	Landscape
Overhead Costs	$150,000	$160,000	$83,600	$47800
Machine Hours		1000	3,600	5,400
# Employees	20		60	80

*Support Departments

** Producing Departments