In: Accounting
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 | $15,000,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 | 16,000,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?
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?
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?
ROI = operating income/average assets
margin = operating income / sales
turnover = sales/average assets
1
for year 1
roi = 1200000/15000000 = 8%
margin = 1200000/15000000 = 8%
turnover = = 15000000/15000000 =1
year 2
roi = 1445000/15000000 = 9.63%
margin = 1445000/9500000 = 15.21%
turnover = = 9500000/15000000 =0.63
year 3
roi = 945000/16000000 = 5.91%
margin = 945000/9000000 = 10.5%
turnover = = 9000000/16000000 =0.56
2
sales = 15000000
operating = 1200000
assets = 16000000
roi = 1200000/16000000 = 7.5%
margin = 1200000/150000000 = 8%
turnover = = 150000000/16000000 = 0.94
ROI increased over year 3 level because for the same average assets, we could generate greater operating profit.
3
sales = 9000000
operating profit = 945000
assets = 16000000 - 20% of 16000000 = 12800000
roi = 945000/12800000 = 7.38%
margin = 945000/9000000 = 10.5%
turnover = = 9000000/12800000 = 0.70
ROI increased over year 3 level because to generate the same operating profit , we needed a lesser amount of asset investment.
4
sales = 15000000
operating = 1200000
assets = 16000000 - 20% of 16000000 = 12800000
roi = 1200000/12800000 = 9.4%
margin = 1200000/150000000 = 8%
turnover = = 150000000/12800000 = 1.17
ROI increased over year 3 level because the company generated extra profit with lesser asset investments