Inventory Decision Model
Not what you're looking for?
THe annual demand is estimated to be 15,000 units and is assumed to be constant throughout the year. Each unit costs $80. THe company's accounting department estimates that hits opportunity cost for holding this item in stock for one year is 18% of the unit value. Each order placed with the supplier costs $220. THe company's policy is to place a fixed order for Q units whenever the inventory level reaches a predetermined reorder point that provides sufficient stock to meet demand until the suppliers order can be shipped and received. Develop a decision model.
1. Define the data, uncontrollable inputs, and decision variables that influence total inventory control.
2. Develop mathematical functions that compute the annual ordering cost and annual holding cost based on average inventory held throughout the year in order to arrive at a model for total cost.
3, Implement model on spreadsheet.
What I have so far...
DEMAND RATE (D) = 15,000
COST (C) = $80
INVENTORY CARRYING RATE (I) = 18% PER YEAR
INVENTORY CARRYING COST (Ch) = 1*C = .18*80 = $14.40 PER YEAR
ORDER COST C0 = $220
EOQ =
Q = EOQ = ?2DC0 = 677.0032 = 677
Ch
OPTIMUM NUMBER OF ORDERS
N = D 15000 =22.15657 = 22
Q 677
Purchase this Solution
Solution Summary
Inventory decision models are examined.
Solution Preview
See the attached file. Thanks
Inventory Decision Model - Fixed Quantity Model
Data Uncontrollable Inputs
Annual Demand (D) 15000 Annual Demand D
Cost (C) $80 Cost C
Inventory Holding Rate ...
Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Operations Management
This quiz tests a student's knowledge about Operations Management
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.