Compute med maxs customer margin for city general and

Assignment Help Accounting Basics

Reference no: EM13484298

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

For years, Med Max believed that the 7% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits Med Max 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	$	567,000	7,000	deliveries
Manual order processing	Number of manual orders		462,000	6,000	orders
Electronic order processing	Number of electronic orders		273,000	13,000	orders
Line item picking	Number of line items picked		1,004,500	410,000	line items
Other organization-sustaining costs	NA		600,000

Total selling and administrative expenses		$	2,906,500

Med Max gathered the data below for two of the many hospitals that it serves-City General and County General (each hospital purchased medical supplies that had cost Med Max $34,000 to buy from its manufacturers):

	Activity
Activity Measure	City General	County General
Number of deliveries	20	23
Number of manual orders	0	41
Number of electronic orders	17	0
Number of line items picked	140	280

Required:
1.	Compute the total revenue that Med Max would receive from City General and County General. (Omit the "$" sign in your response.)

	Total Revenue
City General	$
County General	$

2.	Compute the activity rate for each activity cost pool. (Round the "Line item picking" to 2 decimal places. Omit the "$" sign in your response.)

Activity Cost Pool	Activity Rate
Customer deliveries	$	per delivery
Manual order processing	$	per manual order
Electronic order processing	$	per electronic order
Line item picking	$	per line item picked

3.	Compute the total activity costs that would be assigned to City General and County General. (Round your intermediate calculations and final answers to 2 decimal places. Omit the "$" sign in your response.)

	Total Activity Costs
City General	$
County General	$

Compute Med Max's customer margin for City General and County General. (Hint: Do not overlook the $34,000 cost of goods sold that Med Max incurred serving each hospital.) (Loss amount should be indicated with a minus sign. Round your intermediate calculations and final answers to 2 decimal places. Omit the "$" sign in your response.)

	Customer Margin
City General	$
County General	$

Reference no: EM13484298

Questions Cloud

Mme barefield wishes to have 150000 at the end of 8 years : mme. barefield wishes to have 150000 at the end of 8 years. how much must she invest today to accomplish this purpose

Direct materials each unit of product contains 410 pounds : kimm company has gathered the following information about its product.direct materials each unit of product contains

Mr altgeldt has 5000 to invest he wants to know how much it : mr. altgeldt has 5000 to invest. he wants to know how much it will amount to if he invests it at the following ratesa.

Hnak itzek manufactures and sells homemade wine and he : hnak itzek manufactures and sells homemade wine and he wants to develop a standard cost per gallon. the following are

Compute med maxs customer margin for city general and : med max buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds

Abc invested in a 200000 8 bond issued by the stu company : prepare the proper adjusting journal entries for the abc company. assume all entries are made at year end december 31

During the year samuels company reported net income of : during the year samuels company reported net income of 300000 including amortization of intangible assets of 66000

Would you rather use an interest rate of 6 or 12 in : rather than pay you 1000 a month for the next 20 years the person who injured you in an automobile accident is willing

Stock analysts just predicted that hybrid engine companys : stock analysts just predicted that hybrid engine companys earnings and dividends will grow at 20 each year for the next

User Account

All Pages