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
Q = EOQ = ?2DC0 = 677.0032 = 677
OPTIMUM NUMBER OF ORDERS
N = D 15000 =22.15657 = 22
We provide our clients with 100% unique papers or assignments. This proves how much we value you
We guarantee quality services. Confidentiality of your information is our first priority.
We handle your work according to instructions you have provided. If you feel we did not meet your requirements, ask for revision. We also guarantee your money back if we do not follow your instructions per sayRead more
We have no tolerance to plagiarism. Our experts double check your work to ensure its free of palgiarism. If any case of copied work is identified, we handle it with utmost severityRead more
We are happy for trusting us with your assignment. Collegessaysonline offers you unlimited number of revisions as an act of courtesy. We want you to succeed in your future endeavors.Read more
Our Company is committed to protect your privacy. We do not compromise your privacy by using your personal details for our own gain. As an act of courtesy, we assure you complete anonymityRead more
By outsourcing our services, you agree to trust us with your work. We will do all it takes to meet your instructions. We ask for your coperation to help us reach our goals.Read more