[SOLVED] Data-Driven Retail Decisions

Data-Driven Retail Decisions
Homework 2 Due February 7, 2022
1. B&H needs to decide how to manage its inventory of cameras. The demand for cameras at B&H is 200 cameras per week. Each time that B&H places an order for a new shipment of cameras, it must pay $80 in fixed processing fees. A camera costs B&H $60 to purchase. The cost for B&H to hold a camera in its store for one week is $4. Assume that the lead time for the delivery of a camera is 0 weeks.
a. Suppose that B&H places orders for cameras in quantities of 50 cameras at a time and places a new order for cameras each time that it runs out. Draw a graph showing the number of cameras that B&H has on-hand in inventory at each point in time up until the time when it places its fourth order. Label the points in time at which B&H places a new order. Assume that B&H places its first order for 50 cameras on day 0.

Copyright By Assignmentchef assignmentchef

b. Suppose again that B&H places orders for 50 cameras at a time. What will be B&Hs av- erage holding costs per week? What will be B&Hs average fixed ordering costs per week?
c. What is the optimal number of cameras for B&H to order each time that it places an or- der? Assuming that B&H orders according to its optimal ordering quantity (EOQ), what will be B&Hs average fixed ordering costs over the course of a week? What will be B&Hs average holding costs over the course of a week?
d. Suppose now that the lead time for the delivery of a shipment of cameras increases to 0.2 week. Assuming that B&H orders according to its optimal order quantity from part c above, what should be B&Hs reorder point for a shipment of cameras?
e. Suppose that the lead time for the delivery of cameras is still 0.2 week. However, rather than placing an order when B&Hs inventory of cameras reaches its reorder point calculated in part d above, B&H decides to place a new order for cameras whenever it has 60 cameras in inventory. How much additional holding costs (over the EOQ holding costs) will B&H incur as a result of this ordering policy? (Suppose that B&H orders according to the EOQ level each time that it places an order.)
f. [Extra Credit] Suppose now that the lead time for the delivery of a shipment of cameras in- creases to 0.5 week. Assuming that B&H orders according to its optimal order quantity from part c above, what should be B&Hs reorder point for a shipment of cameras? Explain carefully your answer.

2. Every evening, Empire News needs to determine how many copies of the newspaper to purchase for the following morning. A newspaper costs $0.50 to purchase and sells for $2.25. Any unsold newspapers can be recycled at the end of the day at a value of $0.25 per newspaper. The following table provides Empire News daily demand distribution for newspapers.
Number of newspapers 160 170 175 185 200 205 210 220 Probability 0.2 0.1 0.05 0.2 0.15 0.05 0.20 0.05
a. Suppose that Empire News is considering the purchase of 200 newspapers. What is the marginal value from a 201st newspaper? Is it profitable for Empire News to purchase its 201st newspaper? Justify your answer.
b. What is the optimal number of newspapers for Empire News to purchase each evening?
3. A pastry shop is considering how much hot chocolate to prepare each morning. Hot choco- late costs $0.10 per oz to make and sells for $0.40 per oz. Customers can buy hot chocolate in any number of ounces that they wish. Any hot chocolate not sold by the end of the day is discarded. The daily demand for hot chocolate is normally distributed with a mean of 1,200 oz and a standard deviation of 150 oz. How much hot chocolate should the pastry shop make each morning? You may use a z-table for this question.

CS: assignmentchef QQ: 1823890830 Email: [email protected]