Problem
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. 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
|
|
# of Employees
|
20
|
|
60
|
60
|
*Support Departments
** Producing Departments