Questions
This is a very competitive field that Aeronautics Company operates in. It is imperative they manage...

This is a very competitive field that Aeronautics Company operates in.
It is imperative they manage the non-manufacturing overhead costs effectively in order to achieve an acceptable net profit margin.  
With declining profit margins in recent years, the CEO has become concerned that the cost of obtaining contracts and maintaining relations with its five customers may be getting out of hand.   
You have been hired to conduct a customer profitability analysis.
Below is applicable revenue and cost information you should include in your customer profitability analysis.
Sales
Customer 1 $18,000,000
Customer 2 13,000,000
Customer 3 4,000,000
Customer 4 5,000,000
Customer 5 4,000,000
$44,000,000
Cost of Good Sold (COGS) as a percentage of sales is the following: 80% of Total Sales generated
Aeronautics Company selling and customer support team receives the following sales commissions on each customer account:   6% Sales generated per customer
The accounting staff determined the additional selling and customer support expenses related to the following four activity cost pools and the cost per activity.
Usage of cost driver per customer
Activity Activity Cost Driver Data Cost per unit of activity Customer 1 Customer 2 Customer 3 Customer 4 Customer 5
1. Sales Visits Number of visit days $1,300 106 130 52 34 16
2. Product adjustments Number of adjustments 1,250 23 36 10 6 5
3. Phone and email contracts Number of calls/contracts 150 220 354 180 138 104
4. Promotion and entertainment events Number of events 1,400 82 66 74 18 10
In addition to the above, the sales staff used the corporate jet for trips to customers at a cost per hour as stated below and jet hours used per customer as follows:
There is a cost of $900 hour
Hours used of jet
Customer 1 24
Customer 2 36
Customer 3 5
Customer 4 0
Customer 5 6
Required:
1. Develop a customer profitability analysis for Aeronautics Company that shows the sales, cost of goods sold, gross profit on sales, and all costs that can be assigned to the five customers.
Include the customer profitability ratio for each customer and the company. Make sure you use cell references to make all your calculations.  
2. What type of actions might the company take as a result of this analysis? You need to specifically reference the different customers in the analysis you have performed in your answer to this question.
Solution: Make sure you use cell references to make all your calculations.  

In: Accounting

1.If a company uses accrual basis accounting, accrued revenues differ from deferred revenues in that accrued...

1.If a company uses accrual basis accounting, accrued revenues differ from deferred revenues in that accrued revenues are

a) recorded as liabilities before the cash is collected from customers.

b) recorded as liabilities before they are recognized as revenue earned.

c) recognized as revenue earned after cash is collected from customers.

d) recognized as revenue earned before cash is collected from customers.

e) journalized only when cash is collected from customers.

2. A company paid $24,000 for six months of rent beginning June 1.   The company recorded its payment as prepaid rent. If it prepares financial statements dated June 30, the adjusting entry to be made by the company is

a) debit Rent Expense for $24,000 and credit Prepaid Rent for $24,000.

b) debit Rent Expense for $4,000 and credit Prepaid Rent for $4,000.

c) debit Prepaid Rent for $4,000 and credit Cash for $4,000.

d) debit Prepaid Rent for $4,000 and credit Rent Expense for $4,000.

e) debit Rent Expense for $20,000 and credit Prepaid Rent for $20,000.

In: Accounting

FOR1. Open file Nuclear Power. Select data for Canada. Address the following questions. a. Provide a...

FOR1. Open file Nuclear Power. Select data for Canada. Address the following questions.

a. Provide a plot of the data over time in the space below. (2 pts)

[plot here]

b. Choose an appropriate forecasting model and forecast for the next 3 periods (provide forecast in the table below). Explain model selection approach. (8 pts)

Period

Forecast

2007

2008

2009

c. Using the same data, forecast the next 3 periods in the time series using the 5-period moving average and indicate the values below. (3 pts)

Period

Forecast

2007

2008

2009

d. Using the same data, forecast for the next 3 periods in the time series using the single exponential smoothing technique with a smoothing constant of 0.3 and indicate the values below. (3 pts)

Period

Forecast

2007

2008

2009

e. Compare results from models b, c and d. Which forecast model do you recommend to use for the next 3 periods? Justify your recommendation (6 pts)

DATA:

Nuclear Electric Power Production (Billion KWH)
Year US Canada France
1980 251.12 35.88 63.42
1981 272.67 37.8 99.24
1982 282.77 36.17 102.63
1983 293.68 46.22 135.99
1984 327.63 49.26 180.47
1985 383.69 57.1 211.19
1986 414.04 67.23 239.56
1987 455.27 72.89 249.27
1988 526.97 78.18 260.29
1989 529.35 75.35 288.72
1990 576.86 69.24 298.38
1991 612.57 80.68 314.77
1992 618.78 76.55 321.52
1993 610.29 90.08 349.78
1994 640.44 102.44 341.98
1995 673.4 92.95 358.37
1996 674.73 88.13 377.47
1997 628.64 77.86 375.71
1998 673.7 67.74 368.59
1999 728.25 69.82 374.53
2000 753.89 69.16 394.4
2001 768.83 72.86 400.02
2002 780.06 71.75 414.92
2003 763.73 71.15 419.02
2004 788.53 85.87 425.83
2005 781.99 87.44 428.95
2006 787.22 93.07 427.68

In: Operations Management

This Individual Case Study Assignment should be around 1,000 words in total and should be submitted...

  • This Individual Case Study Assignment should be around 1,000 words in total and should be submitted in the form of a business report (approximately 500 words for each part).

Individual Case Study Assignment Part A

BLC Ltd. is a medium-sized UK manufacturing company based in Liverpool.

The company is seeking to expand its operations with the establishment of an office block to house the marketing and human resources staff in Manchester. The company has narrowed the choice to two alternatives with the following net cash flow information being available:

Year Property 1 Property 2
£000s £000s
0 (2,500) (2,750)
1 1,000 900
2 500 700
3 600 800
4 1,000 600
5 900 700

Items to keep in mind:

  • The company’s current cost of capital is 10%.
  • For this assignment, ignore taxation.

Required

As the company accountant is currently on holiday, you are required to:

  • By calculating net present value, internal rate of return and payback, advise the company which option they should take.
  • Critically evaluate the other qualitative factors that might be taken into account in this decision.

Individual Case Study Assignment Part B

BLC Ltd. has revenue of £500 million and sells all of its goods on credit to a variety of different wholesale customers. At the moment the company offers a standard credit period of 30 days. However, 70% of its customers (by revenue) take an average of 70 days to pay, while the other 30% of customers (by revenue) pay within 30 days. The company is considering offering a 2% discount for payment within 30 days and estimates that 80% of customers (by revenue) will take up this offer (including those that already pay within 30 days).

The Managing Director has asked the credit controller if the cost of this new policy would be worth offering. The company has a £80 million overdraft facility that it regularly uses to the full limit due to the lateness of payment and the cost of this overdraft facility is 15% per annum.

The credit controller also estimates that bad debt level of 2% of revenue would be halved to 1% of revenue as a result of this new policy.

Required

  1. Calculate the approximate equivalent annual percentage cost of a discount of 2%, which reduces the time taken by credit customers to pay from 70 days to 30 days.
  2. Calculate the value of trade receivables under the existing scheme and the proposed scheme at the year-end.
  3. Evaluate the benefits and costs of the scheme and explain with reasons whether the company should go ahead and offer the discount. You should also consider other factors in this decision. (Hint: You need to work out the cost of the discount compared to the interest on the overdraft saved and bad debt reduction.)

In: Accounting

In the introduction to this chapter, we described the situation faced by The Gap, Inc. (GPS)....

In the introduction to this chapter, we described the situation faced by The Gap, Inc. (GPS). We learned that the retail clothing chain had grown dramatically over the first two decades of its existence but had fallen on difficult times in 2007. Assume that you have been hired as a new management trainee by the corporate offices of Gap in the spring of 2009 and that you report directly to the director of sales and marketing. Although your job is not specifically in finance, your boss is a major contributor to the firm’s overall financial success and wants you to familiarize yourself with the firm’s recent financial performance. Specifically, she has asked that you review the following income statements for the years 2005–2008. You are to review the firm’s revenue, gross profit, operating income, and net income trends over these four years.

Gap, Inc.
Income Statements (US$ millions, except per share data), 2005–2008

2008 2007 2006 2005
Total revenues $15,763 $15,923 $16,019 $16,267
 Cost of goods sold 10,071 10,266 10,145 9,886
Gross profit $ 5,692 $ 5,657 $ 5,874 $ 6,381
Total operating expense 4,377 4,432 4,099 4,402
Net operating income $ 1,315 $ 1,225 $ 1,775 $ 1,979
 Interest income (expense) 91 90 48 (108)
Earnings before taxes $ 1,406 $ 1,315 $ 1,823 $ 1,871
 Income taxes 539 506 692 721
Net income $ 867 $ 809 $ 1,131 $ 1,150

After contemplating the assignment, you decide to calculate the gross profit margin, operating profit margin, and net profit margin for each of these years. It is your hope that by evaluating these profit margins you will be able to pinpoint any problems that the firm may be experiencing.

Finally, your boss points out that the firm may need to raise additional capital in the near future and suggests that you review the firm’s past financing decisions using both the firm’s balance sheets and its statements of cash flows. Specifically, she asks that you summarize your assessment of the firm’s use of debt financing over these four years.

Gap, Inc.
Balance Sheets (US$ millions, except per share data), 2005–2008

2008 2007 2006 2005
  Cash and short-term investments 1,901.00 2,600.00 2,987.00 3,062.00
  Inventory 1,575.00 1,796.00 1,696.00 1,814.00
  Other current assets 610.00 633.00 556.00 1,428.00
Total current assets 4,086.00 5,029.00 5,239.00 6,304.00
  Gross plant and equipment 7,320.00 7,135.00 6,958.00 7,169.00
  Other long-term assets 485.00 318.00 336.00 368.00
Total assets 7,838.00 8,544.00 8,821.00 10,048.00
  Accounts payable 1,006.00 772.00 1,132.00 1,240.00
  Accrued expenses 1,259.00 1,159.00 725.00 924.00
  Notes payable/short-term debt 0.00 0.00 0.00 0.00
  Current portion of long-term debt and leases 138.00 325.00 0.00 0.00
  Other current liabilities 30.00 16.00 85.00 78.00
Total current liabilities 2,433.00 2,272.00 1,942.00 2,242.00
  Long-term debt 50.00 188.00 513.00 1,886.00
  Other liabilities 1,081.00 910.00 941.00 984.00
Total liabilities 3,564.00 3,370.00 3,396.00 5,112.00
  Common stock 55.00 55.00 54.00 49.00
  Additional paid-in capital 2,783.00 2,631.00 2,402.00 904.00
  Retained earnings (accumulated deficit) 9,223.00 8,646.00 8,133.00 7,181.00
  Treasury stock—common (7,912.00) (6,225.00) (5,210.00) (3,238.00)
  Other equity 125.00 77.00 46.00 40.00
Total stockholders’ equity 4,274.00 5,174.00 5,425.00 4,936.00
Total liabilities and stockholders’ equity 7,838.00 8,544.00 8,821.00 10,048.00

Legend:

Treasury stock —shares of a firm’s common stock that had previously been issued to the public but that have been repurchased in the equity market by the firm.

Gap, Inc.
Statements of Cash Flows (US$ millions, except per share data), 2006–2008

2008 2007 2006
  Net income $   833 $  778 $  1,113
  Depreciation 547 530 625
  Deferred taxes (51) (41) (46)
  Noncash items 107 67 (28)
  Changes in working capital 645 (84) (113)
Cash flow from operating activities $   2,081 $ 1,250 $  1,551
  Capital expenditures (682) (572) (600)
  Other investing cash flow items, total 408 422 886
Cash flow from investing activities $ (274) $ (150) $   286
  Financing cash flow items 132 213 0
  Total cash dividends paid (252) (265) (179)
  Issuance (retirement) of stock, net (1,700) (1,050) (1,861)
  Issuance (retirement) of debt, net (326) 0 0
  Cash flow from financing activities $(2,146) $(1,102) $(2,040)
  Foreign exchange effects 33 (3) (7)
Net change in cash $ (306) $   (5) (210)

In: Accounting

The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...

The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 37 $ 22 Accounts receivable 46 51 Less: Allowance for uncollectible accounts (4 ) (3 ) Dividends receivable 6 5 Inventory 59 52 Long-term investment 19 12 Land 74 42 Buildings and equipment 223 254 Less: Accumulated depreciation (27 ) (54 ) $ 433 $ 381 Liabilities Accounts payable $ 15 $ 24 Salaries payable 6 8 Interest payable 8 6 Income tax payable 9 11 Notes payable 32 0 Bonds payable 99 72 Less: Discount on bonds (4 ) (7 ) Shareholders' Equity Common stock 212 202 Paid-in capital—excess of par 23 22 Retained earnings 43 43 Less: Treasury stock (10 ) 0 $ 433 $ 381 DUX COMPANY Income Statement For Year Ended December 31, 2018 ($ in 000s) Revenues Sales revenue $ 217 Dividend revenue 5 $ 222 Expenses Cost of goods sold 122 Salaries expense 27 Depreciation expense 9 Bad debt expense 1 Interest expense 10 Loss on sale of building 7 Income tax expense 19 195 Net income $ 27 Additional information from the accounting records: A building that originally cost $48,000, and which was three-fourths depreciated, was sold for $5,000. The common stock of Byrd Corporation was purchased for $7,000 as a long-term investment. Property was acquired by issuing a 12%, seven-year, $32,000 note payable to the seller. New equipment was purchased for $17,000 cash. On January 1, 2018, bonds were sold at their $27,000 face value. On January 19, Dux issued a 4% stock dividend (1,000 shares). The market price of the $10 par value common stock was $11 per share at that time. Cash dividends of $16,000 were paid to shareholders. On November 20,000 shares of common stock were repurchased as treasury stock at a cost of $10,000. Required: Prepare the statement of cash flows for Dux Company using the indirect method. (Do not round intermediate calculations. Amounts to be deducted should be indicated with a minus sign. Enter your answers in thousands. (i.e., 10,000 should be entered as 10).))

In: Accounting

McEwan Industries sells on terms of 3/10, net 20. Total sales for the year are $1,643,000;...

McEwan Industries sells on terms of 3/10, net 20. Total sales for the year are $1,643,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 74 days after their purchases. Assume 365 days in year for your calculations.

  1. What is the days sales outstanding? Round your answer to two decimal places.
    ________ days

  2. What is the average amount of receivables? Round your answer to the nearest cent. Do not round intermediate calculations.
    $_______

  3. What is the percentage cost of trade credit to customers who take the discount? Round your answers to two decimal places.
    _________ %

  4. What is the percentage cost of trade credit to customers who do not take the discount and pay in 74 days? Round your answers to two decimal places. Do not round intermediate calculations.
    Nominal cost: %
    Effective cost: %

  5. What would happen to McEwan’s accounts receivable if it toughened up on its collection policy with the result that all nondiscount customers paid on the 20th day? Round your answers to two decimal places. Do not round intermediate calculations.
    Days sales outstanding (DSO) = _______days

    Average receivables = $_________

In: Finance

Objective: demonstrate knowledge in captive insurers, in relation to enterprise risk management. You are the risk...

Objective: demonstrate knowledge in captive insurers, in relation to enterprise risk management.

You are the risk manager of for Paymore ShoeSource, a large, publicly traded, and expensive shoe store chain. Your boss tells you that you that Paymore is planning to set up a broad insurance captive. Overhearing the conversation, a coworker who is not familiar with captives interrupts the conversation with a number of questions. Please answer the following questions for the coworker.

Generally, why would a large company such as Paymore (that is assumed to be risk neutral) purchase insurance?

What is an insurance captive?

Why might the company want to insure through a captive rather than through a traditional insurer? List two reasons.

a)

b)

What is the structure of a “broad” captive? Please use a diagram to illustrate your answer.

Based on the structure just described, does a broad captive represent a contract of insurance defined by the IRS? Discuss the requirements of an insurance contract and argue whether or not a broad captive meets these requirements.

In: Operations Management

what is 3 3/4 ÷27/16=

what is 3 3/4 ÷ 27/16=

In: Math

Crovo Corporation uses customers served as its measure of activity. During December, the company budgeted for...

Crovo Corporation uses customers served as its measure of activity. During December, the company budgeted for 42,000 customers, but actually served 44,000 customers. The company has provided the following data concerning the formulas used in its budgeting and its actual results for December:


Data used in budgeting:

Fixed element
per month
Variable element
per customer
  Revenue $ 2.60          
  Wages and salaries $ 20,300         $ 0.89          
  Supplies $ 0         $ 0.54          
  Insurance $ 7,300         $ 0.00          
  Miscellaneous $ 3,300         $ 0.34          

Actual results for December:

  Revenue $ 111,300
  Wages and salaries $ 56,000
  Supplies $ 21,860
  Insurance $ 9,300
  Miscellaneous $ 21,860

Required:

Complete the report showing the company's revenue and spending variances for December. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Omit the "$" sign in your response.)

Crovo Corporation
Revenue and Spending Variances
For the Month Ended December 31
Flexible
Budget
Actual
Results
Revenue and
Spending Variances
  Customers served
  Revenue $ $ $
  Expenses:
    Wages and salaries
    Supplies
    Insurance
    Miscellaneous
  
  Total expense
  Net operating income $ $ $

In: Accounting