Economic Oder Quantity


1) R & B Beverage offers a drink product with a near-constant demand of 3600 cases annually. It cost $20 to place each order, and the cost of each storing one case is $0.75 per year.
(a)Construct a graph of order cost, storage cost, and total cost (for order quantities up to 600 cases).

Graph of Cost Versus Quantity


(b)Estimate from your graph the economic order quantity (EOQ).

From the graph, EOQ is 600 cases. This is obtained where the curve of the storage cost meets the curve of the order cost.

(2) The annual demand for a product is 1500 units. Each unit costs $2.50. An order costs $20 to set up, and the annual stock holding cost is $0.50 per unit per year.

(a)Determine the economic order quantity. 

Q=(2DS/H)1/2

((2 X 1500 units X $20)/$0.50)1/2=346.4 units 

(b)What is the total cost of the optimum policy? 

TC=PD + K(D/EOQ) + h(EOQ/2)

(1500X$2.50+$20(1500/346.4)+$0.50(346.4/2) =$3,923.21

(3) The annual demand for a manufacturing component is 5000 units. The component costs $22 per unit.  Order costs are $80 per order, and the stockholding cost is $5 per component.  The manufacturing plant operates 300 days per year.  Assume that stock replenishment is instantaneous.

(a) If the company’s current inventory strategy is to order 250 components per order, determine the time between orders and the number of orders placed per year. 

Number of orders=5000 units/250) = 20 orders 

The time between orders=300 days per year/20 orders = 15 days

(b) Assume an optimal EOQ is 400 components per order.  Calculate the total cost under the current strategy and an EOQ strategy.  What would be the cost savings if the company switched to an EOQ order strategy?

TC= (5000units X $22) +$80(5000units/400) +$5(400/2) =$102,000(Current strategy)
TC= (5000units X $22) +$80(5000units/250) +$5(250/2) =$102225(EOQ strategy)

Cost saving= ($102225-$102,000) = $225 

(4) R&B Beverage offers a drink product with near constant demand of 3600 cases annually.  It costs $20 to place each order and the cost of storing one case is $0.75 per year.  

a.  Determine the EOQ for R&B Beverage using Excel Solver
D
S
H

3600
$20
$0.75










Q=
438.178

b.  If order costs increase by 10%, what is the impact on EOQ and total cost?

10% increase in order cost would lead to increase EOQ and eventually, total cost.
















Comments

Post a Comment

Popular posts from this blog

How to write a Forensic Case Study: Murder of Junko Furuta

Image
Photo of Junko Furuta  For one to score high marks in a Forensic Case Study, one must  adhere to the following: Background of the case: This section contains details about the crime. It includes; the reasons for committing the offense, the conditions which the crime was committed, the circumstances of the crime scene and clear identification of the suspect(s) and the victim(s). One should ensure that the information in this part gives a precise idea of what the case is all about.   Pick and Write an article on Iwriter Website Evidence: This encompasses the piece of evidence found at the crime scene. The evidence should be described in details, that is, ways in which the evidence was collected, processed and preserved.   Forensic Tests: The tests should be two or more that were used to analyze the evidence. The science or theory of instrumentation used must be described fully.   Results: This consists of a detailed explanation of the forensic tests and the data inter
Read more

Roles of Sodium Carbonate when Extracting Caffeine from Tea Leaves

Image
A student failed to add sodium carbonate (Na 2 CO 3 ) when extracting caffeine from tea leaves with hot water. Though, high yield of caffeine was produced. The crystals melted at temperatures between 202  and 214 degree  Celsius. Explain. This happened because sodium carbonate did not interfere with the caffeine content of the tea leaves. Sodium carbonate (which is a base) deprotonates the phenolic hydroxyl group (-OH) (acidic) of tannins rendering them anionic. Hence, making them highly soluble in water, but parsimoniously soluble in methylene chloride. So, if sodium carbonate is not added when extracting caffeine with hot water, the extracted caffeine would also contain tannins. Additionally, sodium carbonate is added during the extraction to keep caffeine (an alkaloid which is an organic base)  in a free base form. It prevents caffeine from reacting with available acid available, which may lead to the formation cation. It reacts with a phenolic hydroxyl group
Read more

What is Hartmann Dispersion Formula?

Image
  Hartmann dispersion formula is a semi-empirical formula. It is also referred to as Cornu Hartmann formula. It relates refractive index (n) with the wavelength (λ). It is given by:  n (λ)= X + Y/( λ-Z)............................................................Equation 1  X, Y, and Z are empirical constants while n (λ) is the refractive index of a material of light of wavelength λ. The constants derived as follows: Z= [(n 1 -n 2 )/ (n 2 -n 3 ) λ 1 (λ 2 - λ 3 ) - λ 3 - λ 3 (λ 1 - λ 2 )]/ [(n1-n2)/ (n2-n3) (λ2- λ 3 )-(λ1- λ 2 )]-....................................................................................Equation 2  Y= (n 1 -n 2 )/ [1/ (λ1-Z)-(1/ (λ2-Z)…………………………Equation 3  X=n 1 -B/ (λ1-Z)…………………………………………...Equation 4  Hartmann dispersion formula is applied in the measurements of spectra wavelengths taken on a prism instruments.  Constant Z is the spectrometer optical function. In the laboratory, it usually measured by lab technicians fo
Read more