Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Also, please provide the calculation formulas 33. Customer Profitability Analysis (L02, 5, 6) Roger's Acronautics, LTD, is a British acronautics subcontract company that designs and

image text in transcribedimage text in transcribed

Also, please provide the calculation formulas

33. Customer Profitability Analysis (L02, 5, 6) Roger's Acronautics, LTD, is a British acronautics subcontract company that designs and manufactures electronic control systems for com manufactured by Boeing in the U.S. and Airbus in Europe; however, there is a relatively small group of companies that manufacture narrow-body commercial jets. Assume for this exercise that Roger's does contract work for the two major manufacturers plus three companies in the second tier are control systems for commercial airlines. The vast majority of all commercial ai Because competition is intense in the industry, Roger's has always operated on a fairly thin 20% gross profit margin; hence, it is crucial that it manage non-manufacturing overhead costs effectively in order to achieve an acceptable net profit margin. With declining profit margins in recent years, Roger's Acronautics' CEO, Len Rogers, has become concerned that the cost of obtaining contracts and maintain- ing relations with its five major customers may be getting out of hand. You have been hired to conduct a customer profitability analysis. Roger's Aeronautics' non-manufacturing overhead consists of $2.5 million of general and admin- istrative (G&A) expense, (including, among other expenses, the CEO's salary and bonus and the cost of operating the company's corporate jet) and selling and customer support expenses of $3 million (includ- ing 5% sales commissions and $1 050,000 of additional costs). The accounting staff determined that the $1,050,000 of additional selling and customer support expenses related to the following four activity cost pools Cost per Unit Activity Cost Driver of Activity $1,400 1,200 1,600 1. Sales visits 2. Product adjustments Number of adjustments Number of calls/contacts ent events... Number of events Financial and activity data on the five customers follows (Sales and Gross Profit data in millions): Quantity of Sales and Support Activity Gross Customer Sales Profit Activity 1 Activity 2 Activity 3Activity 4 $17 $3.4 106 12 354 180 138 104 996 74 18 10 16 $39 $7.8 338 In addition to the above, the sales staff used the corporate jet at a cost of $800 per hour for trips to customers as follows

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Auditing E4 Im

Authors: KNAPP

4th Edition

0324048602, 978-0324048605

More Books

Students also viewed these Accounting questions

Question

Show the products of thesereactions: HCI . H,SO, b) a)

Answered: 1 week ago

Question

Prepare and properly label figures and tables for written reports.

Answered: 1 week ago