Questions
Profit Center Responsibility Reporting XSport Sporting Goods Co. operates two divisions—the Winter Sports Division and the...

Profit Center Responsibility Reporting

XSport Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y9, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted:

Sales—Winter Sports Division $22,785,000
Sales—Summer Sports Division 25,172,000
Cost of Goods Sold—Winter Sports Division 13,671,000
Cost of Goods Sold—Summer Sports Division 14,539,000
Sales Expense—Winter Sports Division 3,906,000
Sales Expense—Summer Sports Division 3,472,000
Administrative Expense—Winter Sports Division 2,278,500
Administrative Expense—Summer Sports Division 2,235,100
Advertising Expense 1,082,000
Transportation Expense 447,000
Accounts Receivable Collection Expense 228,800
Warehouse Expense 2,170,000

The bases to be used in allocating expenses, together with other essential information, are as follows:

  1. Advertising expense—incurred at headquarters, charged back to divisions on the basis of usage: Winter Sports Division, $508,000; Summer Sports Division, $574,000.
  2. Transportation expense—charged back to divisions at a charge rate of $15 per bill of lading: Winter Sports Division, 14,200 bills of lading; Summer Sports Division, 15,600 bills of lading.
  3. Accounts receivable collection expense—incurred at headquarters, charged back to divisions at a charge rate of $8 per invoice: Winter Sports Division, 13,200 sales invoices; Summer Sports Division, 15,400 sales invoices.
  4. Warehouse expense—charged back to divisions on the basis of floor space used in storing division products: Winter Sports Division, 120,000 square feet; Summer Sports Division, 160,000 square feet.

Prepare a divisional income statement with two column headings: Winter Sports Division and Summer Sports Division. Do not round your interim calculations.

XSport Sporting Goods Co.
Divisional Income Statements
For the Year Ended December 31, 20Y9
Winter Sports Division Summer Sports Division
Sales $ $
Cost of goods sold
Gross profit $ $
Divisional selling and administrative expenses:
Divisional selling expenses $ $
Divisional administrative expenses
Total divisional selling and administrative expenses $ $
Income from operations before service department charges $ $
Service department charges:
Advertising expense $ $
Transportation expense
Accounts receivable collection expense
Warehouse expense
Total service department charges $ $
Income from operations $ $

Provide supporting schedules for determining service department charges. If required, round per unit amounts to two decimal places and final answers to the nearest dollar.

XSport Sporting Goods Co.
Service Department Charges
For the Year Ended December 31, 20Y9
Winter Sports Division Summer Sports Division Total
Advertising expense $ $ $
Transportation rate per bill of lading $ $
Number of bills of lading
Transportation expense $ $ $
Accounts receivable collection rate $ $
Number of sales invoices
Accounts receivable collection expense $ $ $
Warehouse rate per sq. ft. $ $
Number of square feet
Warehouse expense $ $ $

In: Accounting

Summarize the case- "Tesco: From Troubles to Turnaround". Explain what other companies should learn from Tesco's...

Summarize the case- "Tesco: From Troubles to Turnaround". Explain what other companies should learn from Tesco's mistakes?

In: Accounting

The balance sheet shows your assets, liabilities, and equity of the business and is a key...

The balance sheet shows your assets, liabilities, and equity of the business and is a key financial statement to analyze. If a business had cash of $200,000, accounts receivable of $500,000, a loan payable of $1,000,000, and equity of -$300,000, then what would this indicate about the business? What would be your overall thoughts on the health of this company and how could you improve its financial health? Would you want to invest in this company? Lead this company? Why or why not?

In: Accounting

The net income of Thomas & Sons, a landscaping company, decreased sharply during 2018. The owner...

The net income of Thomas & Sons, a landscaping company, decreased sharply during 2018. The owner of the company, Jerry Thomas, anticipates the need for a bank loan in 2019. Late in 2018, Jerry instructs the company’s accountant to record $2,000 service revenue for landscape services for the McGrath family, even though the services will not be performed until January 2019. Jerry also tells the accountant not to make the following December 31, 2018 adjusting entries: Salaries owed to employees $900 Prepaid insurance that has expired $400

Requirements:

1) Calculate the total dollar amount of the affect on net income for the three suggested actions. Be detailed in your response so that we can follow how you calculated the total and why the amounts included in your total impact net income.

2) Of the four financial statements, which are impacted by the suggestions and where in the statement? Be specific and provide sufficient detail to suport your answer.

In: Accounting

Required information [The following information applies to the questions displayed below.] Comparative financial statements for Weaver...

Required information

[The following information applies to the questions displayed below.]

Comparative financial statements for Weaver Company follow:

Weaver Company
Comparative Balance Sheet
at December 31
This Year Last Year
Assets
Cash $ 5 $ 13
Accounts receivable 308 230
Inventory 156 196
Prepaid expenses 9 6
Total current assets 478 445
Property, plant, and equipment 505 426
Less accumulated depreciation (85) (72)
Net property, plant, and equipment 420 354
Long-term investments 26 32
Total assets $ 924 $ 831
Liabilities and Stockholders' Equity
Accounts payable $ 304 $ 224
Accrued liabilities 70 77
Income taxes payable 74 64
Total current liabilities 448 365
Bonds payable 196 171
Total liabilities 644 536
Common stock 160 200
Retained earnings 120 95
Total stockholders’ equity 280 295
Total liabilities and stockholders' equity $ 924 $ 831
Weaver Company
Income Statement
For This Year Ended December 31
Sales $ 753
Cost of goods sold 450
Gross margin 303
Selling and administrative expenses 219
Net operating income 84
Nonoperating items:
Gain on sale of investments $ 6
Loss on sale of equipment (2) 4
Income before taxes 88
Income taxes 23
Net income $ 65

During this year, Weaver sold some equipment for $19 that had cost $31 and on which there was accumulated depreciation of $10. In addition, the company sold long-term investments for $12 that had cost $6 when purchased several years ago. Weaver paid a cash dividend this year and the company repurchased $40 of its own stock. This year Weaver did not retire any bonds.

1. Using the indirect method, determine the net cash provided by/used in operating activities for this year. (List any deduction in cash and cash outflows as negative amounts.)

2. Using the information in (1) above, along with an analysis of the remaining balance sheet accounts, prepare a statement of cash flows for this year. (List any deduction in cash and cash outflows as negative amounts.)

In: Accounting

A company is evaluating two independent projects for capital investment purposes. If the company has only...

A company is evaluating two independent projects for capital investment purposes. If the company has only $85 million to invest, and its required return is 10 percent by how much the company’s value will increase?

All values are in millions.

Project 1

Project 2

0

-50

-50

1

30

0

2

25

0

3

20

0

4

20

150

26.62 million

60.77 million

52.45 million

45.33 million

79.07 million

In: Accounting

LaTanya Corporation is planning to issue bonds with a face value of $101,000 and a coupon...

LaTanya Corporation is planning to issue bonds with a face value of $101,000 and a coupon rate of 6 percent. The bonds mature in seven years. Interest is paid annually on December 31. All of the bonds will be sold on January 1 of this year. (FV of $1, PV of $1, FVA of $1, and PVA of $1) (Use the appropriate factor(s) from the tables provided. Round your final answer to whole dollars.) Required: Compute the issue (sale) price on January 1 of this year for each of the following independent cases: a. Case A: Market interest rate (annual): 6 percent. b. Case B: Market interest rate (annual): 4 percent c. Case C: Market interest rate (annual): 7 percent.

In: Accounting

Assess the key ratios for profitability, liquidity, and solvency used by financial analysts to evaluate the...

Assess the key ratios for profitability, liquidity, and solvency used by financial analysts to evaluate the financial performance of Target. How do you indicate one (1) ratio from each of the three (3) categories (profitability, liquidity, and solvency) that you believe to be most indicative of future performance. How do I use actual ratios for Target?

In: Accounting

Cardinal Company is considering a five-year project that would require a $2,945,000 investment in equipment with...

Cardinal Company is considering a five-year project that would require a $2,945,000 investment in equipment with a useful life of five years and no salvage value. The company’s discount rate is 18%. The project would provide net operating income in each of five years as follows:

Sales $ 2,873,000
Variable expenses 1,019,000
Contribution margin 1,854,000
Fixed expenses:
Advertising, salaries, and other fixed out-of-pocket costs $ 754,000
Depreciation 589,000
Total fixed expenses 1,343,000
Net operating income $ 511,000

___________________________________________

6. What is the project’s internal rate of return? (Round your answer to nearest whole percent.)

7. What is the project’s payback period? (Round your answer to 2 decimal places.)

8. What is the project’s simple rate of return for each of the five years? (Round your answer to 2 decimal places.)

13. Assume a postaudit showed that all estimates (including total sales) were exactly correct except for the variable expense ratio, which actually turned out to be 45%. What was the project’s actual net present value? (Negative amount should be indicated by a minus sign. Round discount factor(s) to 3 decimal places, intermediate calculations and final answer to the nearest whole dollar amount.)

In: Accounting

Prepare the journal entries for these transactions. 1) Dur Company purchased equipment on January 2, 2013,...

Prepare the journal entries for these transactions.

1) Dur Company purchased equipment on January 2, 2013, for $112,000. The equipment had an estimated useful life of 5 years with an estimated salvage value of $12,000. Dur uses straight-line depreciation on all assets. On January 2, 2017, Dur exchanged this equipment plus $12,000 in cash for newer equipment. The old equipment has a fair value of $50,000. (Assume that the exchange has commercial substance.)

2) Same transaction except (The exchange lacks commercial substance).

3) Cheng Company traded a used truck for a new truck. The used truck cost $30,000 and has accumulated depreciation of $27,000. The new truck is worth $37,000. Cheng also made a cash payment of $36,000. Prepare Cheng's entry to record the exchange. (The exchange lacks commercial substance.)

4) Slaton Corporation traded a used truck for a new truck. The used truck cost $20,000 and has accumulated depreciation of $17,000. The new truck is worth $35,000. Slaton also made a cash payment of $33,000. Prepare Slaton's entry to record the exchange. (The exchange lacks commercial substance.)

In: Accounting

a. The initial cost of the extraction equipment is $2,500,000. In addition to this cost, the...

a. The initial cost of the extraction equipment is $2,500,000. In addition to this cost, the equipment will require a large concrete foundation at a cost of $300,000. The vendor has quoted an additional cost of $200,000 to install and test the equipment. These costs are all considered part of the cost of acquiring the equipment.

b.The useful life of the equipment is 10 years with no salvage value at the end of this period. However, for tax purposes, the equipment will be classified as 7year property and use the following MACRS depreciation allowances (half year convention) for computing tax depreciation deductions:

Percentage Of Original Year Cost

1 . . . . . . . . . . 14.3%

2 . . . . . 24.5

3 . . . . . . . . . . 17.5

4 . . . . . . . . . . 12.5

5 . . . . . . . . . . 8.9

6 . . . . . . . . . .8.9

7 . . . . . . . . . . 8.9

8 . . . . . . . . . .4.5

100.0%

c. Using the new equipment, 250 pounds of platinum can be extracted annually for the next 10 years from the previously inaccessible area of the mine.

d.The cost to extract and separate platinum from the ore is $4,000 per pound of platinum. After separation, the platinum must undergo further processing and testing that costs $1900 per pound of platinum. These are all out of pocket, variable costs.

e.Two skilled technicians will be hired to operate the new equipment. The total salary and fringe benefit expense for these two employees will be $200,000 annually over the 10 years.

f.Periodic maintenance on the equipment is expected to cost $175,000 per year.

g.The project requires an investment in additional working capital of $300,000. This working capital would be released for use elsewhere at the conclusion of the project in 10 years.

h.Environmental and safety regulations require that the mine be extensively restored and toxic substances be safely disposed at the conclusion of the project. The cost of environmental remediation work is expected to be $4,500,000

i.The current market price of platinum is 12,800 per pound

j.The tax rate is 21% and it uses an 18% after tax discount rate (minimum required rate of return)

Question:

2. Capital investment evaluation
Determine the following for the proposed extractoin equipment investment and specify whether or not the investment is acceptable under each of the following approaches. Assume a minimum payback period of 2 years is required
a. Net Present Value (NPV)
b. Internal rate of return (IRR) [Under TOOLS select GOAL SEEK and SET CELL for NPV equal to "0" - by changing after-tax discount rate 18%
c. Payback (in years) - round to nearest whole year

2.

After-tax Present Value of
Description Year(s) Ending Amount ($) Tax effect (%) Cash Flows ($) Discount Factor Cash Flows ($)
Equipment cost Now
Working capital Now
Revenue 1-10        3,200,000 79%          2,528,000 4.4941
Processing & Testing 1-10
Salaries & benefits 1-10
Maintenance 1-10
PV of depr shield 1-8               365,342
Release of W.C. 10                      - 0.1911
Site Remediation 10
(a) NPV ($) =
check figure: 1236370

In: Accounting

what is the history of phoenix pay?

what is the history of phoenix pay?

In: Accounting

Haley Company produces one product and has the capacity to make 150,000 units per month. The...

Haley Company produces one product and has the capacity to make 150,000 units per month. The cost that is associated with producing 125,000 units is shown below:

Account

Per Unit

Cost at 125,000 units

Direct Materials $ 20.00 $2,500,000.00
Direct Labor $ 30.00 $3,750,000.00
Variable Manufacturing overhead $ 10.00 $1,250,000.00
Fixed Manufacturing overhead $ 15.00 $1,875,000.00
Variable selling and administrative expenses $ 12.00 $1,500,000.00
Fixed selling and administrative expenses $ 14.00 $1,750,000.00
Totals $ 101.00 $12,625,000.00

The selling price per unit is $150. The Haley company was contacted by a prospective customer interested in purchasing 25,000 units for $100. The management team is considering this offer and in the meeting about this new prospect, you (the management accountant), stated that the fixed cost will remain the same, but the variable cost will increase along with $10 shipping expense due to the customer’s international location. Management has asked you to determine if they should accept or reject the new customer proposal and what nonmonetary factors should be considered.

Account Per Unit Cost at 125,000 units
Direct Materials $              20.00 $2,500,000.00
Direct Labor $              30.00 $3,750,000.00
Variable Manufacturing overhead $              10.00 $1,250,000.00
Fixed Manufacturingoverhead $              15.00 $1,875,000.00
Variable selling and adminidtrative expenses $              12.00 $1,500,000.00
Fixed selling and administrative expenses $              14.00 $1,750,000.00
Totals $101.00 $12,625,000.00
Accounts Normal Volume Additional volume Combined Total
Sales
Cost and Expenses:
Direct Materials
Direct Labor
Variable Overhead
Fixed Overhead
Variable Selling and Admin exp.
Fixed selling and Admin exp.
Total costs and expenses:
Net Income $                    -   $                          -   $                   -  

In: Accounting

Financial data for Joel de Paris, Inc., for last year follow: Joel de Paris, Inc. Balance...

Financial data for Joel de Paris, Inc., for last year follow:

Joel de Paris, Inc.
Balance Sheet
Beginning
Balance
Ending
Balance
Assets
Cash $ 130,000 $ 125,000
Accounts receivable 346,000 486,000
Inventory 572,000 472,000
Plant and equipment, net 832,000 837,000
Investment in Buisson, S.A. 404,000 429,000
Land (undeveloped) 250,000 253,000
Total assets $ 2,534,000 $ 2,602,000
Liabilities and Stockholders' Equity
Accounts payable $ 379,000 $ 331,000
Long-term debt 998,000 998,000
Stockholders' equity 1,157,000 1,273,000
Total liabilities and stockholders' equity $ 2,534,000 $ 2,602,000


Joel de Paris, Inc.
Income Statement
Sales $ 4,940,000
Operating expenses 4,297,800
Net operating income 642,200
Interest and taxes:
Interest expense $ 114,000
Tax expense 205,000 319,000
Net income $ 323,200


The company paid dividends of $207,200 last year. The “Investment in Buisson, S.A.,” on the balance sheet represents an investment in the stock of another company. The company's minimum required rate of return of 15%.

Required:

1. Compute the company's average operating assets for last year.

2. Compute the company’s margin, turnover, and return on investment (ROI) for last year. (Do not round intermediate calculations and round your final answers to 2 decimal places.)

3. What was the company’s residual income last year?

In: Accounting

match Point is a retail sports store carrying tennis apparel and equipment. The store is at...

match Point is a retail sports store carrying tennis apparel and equipment. The store is at the end of its second year of operation and is struggling. A major problem is that its cost of inventory has continually increased in the past two years. In the first year of operations, the store assigned inventory costs using LIFO. A loan agreement the store has with its bank, its prime source of financing, requires the store to maintain a certain profit margin and current ratio. The store's owner is currently looking over Match Point’s preliminary financial statements for its second year. The numbers are not favorable. The only way the store can meet the required financial ratios agreed on with the bank is to change from LIFO to FIFO. The store originally decided on LIFO because of its tax advantages. The owner recalculates ending inventory using FIFO and submits those numbers and statements to the loan officer at the bank for the required bank review. The owner thankfully reflects on the available latitude in choosing the inventory costing method.

Required:

  1. How does Match Point’s use of FIFO improve its net profit margin and current ratio?
  2. Is the action by Match Point’s owner ethical? Please justify your answer with an explanation.

In: Accounting