PLEASE RE ANSWER THIS QUESTION THE CALCULATIONS DO NOT $=$ THE ANWSERS Please ensure submission of this assignment in hard copy by Monday, the $27$th$,$ at

the beginning of class, ensuring that it's written clearly and legibly. All calculations

must be explicitly displayed within the solutions; the use of Excel tables is not

permissible. Failure to include all calculations and their sources will result in a

$50\%$ deduction from the problem's value. Avoid presuming the professor's

familiarity with the subject matter; professionally present your assignment in a

clear and organized manner.

Trelex AA is actively developing a weight loss food supplement named

Proctologist, with promising results. With plans to launch in Mexico, where $43\%$

of the population grapples with uncontrolled obesity, the company faces a

packaging challenge due to transportation constraints. Identifying $5$ suppliers with

varying pricing options, Table $1$ illustrates the price breakdown. The U$.$S$.$ demand

is $250$ units weekly, and Mexican demand is anticipated to be $12\mathrm{.}5\%$ lower in the

first year. Trelex AA's ordering cost is $$275,$ with an estimated $32\%$ annual holding

cost$.$ The base unit price is $$6\mathrm{.}45,$ and exceeding storage capacity $(875)$ incurs $50\%$

of the purchasing price paid. Considering total costs and constraints presented,

determine the best supplier. To make a judicious decision, we need further

information on the inventory policy $($Number of orders, average inventory and

days to be supplied for the best option. The options for each supplier is presented

in Table $1.$