Frontier Ranch Supply is a diversified retailer specializing in a wide range of ranch supplies and equipment. Its 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 companys products in those states and the various regions of the country in which it sells. The current focus is on assessing the companys 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 companys 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.

Which state in which Frontier operates generates the largest volume of sales?

Montana

California

Washington

What is the average additional markup percentage ratio for states in the West region?

.66%

.70%

5.08%

How would you characterize that states inventory management relative to demand as measured by the additional markup percentage ratio?

Its inventory management as measured by the additional markup percentage ratio is in line with other states in the same region and more favorable than most other regions. radio button unchecked1 of 3 Its inventory management as measured by the additional markup percentage ratio is more favorable than other states in the same region and roughly in line with most other regions. radio button unchecked2 of 3 Its additional markup percentage ratio is in line with the average for the region in which it operates, but that regional average is considerably lower than that of all other regions.

Which of the following in not true regarding the relative inventory management in the five regions in which the company operates?

	Inventory management as measured by the additional markup percentage ratio is most favorable in the East region. radio button unchecked1 of 3 Inventory management as measured by the additional markup percentage ratio is least favorable in the West region. radio button unchecked2 of 3 Inventory management as measured by the markdown percentage ratio is most favorable in the South region.

Which conclusion is supported by the information provided by the Dashboard?

The South and West regions should be scrutinized for ways to improve the inventory management in those regions. radio button unchecked1 of 3 Across regions, the efficiency of inventory management as measured by the markdown percentage ratio is consistent with the efficiency of inventory management as measured by the additional markup percentage ratios. radio button unchecked2 of 3 Inventory management is most favorable in the East and South regions, depending on which ratio is being analyzed.

Total Sales Inventory Management by Region $2,946 $7,115,574 a Washington North Dakota Montana Minnesota w Maine Nova Scotia South Dakota Wisconsin + IC Oregon Idaho VT Wyoming Michigan New York MA lowa United States Illinois Ohio Nevada Utah Colorado Missouri West Virginia Kentucky California Region (All) Central Oklahoma Tennessee North Carolina Arizona New Mexico Arkansas East Mississippi Northeast Georgia South Texas Louisiana West Florida Additional Markup % 2020 Mapbox OpenStreetMap Markdown % Inventory Management by State Inventory Management by Region East West 7.00% Region 2 East Additional Markup % 0.00% 0.57% 6.00% State District of Colum.. Illinois Maryland New Jersey Ohio Arizona California 5.00% 0.09% 3.91% 5.65% 3.30% West 4.00% 0.70% Total Sales $2,945.56 $35,631.16 $486,624.90 $298,021.58 $5,185,899.26 $1,490,325.64 $4,430,160.68 $1,031,623.66 $158,935.00 $7,115,573.68 $1,719,432.84 $1,185,909.26 $2,933,703.24 $116,864.16 $2,477,712.94 Markdown % 0.00% 5.09% 1.96% 7.41% 2.85% 4.54% 5.00% 4.81% 5.14% 2.82% 7.95% 8.97% 8.44% 0.10% 6.31% Colorado 0.01% 3.00% Idaho 3.34% Montana 0.62% 2.00% Nevada 0.00% New Mexico 0.02% 1.00% 0.16% Oregon Utah 0.31% 0.00% Region: West Markdown %: 5.270 Washington 0.62% Markdown % Additional Markup % Additional Marl % Total Sales Inventory Management by Region $2,946 $7,115,574 a Washington North Dakota Montana Minnesota w Maine Nova Scotia South Dakota Wisconsin + IC Oregon Idaho VT Wyoming Michigan New York MA lowa United States Illinois Ohio Nevada Utah Colorado Missouri West Virginia Kentucky California Region (All) Central Oklahoma Tennessee North Carolina Arizona New Mexico Arkansas East Mississippi Northeast Georgia South Texas Louisiana West Florida Additional Markup % 2020 Mapbox OpenStreetMap Markdown % Inventory Management by State Inventory Management by Region East West 7.00% Region 2 East Additional Markup % 0.00% 0.57% 6.00% State District of Colum.. Illinois Maryland New Jersey Ohio Arizona California 5.00% 0.09% 3.91% 5.65% 3.30% West 4.00% 0.70% Total Sales $2,945.56 $35,631.16 $486,624.90 $298,021.58 $5,185,899.26 $1,490,325.64 $4,430,160.68 $1,031,623.66 $158,935.00 $7,115,573.68 $1,719,432.84 $1,185,909.26 $2,933,703.24 $116,864.16 $2,477,712.94 Markdown % 0.00% 5.09% 1.96% 7.41% 2.85% 4.54% 5.00% 4.81% 5.14% 2.82% 7.95% 8.97% 8.44% 0.10% 6.31% Colorado 0.01% 3.00% Idaho 3.34% Montana 0.62% 2.00% Nevada 0.00% New Mexico 0.02% 1.00% 0.16% Oregon Utah 0.31% 0.00% Region: West Markdown %: 5.270 Washington 0.62% Markdown % Additional Markup % Additional Marl %