Question

Question:\ The Decker Company maintains a fleet of 10 service trucks and crews that provide a...

Question:\

The Decker Company maintains a fleet of 10 service trucks and crews that provide a variety of plumbing, heating, and cooling repair services to residential customers. Currently, it takes on average about six hours before a service team responds to a service request. Each truck and crew averages 12 service calls per week, and the average revenue earned per service call is $150. Each truck is in service 50 weeks per year. Owing to the diffi culty in scheduling and routing, there is considerable slack time for each truck and crew during a typical week. In an effort to more efficiently schedule the trucks and crews and improve their productivity, Decker management is evaluating the purchase of a prewritten routing and scheduling soft ware package. The benefits of the system will include reduced response time to service requests and more productive service teams, but management is having trouble quantifying these benefits. One approach is to make an estimate of how much service response time will decrease with the new system, which then can be used to project the increase in the number of service calls made each week. For example, if the system permits the average service response time to all to four hours, management believes that each truck will be able to make sixteen service calls per week on average—an increase of four calls per week. With each truck making four additional calls per week and the average revenue per call at $150, the revenue increase per truck per week is $600 (4 3 $150). With ten trucks in service fi ft y weeks per year, the average annual revenue increase will be $300,000 ($600 3 10 3 50). Decker Company management is unsure whether the new system will enable response time to fall to four hours on average or if it will be some other number. Therefore, management has developed the following range of outcomes that may be possible outcomes of
the new system, along with probability estimates of each outcome’s occurring. New Response Time # Calls/Truck/Week Likelihood
2 hours 20 20%
3 hours 18 30%
4 hours 16 50%


Given these fi gures, prepare a spreadsheet model that computes the expected value of the annual revenues to be produced by this new system.

Homework Answers

Answer #1
EXPECTED VALUE OF ALL THE OUTCOMES
i Outcome # Details 1 2 3
ii New Response Time(hrs) (given) 2 3 4
iii    Calls per week/truck (given) 20 18 16
iv    Probability of Outcome (given) 20% 30% 50%
v Revenue per Service call $ (given) 150 150 150
vi service weeks /yr (given) 50 50 50
vii Trucks (given) 10 10 10
viii Annual Revenue($) (iii)*(v)*(vi)*(vii)        1,500,000 1,350,000 1,200,000
ix Expected Value (viii)*(iv)            300,000      405,000      600,000
x TOTAL sum of (ix)        1,305,000
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Seabreeze Furniture in Orlando maintains a large, central warehouse where it stores items until they are...
Seabreeze Furniture in Orlando maintains a large, central warehouse where it stores items until they are sold or needed by the company’s many stores in the Central Florida area. A four-person crew works at the warehouse to load or unload trucks that arrive at the warehouse at a rate of one per hour (with exponentially distributed interarrival times).  The time it takes the crew to unload each truck follows an exponential distribution with a mean service rate of 4 trucks per...
PLEASE USE EXCELUPD United Parcel Delivery (UPD) owns a fleet of 1800 delivery trucks serving the...
PLEASE USE EXCELUPD United Parcel Delivery (UPD) owns a fleet of 1800 delivery trucks serving the metropolitan Chicago area. All trucks are maintained at a central garage. On the average, four trucks a week require a new engine. Engines cost $900 each, and the delivery time is two weeks. There is a fixed order cost of $130, and UPD uses an annual inventory holding cost rate of 30%. For each week a truck is out of service, UPD estimates it...
I need a detailed explanation with a formula (show work) included on how to solve this...
I need a detailed explanation with a formula (show work) included on how to solve this question: Scenario Office Equipment, Inc. (OEI) leases automatic mailing machines to business customers in Fort Wayne, Indiana. The company built its success on a reputation of providing timely maintenance and repair service. Each OEI service contract states that a service technician will arrive at a customer's business site within an average of 3 hours from the time that the customer notifies OEI of an...
Scenario: Office Equipment, Inc. (OEI) leases automatic mailing machines to business customers in Fort Wayne, Indiana....
Scenario: Office Equipment, Inc. (OEI) leases automatic mailing machines to business customers in Fort Wayne, Indiana. The company built its success on a reputation of providing timely maintenance and repair service. Each OEI service contract states that a service technician will arrive at a customer’s business site within an average of 3 hours from the time that the customer notifies OEI of an equipment problem. Currently, OEI has 10 customers with service contracts. One service technician is responsible for handling...
Question 1 “PhysicalFun” is a physical center which opens 24 hours per day. Each member of...
Question 1 “PhysicalFun” is a physical center which opens 24 hours per day. Each member of “PhysicalFun” has an access card. Members would be charged in a weekly basic (Sunday 12:00a.m. to Saturday 11: 59 p.m.) according to the accumulated number of hours of facilities used within a week. The weekly basic charge is $150 with an additional charge of $30 per hour. According to the company record, the number of hours a member spends in “PhysicalFun” in a week...
Question 5 (10 marks) Cash Management Bird's Eye Treehouses, Inc., a Kentucky company, has determined that...
Question 5 Cash Management Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. Therefore, it is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 1.5 days. Average number of payments per day 790 Average value of payment $ 740 Variable lockbox fee (per transaction) $ 0.10 Annual interest rate on...
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of...
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of a specific product in the past three years. Quarter Year 1 2 3 4 2015 350 254 176 228 2016 367 258 169 236 2017 342 250 166 228 Predict demand in quarter 1 and quarter 2 of 2018, given that the demand forecast for the whole year is a total of 1,040 units. Question 6: DRP (8 p) A central DC supplies a...
Johnny Mobile started a food truck business in 2017 by investing $100,000 of his own money...
Johnny Mobile started a food truck business in 2017 by investing $100,000 of his own money in the corporation in exchange for stock. Mr. Mobile concentrates on serving Lobster Rolls and his profits have more than doubled from 2017 – 2019. Mr. Mobile does not understand why his profits have increased faster than his volume, but he believes that his focus and strategic positioning regarding high levels of customer service and product quality have helped fuel this growth in his...
Please answer question 3! This question had been asked before but unfortunately all of the answers...
Please answer question 3! This question had been asked before but unfortunately all of the answers were to question 1, not Question 3. I have deleted question 1 from the information so that Question 3 is more available for viewing. The Glory Mountain State Ski Area – owned and managed by a state public authority - expects to attract 292,500 skier days during the coming ski season. A skier day represents one skier at the mountain for one day. In...
Pack-and-Go, a new competitor to FedEx and UPS, does intra-city package deliveries in seven major metropolitan...
Pack-and-Go, a new competitor to FedEx and UPS, does intra-city package deliveries in seven major metropolitan areas. The performance of Pack-and-Go is measured by management as: (1) delivery time (relative to budgeted delivery time), (2) on-time delivery rates (defined as agreed-upon delivery date/time plus or minus a specified cushion), and (3) percentage of lost or damaged deliveries. In response to competitive pressures, Pack-and-Go is evaluating an investment in new technology that would improve customer service and delivery quality, particularly in...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT