Prepare a customer profitability analysis

Assignment Help Cost Accounting
Reference no: EM13498419

Customer Profitability Analysis                                     

Omega Printers Ltd handles printing jobs. Joe Patterson, finds that serving some clients is more demanding than serving others. The demands made by some clients take up a lot of time that the sales staff would prefer to spend on soliciting new clients.  In particular, Joe is interested in knowing the profitability of serving Expert Travels - a travel operator and Evon Cosmetics - a retailer. The management accounting department staff of Omega printers have provided the following information.

 

Expert Travels

Evon Cosmetics

Sales revenue

$554,000

$446,800

Cost of goods sold

$288,000

$223,200

Selling costs

$86,400

$64,800

Administration costs

$68,400

$57,600

 

Cost driver data used by Omega Printers and traceable to the two clients are:

 

Customer-driven activities

Cost driver

Cost driver rate

Sales activity

Sales visits

$200 per visit

Order taking

Purchase orders

$ 40 per purchase order

Sorting & packaging

Number of packages

$ 50 per package

Ordinary shipping

Number of shipments

$ 150 per shipment

Special shipping

Number of shipments

$ 750 per shipment

The following data relates to those same two clients:

 

Customer-driven activities

Expert Travels

Evon Cosmetics

Sales activity

10 sales visits

20 sales visits

Order taking

15 purchase orders

36 purchase orders

Sorting & Packaging

200 packages

1,500 packages

Ordinary shipping

12 shipments

10 shipments

Special shipping

3 shipments

26 shipments

Required:

1.    Prepare a customer profitability analysis for Expert Travels and Evon Cosmetics.

2.    Comment on the relative profitability of the two customers by computing the gross margin, net profit margin and any other relevant ratios.

3.    Suggest and explain one non-financial performance measure that Omega Printers Ltd could use to evaluate each of the following:

a.    Customer acquisition

b.    Customer retention

c.    Customer satisfaction

Reference no: EM13498419

Questions Cloud

Evaluate the molality of the solution : To what volume should you dilute 40.0ml of a 4.65M KI solution so that 27.0ml of the diluted solution contains 3.95g of KI ?2.) An aqueous NaCl solution is made using 111g of NaCl diluted to a total solution volume of 1.00L .Calculate the molality ..
Systems theory proposes open interaction between organizatio : Systems theory proposes open interaction between organizations and their environments
What is the new rate of spinning : A bug that has a mass mb = 3 g walks from the center to the edge of a disk that is freely turning at 20 rpm. The disk has a mass of md = 13 g. what is the new rate of spinning in rpm
Calculate the price and mix variance for each material used : Comment on your calculations to help explain what has happened to the material yield variance.
Prepare a customer profitability analysis : Omega Printers Ltd handles printing jobs. Joe Patterson, finds that serving some clients is more demanding than serving others.
Explain net equation for the preparatory phase of glycolysis : Write a series of balanced equations for all the reactions of the catabolism of glucose into 2 molecules of glyceraldehyde-3-phosphate (preparatory phase of glycolysis) and combine the net equation to give the oveall net equation for the preparato..
What is the slope of equation : In forecasting, MacDonald's Wing® discovered that when it opened its store to the public, it was able to sell 5,000 parachutes in the first year. Given the equation; y=a+bx. Where 'y' represents the number of sales and 'a' is the number they s..
Describe the rate constant at the temperature : The half-life for a first-order reaction is known to be 680 seconds at a given temperature. What is the rate constant at this temperature
Why transfer prices base on actual costs are not appropriate : Compute the ROI for both divisions showing the return on sales and investment turnover for the year ended April 2012.

Reviews

Write a Review

Cost Accounting Questions & Answers

  Describe tax revenue systems

Describe what other tax revenue systems could you consider and how do you think they would be better or worse?

  Evaluate medical expense deduction

Dotty's insurance company reimbursed therefore $8,800 of these expenses. If Dotty's AGI is $47,200, evaluate her medical expense deduction.

  Rum company has developed a new product that will be

rum company has developed a new product that will be marketed for the first time during the next fiscal year. although

  Determine what affect a sales volume increase or decrease

Determine what affect a sales volume increase or decrease will have on unit fixed cost, unit variable cost, total fixed cost, and total variable cost.

  Prepare a five to six 5-6 page paper in which youexamine

prepare a five to six 5-6 page paper in which youexamine and discuss the current effects of ifrs on the pension

  Evaluate managements discussion and analysis

Evaluate managements discussion and analysis

  Evaluate the amount of subscription revenue

Use the horizontal model to record the effects of the subsequent items Subscription fees received in advance in September 2010.

  Examine a performance report

Total the performance evaluation report for this subunit and based on the data shown, what kind of responsibility center is the subunit

  Explain the differences in the four methods of costing

Explain the differences in the four methods of costing you have used in (a.i) and (a.ii) and in which situation you would use them.

  On september 21 2008 the lopez co issues 1000000 of bonds

on september 21 2008 the lopez co issues 1000000 of bonds having a coupon rate of 6. to help the sale detachable stock

  Consider the recent performance of the closed fund a

consider the recent performance of the closed fund a closed-end fund devoted to finding undervalued thinly traded

  Questions on trial balance

Questions on Trial Balance - Neosho River Resort would prepare which statement first?

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