Please uploaded your solution to Blackboard either as a word document, pdf or a picture. Below are the Excel tables we would use to answer this question. The Easy Time Grocery chain operates in major metropolitan areas on the East Coast. The stores have a "no-frills" approach, with low overhead and high volume. They generally buy their stock in volume at low prices. However, in some cases they actually buy stock at stores in other areas and ship it in. They can do this because of high prices in the cities they operate in compared with costs in other locations. One example is baby food. Easy Time purchases baby food at stores in Albany, Binghamton, Claremont, Dover, and Edison and then trucks it to six stores in and around New York City. The stores in the outlying areas know what Easy Time is up to, so they limit the number of cases of baby food Easy Time can purchase. 4. Using this Sensitivity Analysis, what is profit? 5. Suppose Easy Time can purchase all the baby food it needs from a New York City distributor at a price that will result in a profit of $9 per case at stores 1,3 , and 4;$8 per case at stores 2 and 6 ; and $7 per case at store 5. Should Easy Time purchase all or none, of its baby food from the distributor rather than purchase it at other stores and truck it in? Explain. 6. If Easy Time could arrange to purchase more baby food from one of the outlying locations, which should it be, how many additional cases could be purchased, and how much would this increase profit? Please uploaded your solution to Blackboard either as a word document, pdf or a picture. Below are the Excel tables we would use to answer this question. The Easy Time Grocery chain operates in major metropolitan areas on the East Coast. The stores have a "no-frills" approach, with low overhead and high volume. They generally buy their stock in volume at low prices. However, in some cases they actually buy stock at stores in other areas and ship it in. They can do this because of high prices in the cities they operate in compared with costs in other locations. One example is baby food. Easy Time purchases baby food at stores in Albany, Binghamton, Claremont, Dover, and Edison and then trucks it to six stores in and around New York City. The stores in the outlying areas know what Easy Time is up to, so they limit the number of cases of baby food Easy Time can purchase. 4. Using this Sensitivity Analysis, what is profit? 5. Suppose Easy Time can purchase all the baby food it needs from a New York City distributor at a price that will result in a profit of $9 per case at stores 1,3 , and 4;$8 per case at stores 2 and 6 ; and $7 per case at store 5. Should Easy Time purchase all or none, of its baby food from the distributor rather than purchase it at other stores and truck it in? Explain. 6. If Easy Time could arrange to purchase more baby food from one of the outlying locations, which should it be, how many additional cases could be purchased, and how much would this increase profit
