Holding Cost and Ordering Cost Calculation by ygr89581

VIEWS: 79 PAGES: 2

More Info
									                                                Sheet1


        A             B          C         D     E         F        G           H
 1   EOQ1.XLS
 2
 3
 4   Basic Economic Order Quantity Worksheet
 5
 6
 7   MODEL PARAMETERS:
 8
 9   Constant Annual Demand           D           1200
10   Fixed Ordering Cost              K             $5
11   Holding Cost                     H          $1.20
12
13   Decision Variable:               Q              100        For What-If Analysis
14                                                              and Solver
15
16
                                                               =E10*E9/E13
17   Annual Ordering Costs:           To        $60.00
18   Inventory Carrying Costs:        Th        $60.00
19                                                             =E11*E13/2
20   TOTAL COST:                      Tc       $120.00
21
22
23   Direct Calculation of the EOQ:   EOQ            100
24
                                                           =SQRT(2*E10*E9/E11)
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51   File: EOQ1.XLS


                                                Page 1
                                                     Sheet1


        A         B           C           D           E         F      G   H
52 Simple EOQ Model
53 Appendix - Chapter 5
54
55 Figure 5-A.1 Small Deterministic DSS Spreadsheet Inventory Model.




                                                     Page 2

								
To top