Question: Hello! I need help with pivotTables in Excel.. The inventory manager wants to know how much of each SKU to order for each month next

Hello! I need help with pivotTables in Excel..

  • The inventory manager wants to know how much of each SKU to order for each month next year
  • The market manager wants to know if they should renew the market agreements with each of the markets that they have
  • The marketing group wants to know where they should place television advertisements next year
  • The operations person wants to be able to see how many employees each arm of the business might need for the following year.
  • The CEO wants an overall view of the business using sweet-looking visuals.
IMEI Date - Shipped Date Bill To - Name State Item - Price Item - Qty Amount - Order Shipping Amount - Order Tax Amount - Order Total Market - Store Name Item - SKU
4/9/18 19:25 Person 1 CA $ 260.90 1 $ - $ - $ 260.90 Tiger Wireless
4/6/18 16:23 Person 18 CT $ 89.55 1 $ - $ - $ 89.55 Tiger Wireless sku-auc-0
4/6/18 16:21 Person 19 PA $ 158.00 1 $ - $ 6.32 $ 164.32 Tiger Wireless
4/6/18 16:21 Person 20 AL $ 160.15 1 $ - $ - $ 160.15 Tiger Wireless sku-auc-3
4/6/18 16:21 Person 21 AK $ 160.00 1 $ - $ - $ 160.00 Tiger Wireless
4/6/18 16:21 Person 22 HI $ 134.99 1 $ - $ - $ 134.99 Tiger Wireless sku-auc-3
4/6/18 16:21 Person 23 CA $ 184.45 1 $ - $ - $ 184.45 Tiger Wireless sku-auc-1
4/6/18 16:21 Person 24 CT $ 159.99 1 $ - $ - $ 159.99 Tiger Wireless
4/6/18 16:21 Person 25 PA $ 189.00 1 $ - $ - $ 189.00 Tiger Wireless
4/6/18 16:21 Person 26 AL $ 90.00 1 $ - $ - $ 90.00 Tiger Wireless sku-auc-1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!