Return on Investment, Margin, Turnover
Ready Electronics is facing stiff competition from imported goods. Its operating income margin has been declining steadily for the past several years. The company has been forced to lower prices so that it can maintain its market share. The operating results for the past 3 years are as follows:
Year 1 | Year 2 | Year 3 | |
Sales | $13,500,000 | $ 9,500,000 | $ 9,000,000 |
Operating income | 1,200,000 | 1,445,000 | 945,000 |
Average assets | 15,000,000 | 15,000,000 | 17,750,000 |
For the coming year, Ready's president plans to install a JIT purchasing and manufacturing system. She estimates that inventories will be reduced by 70% during the first year of operations, producing a 20% reduction in the average operating assets of the company, which would remain unchanged without the JIT system. She also estimates that sales and operating income will be restored to Year 1 levels because of simultaneous reductions in operating expenses and selling prices. Lower selling prices will allow Ready to expand its market share.
(Note: Round all numbers to two decimal places.)
Required:
1. Compute the ROI, margin, and turnover for Years 1, 2, and 3.
Year 1 | Year 2 | Year 3 | |
ROI | % | % | % |
Margin | % | % | % |
Turnover |
2. Conceptual Connection: Suppose that in Year 4 the sales and operating income were achieved as expected, but inventories remained at the same level as in Year 3. Compute the expected ROI, margin, and turnover.
ROI | % | |
Margin | % | |
Turnover |
Why did the ROI increase over the Year 3 level?
The ROI increased because expenses decreased and assets
turned over at a higher rate (sales increased).
3. Conceptual Connection: Suppose that the sales and net operating income for Year 4 remained the same as in Year 3 but inventory reductions were achieved as projected. Compute the ROI, margin, and turnover.
ROI | % |
Margin | % |
Turnover |
Why did the ROI exceed the Year 3 level?
The ROI increased because assets decreased.
4. Conceptual Connection: Assume that all expectations for Year 4 were realized. Compute the expected ROI, margin, and turnover.
ROI | % |
Margin | % |
Turnover |
Why did the ROI increase over the Year 3 level?
The ROI increased because expenses decreased and assets
turned over at a higher rate.
In: Accounting
One of your Taiwanese suppliers has bid on a new line of molded plastic parts that is currently being assembled at your plant. The supplier has bid $0.10 per part, given a forecast you provided of 200,000 parts in year 1; 400,000 in year 2; and 500,000 in year 3. Shipping and handling of parts from the supplier’s factory is estimated at $0.03 per unit. Additional inventory handling charges should amount to $0.005 per unit. Finally, administrative costs are estimated at $30 per month.
Although your plant is able to continue producing the part, the plant would need to invest in another molding machine, which would cost $20,000. Direct materials can be purchased for $0.06 per unit. Direct labor is estimated at $0.05 per unit for wages plus a 50 percent surcharge for benefits and, indirect labor is estimated at $0.009 per unit plus 50 percent benefits. Up-front engineering and design costs will amount to $30,000. Finally, management has insisted that overhead be allocated if the parts are made in-house at a rate of 100 percent of direct labor wage costs. The firm uses a cost of capital of 15 percent per year.
a. Calculate the difference in NPVs between the Make and Buy options. Express all costs as positive values in your calculations. It is suggested to use the NPV function in Excel. (Do not round intermediate calculations. Round your answer to 2 decimal places.)
(Difference in NPV $
b. Should you continue to produce in-house or accept the bid from your Taiwanese supplier?
In: Accounting
Nicole’s Getaway Spa (NGS) purchased a hydrotherapy tub system to add to the wellness programs at NGS. The machine was purchased at the beginning of the year at a cost of $9,500. The estimated useful life was five years and the residual value was $500. Assume that the estimated productive life of the machine is 10,000 hours. Expected annual production was year 1, 2,200 hours; year 2, 2,300 hours; year 3, 2,400 hours; year 4, 2,100 hours; and year 5, 1,000 hours.
Assume NGS sold the hydrotherapy tub system for $2,850 at the end of year 3.The following amounts were forecast for year 3: Sales Revenues $43,000; Cost of Goods Sold $34,000; Other Operating Expenses $4,300; and Interest Expense $900. Create an income statement for year 3 for each of the different depreciation methods, ending at Income before Income Tax Expense. (Don't forget to include a loss or gain on disposal for each method.).
In: Accounting
Estate Finance Family Tax Plan Question
1. On January 2, 2000, Larry creates a trust with himself as trustee. Larry as trustee may distribute income and principal to Susie and Leon to provide for their health, education, maintenance and support. Upon Larry's death, the remainder is distributed to Susie and Leon equally. Does Larry's power to distribute principal and income cause the trust to be grantor as to Larry under § 671? Why or why not?
In: Accounting
What is the Interpretation between the two companies' ratios for The 2015 & 2016 Celgene & 2015 & 2016 Gilead Financial statements used to calculate these ratios.
Gilead Sciences Inc. | Celgene Corp. | ||||||
Earnings per Share of Common Stock (basic - common) | As given in the income statement | $ 10.08 | $ 2.57 | ||||
Current Ratio | Current Assets | $20,445.0 | = | 2.22 | $10,867.5 | = | 3.67 |
Current Liabilities | $9,219.0 | $2,959.2 | |||||
Gross (Profit) Margin Percentage | Gross Margin | $26,129.0 | = | 86.0% | $10,746.6 | = | 96.1% |
Net Sales | $30,390.0 | $11,184.6 | |||||
Rate of Return (Net Profit Margin) on Sales | Net Income | $13,488.0 | = | 44.4% | $1,999.2 | = | 17.9% |
Net Sales | $30,390.0 | $11,184.6 | |||||
Inventory Turnover | Cost of Goods Sold | $4,261.0 | 2.4 | $438.0 | 0.9 | ||
Average Inventory | $1,771.0 | times | $470.7 | times | |||
Days' Inventory Outstanding (DIO) | 365 Days | $365.0 | = | 152 | $365.0 | = | 392 |
Inventory Turnover | $2.4 | days | $0.9 | days | |||
= |
In: Accounting
Estate Finance Family Tax Plan Question
Assume for the purposes of this question that the UPAIA dictates the calculation of fiduciary accounting income.
1. In 2001, Larry creates a trust with Tenleytown Trust Company as trustee. The trustee must distribute income to Susie, Jeff and Leon (the trust does not provide for distributions of principal). In 2002, the trust has $50,000 of interest from corporate bonds, $50,000 of interest from tax-exempt municipal bonds and $50,000 of dividends. The trust also sells Asset A that has a basis of $100,000 for $500,000. In 2012, trust pays trustee fees to Tenleytown Trust Company of $50,000 and attorney's fees of $50,000 to the law offices of Hiram Katz. What is the trust's fiduciary accounting income? Analyze how much of each receipt and disbursement should be allocated to income or principal.
In: Accounting
Financial accounting information is historical in nature, reporting on what has happened in the past. To facilitate comparisons between companies, this information must conform to certain accounting standards or principles called generally accepted accounting principles (GAAP).
Please discuss this statement, emphasising the importance of a user of financial statements being able to compare financial statements prepared by different companies.
In: Accounting
In 2018, the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,000. The road was completed in 2020. Information related to the contract is as follows:
|
2018 |
2019 |
2020 |
Cost incurred during the year |
2,400,000 |
3,600,000 |
2,200,000 |
Estimated costs to complete as of year-end |
5,600,000 |
2,000,000 |
0 |
Billings during the year |
2,000,000 |
4,000,000 |
4,000,000 |
Cash collections during the year |
1,800,000 |
3,600,000 |
4,600,000 |
2-a. In the journal below, complete the necessary journal entries (construction costs, progress billings, cash collections, gross profit/loss) for the year 2018 (credit "Various accounts" for construction costs incurred). 2-b. In the journal below, complete the necessary journal entries (construction costs, progress billings, cash collections, gross profit/loss) for the year 2019 (credit "Various accounts" for construction costs incurred). 2-c. In the journal below, complete the necessary journal entries (construction costs, progress billings, cash collections, gross profit/loss) for the year 2020 (credit "Various accounts" for construction costs incurred). |
|
|
|
||||||
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
In: Accounting
Write a paragraph discussing the differences between common stock and preferred stock from the investor's perspective for this company. Comment specifically on dividends, potential for the future increase in share price and risks.
Thanks,
In: Accounting
Equivalent Units of Production and Related Costs
The charges to Work in Process—Assembly Department for a period, together with information concerning production, are as follows. All direct materials are placed in process at the beginning of production.
Work in Process-Assembly Department | |||
---|---|---|---|
Bal., 8,000 units, 65% completed | 31,880 | To Finished Goods, 184,000 units | ? |
Direct materials, 188,000 units @ $2.10 | 394,800 | ||
Direct labor | 404,400 | ||
Factory overhead | 157,320 | ||
Bal., ? units, 20% completed | ? |
Determine the following:
a. The number of units in work in process
inventory at the end of the period.
units
b. Equivalent units of production for direct materials and conversion. If an amount is zero or a blank, enter in "0".
Work in Process-Assembly Department | |||
Equivalent Units of Production for Direct Materials and Conversion Costs | |||
Whole Units |
Equivalent Units Direct Materials |
Equivalent Units Conversion |
|
Inventory in process, beginning | |||
Started and completed | |||
Transferred to finished goods | |||
Inventory in process, ending | |||
Total units |
c. Costs per equivalent unit for direct materials and conversion. If required, round your answers to the nearest cent.
Costs Per Equivalent Unit | |
Direct Materials | $ |
Conversion | $ |
d. Cost of the units started and completed
during the period.
$
In: Accounting
Fred Meyer wishes to exchange a unique piece of machinery used
in its operations. Fred Meyer has received three offers from other
companies in the industry, each of which lacks commercial
substance:
Oryx Energy offered to exchange a Franklin desalination water
system, and pay $20,900.
Sara Lee offered to exchange a Komatsu 120-ton truck, and pay
$62,600.
Dyna-Flex offered to exchange a Massey-Ferguson front-loader, and
pay $19,800.
Information concerning each of the assets to be exchanged is noted
below:
Cost | Accum Depn | Fair Value | |
Fred Meyer--unique piece of machinery | $ 330,000 | $ 265,000 | $ 181,200 |
Oryx Energy--Franklin desalination water system | 265,000 | 182,300 | 160,300 |
Sara Lee--Komatsu 120-ton truck | 330,000 | 265,000 | 118,600 |
Dyna-Flex--Massey-Ferguson front-loader | 150,000 | 65,000 | 161,400 |
Based on the three offers above and assuming Fred Meyer uses the straight-line method of depreciation with a salvage value of $1,100 an estimated useful life of 11 years, what is the annual depreciation expense of the exchanged asset that produces the least amount of depreciation expense for Fred Meyer in future years?
In: Accounting
During 2014, Eagle Beach Company EBC) had sales of $1,000,000, cost of goods sold of $425,000, administrative and selling expenses of $95,000, depreciation expense of $140,000 and interest expense of $70,000. The tax rate is 35 percent. Ignore any tax loss carryback or carry forward provisions. What is the operating cash flow for EBC?
A. $340,000
B.$385,500
C.$361,000
In: Accounting
12.
a.
Williams Sonoma took the following markdowns:
Find the total markdown taken on this merchandise.
a. |
$1615.00 |
|
b. |
$1580.00 |
|
c. |
$1609.00 |
|
d. |
$1618.00 |
|
e. |
$1559.00 |
|
f. |
None of the above. |
b.
At a furniture store's clearance center, 33 recliner chairs were sold. All 33 recliners were originally marked at $699.00 and sold at the clearance price of $289.00. Find the total markdown dollars taken.
a. |
$13571.00 |
|
b. |
$13549.00 |
|
c. |
$13565.00 |
|
d. |
$13530.00 |
|
e. |
$13559.00 |
|
f. |
None of the above. |
c.
A buyer of women's jewelry purchased a line of earrings to retail at $51.50 each. The manufacturer has offered these earrings to the retailer at a cost of $9.00 each. Determine the markup percentage.
a. |
80.62427184% |
|
b. |
84.72427184% |
|
c. |
82.52427184% |
|
d. |
84.12427184% |
|
e. |
80.22427184% |
|
f. |
None of the above. |
In: Accounting
Economy Appliance Co. manufactures low-price, no-frills appliances that are in great demand for rental units. Pricing and cost information on Economy's main products are as follows.
|
Customers can contract to purchase either individually at the stated prices or a three-item bundle with a price of $1,800. The bundle price includes delivery and installation. Economy provides delivery and installation as a standalone service for any of its products for a price of $100.
Instructions Respond to the requirements related to the following independent revenue arrangements for Economy Appliance Co.
(a) | On June 1, 2014, Economy sold 100 washer/dryer units without installation to Laplante Rentals for $70,000. Laplante is a newer customer and is unsure how this product will work in its older rental units. Economy offers a 60-day return privilege and estimates, based on prior experience with sales on this product, 4% of the units will be returned. Prepare the journal entries for the sale and related cost of goods sold on June 1, 2014. |
(b) | YellowCard Property Managers operates upscale student apartment buildings. On May 1, 2014, Economy signs a contract with YellowCard for 300 appliance bundles to be delivered and installed in one of its new buildings. YellowCard pays 20% cash at contract signing and will pay the balance upon delivery and installation no later than August 1, 2014. Prepare journal entries for Economy on (1) May 1, 2014, and (2) August 1, 2014, when all appliances are delivered and installed. |
(c) | Refer to the arrangement in part (b). It would help YellowCard secure lease agreements with students if the delivery and installation of the appliance bundles can be completed by July 1, 2014. YellowCard offers a 10% bonus payment if Economy can complete delivery and installation by July 1, 2014. Economy estimates its chances of meeting the bonus deadline to be 60%, based on a number of prior contracts of similar scale. Repeat the requirement for part (b), given this bonus provision. Assume installation is completed by July 1, 2014. |
(d) | Epic Rentals would like to take advantage of the bundle price for its 400-unit project; on February 1, 2014, Economy signs a contract with Epic for delivery and installation of 400 bundles. Under the agreement, Economy will hold the appliance bundles in its warehouses until the new rental units are ready for installation. Epic pays 10% cash at contract signing. On April 1, 2014, Economy completes manufacture of the appliances in the Epic bundle order and places them in the warehouse. Economy and Epic have documented the warehouse arrangement and identified the units designated for Epic. The units are ready to ship, and Economy may not sell these units to other customers. Prepare journal entries for Economy on (1) February 1, 2014, and (2) April 1, 2014. |
Please show work been stuck on this one for two days!
In: Accounting
Which of the following can be done as part of the bank
reconciliation process?
Select all that apply.
Select one or more:
A. You can open and edit transactions listed on the reconciliation screen.
B. Service charges and interest income not previously recorded can be entered.
C. Transactions dated subsequent to the bank statement ending date can be hidden from view.
D. New banking transactions (checks and deposits for example) can be entered.
In: Accounting