Use the 50-day Hypothetical Demand Data (in the table below) and the other Hypothetical data included here: Hypothetical Data:

• Assume 365 days per year.
• Use the Hypothetical Demand Data below, not the actual demand data in the simulation.
• Assume that management considers physical cost of holding inventory negligible compared to the financial costs.
• Assume that Littlefield earns 9 percent interest on all cash balances (annual interest rate, compounded daily), so cash spent on materials purchases represents a financial opportunity cost.
• Assume that material costs are $11 per kit.
• Assume that Littlefield incurs $800 in fixed administrative costs each time an order is placed.
• Assume a supplier lead time of 5 days.
• Assume a service level of 85%.
• Use the normsinv function in Excel to get the correct z-value.
• Use the stdev.s function in Excel for the standard deviation calculation.
• Make sure your answers are in kits. For this hypothetical exercise, assume that one batch consists of 55 kits and that one order requires 55 kits.

What is the correct economic order quantity (EOQ) in kits? (Display your answer to the nearest whole number.) EOQ = kits What is the correct reorder point (ROP) in kits? (Display your answer to the nearest whole number.) ROP = kits

Day	Hypothetical Demand (# of Orders)
1	4
2	13
3	20
4	10
5	20
6	13
7	17
8	20
9	13
10	17
11	10
12	2
13	17
14	13
15	8
16	4
17	6
18	12
19	14
20	11
21	14
22	7
23	13
24	6
25	17
26	12
27	11
28	9
29	9
30	11
31	21
32	11
33	6
34	12
35	6
36	13
37	8
38	13
39	7
40	13
41	16
42	13
43	10
44	12
45	8
46	19
47	13
48	12
49	20
50	17