| 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 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 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
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:
Required
As the company accountant is currently on holiday, you are required to:
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
In: Accounting
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 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; 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.
| Nominal cost: | % |
| Effective cost: | % |
In: Finance
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
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