Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need some help with my homework. Please take a look at the attached PDF for the assignment details. Attached is also an excel template
I need some help with my homework. Please take a look at the attached PDF for the assignment details. Attached is also an excel template that must be followed.
Note, place answers to the problems on the Answer in column c. Show work on each individual tab. You can use t in the class lectures to solve the problems. Copy and paste the final template answer to each of the worksheet tab you do work with the excel templates outside of this template, then just copy your final answers in the template to the work sheet for grading. It will convert to an xlsm file Submitted by: Your name here Answers P1a - Period 1 Minimal # Tellers P1a - Period 2 Minimal # Tellers P1a - Period 3 Minimal # Tellers P1a - Period 4 Minimal # Tellers P1b - Period 1 Wq (in Hrs) P1b - Period 2 Wq (in Hrs) P1b - Period 3 Wq (in Hrs) P1b - Period 4 Wq (in Hrs) Skip Problem 1C P2a - Period 1 # Tellers / Minimal Cost (Optimized Tellers) P2a - Period 2 # Tellers / Minimal Cost (Optimized Tellers) P2a - Period 3 # Tellers / Minimal Cost (Optimized Tellers) P2a - Period 4 # Tellers / Minimal Cost (Optimized Tellers) Skip Problem 2C P3a - Period 1 Mean Arrival Rate (Tellers) (customers / hr) P3a - Period 2 Mean Arrival Rate (Tellers) (customers / hr) P3a - Period 3 Mean Arrival Rate (Tellers) (customers / hr) P3a - Period 4 Mean Arrival Rate (Tellers) (customers / hr) P3b - Period 1 Mean Arrival Rate (ATM) (customers / hr) P3b - Period 2 Mean Arrival Rate (ATM) (customers / hr) P3b - Period 3 Mean Arrival Rate (ATM) (customers / hr) P3b - Period 4 Mean Arrival Rate (ATM) (customers / hr) P3b - Outside Banking Hrs Mean Arrival Rate (ATM) (customers / hr) P3c - Period 1 Minimal # Tellers P3c - Period 2 Minimal # Tellers P3c - Period 3 Minimal # Tellers P3c - Period 4 Minimal # Tellers Skip Problem 4, 5 and 6 (all sections) New problem Part a # Tellers / Minimal Cost (Optimized Tellers) New problem Part b # ATMs / Minimal Cost (Optimized ATMs) Possible Points 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 3 3 3 3 4 4 4 4 4 6 6 Total 100 each individual tab. You can use the excel templates discussed swer to each of the worksheet tabs. Highly recommend that ur final answers in the template to each work sheet. Submit Deductions Total Points Note, need enough tellers to meed demand, Traffic intensity cannot be greater than 100% Note, for problem 2 use cost data to optimize the number of tellers required Note, for problem 3b you ned to consider disversion, expansion and the additional 10% expansion as described in Problem 3 Determine Minimum # of tellers based on new teller arrival rate in P3a Total Grade 0 New problem Part: For the new problem. Consider an arival rate of 200 customers per hour for the Tellers and 100 customer per hours for the ATM. Each teller has a service rate of 2.5 minutes per transactions and aservice rate of 2 minutes per transaction. Cost of each ATM is $5 per hour. Cost of each server is $10 per hour. Cost of wait time, either at the ATM or the tellers, is $0.10 per minute. Detremine: a. Optimized cost per hour for Tellers b. Optimized cost per hour for ATMs not be greater than 100% P2-Period4Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started