I need you to create a mathematical model for multiple products. This model should be designed based on fill rate or Type $1$ service level. The model must include the following components:

Demand Forecasting: Appropriate methods should be used to predict future demand.

Economic Order Quantity $($EOQ$)$: A formula to optimize the order quantity for each product must be included.

Safety Stock: The stock level required to maintain a specific service level should be calculated.

Reorder Point: A formula to determine the stock level at which orders should be placed, based on demand and lead time, must be included.

The data I have includes the following fields:

STOCK NO: A unique identifier for each stock item.

SPEND AMOUNT: The spending amount for each stock item.

UNIT PRICE: The unit price of the stock items.

Cumulative Spend: The cumulative spending $($can be used as a basis for ABC analysis$).$

Critical Stock: The critical stock level for each product.

The model should be detailed and comprehensive, aligning with the requirements of an Industrial Engineering course. It is expected to be capable of performing analyses, deriving insights, and making optimized inventory management decisions based on the provided data. G$8$ A$38$

$\backslash (\backslash$square $\backslash )$

$1047$

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline & A & B & C & D & E $\backslash \backslash$

$\backslash$hline $38$ & $1047$ & $395$ & $236,37$ & $15327$ & $51\backslash \backslash$

$\backslash$hline $39$ & $1796$ & $395$ & $218,32$ & $15722$ & $34\backslash \backslash$

$\backslash$hline $40$ & $626$ & $395$ & $131,02$ & $16117$ & $11\backslash \backslash$

$\backslash$hline $41$ & $2189$ & $395$ & $110,72$ & $16512$ & $13\backslash \backslash$

$\backslash$hline $42$ & $2085$ & $395$ & $55,97$ & $16907$ & $77\backslash \backslash$

$\backslash$hline $43$ & $712$ & $394$ & $389,29$ & $17301$ & $52\backslash \backslash$

$\backslash$hline $44$ & $1447$ & $394$ & $340,97$ & $17695$ & $4\backslash \backslash$

$\backslash$hline $45$ & $299$ & $394$ & $328,46$ & $18089$ & $75\backslash \backslash$

$\backslash$hline $46$ & $925$ & $394$ & $315,77$ & $18483$ & $95\backslash \backslash$

$\backslash$hline $47$ & $277$ & $394$ & $295,48$ & $18877$ & $54\backslash \backslash$

$\backslash$hline $48$ & $2016$ & $394$ & $289,98$ & $19271$ & $92\backslash \backslash$

$\backslash$hline $49$ & $164$ & $394$ & $238,97$ & $19665$ & $93\backslash \backslash$

$\backslash$hline $50$ & $2844$ & $394$ & $227,45$ & $20059$ & $63\backslash \backslash$

$\backslash$hline $51$ & $1567$ & $394$ & $226,78$ & $20453$ & $50\backslash \backslash$

$\backslash$hline $52$ & $2717$ & $394$ & $108,96$ & $20847$ & $83\backslash \backslash$

$\backslash$hline $53$ & $1133$ & $393$ & $313,58$ & $21240$ & $89\backslash \backslash$

$\backslash$hline $54$ & $602$ & $393$ & $307,23$ & $21633$ & $46\backslash \backslash$

$\backslash$hline $55$ & $2225$ & $393$ & $303,58$ & $22026$ & $21\backslash \backslash$

$\backslash$hline $56$ & $2535$ & $393$ & $301,20$ & $22419$ & $7\backslash \backslash$

$\backslash$hline $57$ & $2004$ & $393$ & $134,79$ & $22812$ & $70\backslash \backslash$

$\backslash$hline $58$ & $1866$ & $393$ & $120,46$ & $23205$ & $58\backslash \backslash$

$\backslash$hline $59$ & $1704$ & $393$ & $72,10$ & $23598$ & $31\backslash \backslash$

$\backslash$hline $60$ & $2261$ & $392$ & $326,89$ & $23990$ & $8\backslash \backslash$

$\backslash$hline $61$ & $1351$ & $392$ & $246,55$ & $24382$ & $71\backslash \backslash$

$\backslash$hline $62$ & $1549$ & $392$ & $218,50$ & $24774$ & $46\backslash \backslash$

$\backslash$hline $63$ & $2019$ & $392$ & $105,76$ & $25166$ & $51\backslash \backslash$

$\backslash$hline $64$ & $2279$ & $391$ & $383,18$ & $25557$ & $78\backslash \backslash$

$\backslash$hline $65$ & $2499$ & $391$ & $369,00$ & $25948$ & $99\backslash \backslash$

$\backslash$hline $66$ & $1190$ & $391$ & $120,08$ & $26339$ & $100\backslash \backslash$

$\backslash$hline $67$ & $1283$ & $391$ & $97,11$ & $26730$ & $4\backslash \backslash$

$\backslash$hline $68$ & $1216$ & $391$ & $80,95$ & $27121$ & $23\backslash \backslash$

$\backslash$hline $69$ & $757$ & $391$ & $11,54$ & $27512$ & $88\backslash \backslash$

$\backslash$hline $70$ & $2595$ & $390$ & $354,00$ & $27902$ & $61\backslash \backslash$

$\backslash$hline $71$ & $524$ & $390$ & $257,21$ & $28292$ & $100\backslash \backslash$

$\backslash$hline $72$ & $2213$ & $390$ & $224,42$ & $28682$ & $46\backslash \backslash$

$\backslash$hline $73$ & $1882$ & $390$ & $127,18$ & $29072$ & $85\backslash \backslash$

$\backslash$hline $74$ & $1274$ & $390$ & $100,76$ & $29462$ & $82\backslash \backslash$

$\backslash$hline $75$ & $1936$ & $390$ & $\backslash (\backslash$mathbf$\{3,54\}\backslash )$ & $29852$ & $50\backslash \backslash$

$\backslash$hline $76$ & $2587$ & $389$ & $357,59$ & $30241$ & $9\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Sayfa$1$

Sayfa$2$

$\backslash (+\backslash )$