Customer Profitability Analysis Rogers Aeronautics, LTD, is a British aeronautics subcontract company that designs and manufactures...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Customer Profitability Analysis Rogers Aeronautics, LTD, is a British aeronautics subcontract company that designs and manufactures electronic control systems for commercial airlines. The vast majority of all commercial aircraft are 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 Rogers does contract work for the two major manufacturers plus three companies in the second tier. Because competition is intense in the industry, Rogers 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, Rogers Aeronautics' CEO, Len Rogers, has become concerned that the cost of obtaining contracts and maintaining relations with its five major customers may be getting out of hand. You have been hired to conduct a customer profitability analysis. Rogers Aeronautics' non-manufacturing overhead consists of $2.5 million of general and administrative (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 (including 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: Activity Activity Cost Driver Cost per Unit of Activity 1. Sales visits Number of visit days $1,200 2. Product adjustments Number of adjustments 1,500 3. Phone and email contacts Number of calls/contacts 150 4. Promotion and entertainment events Number of events 1,500 Financial and activity data on the five customers follows (Sales and Gross Profit data in millions): Quantity of Sales and Support Activity Customer Sales Gross Profit Activity 1 Activity 2 Activity 3 Activity 4 #1 $17.00 $3.40 106 23 220 82 #2 12.00 2.40 130 36 354 66 #3 3.00 0.60 52 10 180 74 #4 4.00 0.80 34 6 138 18 3.00 0.60 16 5 104 10 $39.00 $7.80 338 80 996 250 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: Customer #1 24 hours Customer #2 36 hours Customer #3 5 hours Customer #4 0 hours Customer #5 6 hours The total cost of operating the airplane is included in general and administrative expense; none is included in selling and customer support costs. #5 a. Prepare a customer profitability analysis for Rogers Aeronautics that shows the gross profits less all expenses that can reasonably be assigned to the five customers. Enter figures as complete numbers (with all zeros). For example, 1 million is 1,000,000. Do not use negative signs with any answers. Round return on sales to one decimal place. (Ex: 10.4%) Customer #1 Customer #2 Customer #3 Customer #4 Customer #5 Sales Cost of goods sold Gross profit Less expenses Customer profitability Customer return on sales 96 96 96 96 96 b. Now assuming that the remaining general and administrative costs are assigned to the five customers based on relative sales dollars, calculate net profit for each customer. Enter figures as complete numbers (with all zeros). For example, 1 million is 1,000,000. Do not use negative signs with any answers. Do not round during calculation G&A expenses. Round final G&A expenses to the nearest whole number. Round return on sales to one decimal place. (Ex: 10.4%) Customer #1 Customer #2 Customer #3 Customer #4 Customer #5 $ Customer profitability $ Less G & A expense Net customer profitability Net customer return on sales 96 96 Sales commissions Sales visits Product adjustments Phone and other remote contacts Promotion and entertainment Corporate jet expense $ 96 $ 96 100 00 $ 96 $ b. Now assuming that the remaining general and administrative costs are assigned to the five customers based on relative sales dollars, calculate net profit for each customer. Enter figures as complete numbers (with all zeros). For example, 1 million is 1,000,000. Do not use negative signs with any answers. Do not round during calculation G&A expenses. Round final G&A expenses to the nearest whole number. Round return on sales to one decimal place. (Ex: 10.4%) Customer #1 Customer #2 Customer #3 Customer #4 Customer #5 $ Customer profitability $ $ $ $ Less G & A expense Net customer profitability Net customer return on sales Check 96 96 96 96 %6 Customer Profitability Analysis Rogers Aeronautics, LTD, is a British aeronautics subcontract company that designs and manufactures electronic control systems for commercial airlines. The vast majority of all commercial aircraft are 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 Rogers does contract work for the two major manufacturers plus three companies in the second tier. Because competition is intense in the industry, Rogers 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, Rogers Aeronautics' CEO, Len Rogers, has become concerned that the cost of obtaining contracts and maintaining relations with its five major customers may be getting out of hand. You have been hired to conduct a customer profitability analysis. Rogers Aeronautics' non-manufacturing overhead consists of $2.5 million of general and administrative (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 (including 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: Activity Activity Cost Driver Cost per Unit of Activity 1. Sales visits Number of visit days $1,200 2. Product adjustments Number of adjustments 1,500 3. Phone and email contacts Number of calls/contacts 150 4. Promotion and entertainment events Number of events 1,500 Financial and activity data on the five customers follows (Sales and Gross Profit data in millions): Quantity of Sales and Support Activity Customer Sales Gross Profit Activity 1 Activity 2 Activity 3 Activity 4 #1 $17.00 $3.40 106 23 220 82 #2 12.00 2.40 130 36 354 66 #3 3.00 0.60 52 10 180 74 #4 4.00 0.80 34 6 138 18 3.00 0.60 16 5 104 10 $39.00 $7.80 338 80 996 250 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: Customer #1 24 hours Customer #2 36 hours Customer #3 5 hours Customer #4 0 hours Customer #5 6 hours The total cost of operating the airplane is included in general and administrative expense; none is included in selling and customer support costs. #5 a. Prepare a customer profitability analysis for Rogers Aeronautics that shows the gross profits less all expenses that can reasonably be assigned to the five customers. Enter figures as complete numbers (with all zeros). For example, 1 million is 1,000,000. Do not use negative signs with any answers. Round return on sales to one decimal place. (Ex: 10.4%) Customer #1 Customer #2 Customer #3 Customer #4 Customer #5 Sales Cost of goods sold Gross profit Less expenses Customer profitability Customer return on sales 96 96 96 96 96 b. Now assuming that the remaining general and administrative costs are assigned to the five customers based on relative sales dollars, calculate net profit for each customer. Enter figures as complete numbers (with all zeros). For example, 1 million is 1,000,000. Do not use negative signs with any answers. Do not round during calculation G&A expenses. Round final G&A expenses to the nearest whole number. Round return on sales to one decimal place. (Ex: 10.4%) Customer #1 Customer #2 Customer #3 Customer #4 Customer #5 $ Customer profitability $ Less G & A expense Net customer profitability Net customer return on sales 96 96 Sales commissions Sales visits Product adjustments Phone and other remote contacts Promotion and entertainment Corporate jet expense $ 96 $ 96 100 00 $ 96 $ b. Now assuming that the remaining general and administrative costs are assigned to the five customers based on relative sales dollars, calculate net profit for each customer. Enter figures as complete numbers (with all zeros). For example, 1 million is 1,000,000. Do not use negative signs with any answers. Do not round during calculation G&A expenses. Round final G&A expenses to the nearest whole number. Round return on sales to one decimal place. (Ex: 10.4%) Customer #1 Customer #2 Customer #3 Customer #4 Customer #5 $ Customer profitability $ $ $ $ Less G & A expense Net customer profitability Net customer return on sales Check 96 96 96 96 %6
Expert Answer:
Answer rating: 100% (QA)
a Prepare a customer profitability analysis for Rogers Aeronautics that shows the gross profits less all expenses that can reasonably be assigned to t... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Suppose you are buying a car of $26000. The dealer offers that you pay a down payment of $4000 now. Then you will pay the balance with equal monthly payments for 42 months with 6% APR compounded...
-
During the year, cost of goods sold was $40,000; income from operations was $38,000; income tax expense was $8,000; interest expense was $6,000; and selling, general, and administrative expenses were...
-
The Cole Corporation had cost of goods sold of $ 685,000 during 2010. Based on the beginning and ending balances of the Inventory and Accounts Payable Merchandise accounts, how much cash did Cole...
-
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company's current assets, current liabilities, and sales over the last five years...
-
Let S = {(x, y, z): x2 / (2 + y2 / b2 + z2 / c2 ( 1}. Evaluate (xy + xz + yz) dV.
-
Can a program written to use the services of UDP be run on a computer that has installed TCP as the only transport-layer protocol? Explain.
-
Andrew Reitz established a trust in 2000, naming his sons, James and John, as sole beneficiaries and himself as trustee. Upon Andrews death, Hal Rachal Jr., the attorney who drafted the trust, became...
-
Following is the current balance sheet for a local partnership of doctors: The following questions represent independent situations: a. E is going to invest enough money in this partnership to...
-
An economic consultant for a fast-food chain has been given a random sample of the chains service workers. In her model, A, the length of time y between the time the worker is hired and the time a...
-
You are the Owners project manager on an electrical upgrade project. Existing overhead power lines are being buried in a duct bank to hide them from view in an area of the town that is being...
-
A steel rod with a diameter of 24 mm is provided with a screw thread on each end and also nuts having a pitch of 1,0 mm. A pipe of the same material which is 1,2 m long with an internal diameter of...
-
Which document specifically describes Diminishing Manufacturing Sources and Material Shortages (DMSMS) policy for the Department of Defense (DoD) acquisition community?
-
How do individuals reconcile personal integrity with institutional expectations and norms, especially in environments where ethical compromises may seem necessary for advancement or survival?
-
READABILITY Rewrite the Following Sentences to Make Them More Readable by Using the Active Voice and Omitting Nominalizations A new sexual harassment policy was issued by the corporation. Additional...
-
Pre-distribution of iodine thyroid blocking (ITB) agents and identification of relevant locations for pre-distribution should be implemented in what phase?
-
How do philosophical perspectives on integrity, ranging from virtue ethics to deontological principles, inform contemporary debates and practices surrounding moral conduct and character development?
-
What is the kinetic energy of a 1 0 9. 2 cm thin uniform rod with a mass of 4 78 . 9 g that is rotating about its center at 4 . 7 3 rad / s ? Give your answer in Joules.
-
Transform the while loop from the previous exercise into an equivalent for loop (make sure it produces the same output).
-
Refer to the information about Adarmes Adventures given in Exercise 6-4. Alexis King chose to prepare a static budget based on sales of 3,000 canoes. Actual sales were 3,100 canoes at a price of $850...
-
TechGeek designs and produces high-tech gadgets that appeal to highly educated men between the ages of 25 and 50. These customers aren't as concerned about price as they are about innovation and...
-
Drew Corp. designs and manufactures mascot uniforms for high school, college, and professional sports teams. Since each team's uniform is unique in color and design, Drew uses a job order costing...
-
With regard to poison pills and puts, Lees comments are: A. correct. B. incorrect with regard to the poison put. C. incorrect with regard to the poison pill. Mark Zin and Stella Lee are CEO and CFO,...
-
The value the CEO estimated based on comparable company analysis is closest to: A. \($37.33\). B. \($39.30\). C. \($40.80\). Mark Zin and Stella Lee are CEO and CFO, respectively, of Moonbase...
-
Which statement by Zin provides the most support for a strong governance rating? A. Statement 1. B. Statement 2. C. Statement 3. Mark Zin and Stella Lee are CEO and CFO, respectively, of Moonbase...
Study smarter with the SolutionInn App