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...
-
Is it fair to give higher raises to younger officers?
-
Figure 5.6 indicates how to construct a module of chips that can store 1 MByte based on a group of four 256-Kbyte chips. Let's say this module of chips is packaged as a single 1-Mbyte chip, where the...
-
Convert \(\frac{13}{20}\) to decimal form. Do the indicated conversion. If it is a repeating decimal, use the correct notation.
-
Selected accounts from Dences Gourmet Shops adjusted trial balance as of March 31, 2014, the end of the current fiscal year, follow. The merchandise inventory for Dences was $81,222 at the beginning...
-
Please explain 7. On January 1, the Biddle & Biddle, CPAs received a $7,500 cash retainer for accounting services to be provided rateably over the next 3 months. The full amount was credited to th...
-
Mike Greenberg opened Sheffield Window Washing Inc. on July 1, 2022. During July, the following transactions were completed. July 1 Issued 12,700 shares of common stock for $12,700 cash. 1 Purchased...
-
Determine the moment in N.m about line OB of the force F. F = 647 N. N 325 mm 150 mm F 350 mm y 400 mm O a. MOB = 142.3 N.m O b. MOB = -48.5 N.m O c. MOB = -82.9 N.m O d. MOB = -135.9 N.m O e. MOB =...
-
Beach Style is a manufacturer of outdoor furniture. The firm\'s product line includes four side tables designs: Production: Cement - $ 4 4 1 . 1 8 Polystone - $ 0 Travertine - Look - $ 3 9 7 1...
-
1. Brasher Company manufactures and sells a single product that has a positive contribution margin. If the selling price and variable expenses both decrease by 5% and fixed expenses do not change,...
-
Your team received approval for the scope of your project (either the Human Resource Management (HRM) Standardization Project, the Financial Management Standardization (FMS) Project) or the New...
-
The following information pertains to Rica Company: Sales (50,000 units) $1,000,000 Manufacturing costs: Variable 340,000 Fixed 70,000 Selling and admin. expenses: Variable 10,000 Fixed 60,000 How...
-
An investor earns 10.01 percent before tax and is subject to a 32 percent tax on such earnings. Calculate the investor's after-tax rate of return. Round the answer to two decimals in percentage form....
-
Critically evaluate five (5) modes of transport used to move goods across the globe and include in your examples the types of goods that each mode most suitable to carry and why
-
Data 9.2 on page 540 introduces the dataset Cereal, which includes information on the number of grams of fiber in a serving for 30 different breakfast cereals. The cereals come from three different...
-
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?...
-
Write out the full accounting equation.
-
State two different ways in which profit can be measured.
-
In the absence of any new capital introduced, or any withdrawal of capital by the owner, what will cause the balance on the owner's equity account to change from year to year?
Study smarter with the SolutionInn App