Preview

Transcontinental Airways (Tca) Reservations Loading

Good Essays
Open Document
Open Document
2233 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Transcontinental Airways (Tca) Reservations Loading
Transcontinental Airways (TCA) Reservations Loading

Transcontinental Airways (TCA) Reservations Loading

1. Using the Integer Programming template, staff the center as efficiently as possible for a full week. Start by determining the averages and standard deviation of each day's data and then the 95% upper limit. This 95% point will be the RHS for the calls needed to be answered each day.

a) Enter your DATA from PHONE.xls for your GROUP# into the worksheet WEEKLY and determine the averages of the phone calls for each day of the week, the standard deviation, and the upper limit (UL) of the 95% confidence interval (UCL) for the data to provide a 95% probability of service (UCL=avg+z*stdev). Why do some of the values in the data turn light purple and peach (not how, but why)? Light peach represent the highest and lowest values of hours worked per week for the TCAT call center. Explain why TCA wouldn't want to just satisfy the average, and why they want 95% upper confidence interval. Because of the standard of deviation there is possibility that avg calls per day could be greater than the avg. By having Print the data (A1:R9) with row/column borders.

b) Complete the template WEEKLY filling in the missing formula and data. The shading indicates when a shift is ON. c) Complete the Solver setup by adding the INTEGER constraint for the variables and run. HINT: You can only use integer (whole people) so look at the options in the Solver constraint. Print a picture of the Solver setup (not options) here.

d) Print out the model and variance graph and comment on the results. How much money do you save TCA from the current number of FTs and PTs? (show how you computed original cost). Save the ANSWER report and print out the first nine rows. We saved TCA a total of $1280.00, from their total current cost of $10,920.00 The original cost was computed in a three step process: First Step: Take the $15 Hourly wage

You May Also Find These Documents Helpful

  • Good Essays

    Acct 505 Course Project

    • 596 Words
    • 3 Pages

    The median of the data is 3 and the mode is 2. The household size mean is 3.42. The standard deviation is 1.74 and the maximum number of customers has a household size of 2 which is shown in the bar graph and the frequency distribution table.…

    • 596 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Gm 533 Project Part a

    • 481 Words
    • 2 Pages

    The mean household size of the customers is given as 3.42. The median of the data is 3 and the mode is 2. The standard deviation is given approximately as 1.74. Maximum number of customers has a household size of 2 as is evident from the frequency distribution and the bar graph.…

    • 481 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Nt1310 Unit 4 Case Study

    • 317 Words
    • 2 Pages

    I have attached question number 11 for everyone to review. This step is not completely done because we are missing expenses and revenues for 2017. The reason I am sending it out to you guys is so that you can see what I have done so far. This information may be particularly relevant to Jon. In the excel document, there are two tabs so far: the original budget, and expense scenario 1. The first tab is all the calculations I have done to get to tab 2. Also, In tab 1 I have made the following assumptions.…

    • 317 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Mid Term

    • 503 Words
    • 3 Pages

    4. (TCO A) Within the relevant range, variable costs can be expected to: (Points : 6)…

    • 503 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Assignment 2

    • 1856 Words
    • 7 Pages

    b. 3 points: Based on the minimum and maximum number of service calls per day in the sample of…

    • 1856 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    You want to buy a new Computer Aided Design (CAD) system for your business. The cost of the system is $150,000 and you expect to save over $40,000 per year in reduced labor costs. Please calculate the net present value of the CAD if your required return is 10 percent and the life of the system is expected to be 5 years. (12 points)…

    • 658 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Ss2 Assesment

    • 1737 Words
    • 7 Pages

    1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured…

    • 1737 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    SS2 Assessment

    • 2272 Words
    • 11 Pages

    1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured…

    • 2272 Words
    • 11 Pages
    Powerful Essays
  • Good Essays

    1. Complete the answer sheet below by placing an "X" under each heading that identifies the cost involved. The "Xs" can be placed under more than one heading for a single cost. (5 Points)…

    • 622 Words
    • 3 Pages
    Good Essays
  • Good Essays

    The Great Men Analysis

    • 670 Words
    • 3 Pages

    Furthermore, as he chooses to present a White-centered narrative that pays little attention to both the ideas and the methods of the civil rights activist, he diminishes the historical importance of African American activists in transforming the United States by making it both politically and socially more inclusive. The “Great Men” narrative that Lawson utilizes fails to present the complexity of the civil rights movement and the resilience of the activist, who, despite the numerous setbacks they suffered, continued to fight for their rights. By not paying any attention to the grassroots, Lawson creates a false picture of racial and social progress. He implicitly suggests that having a more or less amicable administration in place would be sufficient to maintain or advance the interests of historically marginalized groups. That is unfortunate, particularly because the article was published at the turn of the century, long after conservative forces had begun to dismantle some of the hard-won reforms. Consequently, a more inclusive approach that depicts the essential groundwork before and after the national leaders of the movement negotiated legislative reforms with the national government, would have been warranted.…

    • 670 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Xx Custom Harmon Company

    • 1733 Words
    • 7 Pages

    The equivalent units of production for materials. = 38,000 (See math below) Transferred out= 30,000+ work in process 8,000= 38,000 ii. The cost per equivalent unit for conversion.= $7.50 (see math below) total weighted average units= 8,000 *.3= 24000 plus 30,000 that was transfer= 32,400 Conversion- 48,600 + added during month 194,400= 243,000 cost per unit 243,000/ total weighted avg unit 32,400 = $7.50 per unit iii. The total cost assigned to units transferred out of the Curing Department during November. = Materials= $142,500 (see math below) Conversion= $225,000 Total cost= $367,500 Materials = work in process plus added during month ( 34,500+146,000) = 180500 transferred materials divide by total average unit= 30,000/38,000=.7894 180500*.7894=$142,500 Materials Conversion= materials transferred times cost per equivalent unit 30,000*$7.50= 225,000 Add together for total cost= 225000+142500= 367500 iv. The cost assigned to work in process inventory as of November 30.= Materials $38,000 + conversion $18,000= Total cost $56,000 (See math below) Materials times ending work in process divide total materials= 34500+146000= 180500 180500* (8,000/38,000)= 38,000 Conversion ending work process inventory 8,000*.3=2,400 conversion cost conversion times per unit= 2,400*$7.50= $18,000 Total cost= 38,000+18,000=…

    • 1733 Words
    • 7 Pages
    Satisfactory Essays
  • Powerful Essays

    Evaluate the opportunity that is identified by Chris and Val in the case using the analytical tools you have covered in class?…

    • 2254 Words
    • 10 Pages
    Powerful Essays
  • Better Essays

    Data Analysis Data Analysis Descriptive Statistics. In the Input Range enter the range for returns using the pointing method. Under Output options select New Worksheet Ply. Further down select all the four boxes, enter 95% next to Confidence Level for Mean and 5 in each of the two boxes…

    • 3520 Words
    • 15 Pages
    Better Essays
  • Good Essays

    Project Management Study Guide

    • 25185 Words
    • 101 Pages

    6 If earned value (EV) = 350, actual cost (AC) = 400, planned value (PV) = 325, what is cost variance (CV)?…

    • 25185 Words
    • 101 Pages
    Good Essays
  • Satisfactory Essays

    Illustrate and briefly explain the relationship between marginal cost (MC) and average cost (AC) curves of a firm…

    • 599 Words
    • 3 Pages
    Satisfactory Essays