Solve the following Questions USING EXCEL:

8. Given the weekly demand data below, illustrate the operation of a fixed-order-quantity

inventory system with a reorder point of 75, an order quantity of 100, and a beginning inventory

of 80. Lead time is one week. All orders are placed at the end of the week and backordering is

not allowed. Using Equation 12.1, what is the average end-of-week inventory on hand and the

number of stockouts?

Week	1	2	3	4	5	6	7	8	9	10	11	12
Demand	25	30	20	40	40	25	50	35	30	40	20	25

Hint: You may use the following template to solve the question:

Week	Beginning Inventory	Quanity On-Order	Demand	Ending Inventory	Inventory Position	Order? (yes/No)
1			25
2			30
3			20
4			40
5			40
6			25
7			50
8			35
9			30
10			40
11			20
12			25