Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedCompute 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%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting in an Economic Context

Authors: Jamie Pratt

8th Edition

9781118139424, 9781118139431, 470635290, 1118139429, 1118139437, 978-0470635292

More Books

Students also viewed these Accounting questions