Basic formulas for inventory management Q Model (with variation on demand) 2*S*D Q* = EOQ= =...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Basic formulas for inventory management Q Model (with variation on demand) 2*S*D Q* = EOQ= = i*C R = a *L+ss ss = z* L* H TBO = n Average stock = 2 + ss 2 TCH=D*C + * S + (+ ss) ic P Model (with variation on demand) Pt* T = d * (P + L) + ss ss = 3* (P+L) * Use the p model when working with an allotted time period (revision/review period 15 days) -> Golias example uses p model Average stock + ss 2 TCH=DC+n*S+ + ( 7 + s ) * i * C Basic formulas for inventory management Symbols Variable Purchasing cost Ordering cost Symbols Unit C (or P) Per unit S Per order Holding cost percentage, in the horizon Period of time between orders i % of unitary cost t;P; TBO Time Horizon Service level %; equiv. z H Time Z Lead time Number of orders Revision Period Reorder point Demand in the horizon Demand n P Number of standard deviations Number or orders Time R Number of products L Time D Number of units d Number of units Economic order quantity Q*; EOQ Number of units Quantity Target inventory 2 Number of units T Number of units Safety stock SS Number of units Economic Order Quantity TCH= D*C+ *S+ 2 2*S*D Q* = EOQ= i*C 2*S t* = TBO* = i*C*D Q = d*TBO R = d*L n=D/Q Exercise 9 Russel, Lda (RSS) imports sweets. Drops are supplied from Spain by BARCINO, a company located in Barcelona. Both RSS and BARCINO work 52 weeks a year. RSS has its warehouse in Carregado. From this warehouse it supplies its 4 retail stores. RSS receives daily orders from the stores from Monday to Saturday. Stores are open from Monday to Saturday, from 10:00 to 22:00. The warehouse supplies one day after the order, 6 days a week. BARCINO supplies every Tuesday before 10:00 at the central warehouse, according to the orders placed on Friday until 10:00. Note that the warehouse works 6 days a week, from Monday to Saturday. The daily demand from each store, and daily standard deviation in demand, in boxes, are as follows (demand (standard deviation)): Drops Lisbon 25 (2) Porto 35 (4) Braga 25 (3) Setbal 20 (2) Note: RSS places orders in boxes, is supplied in boxes and delivers in boxes Ordering cost BARCINO (drops) 20 per order Selling price (box) Cost price (box) Carrying cost (per year) Service level (99,9%) Stock on hand, in the warehouse Orders already placed 1 week 125 per box 50 per box 56%/year Z = 3,09 330 boxes O boxes 6 days a) Today is Friday 9:00am. RSS Logistics Director asks you to identify how many boxes should be ordered. b) Knowing in advance that BARCINO is willing to change the time between orders and keep lead time, the Director of RSS is not satisfied with the average inventory level of drops as they consider that it is too high. The following suggestion is made: "Without changing the inventory model, I think we should change our time between orders (TBO) to become closer to the economic time between orders (TBO*). I think that this would decrease the average level of inventory of drops". Comment on this statement and justify your position. need to Review Operations Midterms Final 51 Inventory Management exercise 9 (RUSSEL). 25 (2) BARCINO RSS W 35 (4) 25(3) P=lwech 6 days 20 (2) 3 days s PEIday L= Iday closed Sunday orders Friday & drivers Tuesday 1 week days 1 year = 52 weeks a) T=d(P+1) + P+L 6v Why are the Squand = (25 +35+25+20)(6+3)+3.09.6+3 x 22 +42 +32 +22 =945 +53.25 = 998.25999 boxes Order qt 999-330 = 669 boxes. b)+* =TBO* =2*5. 2x 20 because T > Stock on hand 0.56 50105-6.52=0.0066036 years fholding cost purchasing cost demandin horizon (x652)= =2.06 days 105.6 (inventory (R-(days) = 2 +3.09.16 +3 22 + 42 +33 +2 = 368.25 boxes inventory (P= 2 days) = 10522 + 3.09 2+3+ 22+423 +2 = 144,69 boxes Basic formulas for inventory management Q Model (with variation on demand) 2*S*D Q* = EOQ= = i*C R = a *L+ss ss = z* L* H TBO = n Average stock = 2 + ss 2 TCH=D*C + * S + (+ ss) ic P Model (with variation on demand) Pt* T = d * (P + L) + ss ss = 3* (P+L) * Use the p model when working with an allotted time period (revision/review period 15 days) -> Golias example uses p model Average stock + ss 2 TCH=DC+n*S+ + ( 7 + s ) * i * C Basic formulas for inventory management Symbols Variable Purchasing cost Ordering cost Symbols Unit C (or P) Per unit S Per order Holding cost percentage, in the horizon Period of time between orders i % of unitary cost t;P; TBO Time Horizon Service level %; equiv. z H Time Z Lead time Number of orders Revision Period Reorder point Demand in the horizon Demand n P Number of standard deviations Number or orders Time R Number of products L Time D Number of units d Number of units Economic order quantity Q*; EOQ Number of units Quantity Target inventory 2 Number of units T Number of units Safety stock SS Number of units Economic Order Quantity TCH= D*C+ *S+ 2 2*S*D Q* = EOQ= i*C 2*S t* = TBO* = i*C*D Q = d*TBO R = d*L n=D/Q Exercise 9 Russel, Lda (RSS) imports sweets. Drops are supplied from Spain by BARCINO, a company located in Barcelona. Both RSS and BARCINO work 52 weeks a year. RSS has its warehouse in Carregado. From this warehouse it supplies its 4 retail stores. RSS receives daily orders from the stores from Monday to Saturday. Stores are open from Monday to Saturday, from 10:00 to 22:00. The warehouse supplies one day after the order, 6 days a week. BARCINO supplies every Tuesday before 10:00 at the central warehouse, according to the orders placed on Friday until 10:00. Note that the warehouse works 6 days a week, from Monday to Saturday. The daily demand from each store, and daily standard deviation in demand, in boxes, are as follows (demand (standard deviation)): Drops Lisbon 25 (2) Porto 35 (4) Braga 25 (3) Setbal 20 (2) Note: RSS places orders in boxes, is supplied in boxes and delivers in boxes Ordering cost BARCINO (drops) 20 per order Selling price (box) Cost price (box) Carrying cost (per year) Service level (99,9%) Stock on hand, in the warehouse Orders already placed 1 week 125 per box 50 per box 56%/year Z = 3,09 330 boxes O boxes 6 days a) Today is Friday 9:00am. RSS Logistics Director asks you to identify how many boxes should be ordered. b) Knowing in advance that BARCINO is willing to change the time between orders and keep lead time, the Director of RSS is not satisfied with the average inventory level of drops as they consider that it is too high. The following suggestion is made: "Without changing the inventory model, I think we should change our time between orders (TBO) to become closer to the economic time between orders (TBO*). I think that this would decrease the average level of inventory of drops". Comment on this statement and justify your position. need to Review Operations Midterms Final 51 Inventory Management exercise 9 (RUSSEL). 25 (2) BARCINO RSS W 35 (4) 25(3) P=lwech 6 days 20 (2) 3 days s PEIday L= Iday closed Sunday orders Friday & drivers Tuesday 1 week days 1 year = 52 weeks a) T=d(P+1) + P+L 6v Why are the Squand = (25 +35+25+20)(6+3)+3.09.6+3 x 22 +42 +32 +22 =945 +53.25 = 998.25999 boxes Order qt 999-330 = 669 boxes. b)+* =TBO* =2*5. 2x 20 because T > Stock on hand 0.56 50105-6.52=0.0066036 years fholding cost purchasing cost demandin horizon (x652)= =2.06 days 105.6 (inventory (R-(days) = 2 +3.09.16 +3 22 + 42 +33 +2 = 368.25 boxes inventory (P= 2 days) = 10522 + 3.09 2+3+ 22+423 +2 = 144,69 boxes
Expert Answer:
Posted Date:
Students also viewed these general management questions
-
The investment cost of the project to launch a new production line is 200 million rubles; the revenue from the sale of new products manufactured using this line is 80 million rubles a year (before...
-
Divine Homes manufactures prefabricated chalets in Colorado. The company uses a perpetual inventory system and a job cost system in which each chalet is a job. The following events occurred during...
-
S&L Financial buys and sells securities expecting to earn profits on short-term differences in price. On December 27, 2011, S&L purchasedCoca-Cola common shares for $875,000 and sold the shares on...
-
On March 10, Chancey, Inc., declared a \(\$ 700\) account receivable from the Gates Company as uncollectible and wrote off the account. On November 18, Chancey received a \(\$ 200\) payment on the...
-
An artificial tooth manufacturer sells teeth to distributors through a dealer network. The dealers sell to dental labs, which construct dentures for consumers. The manufacturer has spent a great deal...
-
Rundle Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, year 1. The company president formed a planning...
-
Westbrick Pty Company is a construction brick manufacturer in Gauteng that has been particularly hard hit by the recent recession. Faced with a dramatic fall in orders and two years of losses,...
-
The balance sheet for Yakima Corporation reported the following: noncurrent assets, $180,000; total assets, $370,000; noncurrent liabilities, $190,000; total stockholders' equity, $88,000. Compute...
-
defineeee the terms with sources1. Adversarial System 2) Case Law 3) Civil Law 4) Common Law 5) Constraint of Fact 6) Constraint of Law 7) Dual Court System 8) Federalism 9) Judicial Activism 10)...
-
This year, Rupert, a single taxpayer, sold a residence for $510,000. Rupert originally purchased the home 6 years ago for $200,000. During the first 4 years of ownership, Rupert used the home as his...
-
Discuss how the different parity conditions are related one to another: Interest Rate Parity, Purchasing Power Parity and Fisher effect in Group Ariel Case
-
What is the present value of $590,000 to be paid in 10 years? The annual interest rate is 8 percent. (FV of $1, PV of $1, FVA of $1, and PVA of $1) Note: Use appropriate factor(s) from the tables...
-
Two methods are being evaluated for constructing a second story floor onto an existing building at the Pentagon. Method A will use lightweight expanded shale on a metal deck with open web joists and...
-
The electric field due to a line charge is given by where l is a constant. Show that E is solenoidal. Show that it is also conservative. E =
-
On January 1, Bush Company purchased a delivery truck for \(\$ 10,000\). The company estimates is \(\$ 2,000\). The truck was driven \(\mathbf{1 2 , 0 0 0}\) miles in its first year. Which method...
-
On the first day of the current year, Griffin Company sold equipment for less than its book value. Which of the following is part of the journal entry to record the sale? a. A debit to Equipment b. A...
-
An exclusive right to operate or sell a specific brand of products in a given geographic area is called: a. A franchise. c. A patent. b. Goodwill. d. A copyright.
Study smarter with the SolutionInn App