Question

In: Accounting

Pharmacy Company has two customers CVX and Ma & Pa with data as follows: CVX Ma...

Pharmacy Company has two customers CVX and Ma & Pa with data as follows:

CVX

Ma & Pa

Selling price per unit

$40.00

$40.00

Units Sold

4,500

3,800

Manufacturing Cost per unit

$14.00

$14.00

Number of Purchase Orders

25

155

Number of Deliveries

107

183

Number of Expedited deliveries

189

250

Customer Visits

44

85

Pharmacy Company’s management accountant gathered the following ABC rate information:

ABC Cost Rate

Purchase Orders

$216 per purchase order

Deliveries

$112 per delivery

Expedited Deliveries

$131 per expedited delivery

Customer Visits

$ 62 per customer visit

Using the information in the tables above and allocating indirect support costs using ABC to customers, what is the Operating Income for the CVX customer?

Multiple Choice

  • $ 59,400

  • $ 72,129

  • $ 117,000

Solutions

Expert Solution

Working Notes:
Calculation of the Overhead Cost as per ABC Method for CVX Method
Activity Activity Used   "X " By Cost Driver rate   Cost  
Number if Purchase Orders                                         25 "X " By $             216.00 $                     5,400
Number of Deliveries                                      107 "X " By $             112.00 $                   11,984
Number of Expedited Deliveries                                      189 "X " By $             131.00 $                   24,759
Customer Visit                                       44 "X " By $               62.00 $                     2,728
Total Cost $                   44,871
Solution :  
Calculation of the Operating Income For the CVX Customer
Sales (4,500 Units X $ 40) $                      1,80,000
Less: Expenses
Manufacturing Cost (4,500 Units X $ 14)                              63,000
Overhead Cost as per ABC(WN1)                              44,871
Customer Visit
Total Expenses   $                      1,07,871
Net Income   $                          72,129
Answer = Option 2 = $ 72,129

Related Solutions

A company has recorded data on a sample of real estate listings from Waltham, MA. The...
A company has recorded data on a sample of real estate listings from Waltham, MA. The variables are: PRICE -- List price, thousands of dollars SQFT -- Square footage BEDS -- Number of bedrooms BATHS -- Number of bathrooms HWY -- A dummy variable (1 = close to highways; 0 = far from highways). Use Excel's Regression tool to answer the following questions: PRICE SQFT BEDS BATHS HWY 713 2400 3 3 0 645 2524 3 2 1 625 2732...
The Red Company makes two products. Cost data for these two products is as follows: Product...
The Red Company makes two products. Cost data for these two products is as follows: Product A Product B Selling price $10 $20 Variable costs   7 12 Total annual fixed costs are $840,000. The firm's experience has been that about 20 percent of unit sales come from product A, 80 percent from B. The Red Company is taxed at 30% Required: a. Determine the number of units to be sold at the break-even point. b. Determine the number of units...
Bluffton Pharmacy Two New Pharmacy Owners Learn Valuable Lessons About Financial Statements and Analysis It has...
Bluffton Pharmacy Two New Pharmacy Owners Learn Valuable Lessons About Financial Statements and Analysis It has been a little more than two years since Angela Crawford and Martin Rodriguez purchased the Bluffton Pharmacy from Frank White, the previous owner and founder, who had started the pharmacy in 1969. The two have spent many long hours in the store and have learned many valuable lessons as business owners that they had not had the opportunity to learn as employees of large...
1. If the squirrel population of western MA has two alleles of a gene that determines...
1. If the squirrel population of western MA has two alleles of a gene that determines coat color and 78% of the alleles in the population are the gray allele (the other 22% are the jet-black allele), then the gray allele is dominant over jet-black. Select one: a. False b. True 2. You meet a woman who is heterozygous for an X-linked dominant disorder. If this woman has children, who will inherit this disorder from her? Select one: a. All...
Data for the two departments of Kimble & Pierce Company for June of the current fiscal year are as follows:
Equivalent Units of Production Data for the two departments of Kimble & Pierce Company for June of the current fiscal year are as follows:     Drawing Department Winding Department Work in process, June 17,400 units, 30% completed2,900 units, 60% completedCompleted and transferred to next  processing department during June101,400 units100,400 unitsWork in process, June 305,600 units, 75% completed3,900 units, 30% completed Production begins in the Drawing Department and finishes in the Winding Department. a. If all direct materials are placed in process at the beginning of...
Salarian Company is considering two capital expenditures. Relevant data for the projects are as follows: Project...
Salarian Company is considering two capital expenditures. Relevant data for the projects are as follows: Project A B Initial investment $202,575 $251,438 Annual income $43,820 $43,660 Life of project 6 years 9 years Salvage value $0 $0 Salarian Company uses the straight-line method to depreciate its assets. (a) Calculate the internal rate of return for each project. (For calculation purposes, use 4 decimal places as displayed in the factor table provided, e.g. 1.2512. Round answers to 0 decimal places, e.g....
Salarian Company is considering two capital expenditures. Relevant data for the projects are as follows: Project...
Salarian Company is considering two capital expenditures. Relevant data for the projects are as follows: Project A B Initial investment $215,545 $230,821 Annual income $41,400 $40,080 Life of project 7 years 9 years Salvage value $0 $0 Salarian Company uses the straight-line method to depreciate its assets. (a) Calculate the internal rate of return for each project. (For calculation purposes, use 4 decimal places as displayed in the factor table provided, e.g. 1.2512. Round answers to 0 decimal places, e.g....
Salarian Company is considering two capital expenditures. Relevant data for the projects are as follows: Project...
Salarian Company is considering two capital expenditures. Relevant data for the projects are as follows: Project A B Initial investment $215,545 $230,821 Annual income $41,400 $40,080 Life of project 7 years 9 years Salvage value $0 $0 Salarian Company uses the straight-line method to depreciate its assets. (a) Calculate the internal rate of return for each project. (For calculation purposes, use 4 decimal places as displayed in the factor table provided, e.g. 1.2512. Round answers to 0 decimal places, e.g....
Elsa is a data analytics intern at a financial firm. Her company has obtained their customers...
Elsa is a data analytics intern at a financial firm. Her company has obtained their customers bank transaction records recently. Elsa has been asked by her manager to find out all the attributes (variables) that can be delivered from those bank transaction records for creating the machine learning algorithm. The machine learning algorithm will help Elsa's firm to determine whether someone is likely to get a loan approval or not. List 5 attributes (variables) and explain why they should be...
Income statement data for Winthrop Company for two recent years ended December 31 are as follows:...
Income statement data for Winthrop Company for two recent years ended December 31 are as follows: 1 Current Year Previous Year 2 Sales $1,938,000.00 $1,700,000.00 3 Cost of goods sold 1,608,200.00 1,462,000.00 4 Gross profit $329,800.00 $238,000.00 5 Selling expenses $67,800.00 $60,000.00 6 Administrative expenses 49,280.00 44,000.00 7 Total operating expenses $117,080.00 $104,000.00 8 Income before income tax $212,720.00 $134,000.00 9 Income tax expense 13,090.00 8,500.00 10 Net income $199,630.00 $125,500.00 A. Prepare a comparative income statement with horizontal analysis,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT