{"id":21903,"date":"2023-06-13T20:45:32","date_gmt":"2023-06-13T20:45:32","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/chapter-02-weekly-data-discussion-board-exercise-pareto-principle-using-bicycle-inventory-data-chapter-02-weekly-data-discussion-board-exercise-pareto-principle-using-bicycle-inven\/"},"modified":"2023-06-13T20:45:32","modified_gmt":"2023-06-13T20:45:32","slug":"chapter-02-weekly-data-discussion-board-exercise-pareto-principle-using-bicycle-inventory-data-chapter-02-weekly-data-discussion-board-exercise-pareto-principle-using-bicycle-inven","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/chapter-02-weekly-data-discussion-board-exercise-pareto-principle-using-bicycle-inventory-data-chapter-02-weekly-data-discussion-board-exercise-pareto-principle-using-bicycle-inven\/","title":{"rendered":"Chapter 02 Weekly Data Discussion Board Exercise \u2013 Pareto Principle using Bicycle Inventory Data Chapter 02 Weekly Data Discussion Board Exercise \u2013 Pareto Principle using Bicycle Inventory Data"},"content":{"rendered":"<ol style=\"margin-top: 1em; margin-right: 0px; margin-left: 0px; padding: 0px 0px 5px 40px; font-size: 14px; cursor: auto; color: inherit;\">\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Open the file and save your working file as a .xlsx file in another folder.<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Create columns for Inventory Value, Percentage, and Cumulative % in H-J.<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Calculate the Inventory Value in Column H using Purchase Cost x Quantity.<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Use the SUM formula to calculate the Total Inventory column total.<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Use the Data\u2013Sort option to sort all columns by Inventory Value in descending order.<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Calculate the Percentage of Inventory in column I; use an anchor ($) in the formula.<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Use the SUM formula to calculate the percentage column total.<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Create a formula to calculate the Cumulative %.<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Prepare a Pareto Chart and Pivot Table showing total Inventory Value by Product Name as shown in the video.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Open the file and save your working file as a .xlsx file in another folder. Create columns for Inventory Value, Percentage, and Cumulative % in H-J. Calculate the Inventory Value in Column H using Purchase Cost x Quantity. Use the SUM formula to calculate the Total Inventory column total. Use the Data\u2013Sort option to sort [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[706],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/21903"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=21903"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/21903\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=21903"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=21903"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=21903"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=21903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}