An Office Supply Company Is Attempting to Determine the Order

question 82

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?

---

Definitions:

Personnel Expenses

Costs associated with employing staff, including wages, benefits, and taxes.

Client-visits

Meetings or engagements with clients outside the company's premises for business discussions or services.

Activity Variance

The variance between the projected budget for a task and the actual expenses incurred.

Budgeting

The process of creating a plan to spend your money by estimating the revenue and expenses for a future period, used as a financial guide.