Question

In: Accounting

Principal Skinner Company produces gourmet cheeses. Selected results from the most current year were as follows:...

Principal Skinner Company produces gourmet cheeses. Selected results from the most current year were as follows:

                             Sales revenue                               $3,500,000

                             Operating income                           560,000

                             Assets 1/1                                     5,000,000

                             Assets 12/31                                5,800,000

                             Current liabilities 12/31               925,000

                             Long-term Liabilities 12/31      3,050,000

Production manager Marge Simpson is considering investing in the purchase of a new fermenting station that will increase the plant’s production capacity. Based on her research, Marge thinks the station would cost $2,200,000 and would increase sales revenue by $1,750,000 and operating income by $450,000.

Required

  1. Calculate Principal Skinner’s current sales margin, asset turnover, and return on investment.
  2. Calculate Principal Skinner’s sales margin, asset turnover, and return on investment assuming the company purchases the new fermenting station.
  3. Assume Marge Simpson’s annual bonus is based on the company’s return on investment. Will Marge support the purchase of the new fermenting station? Why or why not?

Solutions

Expert Solution

Answer:

1. Calculate Principal Skinner’s current sales margin, asset turnover, and return on investment.

Sales Margin 16.00%
Turonver             0.65
ROI 10.37%

2. Calculate Principal Skinner’s sales margin, asset turnover, and return on investment assuming the company purchases the new fermenting station.

Sales Margin 19.24%
Turonver           0.69
ROI 13.29%

3. Assume Marge Simpson’s annual bonus is based on the company’s return on investment. Will Marge support the purchase of the new fermenting station? Why or why not?

Yes

Melinda will support the purchase of the fermenting station.

It is because investing in the purchase of a new fermenting station that will increase the plant’s production capacity and also will increase the Return on investments

Calculation:

1.

Sales margin is the profit generated from the sale of the product or service provided. Here we need to divide the operating income with the Sales revenue to get the Sales margin.

Sales Margin = Operating Income / Sales Revenue = 560,000 / 3,500,000 = 16%

Asset turnover ratio is used to see how effectively companies use the assets to generate sales. Here we need to divide the Sales revenue with Average Assets.

So first we need to calculate the average total assets.

Average total assets = (5,000,000 + 5,800,000) / 2 = 5,400,000

Then, Asset turnover ratio = Sales Revenue / Average total assets = 3,500,000 / 5,400,000 = 0.648 times

Return on investment (ROI) ratio is used to calculate the benefit an investor will receive for an investment. Here we could calculate that by multiplying the Sales margin and Turnover ratio.

Return on investment = Sales margin x Turnover ratio = 16% x 0.65 = 10.37%

2.

The station would cost $2,200,000 and would increase sales revenue by $1,750,000 and operating income by $450,000.

Sales margin is the profit generated from the sale of the product or service provided. Here we need to divide the operating income with the Sales revenue to get the Sales margin.

Sales Margin = Operating Income + increase operating profit / Sales Revenue + increase sales revenue = 560,000 + 450,000 / 3,500,000 +1,750,000 = 19.24%

Asset turnover ratio is used to see how effectively companies use the assets to generate sales. Here we need to divide the Sales revenue with Average Assets.

So first we need to calculate the average total assets.

Average total assets = (5,000,000 + 5,800,000) / 2 = 5,400,000

Then, Asset turnover ratio = Sales Revenue + increase sales revenue / Average total assets + Increase in cost = 3,500,000 +1,750,000 / 5,400,000 + 2,200,000  = 0.691 times

Return on investment (ROI) ratio is used to calculate the benefit an investor will receive for an investment. Here we could calculate that by multiplying the Sales margin and Turnover ratio.

Return on investment = Sales margin x Turnover ratio = 19.24% x 0.69 = 13.29%


Related Solutions

Principal Skinner Company produces gourmet cheeses. Selected results from the most current year were as follows:...
Principal Skinner Company produces gourmet cheeses. Selected results from the most current year were as follows: Sales Revenue: $3,500,000 Operating Income: $560,000 Assets 1/1: $5,000,000 Assets 12/31: $5,800,000 Current Liabilities 12/31: $925,000 Long-term Liabilities 12/31: $3,050,000 Production Manager Marge Simpson is considering investing in the purchase of a new fermenting station that will increase the plant’s production capacity. Based on her research, Marge thinks the station would cost $2,200,000 and would increase sales revenue by $1,750,000 and operating income by...
Joyner Pickled Pepper Company produces pickled jalapeno pepper relish. Selected results from the most current year...
Joyner Pickled Pepper Company produces pickled jalapeno pepper relish. Selected results from the most current year were as follows: Sales revenue $3,485,300 Operating income 453,089 Average total assets 3,830,000 Production manager Veronica Brockman is investigating the purchase of a new brining station that will increase the plant’s production capacity. Based on her research, Veronica thinks the station would cost $162,000 and would increase sales revenue by $200,000 and operating profit by $26,000. Calculate Joyner’s current margin, asset turnover, and return...
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales...
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales Quantity Target Price Actual Price Difference A 1,900.00 $ 302.00 $ 303.00 $ 1.00 B 9,500.00 314.60 272.60 (42.00 ) C 950.00 219.50 327.00 $ 107.50 The firm sets the target price of each product at 150% of the product’s total manufacturing cost. It appears that the firm was able to sell Product C at a much higher price than the target price of...
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales...
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales Quantity Target Price Actual Price Difference A 1,550.00 $ 295.00 $ 296.00 $ 1.00 B 7,750.00 307.60 265.60 (42.00 ) C 775.00 212.50 320.00 $ 107.50 The firm sets the target price of each product at 150% of the product’s total manufacturing cost. It appears that the firm was able to sell Product C at a much higher price than the target price of...
The following were selected from among the transactions completed during the current year by Danix Co.,...
The following were selected from among the transactions completed during the current year by Danix Co., an appliance wholesale company: Jan. 13. Sold merchandise on account to Black Tie Co., $35,700. The cost of goods sold was $21,420. Mar. 10. Accepted a 60-day, 9% note for $35,700 from Black Tie Co. on account. May 9. Received from Black Tie Co. the amount due on the note of March 10. June 10. Sold merchandise on account, terms 1/10, n/30, to Holen...
The following were selected from among the transactions completed by Caldemeyer Co. during the current year....
The following were selected from among the transactions completed by Caldemeyer Co. during the current year. Caldemeyer Co. sells and installs home and business security systems. Jan. 3 Loaned $18,000 cash to Trina Gelhaus, receiving a 90-day, 8% note. Feb. 10 Sold merchandise on account to Bradford & Co., $24,000. The cost of the merchandise sold was $14,400. 13 Sold merchandise on account to Dry Creek Co., $60,000. The cost of merchandise sold was $54,000. Mar. 12 Accepted a 60-day,...
The following were selected from among the transactions completed during the current year by Danix Co.,...
The following were selected from among the transactions completed during the current year by Danix Co., an appliance wholesale company: Jan. 13. Sold merchandise on account to Black Tie Co., $41,100. The cost of goods sold was $24,660. Mar. 10. Accepted a 60-day, 8% note for $41,100 from Black Tie Co. on account. May 9. Received from Black Tie Co. the amount due on the note of March 10. June 10. Sold merchandise on account, terms 2/10, n/30, to Holen...
The following were selected from among the transactions completed during the current year by Danix Co.,...
The following were selected from among the transactions completed during the current year by Danix Co., an appliance wholesale company: Jan. 21. Sold merchandise on account to Black Tie Co., $41,400. The cost of merchandise sold was $24,840. Mar. 18. Accepted a 60-day, 9% note for $41,400 from Black Tie Co. on account. May 17. Received from Black Tie Co. the amount due on the note of March 18. June 15. Sold merchandise on account to Pioneer Co. for $17,900....
The following were selected from among the transactions completed during the current year by Danix Co.,...
The following were selected from among the transactions completed during the current year by Danix Co., an appliance wholesale company: Jan. 21. Sold merchandise on account to Black Tie Co., $28,000. The cost of merchandise sold was $16,800. Mar. 18. Accepted a 60-day, 6% note for $28,000 from Black Tie Co. on account. May 17. Received from Black Tie Co. the amount due on the note of March 18. June 15. Sold merchandise on account to Pioneer Co. for $17,700,...
The following were selected from among the transactions completed during the current year by Danix Co.,...
The following were selected from among the transactions completed during the current year by Danix Co., an appliance wholesale company: Jan. 13. Sold merchandise on account to Black Tie Co., $30,300. The cost of goods sold was $18,180. Mar. 10. Accepted a 60-day, 6% note for $30,300 from Black Tie Co. on account. May 9. Received from Black Tie Co. the amount due on the note of March 10. June 10. Sold merchandise on account, terms 2/10, n/30, to Holen...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT