Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Due to a rounding error in the Solutions, the G&A allocation is as follows: Customer 1: 1,064,980 Customer 2: 751,750 Customer 3: 187,940 Customer 4:
Due to a rounding error in the Solutions, the G&A allocation is as follows:
Customer 1: 1,064,980
Customer 2: 751,750
Customer 3: 187,940
Customer 4: 250,580
Customer 5: 187,940
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: Cost per Unit of Activity Activity 1. Sales visits $800 2. Product adjustments 3. Phone and email contacts 4. Promotion and entertainment events Activity Cost Driver Number of visit days Number of adjustments Number of calls/contacts Number of events 1,300 50 2,000 Financial and activity data on the five customers follows (Sales and Gross Profit data in millions): #2 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 12.00 2.40 130 36 354 66 #3 - 3.00 0.60 52 10 180 74 4.00 0.80 34 6 138 18 #5 3.00 0.60 R 16 5 104 $39.00 $7.80 338 996 #4 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 O 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. 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 Sales commissions Sales visits Product adjustments Phone and other remote contacts Promotion and entertainment Corporate jet expense Customer profitability 0 $ 0 $ 0 $ Customer return on sales 0% 0% 0% 0% 0% 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 profitability Less G&A expense Net customer profitability Net customer return on sales Customer #1 Customer #2 Customer #3 Customer #4 Customer #5 $ 0 $ 0 $ 0 $ 0 $ 0 0 0 0 0 0 0 0 0 0 0 0% 0% 0% 0% 0% 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: Cost per Unit of Activity Activity 1. Sales visits $800 2. Product adjustments 3. Phone and email contacts 4. Promotion and entertainment events Activity Cost Driver Number of visit days Number of adjustments Number of calls/contacts Number of events 1,300 50 2,000 Financial and activity data on the five customers follows (Sales and Gross Profit data in millions): #2 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 12.00 2.40 130 36 354 66 #3 - 3.00 0.60 52 10 180 74 4.00 0.80 34 6 138 18 #5 3.00 0.60 R 16 5 104 $39.00 $7.80 338 996 #4 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 O 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. 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 Sales commissions Sales visits Product adjustments Phone and other remote contacts Promotion and entertainment Corporate jet expense Customer profitability 0 $ 0 $ 0 $ Customer return on sales 0% 0% 0% 0% 0% 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 profitability Less G&A expense Net customer profitability Net customer return on sales Customer #1 Customer #2 Customer #3 Customer #4 Customer #5 $ 0 $ 0 $ 0 $ 0 $ 0 0 0 0 0 0 0 0 0 0 0 0% 0% 0% 0% 0%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started