70.2K

Verified Solution

Link Copied!

Compute cost of goods sold (COGS), gross margin, and gross margin % in total and by store.2 Identify the two most profitable and the two least profitable stores overall and by segment. Provide the CFO at least two reasons why this profitability analysis is important for managing Bibitor.

I have already calculated the data in Tableau just need the part in bold answered please.

F Store 64 COGS 3,362,420 2,359,574 GM 1,673,437 1,162,891 GM% = 33.2% 33.0% 2 most profitable by GM% Overall 39 COGS GM Store Wine Wine Wine Spirits 944,519 1,297,875 52 GM% Spirits 28.5% 28.2% Spirits 376,624 509,195 339,215 1,061,698 212,525 653,696 38.5% 38.1% 2 most profitable by GM% Segment (Spirits) 39 Store COGS Spirits 1,501,664 1,209,970 GM Spirits 572,010 461,117 Wine 474,124 387,455 Wine ? - 2 most profitable by GM% Segment (Wine) GM% Spirits 27.6% 78 Wine 307,299 248,865 39.3% 57 27.6% 39.1% Store E 48 COGS 3,480,052 2,826,383 GM 1,425,192 1,170,226 GM% = 29.1% 29.3% 2 least profitable by GM% Overall 27 GM Store COGS Spirits 2,941,558 2,491,837 Wine 538,494 808,399 48 Spirits 1,096,654 930,240 GM% Spirits : 27.2% 27.2% Wine 328,539 500,856 Wine 37.9% 38.3% 2 least profitable by GM% Segment (Spirits) 61 Store COGS Spirits Wine 6,062,806 3,879,531 5,990,224 4,562,384 GM Spirits 2,297,913 2,255,638 GM% Spirits 27.5% Wine 2,276,667 2,679,509 Wine E 37.0% 69 2 least profitable by GM% Segment (Wine) 67 27.4% 37.0%

Answer & Explanation Solved by verified expert

See Answer