Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started