Question Details

[solution] » Would it possible to get the answers on the excel sheet

Brief item decscription

Step-by-step solution file

Item details:

Would it possible to get the answers on the excel sheet

Would it possible to get the answers on the excel sheet explaining how you got those answers? 

Vacations Inc. (VI) markets time-share condominiums throughout North America. One way the company


generates sales leads is by offering a chance to win a free mini-vacation to anyone who fills out an


information card at places it in VI boxes located in malls. The ones who fill out the form and indicate an


adequate income level receive a letter from VI with a toll-free number. A call to the toll-free number


reveals that the mini-vacation consists of a free dinner, entertainment, and two-night stay at one of VI?s


time-share properties. About half the people who call to claim their ?prize? reject the offer once they find out about the twohour property tour. About 40% accept the mini-vacation and do the tour, but do not buy anything. The


remaining 10% accept the offer, accept the mini-vacation and ultimately purchase a time-share. Each


mini-vacation costs VI about $250 and generates a net profit of $7,000. VI?s call center operates from 10 am to 10 pm daily with three sales representatives and receives calls at


the rate of 50 per hour, with inter-arrival times being exponentially distributed. It takes an average of 4


minutes to handle each call with actual times being exponentially distributed. The phone system keeps


up to 10 callers on hold. Assume those who receive a busy signal do not call back. Use waiting line analysis to answer the following questions. (1) On average, how long are customers on hold before they get to speak to a sales person? (2) If VI has a service goal of less than 3 minutes for average waiting time, how many salespeople


should it employ?


(3) Would the capacity have to be altered for a service goal of 1 min or less of average wait time? (4) What is the expected value of each call to VI? (5) On average, how many customers does each salesperson process in a single day? (Hint: Look at the


utilization of servers)


(6) What is the daily expected profit? (7) Suppose VI pays its sales people $12 per hour. How many sales people should it employ to


maximize daily profit?


(8) If the customer call arrival rate increased to 60 calls per hour, how would it affect your decision on


the number of sales




About this question:

This question was answered on: Feb 21, 2020

PRICE: $24 (18.37 KB)

Buy this answer for only: $24

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.

Need a similar solution fast, written anew from scratch? Place your own custom order

We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

Order Now