Solved

An Office Supply Company Is Attempting to Determine the Order

Question 48

Essay

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?
 A  B 123 Annual Demand: 45 Cost per Unit: 6 Ordering Cost: 7 Carying Cost: 89 Order Quantity: 1011 Total Cost: \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:

verifed

Verified

None...

View Answer

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

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents