IT445 Saint Leo University Mod 4 Decision Support Systems Worksheet Mod 4 Decision Support Systems. MBA550. 6 Questions are Math related. Answers must be i

IT445 Saint Leo University Mod 4 Decision Support Systems Worksheet Mod 4 Decision Support Systems. MBA550. 6 Questions are Math related. Answers must be in Excel format explaining how you got your answers. I need this completed today because my other Study Pool person could not complete the assignment. It was due last night. These questions are tough. 643
PROBLEMS
4. The ticket booth on the Tech campus is operated by one person, who is selling tickets for the annual
Tech versus State football game on Saturday. The ticket seller can serve an average of 12 custom-
ers per hour; on average, 10 customers arrive to purchase tickets each hour (Poisson distributed).
Determine the average time a ticket buyer must wait and the portion of time the ticket seller is
busy.
5. The Petroco Service Station has one pump for regular unleaded gas, which (with an attendant) can sera
vice 10 customers per hour. Cars arrive at the regular unleaded pump at a rate of 6 per hour. Determine
the average queue length, the average time a car is in the system, and the average time a car must wait.
If the arrival rate increases to 12 cars per hour, what will be the effect on the average queue length?
6. The Dynaco Manufacturing Company produces a particular product in an assembly line operation,
One of the machines on the line is a drill press that has a single assembly line feeding into it. A
partially completed unit arrives at the press to be worked on every 7.5 minutes, on average. The
machine operator can process an average of 10 parts per hour. Determine the average number of
parts waiting to be worked on, the percentage of time the operator is working, and the percentage
of time the machine is idle.
7. The management of Dynaco Manufacturing Company (see Problem 6) likes to have its operators
working 90% of the time. What must the assembly line arrival rate be for the operators to be as
busy as management would like?
8. The Peachtree Airport in Atlanta serves light aircraft. It has a single runway and one air traffic
controller to land planes. It takes an airplane 12 minutes to land and clear the runway. Planes arrive
at the airport at the rate of 4 per hour.
a. Determine the average number of planes that will stack up, waiting to land.
b. Find the average time a plane must wait in line before it can land.
c. Calculate the average time it takes a plane to clear the runway once it has notified the airport
that it is in the vicinity and wants to land.
d. The FAA has a rule that an air traffic controller can, on average, land planes a maximum of
45 minutes out of every hour. There must be 15 minutes of idle time available to relieve the
tension. Will this airport have to hire an extra air traffic controller?
9. The First American Bank of Rapid City has one outside drive-up teller. It takes the teller an aver-
age of 4 minutes to serve a bank customer. Customers arrive at the drive-up window at a rate o
12 per hour. The bank operations officer is currently analyzing the possibility of adding a secon
drive-up window, at an annual cost of $20,000. It is assumed that arriving cars would be equall
divided between both windows. The operations officer estimates that each minute’s reduction
customer waiting time would increase the bank’s revenue by $2,000 annually. Should the secon
drive-up window be installed?
10. During registration at State University every semester, students in the college of business m
have their courses approved by the college adviser. It takes the adviser an average of 2 minute:
approve each schedule, and students arrive at the adviser’s office at the rate of 28 per hour.
a. Compute L, Lq, W, Wq, and U.
b. The dean of the college has received a number of complaints from students about the lengt
time they must wait to have their schedules approved. The dean feels that waiting 10.00 mir
to get a schedule approved is not unreasonable. Each assistant the dean assigns to the advi
office will reduce the average time required to approve a schedule by 0.25 minute, dowi
minimum time of 1.00 minute to approve a schedule. How many assistants should the
assign to the adviser?
all trunke traveling on Interstate 40 between Albuquerque and Amarillo are required to ste
inh station at a rate of 200 per 8-hour day, and the
INVENTORY MANAGEMENT
Step 2: Solve for R
R = dl + Zo VI = (1.0(15) + (2.05)(0,4)V 15 = 24 + 3,18 = 27.18 monitors
Problems
1. Hayes Electronics stocks and sells a particular brand of personal computer. It costs the firm $450
each time it places an order with the manufacturer for the personal computers. The cost of carrying
one PC in inventory for a year is $170. The store manager estimates that total annual demand for
the computers will be 1,200 units, with a constant demand rate throughout the year. Orders are
received within minutes after placement from a local warehouse maintained by the manufacturer.
The store policy is never to have stockouts of the PCs. The store is open for business every day of
. However, the inventory model parameters
the year except Christmas Day. Determine the following:
a. The optimal order quantity per order
b. The minimum total annual inventory costs
c. The optimal number of orders per year
d. The optimal time between orders (in working days)
2. Hayes Electronics in Problem 1 assumed with certainty that the ordering cost is $450 per order
$
are frequently only estimates that are subject to some degree of uncertainty. Consider four cases
of variation in the model parameters: (a) Both ordering cost and carrying cost are 10% less than
originally estimated, (b) both ordering cost and carrying cost are 10% higher than originally esti-
mated, (c) ordering cost is 10% higher and carrying cost is 10% lower than originally estimated,
and (d) ordering cost is 10% lower and carrying cost is 10% higher than originally estimated.
Determine the optimal order quantity and total inventory cost for each of the four cases. Prepare a
table with values from all four cases and compare the sensitivity of the model solution to changes
in parameter values.
3. A firm is faced with the attractive situation in which it can obtain immediate delivery of an item
it stocks for retail sale. The firm has therefore not bothered to order the item in any systematic
way. Recently, however, profits have been squeezed due to increasing competitive pressures, and
the firm has retained a management consultant to study its inventory management. The consultant
has determined that the various costs associated with making an order for the item stocked are
approximately $30 per order. She has also determined that the costs of carrying the item in inven-
tory amount to approximately $20 per unit per year (primarily direct storage costs and foregone
profit on investment in inventory). Demand for the item is reasonably constant over time, and
the forecast is for 19,200 units per year. When an order is placed for the item, the entire order
is immediately delivered to the firm by the supplier. The firm operates 6 days a week plus a few
Sundays, or approximately 320 days per year. Determine the following:
a. The optimal order quantity per order
b. The total annual inventory costs
c. The optimal number of orders to place per year
d. The number of operating days between orders, based on the optimal number of orders
4. The Western Jeans Company purchases denim from Cumberland Textile Mills. The Western Jean
Company uses 35,000 yards of denim per year to make jeans. The cost of ordering denim from
the textile company is $500 per order. It costs Western $0.35 per yard annually to hold a yard
denim in inventory. Determine the optimal number of yards of denim the Western Jeans Compar
should order, the minimum total annual inventory cost, the optimal number of orders per year, at
the optimal time between orders.

Purchase answer to see full
attachment