An Office Supply Company Is Attempting to Determine the Order

An office supply company is attempting to determine the order quantity for Mt.White fountain pens which are sold to local executives.Annual demand is 5,000 units and each pen costs the store $50.It costs $75 to place an order and the inventory carrying cost rate is 30% of the value of the item.
What values should go in cells B3:B11 of the spreadsheet for this problem if Q = 223.61?
$$\begin{array} { | c | c | c | } \hline & \text { A } & \text { B } \\\hline 1 & & \\\hline 2 & & \\\hline 3 & \text { Annual Demand: } & \\\hline 4 & & \\\hline 5 & \text { Cost per Unit: } & \\\hline 6 & \text { Ordering Cost: } & \\\hline 7 & \text { Carying Cost: } & \\\hline \mathbf { 8 } & & \\\hline 9 & \text { Order Quantity: } & \\\hline 10 & & \\\hline 11 & \text { Total Cost: } & \\\hline\end{array}$$

Correct Answer:

Verified

None...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

View Full Answer For Free