$($PLEASE SHOW EXCEL DATA$)$

A manufacturing organization uses a part that it produces in$-$house. The cost of

production for this part is $$500$ per unit and the annual demand is $2000$ units. The cost of

setting up the production process is $$5000$ for each set up$.$ The holding cost of the item is

$25\%$ per unit per year. Based on this information, compute the optimal quantity of the

part that should be made in each production run. Provide complete details of the total

annual cost of this part.