Aegis Industries Inc., is the biggest snowmobile manufacturer in the world. It reported the following amounts in its financial statements (in millions): 2013 $4,900 $4,360 $3,690 $3,270 3,810 440 2012 2014 2015 Net Sales Revenue 4,290 490 3,290 2,870 380 Cost of Goods Sold Average Inventory 370 Required: 1-a. Calculate the inventory turnover ratio for 2015, 2014, and 2013. 1-b. Calculate the average days to sell inventory for 2015, 2014, and 2013. 2. Is Aegis performing better than its competitor Snow Pack Corporation where the inventory turned over is 71 times in 2015 (51.4 days to sell). Both companies use the same inventory costing method (FIFO). Complete this question by entering your answers in the tabs below. nces Reg Req 1B Req 2 Calculate the inventory turnover ratio for 2015, 2014, and 2013. (Round your answers to 1 decimal place.) Times per Year 2014 2013 2015 Inventory Turnover Ratio Reg 1A Req 18
Aegis Industries Inc., is the biggest snowmobile manufacturer in the world. It reported the following amounts in its financial statements (in millions): 2013 $4,900 $4,360 $3,690 $3,270 3,810 440 2012 2014 2015 Net Sales Revenue 4,290 490 3,290 2,870 380 Cost of Goods Sold Average Inventory 370 Required: 1-a. Calculate the inventory turnover ratio for 2015, 2014, and 2013. 1-b. Calculate the average days to sell inventory for 2015, 2014, and 2013. 2. Is Aegis performing better than its competitor Snow Pack Corporation where the inventory turned over is 71 times in 2015 (51.4 days to sell). Both companies use the same inventory costing method (FIFO). Complete this question by entering your answers in the tabs below. nces Reg Req 1B Req 2 Calculate the inventory turnover ratio for 2015, 2014, and 2013. (Round your answers to 1 decimal place.) Times per Year 2014 2013 2015 Inventory Turnover Ratio Reg 1A Req 18
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Topic Video
Question
![**Aegis Industries Inc. Financial Analysis**
Aegis Industries Inc., a leading snowmobile manufacturer worldwide, presented the following financial data:
### Financial Statements (in millions)
| Year | Net Sales Revenue | Cost of Goods Sold | Average Inventory |
|------|-------------------|--------------------|-------------------|
| 2012 | $4,900 | $4,290 | $490 |
| 2013 | $4,360 | $3,810 | $440 |
| 2014 | $3,690 | $3,290 | $380 |
| 2015 | $3,270 | $2,870 | $370 |
### Required Calculations
1-a. **Inventory Turnover Ratio (2015, 2014, 2013):**
- Calculate the inventory turnover ratio to understand how efficiently the company manages its stock. Use the formula:
\[
\text{Inventory Turnover Ratio} = \frac{\text{Cost of Goods Sold}}{\text{Average Inventory}}
\]
1-b. **Average Days to Sell Inventory (2015, 2014, 2013):**
- Calculate the average number of days it takes to sell the inventory using the formula:
\[
\text{Average Days to Sell Inventory} = \frac{365}{\text{Inventory Turnover Ratio}}
\]
2. **Comparison with Competitor:**
- Evaluate Aegis' performance against Snow Pack Co., whose inventory turnover was 7.1 times, equating to 51.4 days to sell inventory in 2015. Both companies utilize the same inventory costing method (FIFO).
### Graph/Diagram:
The visual component at the bottom includes a chart to input calculated values for the requirements:
- A tabular entry point for Inventory Turnover Ratios for the years 2015, 2014, and 2013. It is structured with sections titled "Req 1A" and "Req 1B" for inputting respective calculations.
This analysis helps compare Aegis Industries Inc. with industry benchmarks and competitors for informed decision-making.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2bd93233-75ab-47a8-9b3f-39d1bbb35924%2Fa5de3b55-24d1-49e5-afd4-f9e1a42c4237%2F1zng6t_processed.jpeg&w=3840&q=75)
Transcribed Image Text:**Aegis Industries Inc. Financial Analysis**
Aegis Industries Inc., a leading snowmobile manufacturer worldwide, presented the following financial data:
### Financial Statements (in millions)
| Year | Net Sales Revenue | Cost of Goods Sold | Average Inventory |
|------|-------------------|--------------------|-------------------|
| 2012 | $4,900 | $4,290 | $490 |
| 2013 | $4,360 | $3,810 | $440 |
| 2014 | $3,690 | $3,290 | $380 |
| 2015 | $3,270 | $2,870 | $370 |
### Required Calculations
1-a. **Inventory Turnover Ratio (2015, 2014, 2013):**
- Calculate the inventory turnover ratio to understand how efficiently the company manages its stock. Use the formula:
\[
\text{Inventory Turnover Ratio} = \frac{\text{Cost of Goods Sold}}{\text{Average Inventory}}
\]
1-b. **Average Days to Sell Inventory (2015, 2014, 2013):**
- Calculate the average number of days it takes to sell the inventory using the formula:
\[
\text{Average Days to Sell Inventory} = \frac{365}{\text{Inventory Turnover Ratio}}
\]
2. **Comparison with Competitor:**
- Evaluate Aegis' performance against Snow Pack Co., whose inventory turnover was 7.1 times, equating to 51.4 days to sell inventory in 2015. Both companies utilize the same inventory costing method (FIFO).
### Graph/Diagram:
The visual component at the bottom includes a chart to input calculated values for the requirements:
- A tabular entry point for Inventory Turnover Ratios for the years 2015, 2014, and 2013. It is structured with sections titled "Req 1A" and "Req 1B" for inputting respective calculations.
This analysis helps compare Aegis Industries Inc. with industry benchmarks and competitors for informed decision-making.
![**Aegis Industries Inc. Financial Summary (2012-2015)**
Aegis Industries Inc. is recognized as the largest snowmobile manufacturer globally. Below are key financial figures reported in millions:
| Year | Net Sales Revenue | Cost of Goods Sold | Average Inventory |
|------|------------------|-------------------|------------------|
| 2012 | $4,990 | $4,290 | 490 |
| 2013 | $4,360 | $3,810 | 440 |
| 2014 | $3,690 | $3,290 | 380 |
| 2015 | $3,270 | $2,870 | 370 |
### Required Analysis:
1. **Inventory Turnover Ratio Calculation:**
- Determine the inventory turnover ratio for the years 2015, 2014, and 2013.
2. **Average Days to Sell Inventory:**
- Calculate the average days it takes to sell inventory for the years 2015, 2014, and 2013 using a 365-day year, and provide answers rounded to one decimal place.
3. **Performance Comparison:**
- Compare Aegis Industries Inc. with its competitor, Snow Pack Corporation, which reported an inventory turnover of 7.1 times in 2015 (equivalent to 51.4 days to sell). Both companies use the FIFO inventory costing method.
### Calculating Inventory Turnover Ratio and Days to Sell:
- **Inventory Turnover Ratio:** This measures how often a company sells and replaces its inventory within a period. It is calculated using the formula:
\[
\text{Inventory Turnover Ratio} = \frac{\text{Cost of Goods Sold}}{\text{Average Inventory}}
\]
- **Average Days to Sell Inventory:** Reflects the average number of days taken to sell the entire inventory:
\[
\text{Average Days to Sell} = \frac{365}{\text{Inventory Turnover Ratio}}
\]
### Data Inputs for Evaluation:
- Tabs provided to input calculated results.
- Assess whether Aegis is outperforming its competitor based on the turnover ratios and days to sell inventory.
Complete this task using the placeholders specified in the tabs.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2bd93233-75ab-47a8-9b3f-39d1bbb35924%2Fa5de3b55-24d1-49e5-afd4-f9e1a42c4237%2Fl9rrhnb_processed.jpeg&w=3840&q=75)
Transcribed Image Text:**Aegis Industries Inc. Financial Summary (2012-2015)**
Aegis Industries Inc. is recognized as the largest snowmobile manufacturer globally. Below are key financial figures reported in millions:
| Year | Net Sales Revenue | Cost of Goods Sold | Average Inventory |
|------|------------------|-------------------|------------------|
| 2012 | $4,990 | $4,290 | 490 |
| 2013 | $4,360 | $3,810 | 440 |
| 2014 | $3,690 | $3,290 | 380 |
| 2015 | $3,270 | $2,870 | 370 |
### Required Analysis:
1. **Inventory Turnover Ratio Calculation:**
- Determine the inventory turnover ratio for the years 2015, 2014, and 2013.
2. **Average Days to Sell Inventory:**
- Calculate the average days it takes to sell inventory for the years 2015, 2014, and 2013 using a 365-day year, and provide answers rounded to one decimal place.
3. **Performance Comparison:**
- Compare Aegis Industries Inc. with its competitor, Snow Pack Corporation, which reported an inventory turnover of 7.1 times in 2015 (equivalent to 51.4 days to sell). Both companies use the FIFO inventory costing method.
### Calculating Inventory Turnover Ratio and Days to Sell:
- **Inventory Turnover Ratio:** This measures how often a company sells and replaces its inventory within a period. It is calculated using the formula:
\[
\text{Inventory Turnover Ratio} = \frac{\text{Cost of Goods Sold}}{\text{Average Inventory}}
\]
- **Average Days to Sell Inventory:** Reflects the average number of days taken to sell the entire inventory:
\[
\text{Average Days to Sell} = \frac{365}{\text{Inventory Turnover Ratio}}
\]
### Data Inputs for Evaluation:
- Tabs provided to input calculated results.
- Assess whether Aegis is outperforming its competitor based on the turnover ratios and days to sell inventory.
Complete this task using the placeholders specified in the tabs.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education