70.2K

Verified Solution

Link Copied!

Darren's golf Suppliers is a private-equity owned wholesale distributor of golf clubs, apparel, and accessories. In 2020, the company implemented various measures to help drive sales growth vs prior years. It is now January 2021. You have been engaged to help stakeholders better understand 2020 results vs. the prior year. The company has provided you with the information on the "Sales Data" tab as a starting point for the analysis. Your key objectives are now to:

1. Summarize changes in financial performance from 2019 to 2020

2. Create a financial bridge / walk that breaks out key drivers of YoY changes to gross margin percentage and gross margin dollars (including exec-level commentary that the CFO can leverage when presenting findings to the Board of Directors)

3. Identify any YoY brand or customer-level trends that warrant further investigation and list out additional data points that should be requested in order to better understand the financial performance of the business

4. Summarize potential next steps / actions that mgmt. should consider taking in order to drive future profitability

Customer Name	Brand Name	Sales Year	Sales Month	Net Sales	Net Cost
Golfer's Warehouse	Bag Boy	2019	Jan	$ 237,732	$ (176,397)
Golfer's Warehouse	Bag Boy	2019	Jan	$ 183,093	$ (142,044)
PGA Galaxy	Srixon	2019	Jan	$ 180,420	$ (154,506)
Rock Bottom Golf	PING	2019	Feb	$ 177,471	$ (119,665)
PGA Galaxy	Bridgestone Golf	2019	Feb	$ 311,160	$ (202,254)
PGA Galaxy	Titleist	2019	Feb	$ 172,320	$ (149,938)
The Golf SuperStore	Titleist	2019	Feb	$ 169,432	$ (147,419)
PGA Galaxy	Mizuno	2019	Feb	$ 150,532	$ (109,918)
Joe's Sporting World	Titleist	2019	Mar	$ 138,626	$ (120,620)
PGA Galaxy	Srixon	2019	Mar	$ 124,503	$ (106,624)
The Golf SuperStore	Titleist	2019	Mar	$ 115,105	$ (99,877)
Golfer's Warehouse	PING	2019	Mar	$ 113,141	$ (79,157)
PGA Galaxy	Srixon	2019	Mar	$ 101,840	$ (87,103)
Golfer's Warehouse	Bag Boy	2019	Mar	$ 101,203	$ (75,275)
Joe's Sporting World	TaylorMade	2019	Apr	$ 259,262	$ (226,455)
Rock Bottom Golf	ECCO	2019	Apr	$ 96,783	$ (69,730)
Golfer's Warehouse	Titleist	2019	Apr	$ 89,054	$ (63,537)
Golf Tec	Odyssey	2019	Apr	$ 88,559	$ (66,722)
Preppy Boy Sports	Cleveland	2019	Apr	$ 82,133	$ (68,083)
Golf Tec	Garmin	2019	Apr	$ 81,123	$ (61,695)
Rock Bottom Golf	PING	2019	Apr	$ 77,191	$ (53,489)
PGA Galaxy	Bridgestone Golf	2019	Apr	$ 127,974	$ (83,183)
The Golf SuperStore	Titleist	2019	May	$ 67,949	$ (59,122)
Golfer's Warehouse	PING	2019	May	$ 67,005	$ (47,126)
Golfer's Warehouse	PING	2019	May	$ 65,760	$ (44,677)
Rock Bottom Golf	TaylorMade	2019	May	$ 164,598	$ (138,762)
The Golf SuperStore	Bridgestone Golf	2019	May	$ 110,411	$ (71,767)
Golf Tec	Garmin	2019	May	$ 58,437	$ (44,441)
Rock Bottom Golf	ECCO	2019	May	$ 57,789	$ (41,636)
The Golf SuperStore	Odyssey	2019	May	$ 56,778	$ (42,279)
Golfer's Warehouse	Maxfli	2019	Jun	$ 56,305	$ (43,168)
The Golf SuperStore	Srixon	2019	Jun	$ 54,910	$ (47,023)
Golfer's Warehouse	Srixon	2019	Jun	$ 54,653	$ (39,085)
Joe's Sporting World	Titleist	2019	Jun	$ 54,458	$ (47,385)
PGA Galaxy	Srixon	2019	Jun	$ 53,487	$ (45,805)
Golf Tec	Titleist	2019	Jun	$ 52,830	$ (39,390)
Joe's Sporting World	Titleist	2019	Jul	$ 51,198	$ (44,548)
Olympus Golf	Slazenger	2019	Jul	$ 51,063	$ (36,335)
Marathon Sports	Odyssey	2019	Jul	$ 50,985	$ (37,961)
PGA Galaxy	Mizuno	2019	Jul	$ 50,903	$ (37,169)
Golf Tec	OGIO	2019	Aug	$ 50,226	$ (40,080)
Roger Dunn Golf Shops	PING	2019	Aug	$ 48,806	$ (34,139)
Joe's Sporting World	TaylorMade	2019	Aug	$ 125,255	$ (109,406)
The Golf SuperStore	Titleist	2019	Aug	$ 47,310	$ (41,105)
Golfer's Warehouse	Maxfli	2019	Sep	$ 47,308	$ (36,310)
Marathon Sports	Titleist	2019	Sep	$ 46,960	$ (33,505)
Golfer's Warehouse	Maxfli	2019	Sep	$ 46,899	$ (35,964)
Golf Tec	Odyssey	2019	Oct	$ 46,350	$ (36,071)
Golfer's Warehouse	PING	2019	Oct	$ 46,178	$ (31,432)
PGA Galaxy	True Temper	2019	Oct	$ 46,041	$ (35,341)
The Golf SuperStore	Bridgestone Golf	2019	Nov	$ 82,649	$ (53,722)
Preppy Boy Sports	OGIO	2019	Nov	$ 45,518	$ (37,053)
Golfer's Warehouse	Titleist	2019	Nov	$ 45,432	$ (32,415)
PGA Galaxy	Bushnell	2019	Dec	$ 33,786	$ (26,995)
Golfer's Warehouse	GolfBuddy	2019	Dec	$ 45,005	$ (36,378)
PGA Galaxy	Bridgestone Golf	2019	Dec	$ 80,800	$ (52,520)
Rock Bottom Golf	TaylorMade	2019	Dec	$ 115,823	$ (99,352)

Answer & Explanation Solved by verified expert

See Answer