Question: Use Excel to fill in the table in the EOQ sheet in 1524Lab5data.xlsx, given the following: annual demand(D) 16000 fixed cost per order(S) = $70


Use Excel to fill in the table in the EOQ sheet in 1524Lab5data.xlsx, given the following: annual demand(D) 16000 fixed cost per order(S) = $70 annual holding cost per unit(H) = $5.00 number of units per order(Q) =values from 500 to 1250 in increments of 50 If you begin entering the data with cell A2, which of the following are correct? I. B9 = $1,317.65 II. C13= $7,875.00 III. D13 = $2,461.11 o a All are correct ob) Only I and II are correct Only I and III are correct od) Only III is correct Only II is correct od) Only III is correct Only II is correct Only II and III are correct Only I is correct oh) None are correct Use Excel to fill in the table in the EOQ sheet in 1524Lab5data.xlsx, given the following: annual demand(D) 16000 fixed cost per order(S) = $70 annual holding cost per unit(H) = $5.00 number of units per order(Q) =values from 500 to 1250 in increments of 50 If you begin entering the data with cell A2, which of the following are correct? I. B9 = $1,317.65 II. C13= $7,875.00 III. D13 = $2,461.11 o a All are correct ob) Only I and II are correct Only I and III are correct od) Only III is correct Only II is correct od) Only III is correct Only II is correct Only II and III are correct Only I is correct oh) None are correct
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
