Can you help me solve this on excel: Gomak Inc. is a private company owned by Nicolas Gauthier. It operates as a distributor of specialty condiments such as pickles, spices, and seasonings. It currently imports from three countries and distributes $28$ products in North America, all in specialized gourmet stores. Gomak Inc. One of its prime products, representing $10\%$ of its sales $($$$431,250),$ is a type of artisanal salt called Fleur de Sel de Guerande salt made from the marshes in France.

The annual demand for Guerande salt sold by Gomak Inc. in North America is stable at $1,500$ cases, each containing $50$ jars. Gomak Inc. purchases this product three times a year from a food cooperative in Guarende, France. The salt cases arrive two weeks after placing an order. As the exclusive distributor, Gomak Inc. always received good quality products with reliable transportation between France and Canada. The time it takes to receive an order is$,$ therefore, relatively stable. Ordering directly from the producer, Gomak Inc. is always able to receive the quantity ordered in a single shipment.

Gomak Inc. employs one employee, Mrs$.$ Menard, who is responsible for all administrative tasks, including ordering, invoicing, and bookkeeping. Mrs$.$ Menard's annual salary is $$40,000.$ According to Mrs$.$ Menard, $30\%$ of her time is spent on ordering activities, where $10\%$ of the total orders are for Guerande salt. The owner identifies that the only variable holding cost, depending on the inventory levels, is the insurance cost of $$20,000,$ which can be considered as the total annual holding cost for Gomak Inc for its entire inventory. Recall that Guerande salt represents $10\%$ of its sales.

Currently, the company orders $3$ times a year. Mr$.$ Gauthier would like to refine his decision$-$making process by using operations management tools that will help him and his company to be more successful and grow. He has contacted the Robins School of Business' bright and brilliant students to evaluate whether they can help calculate a better ordering policy for his company. To help this company out, you have the following questions to answer.

What is Gomak Inc.$$s total inventory cost with its current ordering policy? Hint: Please calculate the ordering and holding cost according to the information above.

Is Gomak Inc.$$s ordering policy optimal according to the Economic Order Quantity model? If not, propose a new ordering policy through the EOQ model by calculating the optimal order quantity, reorder point, and total inventory cost. Please assume that Gomak Inc. works for $250$ days a year.

Should the company employ the new ordering policy you found in part b$?$ Why or why not? Justify your answer.

Critical thinking. Do you think that this question is a suitable application of the EOQ model? Why$/$Why not?