ChatGPT

Lab $5--$Economic Order C

Take Quiz $14$

Math Emporium Assessm

ssessment.emporium.vt$.$edu:$8443/$assessment$/$wicket$/$page$?12-1.$IFormSubmitListener$-$itemPanel$-$itemForm

MATH $1524$ L$5.$S$4[140348191]$

Use Excel to create a connected scatter plot of Total Annual Ordering Costs, Total Annual Holding Costs and Total Cost using the following:

annual demand $(D)=10000$

fixed cost per order$(S)=$$$50$

annual holding cost per unit $(H)=$$$4\mathrm{.}50$

number of units per order $(Q)=$ values from $200$ to $600$ in increments of $50$

Which of the following correctly plots the three graphs over the given $Q$ values?

a$)$

Total Annual Ordering Costs

Total Annual Holding Costs

Total Cost

b$)$