An Office Supply Store Wants to Simulate Its Inventory System

question 59

Essay

An office supply store wants to simulate its inventory system for notebooks. The company has collected data on the shipping time and daily demand for notebooks. Each notebook generates a $2 profit. Customers can buy notebooks at any office supply store so there are no backorders (the company loses the sale and profit). The company orders 200 notebooks whenever the inventory position falls below the reorder point of 100 notebooks. Orders are placed at the beginning of the day and delivered at the beginning of the day so the notebooks are available on the arrival day. The average daily demand is 23.5 notebooks. An average service level of 99% is desired. There are currently 25 notebooks on hand and no orders are pending. The following spreadsheets have been developed for this problem. The company has simulated 1 month of operation for its inventory system. (HINT: This covers Rows 8 to 37 of the spreadsheet.) What formulas go in cells A1:J37 of the "Model" worksheet for this simulation?

---

Definitions:

Interest Revenue

The income earned from lending money or investing in interest-bearing assets.

Income Statements

Financial statements that show a company's revenue, expenses, and profit over a specific period.

Notes Receivables

Financial assets representing amounts owed to a company, evidenced by a written promise to pay the specified amount of money at a certain date.

Interest Revenue

Interest Revenue refers to the income earned by an entity from its lending activities or investments in interest-bearing assets.