(a) What is the expected jet fuel yearly average demand D? =4160 tons (b) Given D, find the order lot size Q that gives the economic order quantity (EOQ). =60.39 unit (c) Given the EOQ, what is the total inventory holding cost?= $1067695.2 (d) Given the EOQ, what is the total inventory ordering cost? =OC=$1067726.4 (e) Given the EOQ, what is the total annual inventory cost?TIC=2135421.6  =1.32

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...
icon
Related questions
icon
Concept explainers
Topic Video
Question

please Solve question G,H AND I

Question A to F IS SOLVED 

(a) What is the expected jet fuel yearly average demand D? =4160 tons
(b) Given D, find the order lot size Q that gives the economic order quantity (EOQ). =60.39 unit
(c) Given the EOQ, what is the total inventory holding cost?= $1067695.2
(d) Given the EOQ, what is the total inventory ordering cost? =OC=$1067726.4
(e) Given the EOQ, what is the total annual inventory cost?TIC=2135421.6  =1.32
(f) What is the time between orders in weeks? = 39.39

The airport is convinced that placing an order every season (every P = 13
weeks) will be best. It is also aware that the expected demand will vary
with a standard deviation of 20 tons, so it needs to take this information into account.

(g) What is the protection period required by the proposed 13-week periodic review system?
(h) The airport is required by the airlines to maintain a 99.75% service level.
What is the required safety stock?
(i) Calculate the order size (Q) when using P = 13.
(j) What is the total annual inventory cost for the P = 3 inventory system?
(k) What is the target inventory level (T)? The airport has shopped for fuel
holding tanks and has found a 1000, 1500, 2000, and 2500 ton tanks.
Which would you recommend?
(l) List one advantage of using the order interval calculated in (f) over P =
13. What is one disadvantage?

A small airport is considering whether it should provide jet fuel to
airlines if required. To understand the possible demand, the airport surveyed
its potential customers and compiled the following data:
1.
Weekly average jet fuel demand (4)
Weekly jet fuel demand standard deviation (o,)
Weekly holding cost
Order cost
80 tons
20 tons
$680/ton
$15,500/order
Lead time
3 weeks
Working weeks per year
52 weeks
The airport is interested to know what size of fuel holding tank to build, and
so would like to know the best inventory strategy.
Transcribed Image Text:A small airport is considering whether it should provide jet fuel to airlines if required. To understand the possible demand, the airport surveyed its potential customers and compiled the following data: 1. Weekly average jet fuel demand (4) Weekly jet fuel demand standard deviation (o,) Weekly holding cost Order cost 80 tons 20 tons $680/ton $15,500/order Lead time 3 weeks Working weeks per year 52 weeks The airport is interested to know what size of fuel holding tank to build, and so would like to know the best inventory strategy.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,