You are part of the Supply Chain Analytics team at IDEA Company. They are in the business of selling home decorations and furnishings. The following is a map of the USA. Red represents population density. The green circle represents the company warehouse storing and shipping items that qualify as Small Items (Small Items are defined as any item where one dimension length, width or height is not more than 90 inches and item weight is less than 70 lbs). The blue circles represent warehouses that store and ship Large and Bulky Items (Large and Bulky Items are anything that is not a Small Item). You have access to the two data tables shown below (Item master table and Purchase orders table) and you are asked to determine which Purchase Orders (meaning, your orders to your Supplier) should be sent to which type of facility Small Items facility or Large and Bulky Items facility. (a) How will you go about doing it? (Hint: Remember to look for the Unique identifier). (b) When your company launches a new item that you have never sold before, what should be done to make sure that you have the information to send it to the right facility? (c) Why are these two types of facilities are split this way?

ECIS-634-W Assignment