60.1K
Verified Solution
Link Copied!
Please fill out the empty tables of eoq, and order quality. I want to learn how to find that in excel.
Q4) Below is a quantity discount schedule for an item with an annual demand of 10,000 units that a company orders regularly at an ordering cost of $4. The annual holding cost is 2% of the purchase price per year. a) Determine the optimal order quantity. PD TC=QDS+2QIP+PD QDS Q=IP2DS 2QIP \begin{tabular}{|c|c|} \hline Ordering Cost/order & 4 \\ \hline Demand/year & 10,000 \\ \hline I & 2.00% \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \multicolumn{1}{c|}{} & \multicolumn{1}{c|}{} & \multicolumn{3}{|c|}{ Annual Cost } \\ \cline { 2 - 8 } & Quantity Purchased & Unit Price & EOQ & Order Quantity & Product & Ordering & Holding & Total Cost \\ \hline 1 & 02499 & 1.20 & & & & & & \\ \hline 2 & 25003999 & 1.00 & & & & & & \\ \hline 3 & 4000+ & 0.98 & & & & & & \\ \hline & & & & & & & \\ \hline \end{tabular}
Answer & Explanation
Solved by verified expert
