Calculate reciprocal amounts using a formula in output area

Assignment Help Accounting Basics

Reference no: EM131988195

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

Reference no: EM131988195

Questions Cloud

Most common in occupations than be monitored easily : Piece rate wage contracts are most common in occupations than be monitored easily by managers?

Describe an experience for each domain of nursing practice : In describing the three experiences, use the appropriate criteria to outline the description of your experience, and to validate your level of competence.

Determine the cash flow after taxes : The asset will be classified as class 8 property with d = 20%. Using the generalized cash flow approach, determine the cash flow after taxes.

Compute equilibrium price and quantity for problem : Assume that the income changed from Y= 10 to Y= 7. What are the equilibrium price and quantity now

Calculate reciprocal amounts using a formula in output area : Support Department Allocation Assignment Use the following data to prepare a model. Calculate the reciprocal amounts using a formula in the output area.

Re-write of an australian classic short story : The drover"s wife by Henry LawsonRe-write one of the short stories we have studied in class from our Australian Literature unit and set it in modern day.

Typical downward-sloping straight lines : Assume that the demand curve and marginal revenue curve are the typical downward-sloping straight lines. The monopoly deadweight loss equals $4,000.

How you would obtain best available evidence for practice : You are the manager at the local community health service in a rural area and you are in charge of a multidisciplinary team.

Real gdp in 2016? in economy : Based on the information in Scenario? 1, real GDP in 2016? (in 2015? dollars) in this economy was.

User Account

All Pages