Please use excel to solve this question! Thank You! Year Quarter Period Inventor
ID: 3057676 • Letter: P
Question
Please use excel to solve this question! Thank You!
Year Quarter Period Inventory (1000s) 2006 Q1 1 156 Q2 2 114 Q3 3 166 Q4 4 175 2007 Q1 5 169 Q2 6 137 Q3 7 175 Q4 8 191 2008 Q1 9 185 Q2 10 160 Q3 11 192 Q4 12 209 2009 Q1 13 203 Q2 14 172 Q3 15 214 Q4 16 228 2010 Q1 17 219 Q2 18 197 Q3 19 251 2011 Q4 20 264 Q1 21 239 Q2 22 217 Q3 23 271 Q4 24 284 DistCo, a large warehouse service company in the San Francisco Bay Area, stores pharmaceutical products for customers while they are in transit to local retailers. DistCo can store a maximum of 294,000 cases of products at its present facility. Because their business has been growing, the company's management wonders if they should acquire other warehouses in 2012. The materials manager has accumulated the inventory data presented in the MGMT3100 Case 2 - Distco Company Data Set.xlsx file. present facility. Because data kco Company Data SefExplanation / Answer
Please use excel to solve this question! Thank You!
Year Quarter Period Inventory (1000s) 2006 Q1 1 156 Q2 2 114 Q3 3 166 Q4 4 175 2007 Q1 5 169 Q2 6 137 Q3 7 175 Q4 8 191 2008 Q1 9 185 Q2 10 160 Q3 11 192 Q4 12 209 2009 Q1 13 203 Q2 14 172 Q3 15 214 Q4 16 228 2010 Q1 17 219 Q2 18 197 Q3 19 251 2011 Q4 20 264 Q1 21 239 Q2 22 217 Q3 23 271 Q4 24 284 DistCo, a large warehouse service company in the San Francisco Bay Area, stores pharmaceutical products for customers while they are in transit to local retailers. DistCo can store a maximum of 294,000 cases of products at its present facility. Because their business has been growing, the company's management wonders if they should acquire other warehouses in 2012. The materials manager has accumulated the inventory data presented in the MGMT3100 Case 2 - Distco Company Data Set.xlsx file. present facility. Because data kco Company Data Sef