5 5 7 B 9 Problem Ithacor Training Inc. started as a single facility for job...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
5 5 7 B 9 Problem Ithacor Training Inc. started as a single facility for job retraining in Ithaca, New York. The company recently expanded to a new, much larger, second facility in Cortland. The company provides meals from the cafeteria in the Cortland facility to the employees at both locations. Ithacor Training also has a common cleaning crew, and an HR department that provides hiring and job placement for the retrained workers. The company is interested in how the support costs can best be assigned to the facilities which should be held responsible. Information about the costs for the support departments and the consumption of that support is provided here. 0 1 2 23 24 Operating costs incurred by department Cost per year to operate Cost allocation bases and usage by department Number of employees served Square footage cleaned Number of employees hired Human Cafeteria Janitorial Resources $1,450,000 $160,000 $98,000 $ 1,708,000 Cafeteria 35,000 20 Janitorial 75 75 Human Resources Total Service Department Costs 50 10,000 Ithaca 300 50,000 300 Cortland ALIAGE 75 105,000 75 H Total Benchmark 25 Instructions 26 There are four parts to this problem. Use Excel to perform the following: 27 a. Set up the iterative formulas to compute the costs allocated to each support department using the 500 200,000 470 28 reciprocal method. 29 b. Use formulas to calculate the amount allocated from the three service departments to the two locations, use the reciprocal method. 30 Dennnge untered column short buon the alle Antal a. Total costs plus resources consumed Department's own costs Allocate Cafeteria Allocate Janitorial Allocate HR Total costs plus resources consumed by each support department Cafeteria Janitorial b. Allocation of support costs using the reciprocal method Cafeteria Janitorial Department's own costs Cafeteria Janitorial Human Resources Total costs after allocations Human Resources Resources Ithaca Cortland Total 5 5 7 B 9 Problem Ithacor Training Inc. started as a single facility for job retraining in Ithaca, New York. The company recently expanded to a new, much larger, second facility in Cortland. The company provides meals from the cafeteria in the Cortland facility to the employees at both locations. Ithacor Training also has a common cleaning crew, and an HR department that provides hiring and job placement for the retrained workers. The company is interested in how the support costs can best be assigned to the facilities which should be held responsible. Information about the costs for the support departments and the consumption of that support is provided here. 0 1 2 23 24 Operating costs incurred by department Cost per year to operate Cost allocation bases and usage by department Number of employees served Square footage cleaned Number of employees hired Human Cafeteria Janitorial Resources $1,450,000 $160,000 $98,000 $ 1,708,000 Cafeteria 35,000 20 Janitorial 75 75 Human Resources Total Service Department Costs 50 10,000 Ithaca 300 50,000 300 Cortland ALIAGE 75 105,000 75 H Total Benchmark 25 Instructions 26 There are four parts to this problem. Use Excel to perform the following: 27 a. Set up the iterative formulas to compute the costs allocated to each support department using the 500 200,000 470 28 reciprocal method. 29 b. Use formulas to calculate the amount allocated from the three service departments to the two locations, use the reciprocal method. 30 Dennnge untered column short buon the alle Antal a. Total costs plus resources consumed Department's own costs Allocate Cafeteria Allocate Janitorial Allocate HR Total costs plus resources consumed by each support department Cafeteria Janitorial b. Allocation of support costs using the reciprocal method Cafeteria Janitorial Department's own costs Cafeteria Janitorial Human Resources Total costs after allocations Human Resources Resources Ithaca Cortland Total
Expert Answer:
Answer rating: 100% (QA)
Requirement A Allocation of support costs using the direct method Departments own costs Allocate Caf... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
B 4 5 5 7 B 9 0 1 23456 7 8 9 0 1 2 3 4 Current year: Sales Inventory purchases Sales and marketing expense Accounts receivable Accumulated depreciation Accrued expenses Interest expense Inventory...
-
Lynsar Corporation started as a single plant to produce its major components and then assembled its main product into electric motors. Lynsar later expanded by developing outside markets for some...
-
Mylar Corporation started as a single plant to produce its major components and then assembled its main product into electric motors. Mylar later expanded by developing outside markets for some...
-
5 Melbourne Corporation has traditionally made a subcomponent of its major product. Annual production of 30,000 subcomponents results in the following costs: Direct materials Direct labor Variable...
-
A stock has had the following year-end prices and dividends: What are the arithmetic and geometric returns for the stock? Price $43.15 48.13 57.05 45.13 52.05 61.13 Year Dividend $.45 .49 .55 62 .68
-
Quebec Urban Furniture, Inc. produces all types of office furniture. The "Executive Secretary" is a chair that has been designed using ergonomics to provide comfort during long work hours. The chair...
-
The material that formed the earth was created in a supernova explosion approximately 6 billion years ago. The two most common isotopes of uranium, \({ }^{238} \mathrm{U}\) and \({ }^{235}...
-
The following stockholders equity accounts arranged alphabetically are in the ledger of Tyner Corporation at December 31, 2010. Common Stock ($5 stated value) ........... $2,000,000 Paid-in Capital...
-
d) Write down the exact outputs of the following program. Please explain with detailed steps. public class Qld { public static void main(String[] args) { [6 marks] } func("Abc123 Aabd2223"); public...
-
The proposed rates were not in the range the CEO expected given the pricing analysis. The CEO has asked the pricing actuary to verify the total projected loss cost excluding potential large storm...
-
operations. This challenge has 3 parts: (1) What are motivational operations? Your answer is limited to no more than 20 words. (2) How do they relate to abolishing and establishing operations? Your...
-
In September 2018, Hangzhou All Venture Capital (HAVC), an investment arm of Alibaba, purchased 218 million shares of One97Communications (One97C) in a private placement, which represents 25% of the...
-
If WACC is 7.28%, perpetual (terminal) growth rate is 2.8%, non-operating assets equal $290,000 and debt/non-equity claims equal $179,500, calculate the Discounted Cash Flow value given the unlevered...
-
In our text Our Iceberg Is Melting , Kotter provides a story-based scenario of a situation needing a change intervention. Review the reading from our text and state how Kotter's last four steps (5...
-
JUnit: PrimeGensTest.java In Python 3, all kinds of lazy sequences are easy to produce with generators , special functions that yield their results one element at the time and then continue their...
-
Research "mediation and arbitration agreement". Conduct additional research into these types of arrangements where employers mandate how employment-related disputes will be resolved. These are legal,...
-
Ben takes 3 hours to wash 270 dishes, and Frank takes 4 hours to wash 460 dishes. How long will they take, working together, to wash 3800 dishes?
-
Describe a job you have had in the past or a job you are very familiar with. Indicate the negative aspects of the job and how it could be improved with current human resource management techniques.
-
Ray and Maria Gomez have been married 3 years. They live at 1610 Quince Ave., McAllen, TX 78701. Ray works for Palm Oil Corporation and Maria works for the City of McAllen. Maria's Social Security...
-
Kathy Kennedy (age 44) is a single taxpayer and she lives at 212 North Pine Way, Payson, AZ 85541. Her Social Security number is 467-98-9784. Kathy's earnings and income tax withholding as the...
-
If Charles, a 16-year-old child model, earns $50,000 a year and is completely self supporting even though he lives with his parents, can his parents claim him as a dependent? Why or why not?...
-
Who was Phar-Mors flamboyant Chief Executive Officer?
-
Which of the following generally is not considered something of value? 1. Cash, money or checks 2. Airline miles or hotel credits associated with frequent activity (e.g., frequent flier miles) 3. An...
-
Which of the following is not one of the five major categories of fraudulent disbursements? 1. Payroll schemes 2. Expense reimbursement schemes 3. Shell company schemes 4. Billing schemes
Study smarter with the SolutionInn App