The provided spreadsheet has the required amount of materials to make one pair of each type of footwear. Using 21 working days (unless YOU want to work weekends), determine the average daily demand based on the provided demand plan and account for five days of lead time demand and two days of safety stock what is your Reorder point for each material? Then, based on required quantity per pair and the supplied cross-product use of materials, determine how much of each material should be purchased in each month. Hint: start in December and assume you start with zero-quantity of each material. Your goal is only to meet demand do not worry about having extra at the end of

Frridlay Foontweaur Co. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{11}{|c|}{ DAILY DEMAND (Component Goods) - Leather } \\ \hline Product Line & 1/1/22 & 2/1/22 & 3/1/22 & 4/1/22 & 5/1/22 & 6/1/22 & AVERAGE & & & \\ \hline Cowboy Boots & & & & & & & \#DIV/0! & & & \\ \hline Sneakers & & & & & & & \#DIV/0! & & & \\ \hline Sandals & & & & & & & \#DIV/0! & Lead Time Stock (5 days) & Safety Stock (2 days) & ReOrder Point (7 days of Demand) \\ \hline & r & & T & T & T & T & \#DIV/0! & & & 0 \\ \hline DAILY DEMAND (Compo & Goods) - Rubber & & & & & & & & & \\ \hline Product Line & 1/1/22 & 2/1/22 & 3/1/22 & 4/1/22 & 5/1/22 & 6/1/22 & AVERAGE & & & \\ \hline Cowboy Boots & & & & & & & \#DIV/01 & & & \\ \hline Sneakers & & & & & & & \#DIV/0! & & & \\ \hline Sandals & & & & & & & \#DIV/0! & Lead Time Stock (5 days) & Safety Stock (2 days) & ReOrder Point (7 days of Demand) \\ \hline & r & & 1 & & T & T & \#DIV/0! & & & 0 \\ \hline & & & & & & & & & & \\ \hline DAIIY DEMAND (Compo & Goods) - Cork & & & & & & & & & \\ \hline Product Line & 1/1/22 & 2/1/22 & 3/1/22 & 4/1/22 & 5/1/22 & 6/1/22 & 2 AVERAGE & & & \\ \hline Cowboy Boots & & & & & & & \#DIV/0! & & & \\ \hline Sneakers & & & & & & & \#DIV/0! & & & \\ \hline Sandals & & & & & & & \#DIV/0! & Lead Time Stock (5 days) & Safety Stock (2 days) & ReOrder Point (7 days of Demand) \\ \hline & r & & 1 & & 1 & & \#DIV/0! & & & 0 \\ \hline DAILY DEMAND (Compo & Goods) - Thread & & & & & & & & & \\ \hline Product Line & 1/1/22 & 2/1/22 & 3/1/22 & 4/1/22 & 5/1/22 & 6/1/22 & 2 AVERAGE & & & \\ \hline Cowboy Boots & & & & & & & \#DIV/0! & & & \\ \hline Sneakers & & & & & & & \#DIV/0! & & & \\ \hline Sandals & & & & & & & \#DIV/0! & Lead Time Stock (5 days) & Safety Stock (2 days) & ReOrder Point (7 days of Demand) \\ \hline & 1 & & 7 & & & & \#DIV/0! & & & 0 \\ \hline & & & & & & & & & & \\ \hline & & & & & & & & & & \\ \hline & & & & & & & & & & \\ \hline Purchases per Month & 1/1/22 & 2/1/22 & 3/1/22 & 4/1/22 & 5/1/22 & 6/1/22 & & & & \\ \hline Leather & . & . & . & . & . & . & & & & \\ \hline Rubber & . & . & . & . & . & . & & & & \\ \hline Cork & - & . & . & & - & - & & & & \\ \hline Thread & . & & & - & & - & & & & \\ \hline \end{tabular}