Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please fill out the empty tables of eoq, and order

Please fill out the empty tables of eoq, and order quality. I want to learn...

90.2K

Verified Solution

Question

Accounting

image

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
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students