Tableau File Data Worksheet 100% 2 Tue 10:49 PM Dashboard Story Analysis Map Format Server Window Help Tableau - DA9_AJ . . Standard - = Show Me Data Analytics . Pages ili Columns Region Measure Names Sheet1 (Inventory) E Rows Measure Values Search Y Filters Measure Names Inventory Management by Region Tables Status: S Additional Markup Markdown Region Northeast Measure Names Central East Soulli 0.07 0.05611 Marks od Automatic 0.06 I 90 Color Size Label 0.05272 0.05076 0.05144 0.05 Detal Toatin Measure Names Region: South Markdown 0.06611 Abe Category A Customer Name # Number Ax Product Number Mx Region Moc Segment State Moc Status e Zip Moc Moasure Names -# Acc itional Markup # Cost # Freight in -# Markdown # Net Markdowns # Net Markups # Selling Price - Total Markdowns -# Total Markus - Total Sales Latitude ( geral) Longitude (generaled) # Shetl (Count) # Messure Values 0.04 Measure Values 0.03123 0.03013 AGG(Additional Mark. AGGI Markdawi) 0.03 0.02213 0.02 0.01582 0.01436 0.01 0.00562 0.00 Additional Markdown Additional Markdown Additional Maricdown Additional Markdown Additional Markdown Markup % Markup % Markup Markup % Markup: CO Data Source Inventory Management by Regi... Inventory Management by State 3d marks 1 row by 10 columns SUM of Measure Values 0.84123 Odtv W 22 100% Tue 10:49 PM Tableau File Data Worksheet Dashboard Story Analysis Map Format Server Window Help Tableau - DA9_AJ > G-0.6 Standard - = Show Me Data Analytics . Pages ili Columns Messure Names Sheet1 (Inventory) E Rows State F Search Y Filters Tables Neasure Names E Marks Markdown % 1.36% 0.42% 0.77% 1.94% 2.44% 0.61% 1.40% T Automate Color Teat 1.07% Tootie 1 Measure Values 0.53% 0.51% Abe Category A Customer Name # Number Ax Product Number Mx Region Moc Segment State Moc Status e Zip Moc Moasure Names -# Acc itional Markup # Cost # Freight in -# Markdown # Net Markdowns # Net Markups # Selling Price - Total Markdowns -# Total Markus - Total Sales Latitude (general) Longitude (generaled) # Shetl (Count) # Messure Values Measure Values Inventory Management by State State Additional Markup % Missouri 5.58% South Carolina Florida 2.48% North Carolina 2.31% Maine 2.24% Illinois 2.16% Virginia 1.87% Montana 1.59% Idaho 1,13% Massachusetts 1.10% Ohio 1.02% Connecticut 1.0.1% Minnesota 0.95% Texas 0.87% Michigan 0.76% Delaware 0.67% California 0.59% Indiana 0.51% Nebraska 0.49% Pennsylvania 0.46% Arizona 0.45% Louisiana 0.45% 0.43% Rhode Island 0.39% New Jersey 0.35% Washington 0.27% Oklahoma 0.25% Iowa 0.24% ACG(Additional Mark.. AGG Markdown") 0.03% 0.05% 1.28% 1.00% 0.16% 0,07% 2.90% 1.62% 0.59% 1.91% 0,05% 3.07% 0.67% 2.64% 0.73% 4.60% Data Source Inventory Management by Region Inventory Management by State 0 0 90 marks 45 raw by 45 rows by 2 columns SUMO Measure Value: 108.02 LL O tv W MIS 100% 2 Tue 10:49 PM Tableau File Data Worksheet Dashboard Story Analysis Map Format Server Window Help Tableau - DA9_AJ AG-. - - . Standard - = Show Me Data Analytics . Pages ili Columns Messure Names Sheet1 (Inventory) E Rows State F Search Filters Tables Neasure Names = Markdown Marks T Automate 0.07% 2.91% 1.62% 0.59% 1.90% 0.05% T Teat Color Tootie 1 Measure Values Abe Category A Customer Name # Number Ax Product Number Mx Region Moc Segment State Moc Status e Zip Moc Moasure Names -# Acc itional Markup # Cost # Freight in -# Markdown # Net Markdowns # Net Markups # Selling Price - Total Markdowns -# Total Markus - Total Sales Latitude (general) Longitude (generaled) # Shetl (Count) # Messure Values Inventory Management by State State Additional Markup % Indiana 0.51% Nebraska 0.49% Pennsylvaniu 0.46% Arizona 0.45% Louisiana 0.45% Llah 0.43% Rhode Island 0.19% New Jersey 0.35% Washington 0.27% Oklahoma Lowa 0.24% New York 0.23% Arkansas 0.18% New Hampshire 0.11% % Wisconsin 0.10% Oregon 0.08% Alabama 0,06% Kentucky 0.06% Tennessee 0.05% Vermont 0.03% Kannus 0.02% Maryland 0.02% Colorado 0.01% New Mexico 0.01% Georgia 0.01% Nevada 0,00% Mississippi District of Columbia 0,67% 2.64% 0.73% 4.661% 0.68% 2.83% 0.08% 0.42% Measure Values AGG(Additional Mark. AGGI Markdown') 0.03% 1.90% 0.72% 0.60% 7.53% 0.55% 0.63% 4.55% 3.59% 4.31% 02 Data Source Inventory Management by Region Inventory Management by State 90 marks 45 rows by 2 columns SUMO Measure Value: 108.02 LCHILGE LL Odtv W P p. A. Which of the five regions' operations has the most favorable inventory management relative to demand as measured by the additional markup percentage ratio and what is that ratio? (Round your answer to 1 decimal place.) B. Which of the five regions' operations has the least favorable inventory management relative to demand as measured by markdown percentage ratio and what is that ratio? (Round your answer to 1 decimal place.) eBook To view the state inventory management results more clearly, highlight the column "Additional Markup %" in the "Inventory Management by State" column and sort from largest to smallest. You can answer problem 4 below by following the same procedure for the "Markdown %" column. C. Which state's operations has the most favorable inventory management relative to demand as measured by additional markup percentage ratio and what is that ratio? (Round your answer to 2 decimal places.) D. Which state's operations has the least favorable inventory management relative to demand as measured by markdown percentage ratio and what is that ratio? (Round your answer to 2 decimal places.) %. A. The: B. The c. region's operations has the most favorable inventory management with an additional markup percentage of regions' operations has the least favorable inventory management relative to demand with a markdown percentage of operations has the most favorable inventory management relative to demand with an additional markup percentage ratio of operations has the least favorable inventory management relative to demand with a markdown percentage ratio of %. %. D. %