Compute the activity rate for each activity cost pool

Assignment Help Cost Accounting
Reference no: EM13974456

Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 5%. For example, if a hospital buys supplies from Worley that had cost Worley $100 to buy from manufacturers, Worley would charge the hospital $105 to purchase these supplies.

For years, Worley believed that the 5% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits Worley decided to implement an activity-based costing system to help improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities as shown below:

  Activity Cost Pool (Activity Measure) Total Cost Total Activity
  Customer deliveries (Number of deliveries) $ 500,000 5,000  deliveries
  Manual order processing (Number of manual orders) 248,000 4,000  orders
  Electronic order processing (Number of electronic orders) 200,000 12,500  orders
  Line item picking (Number of line items picked) 450,000 450,000  line items
  Other organization-sustaining costs (None) 602,000    
  Total selling and administrative expenses $2,000,000    

Worley gathered the data below for two of the many hospitals that it serves-University and Memorial (both hospitals purchased a total quantity of medical supplies that had cost Worley $30,000 to buy from its manufacturers):

 

Activity

  Activity Measure University Memorial
  Number of deliveries 10 25
  Number of manual orders 0 30
  Number of electronic orders 15 0
  Number of line items picked 120 250

Required:

1. Compute the total revenue that Worley would receive from University and Memorial.

2. Compute the activity rate for each activity cost pool.

3. Compute the total activity costs that would be assigned to University and Memorial.

4. Compute Worley's customer margin for University and Memorial. (Hint: Do not overlook the $30,000 cost of goods sold that Worley incurred serving each hospital.) (Loss amount should be indicated with a minus sign.)

Reference no: EM13974456

Questions Cloud

Problem regarding the complementary systems : Leadership and management are two distinct but complementary systems. While managers promote stability, leaders press for change. explain what the statement mean with an aid of a practical example
What is part of the project : Discuss the statement: Failing to define what is not part of the project is just as important as failing to define what is part of the project.
Document that describes your process steps and results : Create a word or PDF document that describes your process, steps and results. Be sure to describe your schema and why you selected the tables and columns you did for your Private database
Explore attitudes toward death in contemporary society : i need you to explore attitudes toward death in contemporary society. the theme may be discussed using film, literature or music. 5-6 pages
Compute the activity rate for each activity cost pool : Compute the activity rate for each activity cost pool. Compute the total activity costs that would be assigned to University and Memorial.
My ethical philosophy based on kant''s : Write based on your current ethical philosophy using the following ethical principles, and include examples for each (use the information in your textbook as a guide):
Question regarding the financial statements : Indicate by letter how each of the following usually should be classified. If an item should appear in a note to the financial statements, use the letter ?oN?? to indicate this fact. If an item need not be reported at all on the balance sheet, use..
Corporate strategic audit : You have been hired by United Airlines (UA) to perform a corporate strategic audit. With respect to UA, which of the following statements are true concerning American Airlines (AA)? A. AA is a competitor to UA B. AA represents a rivalry to UA C. B..
Draw poles and zeros for the closed loop transfer function : Draw the poles and zeros for the closed loop transfer function and determine whether the system is stable or unstable and determine overall transfer function T(z) for the system with unity feedback

Reviews

Write a Review

Cost Accounting Questions & Answers

  Compute the variable and fixed cost elements

Byrnes Company accumulates the following data concerning a mixed cost, using units produced as the activity level.

  What is the ending inventory value at cost

Barker Pet supply uses the conventional retail method to determine its ending inventory at cost. Assume the beginning inventory at cost (retail) were $531,200 ($653,800).

  What would the journal entry be to record this transaction

Prepare the journal entries to create and close the warranty period for the contingent liability due to sales from February - What would you recommend that the company do and why and What would the journal entry be to record this transaction?

  Submit your responses to the following questions in a 1-2

submit your responses to the following questions in a 1-2 page summary msword document. label each question clearly.

  Prepare a trial balance for patel rentals

Prepare a trial balance for Patel Rentals as of June 30, 2011 and compare and contrast how the issues of recognition, valuation, and classification are settled in the transactions of June 3 and 10.

  What is the break-even point in sales revenue

What is the break-even point in sales revenue dollars per month and what is the break-even point in number of flights per month (round up)?

  Evaluate overall revenue and spending variance

The company has provided the data concerning the formulas used in its budgeting and its actual results for April

  Determine the number of units that mac company

Determine which one of the alternatives Mac Company should select to achieve its annual after-tax profit objective. Be sure to support your selection with appropriate calculations.

  What amount should be reported by ruse inc

What amount should be reported by Ruse Inc. as cash provided by operating activities in the statement of cash flows

  Questionrailway company a has 1000 miles of get that extend

questionrailway company a has 1000 miles of get that extend from location a to location b. railway company a adopted

  Prepare the adjusting entry to record bad debts

Prepare the adjusting entry to record Bad Debts Expense assuming uncollectibles are estimated to be 1.5% of credit sales and prepare the adjusting entry to record Bad Debts

  What does cash flow timeline look like from your perspective

What does the cash flow timeline look like from your perspective and what does it look like from the bank's perspective?

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