

If you copy/paste from the 7 Instruction tab you will be marked wrong.) 8 9 Steger Enterprises Bluestone Inc.We also want to use our platform to highlight the response from the scientific community.
#Formation xlstat full#
(Always use cell references and formulas where appropriate to receive full credit. jobs if Wharton Associates had used its 6 refined costing system with multiple direct-cost categories and one indirect-cost pool. Compute the costs of the Steger Enterprises and Bluestone Inc.
#Formation xlstat professional#
If you copy/paste from the e Instruction tab you will be marked wrong.) 3 4 5 per professional labor hour 2. Calculate the revised indirect-cost allocation rate per professional labor-hour for Wharton Associates when total indirect costs are $200,000.

8 9 Total cost of the jobs using the simple costing system are as follows: 10 11 Steger Enterprises Bluestone Inc. Total indirect 7 costs in the most recent period were $500,000. Indirect costs are allocated to cases at $100 an hour.

5 Professional labor hours 3,000 2,000 6 Professional labor costs at Wharton Associates are $160 an hour. jobs if Wharton Associates had used its refined costing system with multiple direct-cost categories INSTRUCTIONS JOBFILES ENTERANSWERS 14 2Ī2 The job files for two of Wharton's clients, Steger Enterprises and Blu D E F A 1 **DATA SHEET - DO NOT ENTER ANSWERS HERE** The job files for two of Wharton's clients, Steger Enterprises and 2 Blueston Inc., show the following: 3 4 Steger Enterprises Bluestone Inc. 12 13 Requirements 1 Calculate the revised indirect-cost allocation rate per professional labor-hour for Wharton Associates when total indirect costs are $200,000 Compute the costs of the Steger Enterprises and Bluestone Inc. If you copy/paste from 11 the Instruction tab you will be marked wrong. Always use cell references and formulas where appropriate to receive full credit. 8 9 10 Use the blue shaded areas on the ENTERANSWERS tab for inputs. The single indirect-cost pool would have $200,000 of costs and would be allocated to each case using the professional labor-hours base. 7 Peyton decides to calculate the costs of each job as if Wharton had used six direct-cost pools and a single indirect-cost pool. The direct costs can be found 6 on the "JOBFILES" tab. After analysis, Wharton is able to reclassify $300,000 of the $500,000 as direct costs. 4 5 Denise Peyton, the managing partner of Wharton Associates, asks her assistant to collect details on those costs included in the $500,000 indirect-cost pool that can be traced to each individual job (see "JOBFILES" tab for details). The job files for two of Wharton's clients, Steger Enterprises and Bluestone, Inc., can be found on the "JOBFILES" tab. Indirect costs are allocated to cases on the basis of professional labor-hours per case. Currently it uses a simple costing system with a single direct-cost category (professional labor-hours) and a single indirect-cost pool (general support). Wharton Associates operates at capacity and uses a cost-based approach to pricing (billing) each job.

#Formation xlstat pdf#
Transcribed image text: File Home Insert Draw Page Layout Formulas Data Review View Help PDF Pro 10 XLSTAT K7 A с D F G H B E Wharton Associates is a recently formed law partnership.
