Questions
Rogers Aeronautics, LTD, is a British aeronautics subcontract company that designs and manufactures electronic control systems...

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

$800

2. Product adjustments

Number of adjustments

1,300

3. Phone and email contacts Number of calls/contacts

50

4. Promotion and entertainment events

Number of events

2,000

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
#5 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.

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.


Notes:

  • Enter figures as complete numbers (with all zeros). For example, 17 million is 17,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 Answer Answer Answer Answer Answer
Cost of goods sold Answer Answer Answer Answer Answer
Gross profit Answer Answer Answer Answer Answer
Less expenses
Sales commissions Answer Answer Answer Answer Answer
Sales visits Answer Answer Answer Answer Answer
Product adjustments Answer Answer Answer Answer Answer
Phone and other remote contacts Answer Answer Answer Answer Answer
Promotion and entertainment Answer Answer Answer Answer Answer
Corporate jet expense Answer Answer Answer Answer Answer
Customer profitability Answer Answer Answer Answer Answer
Customer return on sales Answer Answer Answer Answer Answer

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 Answer Answer Answer Answer Answer
Less G & A expense Answer Answer Answer Answer Answer
Net customer profitability Answer Answer Answer Answer Answer
Net customer return on sales Answer Answer Answer Answer Answer

In: Accounting

How does a company transform its breakeven or loss customers into profitable ones while using activity-based...

How does a company transform its breakeven or loss customers into profitable ones while using activity-based (menu-based) pricing? Provide a specific example!

In: Accounting

Pick a specific company or industry and then list and describe one macro and one micro...

Pick a specific company or industry and then list and describe one macro and one micro environmental factor that must be considered by that organization when it tries to successfully market to their customers.

In: Economics

Customers have “mental rules” that impact their attitude about a business. What can a company do...

Customers have “mental rules” that impact their attitude about a business. What can a company do to help ensure that a customer’s rule is not broken? Give two examples.

In: Operations Management

How much time do Americans living in or near cities spend waiting in traffic, and how...

How much time do Americans living in or near cities spend waiting in traffic, and how much does waiting in traffic cost them per year? The data set given includes this cost for 31 cities. For the time Americans living in or near cities spend waiting in traffic and the cost of waiting in traffic per year:

a. Compute the mean, median, first quartile, and third quartile.

b. Compute the range, interquartile range, variance, standard deviation, and coefficient of variation.

c. Construct a boxplot. Are the data skewed? If so, how?

d. Compute the correlation coefficient between the time spent sitting in traffic and the cost of sitting in traffic.

e. Based on the results of (a) through (c), what conclusions might you reach concerning the time spent waiting in traffic and the cost of waiting in traffic.

City Annual Time Sitting in Traffic (hours) Cost of Sitting in Traffic ($)
Boston 47 980
New York 54 1126
Philadelphia 42 864
Washington 74 495
Miami 38 785
Detroit 33 687
Cleveland 20 383
Minneapolis 45 916
Milwaukee 27 541
Chicago 71 1568
St. Louis 30 642
Nashville 35 722
Memphis 23 477
Atlanta 43 824
New Orleans 35 746
Omaha 21 389
Wichita 20 379
Dallas 45 924
Houston 57 1171
Denver 49 993
Albuquerque 25 525
Phoenix 35 821
Salt Lake City 27 512
Las Vegas 28 512
Boise 19 345
Seattle 44 942
Portland 37 744
San Francisco 50 1019
San Jose 37 721
Los Angeles 64 1334
San Diego 38 794

In: Statistics and Probability

1. Given the information below about Thomas Corporation, what was the amount of dividends the company...

1. Given the information below about Thomas Corporation, what was the amount of dividends the company paid in the current period?

Beginning retained earnings $ 54,000
Ending retained earnings $ 117,000
Decrease in cash $ 9,900
Net income $ 91,000
Change in stockholders’ equity $ 13,000

2. The ending Retained Earnings balance of Boomer Inc. decreased by $1.9 million from the beginning of the year. The company declared a dividend of $4.7 million during the year. What was the net income for the year?

3. When a company pays utilities of $1,710 in cash, the transaction is recorded as:

4. When a company pays $2,100 dividends to its stockholders, the transaction should be recorded as:

5. A company received a bill for newspaper advertising services, $460. The bill will be paid in 10 days. How would the transaction be recorded today?

6. On March 3, Cobra Inc. purchased a desk for $350 on account. On March 22, Cobra purchased another desk for $415 also on account, and then on March 24, Cobra paid $470 on account. At the end of March, what amount should Cobra report for desks (assuming these two desks were the only desks they had)?

7.

Use the following information to prepare a trial balance.

Cash $ 6,100
Deferred revenue 1,500
Prepaid insurance 1,600
Accounts payable 1,900
Retained earnings 1,300
Utilities expense 3,100
Dividends 1,000
Salaries expense 2,500
Accounts receivable 3,200
Common stock 6,700
Service revenue 7,000
Maintenance expense 900

8. At the beginning of December, Global Corporation had $1,800 in supplies on hand. During the month, supplies purchased amounted to $3,000, but by the end of the month the supplies balance was only $1,400. What is the appropriate month-end adjusting entry?

9.

The following table contains financial information for Trumpeter Inc. before closing entries:

Cash $ 12,400
Supplies 5,100
Prepaid Rent 2,000
Salaries Expense 4,700
Equipment 65,100
Service Revenue 28,500
Miscellaneous Expenses 20,000
Dividends 3,000
Accounts Payable 3,200
Common Stock 66,400
Retained Earnings 14,200


What is Trumpeter's net income?

In: Accounting

Foreign currency analysis of NVIDIA Corp which is an American technology company which is based in...

Foreign currency analysis of NVIDIA Corp which is an American technology company which is based in Santa Clara, California. Nvidia now operates broadly as a visual computing company and serves its customers in two primary segments: GPU (graphics processing units) and Tegra processors Explain the business activities and environment of NVIDIA Corp from the perspective of foreign currency and identify three currencies that NVIDIA Corp is exposed against. This can be due to its business structure (i.g. location of factories, customers and suppliers, and the currency that the products/services are quoted), and arising from the competition against its rivals. State the rationales of your selection and references.

In: Finance

8-27 Straightforward 4-variance overhead analysis. The Lopez Company uses standard costing in its manufacturing plant for...

8-27 Straightforward 4-variance overhead analysis. The Lopez Company uses standard costing in its manufacturing plant for auto parts. The standard cost of a particular auto part, based on a denominator level of 4,000 output units per year, included 6 machine-hours of variable manufacturing overhead at $8 per hour and 6 machine-hours of fixed manufacturing overhead at $15 per hour. Actual output produced was 4,400 units. Variable manufacturing overhead incurred was $245,000. Fixed manufacturing overhead incurred was $373,000. Actual machine-hours were 28,400.

Required:

1. Prepare an analysis of all variable manufacturing overhead and fixed manufacturing overhead variances, using the 4-variance analysis in Exhibit 8-4 (page 324).

2. Prepare journal entries using the 4-variance analysis.

3. Describe how individual fixed manufacturing overhead items are controlled from day to day.

4. Discuss possible causes of the fixed manufacturing overhead variances.

plz use computer writing, not hand writing

In: Accounting

25/ A company borrowed $40,300 cash from the bank and signed a 3-year note at 10%...

25/ A company borrowed $40,300 cash from the bank and signed a 3-year note at 10% annual interest. The present value of an annuity factor for 3 years at 10% is 2.4869. The present value of a single sum factor for 3 years at 10% is .7513. The annual annuity payments equal:

Multiple Choice

$30,277.39.

$16,204.91.

$40,300.00.

$53,640.36.

$100,222.07.

26/ A company issued 9%, 15-year bonds with a par value of $590,000 that pay interest semiannually. The market rate on the date of issuance was 9%. The journal entry to record each semiannual interest payment is:

Multiple Choice

Debit Bond Interest Expense $26,550; credit Cash $26,550.

Debit Bond Interest Expense $53,100; credit Cash $53,100.

Debit Bond Interest Payable $39,333; credit Cash $39,333.

Debit Bond Interest Expense $540,000; credit Cash $540,000.

No entry is needed, since no interest is paid until the bond is due.

27/ A company issued 5-year, 8% bonds with a par value of $99,000. The company received $96,947 for the bonds. Using the straight-line method, the amount of interest expense for the first semiannual interest period is:

Multiple Choice

$8,330.60.

$3,754.70.

$4,165.30.

$3,960.00.

$7,920.00.

28/ A company issues 7% bonds with a par value of $200,000 at par on January 1. The market rate on the date of issuance was 6%. The bonds pay interest semiannually on January 1 and July 1. The cash paid on July 1 to the bond holder(s) is:

Multiple Choice

$14,000.

$12,000.

$7,000.

$6,000.

$0.

In: Accounting

Which attribute would one look at to determine a stock's fundamental value? Competitors Revenue and profit...

Which attribute would one look at to determine a stock's fundamental value?

Competitors

Revenue and profit margin

Company management

All of the above

Which "red flag" could deter a stock purchase?

Company earnings are average and cash flow is weak

A company has announced, but not delivered an innovative product

A company has a little competition in a small market

A company has top-rated management

What should determine an actual profit?

Extraordinary events

Net income

Total operating results and consistent net income

Material losses verses revenue

Which factor determines a company's long-term viability?

Concentrating sales on a small customer base

Selling everything on company credit

Developing products slowly

Ensuring excellent cash flow

In: Finance