Identify how these stores are packing their inventory

Assignment Help Other Subject

Reference no: EM133891519

Question: With this Data Table you have to investigate boxes being shipped from 5 different stores to multiple stores. First you will need to create pivot tables reflecting the unique shipments in detail. Identify how these 5 stores are packing their inventory. Each line will show Box Numbers and the item it contained inside (Item code/PLU) The Division # is the specific code # for a specific genre of item, for example 291 is mens inner wear one specific division/Category however boxes could contain multiple kinds of items within that division for example if there are two item codes with the same division then there are two different types of mens inner in that box (Socks, boxers). The quantity is the amount of each item is in that box, there are multiple lines for one box as stores are shipping more than one item in a box. To ensure that stores are consolidating items into one box when shipping to stores please analyze if stores instead of consolidating they are separating boxes and shipping multiple boxes to one store during each shipment (Ship date) Get affordable and professional assignment help now!

For this assignment you will be specifying the total amount of shipments these 5 stores have completed to each store location and in total as a whole store. Analyze how many boxes can be reduced if multiple divisions consolidation are applied. Average quantity that is being shipped in each box for each store and if multiple divisions are in one box, if not multiple divisions also specify if store is not shipping multiple divisions in one box meaning they are separating by division or by item which means they are ineffectively shipping and spending more money by shipping various boxes to same store during same Ship Date.

Reference no: EM133891519

Questions Cloud

Determine the impacts of the health information issue : Determine the impacts of the health information issue(s) on health care professionals (e.g., physicians, nurses, other providers, and administrative staff)

Multiple complaints from customers concerning : A Canadian bank has received multiple complaints from customers concerning its Philippines-based call center.

What do the details suggest about the relationship : We had arrived in Nsukka before he finally spoke. What do the details suggest about the relationship between Nnamabia and his parents?

Demonstrate how you would present and deliver : Presentation with recorded audio that demonstrates how you would present and deliver your capstone project to your intended audience

Identify how these stores are packing their inventory : Identify how these stores are packing their inventory. Each line will show Box Numbers and the item it contained inside (Item code/PLU)

Describe Mertons strain theory : The study found that providing these services reduced the rate of re-offending. Briefly describe Merton's strain theory.

Describe the nature of bias in corporate decision-making : Describe the nature of bias in corporate decision-making? What are two possible causes and how do they create such bias?

Which mood is created by the details that describe setting : The dirt road was hilly and there were sudden wash in it and sharp curve on dangerous embankment. Which mood is created by the detail that describe the setting?

Strengths and weaknesses of secondary data analysis : What are the strengths and weaknesses of secondary data analysis?

User Account

All Pages