Calculate activity cost rates for each of activity pools

Assignment Help Cost Accounting
Reference no: EM13170779

Develop an ABC Costing System for Classic Pen Co. using the information provided in the case and the requirements below.

Required:

1. Identify the appropriate activity cost pools and cost drivers (hint: there should be four).

2. Identify the appropriate portions of the $60,000 "Support Expenses" to be aligned with each of the identified activity cost pools.

3. Calculate the activity cost rates for each of the activity cost pools.

4. Calculate the amount of "Support Expenses" to be allocated to each of the four product lines for each activity.

5. Calculate the operating income for each product line within this ABC costing environment.  Which product lines were being undercosted under the old simple costing system?  Which product lines were being overcosted?

Detail your answers to each of the above requirements within a single Microsoft Excel worksheet, using a logical and coherent presentation of all calculations and results (presentation, readability, and logical flow of worksheet will be considered as part of the grade on this assignment).  Please use formulas in all cells where calculations are present, using cell references for inputs where applicable. You should be detailing the inputs of all calculations within your worksheet prior to representing the calculation result.  For example, if you're calculating the activity cost rate of the [insert generic activity cost pool name here] cost pool:

Instead of:

[Generic] cost pool activity cost rate:

50%

Show:

Generic cost pool:

$100,000

/

$200,000

=

50%

Attachment:- Pencase.pdf

Reference no: EM13170779

Questions Cloud

Sodium sulfate and barium sulfate : solution containing 1.00 g of barium nitrate (199.33g/mol) is combined with 500 mL of a solution containing 1.00 g of sodium sulfate (142.03 g/mol)
What will the volume be for the same amount of gas : A gas temperature at 100C occupies a volume of 154 mL. What will the volume be for the same amount of gas at a temperature of 10C, assuming no change in pressure?
Define situation the oylan vinegar company : In a crazy situation the Oylan Vinegar Company has 10,000 gallons of vinegar with a concentration of .114 M. It also hass a .68% acetic acid by mass
Compute the volume of naoh needed to titrate : Calculate the volume of .100 M NaOH needed to titrate 25 mL of store bought vinegar
Calculate activity cost rates for each of activity pools : Calculate the activity cost rates for each of the activity cost pools and calculate the amount of "Support Expenses" to be allocated to each of the four product lines for each activity.
State what is the minimum volume of dripping water saturated : What is the minimum volume of dripping water saturated with calcium carbonate that would be required to form a small stalactite that had a mass of 1.000 kg?
Explain how would prepare buffer solution : Describe how you would prepare 150.0 mL of a pH = 5.00 buffer solution from a solution of 0.200-M aniline, C6H5NH2, a weak base
Who associated with american federation of labor : Who succeeded Andrew Johnson as the president?  Who is associated with American Federation of Labor (AFL)?  Who was a famous commander of the Confederate Army?
Compute the solubility from ksp and vice versa : To learn how to calculate the solubility from Ksp and vice versa. Consider the following equilibrium between a solid salt and its dissolved form (ions) in a saturated solution:

Reviews

Write a Review

 

Cost Accounting Questions & Answers

  Compare the two resorts'' net incomes

To compare the two resorts, convert gold rush net income to the accounting methods and the estimated useful lives used by Mountain hideway. Compare the two resorts' net incomes after you have revised gold rush's figures. Whish resort looked better..

  Examine the role of the accc is this issue

Examine the role of the ACCC is this issue and whether is appropriate for them to adopt the role they have in this debate. Justify your position.

  Evaluate point price elasticity of demand

Evaluate the point price elasticity of demand for Richardson's Stores, Inc and evaluate the company's optimal shoe price if marginal cost is $10 per unit

  Difficulties associated with allocating overhead costs

Discuss the difficulties associated with allocating overhead costs in the contemporary manufacturing environment and identify strategies that firms can adopt to help make their overhead allocations more accurate and reliable.

  Determine the monthly breakeven sales in dollars

Determine the monthly breakeven sales during the first year of nacho sales, assuming a constant sales mix of 1 hotdog and 2 units of nachos.

  Provide a brief definition of a compilation

Explain one difference in auditor's procedures when conducting a evaluation under SSARS vs. a review of interim financial information conducted under auditing standards.

  Accounting for bad debt expense

Accounting for bad debt expense

  Evaluate direct material cost per product

Prepare an Excel format to show how you are evaluating things. Provide detailed information of profitability by product and for year. Then make precise recommendations with financial projections.

  Evaluate total amount for intangible assets

Evaluate the total amount to be reported by Langrova for intangible assets

  Outcome evaluation and cost evaluation comparisons

Explain the following four levels of outcome evaluation. Provide one example of how every evaluation is performed, and one factor that influences the outcome at each level.

  Evaluate the carrying value of inventory

Evaluate the carrying value of inventory on each year-end balance sheet - The Ryan Hunt Company uses the dollar-value LIFO method of computing inventory

  Financing charges and net present value

how can u adjust the net present value analysis to compensate for the inclusion of the interest expense and should Baltic buy the new machine

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd