Make a customer profitability statement

Assignment Help Accounting Basics
Reference no: EM132757241

Problem - Star Pharma is a pharmaceutical firm operating in Singapore. It serves two channels: (a) small pharmacy stores and (b) large pharmacy stores. Star Pharma has four customers in total, two of which are small pharmacies (C1 and C2) and the other two are large pharmacies (C3 and C4). Star Pharma uses a discount pricing strategy and prices its products at variable cost plus 25%.

Relevant data for the year 2019 is as follows:

Particulars

C1

C2

C3

C4

Number of orders

4

9

6

3

Average order value before discount

$40,000

$20,000

$425,000

$400,000

Average discount

4.5%

9.5%

17.5%

11.5%

Regular deliveries

4

9

6

3

Expedited deliveries

2

0

2

0

Other important information:

Variable cost of goods sold amount to 80% of gross sales for each customer.

The general administration cost to small pharmacies for the year 2019 was $20,250 and the general administration cost to serve large pharmacies was $48,375.

The total order processing cost for the year 2019 was $16,500. The cost driver for order processing cost was number of orders.

The total cost for making regular deliveries in the year 2019 was $8,250. The cost driver for regular delivery cost was number of regular deliveries made.

The total cost for expedited deliveries in the year 2019 was $5,000. The cost driver for expedited delivery cost was number of expedited deliveries made.

Required -

(a) Calculate the activity cost driver rates for order processing, regular deliveries and expedited deliveries.

(b) Make a customer profitability statement that shows the contribution and operating profit from each customer and each customer channel.

Reference no: EM132757241

Questions Cloud

What is the financial breakeven point for each plan : What is the financial breakeven point for each plan? What is the degree of financial leverage for each plan at $7,000,000 of EBIT?
Compute break-even point under alternative courses of action : The beverage is sold for 50 cents per 16-ounce bottle to retailers. Compute break-even point under alternative courses of action
Find and solve the copy department costs allocated to sales : Copies were made during the year, 2,511,750 for sales and 2,534,250 for administration, calculate the copy department costs allocated to sales
How do calculate the new pe ratio of the company : Solve the new PE ratio of the company. Pacific Energy Company has a new project that will generate additional earnings of $100,000 each year in perpetuity.
Make a customer profitability statement : Make a customer profitability statement that shows the contribution and operating profit from each customer and each customer channel
What structural approaches ali and amira employ to resolve : What structural approaches can Ali and Amira employ to resolve the conflict and minimize the resistance to the proposed change in organizational structure?
Find what the unadjusted balance of the home office account : On December 30, 2020, the branch sent a check, Find what the unadjusted balance of the home office account in the books of the branch at December 31, 2020 is
What working capital at december was : Accounting Policies, Changes in Estimates and Errors, Assume the same facts as above. Working capital at December 31, 20x0, was
Compute how much carrying amount of equipment on dec : Entity A uses the straight line method of depreciation. How much is the carrying amount of the equipment on December 31, 20x3?

Reviews

Write a Review

Accounting Basics Questions & Answers

  Real interest rate one assumption

Real Interest Rate One assumption made in developing the IFE is that all investors in all countries have the same real interest rate. What does this mean?

  Determine the cost per pound of goody

Pitt Chemical Co. manufactures & sells Goody, a product that sells for $10 per pound. The mfg process also yields 1 pound of a waste product, called Baddy, in the production of every 10 pounds of Goody. Determine the cost per pound of Goody.

  What is the amount of their itemized deductions

Duke and Pat Collins have adjusted gross income of $500,000. What is the amount of their itemized deductions

  Determine the appropriate income statement presentation

Determine the appropriate income statement presentation (sales, cost of sales,

  How did guisti commit the fraud

Case - The Greater Providence Deposit & Trust Embezzlement. How did Guisti commit the fraud, conceal it, and convert the fraudulent actions to personal gain?

  Mark corporation produces two models of calculators the

mark corporation produces two models of calculators. the business model sells for 60 and the math model sells for 30.

  Discuss total utility expenses depreciation

is used for the law office. Her total utility expenses, depreciation, including gas, electric

  Surendra personal residence originally cost

Surendra's personal residence originally cost $340,000 (ignore any value assigned to land). After living in the house for five years, he converts it to rental property. At the date of conversion, the fair market value of the house is $320,000.

  What is the absolute value of the swap

LIBOR is 0.03, and the year three payment was just made (two years of payments remain on the swap), What is the absolute value of the swap?

  Printers inc manufactures and sells a mid-volume color

printers inc. manufactures and sells a mid-volume color printer mc and a high-volume color printer hc. each mc requires

  Probability and lottery per month problem

A state run monthly lottery can sell 13,111 tickets at $4 a piece. A ticket wins $100,000 with probability 0.00002, $100 with probability 0.006, and $10 with probability 0.08. On average, how much can the state expect to profit from the lottery pe..

  How much is depreciated by the end of the first year

On January 1, Stewart Company paid $38,100 to purchase a large piece of equipment that will last 6 years. How much is depreciated by the end of the first year

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