Fair Share Method $-$ Please Show in Excel!

Chattem industries manufactures and distributes Allegra D $($allergy relief medication$)$ products from the plant warehouse in Chattanooga, TN$,$ to the Southeast. The plant's warehouse currently has $315,600$ units of the product retains $45,000$ units $($truck load$)$ of the products at the warehouse as a buffer $($safety stock$).$ The Floridad DC currently has$22,000$ units in stock and a daily demand or $7,500$ units. The Georgia DC has $15,000$ units in stock and daily demand of $3,700,$ while the South

Carolina DC has $7,000$ units and a daily demand of $1,200$ units. Last, the Tennessee DC keeps $9,500$ units in stock with a daily demand of $2,100$units, and the Alabama DC has $6,040$ units in stock with a daily demand of $800$ units.

a$.$ What type of situation$/$problem is described here? Why is this situation a problem for the DCs or Chattem?

b$.$ What tools, approaches, and$/$or strategies, including the Fair$-$share method, can you use to assign inventory to your customers$/$retailer$?$

c$.$ Determine the Common Day's Supply$/$Inventory of Allegra D$.$

d$.$ Given the information and your answer to part $($c$),$ use the Fair$-$Share$-$allocation logic to determine$/$calculate the number of Allegre D to be allocated to each DC$.$ Show all your calculations in sequence and order.

d$.$ Assess your results. Include the implications and pros$/$cons of assigning inventory using this method.