Excel Assignment Dept cost : must be in Excel

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 the support department with the highest cost first.

4. For the reciprocal method, either calculate the reciprocal amounts using a formula in Excel or use iterative equations to calculate the amounts. Do NOT type the amounts in.

	Support Departments		Producing Departments
Departments	Admin	Accounting	Machining	Packaging
Direct Overhead	$200,000	$100,000	$40,000	$70,000
Square Footage		2,000	4,000	3,000
# of Receiving Orders	200		1,600	200