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

  Explain the relevance of cost acconting

Explain the relevance of cost acconting in today's environment Includeconcepts covered and These are the role of cost accoutants, cost terms and purposes, job and process costing and the concepts of flexible budgets, variances and management contro..

  What combinations of analytical and statistical process

What combinations of analytical and statistical process will be applied to the data and which of these will allow me to accept or reject my hypotheses?

  What is the npv if the discount rate is 15.30%

What is the NPV if the discount rate is 15.30% and Evaluate Capital's after-tax WACC

  Prepare adjusting journal entries

Prepare adjusting journal entries as you deem necessary. Besides the information provided for adjusting journal entries, review the transactions and review your unadjusted trial balance for any other adjusting journal entries you may need to prepare.

  Questionon 1st december 2009 twilight corporation decided

questionon 1st december 2009 twilight corporation decided upon a plan to issue to its ceo one share of its 1 par common

  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.

  What would you do in the ethical dilemma

The president says "hey, the life is only an estimate, and I've heard that our competition uses a 12-year life on their product equipment - What would you do

  Value and present financial statements

Assess financial accounting standards as they relate to presentation and disclosure in general purpose financial statements and evaluate, measure, value and present financial statements in conformity with GAAP relating to assets

  Calculate activity rates for each activity cost pool

Costs in the Machining cost pool are assigned to products based on machine-hours (MHs) and costs in the Setting Up cost pool are assigned to products based on the number of batches. Costs in the Other cost pool are not assigned to products.

  Traditional system to an activity based cost system

Will the coming years EVA be greater than, less than, or equal to the current year's EVA and effect of changing to the ABC systeman increase in EVA, a decrease in EVA, or neither? Why?

  How would the selling price of the bonds be evaluated

How would the selling price of the bonds be evaluated

  How many pounds of material does manzoni plan

How many pounds of material does Manzoni plan to purchase in July and what is the budgeted August 31 finished goods inventory balance (in dollars)?

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