Question
Frontier Ranch Supply is a diversified retailer specializing in a wide range of ranch supplies and equipment. It's store network of company-owned stores operates
Frontier Ranch Supply is a diversified retailer specializing in a wide range of ranch supplies and equipment. It's store network of company-owned stores operates in most of the lower 48 states. The company is seeking to gain insight into the relative demand for the company's products in those states and the various regions of the country in which it sells. The current focus is on assessing the company's inventory management relative to regional and local demand. To assist in the analysis, the accounting team has assembled data in Tableau on sales, additional markup percentage ratios, and markdown percentage ratios for each state and each of the five regions of the country designated in the company's data base. Higher ratios of additional markups relative to sales indicate favorable inventory management while lower ratios of markdowns relative to sales indicate favorable inventory management. Inventory Management by Region Q+IG 2021 Mapbox OpenStreetMap Inventory Management by State Wyoming Total Sales $2,946 $7,115,574 North Dakota Minnesota South Dakota Nova Scotia Wisconsin VT Michigan New York MA lowa United States Missouri est Virginja Kentucky Tennessee North Carolina Oklahoma Arkansas Mississippi Georgia Texas Louisiana Region (All) Central East Northeast South West Florida Inventory Management by Region Additional Markup % Markdown% Additional East West Region East State Total Sales Markup % Markdown % 7.00% District of Colum.. $2,945.56 0.00% 0.00% 6.00% Illinois $35,631.16 0.57% 5.09% Maryland $486,624.90 0.09% 1.96% New Jersey $298,021.58 3.91% 7.41% 5.00% Ohio $5,185,899.26 5.65% 2.85% West Arizona $1,490,325.64 3.30% 4.54% 4.00% California $4,430,160.68 0.70% 5.00% Colorado $1,031,623.66 0.01% 4.81% 3.00% Idaho $158,935.00 3.34% 5.14% Montana $7,115,573.68 0.62% 2.82% 2.00% Nevada $1,719,432.84 0.00% 7.95% New Mexico $1,185,909.26 0.02% 8.97% 1.00% Oregon Utah $2,933,703.24 0.16% 8.44% $116,864.16 0.31% 0.10% 0.00% Washington $2,477,712.94 0.62% 6.31% Additional Markup Markdown % Additional Markup % Markdown % +ableau Drawing from the data available, assess the following: K C
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started