I Need help creating an IE Table for Dicks Sporting Goods

				THE IFE TOTAL WEIGHTED SCORES
			Strong					Weak
			4.0					1.0
	High
	4.0
THE EFE WEIGHTED SCORES
	Low
	1.0
	Division	Firm's Division Revenues	Estimated IFE Score	Estimated EFE Score
	0	$0	0.0	0.0
	0	$0	0.0	0.0
	0	$0	0.0	0.0
	0	$0	0.0	0.0
	0	$0	0.0	0.0

IFE Table

	Strengths	Weight	Rating	Weighted Score
1	Holds a significant 30.8% of market share in the Liscenced Sports Apparel Stores industry based on revenues- 30.8% (IBIS, 2022)	0.10	4	0.40
2	Owns & operates 20 different brands such as Golf Galaxy, Calia, Field & Stream, and Public Lands	0.04	3	0.12
3	Partnership with Nike in DSG mobile app, giving athletes access to exclusive product, experiences and content. (Annual Report, 2021).	0.02	3	0.06
4	Strong omni-channel platform & fulfillment capabilities utilizing in-store experience knowledgeable staff to drive sales (Annual Report, 2021).	0.10	4	0.40
5	High level of customer satisfaction - scored 38 on NPS and with 73% of customers stating they are loyal customers of the company. (Comparably, 2022).	0.06	3	0.18
6	Good returns on capital expenditures - 19.5% in last 12 months for an increase of 3.4% above the average returns. This is a measure on the firms ability to create value for all its stakeholders. (Finbox, 2022).	0.03	3	0.09
7	Accomplishment qualifies for inclusion in the Fortune 500 - has over seven hundred locations	0.02	2	0.04
8	Workplace diversity	0.06	3	0.18
9	The horizontal and/or vertical integration can increase the control over whole value chain	0.05	3	0.15
10	Competent and committed human capital can act as a powerful source of competitive advantage	0.04	2	0.08
	Weaknesses	Weight	Rating	Weighted Score
1	Lower profit and revenue growth than competitors (IBIS, 2020).	0.05	2	0.10
2	Heavily reliant on sales from Nike and Under Armour who account for 32% of net sales. (David et al., 2020).	0.09	4	0.36
3	Lower number of storefronts in the Western United States (ScrapeHero, 2022).	0.04	3	0.12
4	Fewer fishing & hunting lines compared to competitors (David et al., 2020).	0.02	2	0.04
5	Poor financial management and a lack of cash management may be costly.	0.04	3	0.12
6	Need more investment in new technologies	0.03	3	0.09
7	Investment in R&D lags behind industry leaders.	0.05	3	0.15
8	High cost of replacing existing experts	0.03	3	0.09
9	High rate of staff turnover at the lowest levels.	0.10	4	0.40
10	Poor project management practices	0.03	3	0.09
	Total IFE Score	1.00		3.26

Efe Table

	Opportunities	Weight	Rating	Weighted Score
1	Grow vertical brands as they are the 2nd largest brand category, yet only account for 14% of net sales (Annual Report, 2021).	0.09	3	0.27
2	Make continuious improvements to the eCommerce business.	0.08	3	0.24
3	New environmental regulations and consumer preferences - provides opportunity to capitalize on investments in new technology to tap into a growing market of eco-friendly customers (Emmert, 2021).	0.05	3	0.15
4	Growing sports participation post-covid (IBIS, 2022).	0.03	3	0.09
5	Higher demand for fitness equipment and home-gym setups (IBIS, 2022).	0.06	3	0.18
6	Growing market of retired adults who are increasingly interested in staying active (Jenkin et al., 2017).	0.02	1	0.02
7	New market segments and niches provide chances to expand company and product lines.	0.05	3	0.15
8	Diminishing borders and expanding global interconnection enable the company to enter the worldwide market, target geographically dispersed customers, and boost profitability.	0.03	2	0.06
9	Government subsidies and favorable policies.	0.04	2	0.08
10	459 adverts a day in the company's external environment.	0.03	2	0.06
	Threats	Weight	Rating	Weighted Score
1	U.S. Gun control regulations threatening revenues from guns in their hardlines, which accounted for revenues over $5 million in fiscal year 2021. (Annual Report, 2021).	0.04	3	0.12
2	Decline of traditional brick-and-mortar stores due to cost advantages of online competitors (Forbes, 2021).	0.04	3	0.12
3	Social media, smartphones, & video games threaten the need for DSG products & services. by curbing physical activity (Kolhar et al., 2021).	0.08	3	0.24
4	Discretionary spending and reductions in consumer spending might adversely affect the Company's business, operations, liquidity, financial results and stock price.	0.05	2	0.10
5	External environment is an excessive number of retailers selling athletic goods; not enough clients.	0.03	2	0.06
6	External environment is internet commerce. May indicate that customers are shopping elsewhere	0.03	2	0.06
7	A high personnel turnover rate and a rising reliance on new solutions	0.06	3	0.18
8	Lasting effects of COVID-19 on the business.	0.10	3	0.30
9	Different nations' liability rules may be vulnerable to liability claims due to policy changes.	0.05	3	0.15
10	Inability to optimize the network or distruptions by third-party transportation resulting in loss of merchandise to stores and athletes.	0.04	3	0.12
	Total EFE Score	1.00		2.75