An Office Supply Company Is Attempting to Determine the Order

question 68

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?
$$\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}$$

---

Definitions:

Sociopetal Arrangements

Spatial configurations designed to encourage social interaction, typically in architectural and urban design.

Sociofugal Arrangements

Spatial or social arrangements that encourage individuals to keep apart or deter social interaction.

Social Support

The perception and reality that one is cared for, has assistance available from other people, and is part of a supportive social network.

Social Design

The application of design principles to social problems, with the goal of creating more equitable, sustainable, and thriving communities.