Buservice Inc. is a transportation company in the Tampa area that provides bus services. Twelve months...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Buservice Inc. is a transportation company in the Tampa area that provides bus services. Twelve months ago. Buservice Inc. initiated a project with the intent of reducing the annual maintenance cost, with an experiment executed with two identical new buses. Bus #32 had the TRADITIONAL preventive maintenance program executed as usual, while Bus # 33 had the NEW preventive maintenance program in the first 12 months of its life. The 12-month project was just completed this week and the following table was put together to present the monthly maintenance cost for the first 12 months for both buses: Month 1 5 6 7 8 9 10 11 12 Bus #32 Monthly Maintenance Cost (S/month) 2,450 3,235 3,780 4,275 5,425 6,890 6,580 7,350 8,750 8,250 9,245 10,025 TOPIC. Bus #33 Monthly Maintenance Cost (S/month) 1,250 2,060 1,890 2,290 2,540 2,890 3,750 3,150 4.250 3,590 5,250 4,000 Maintenance Reduction (S/month) a) (1 point) - Create a descriptive statistics analysis in Excel at 95% confidence level for the maintenance cost data for Bus #32 and Bus # 33. Use the output form the descriptive analysis tool and compare average, standard deviation and coefficient of variation between Bus # 32 and # 33. UPLOAD THE EXCEL SPREADSHEET FOR THIS CALCULATION IN ORDER TO GET POINTS FOR THIS TOPIC. b) (1 point) - Use the output from the descriptive statistics analysis in topic (a) and create a confidence interval for 95% confidence level for the monthly maintenance cost for Bus # 32 and # 33. UPLOAD THE EXCEL SPREADSHEET FOR THIS CALCULATION IN ORDER TO GET POINTS FOR THIS c) (1 point) - Create a Scatter Chart with the monthly maintenance cost y-axis and month # on x-axis for both buses. Include axis title and chart title. What is your analysis of this chart? Discuss in detail. UPLOAD THE EXCEL SPREADSHEET FOR THIS CALCULATION IN ORDER TO GET POINTS FOR THIS TOPIC. Buservice Inc. is a transportation company in the Tampa area that provides bus services. Twelve months ago. Buservice Inc. initiated a project with the intent of reducing the annual maintenance cost, with an experiment executed with two identical new buses. Bus #32 had the TRADITIONAL preventive maintenance program executed as usual, while Bus # 33 had the NEW preventive maintenance program in the first 12 months of its life. The 12-month project was just completed this week and the following table was put together to present the monthly maintenance cost for the first 12 months for both buses: Month 1 5 6 7 8 9 10 11 12 Bus #32 Monthly Maintenance Cost (S/month) 2,450 3,235 3,780 4,275 5,425 6,890 6,580 7,350 8,750 8,250 9,245 10,025 TOPIC. Bus #33 Monthly Maintenance Cost (S/month) 1,250 2,060 1,890 2,290 2,540 2,890 3,750 3,150 4.250 3,590 5,250 4,000 Maintenance Reduction (S/month) a) (1 point) - Create a descriptive statistics analysis in Excel at 95% confidence level for the maintenance cost data for Bus #32 and Bus # 33. Use the output form the descriptive analysis tool and compare average, standard deviation and coefficient of variation between Bus # 32 and # 33. UPLOAD THE EXCEL SPREADSHEET FOR THIS CALCULATION IN ORDER TO GET POINTS FOR THIS TOPIC. b) (1 point) - Use the output from the descriptive statistics analysis in topic (a) and create a confidence interval for 95% confidence level for the monthly maintenance cost for Bus # 32 and # 33. UPLOAD THE EXCEL SPREADSHEET FOR THIS CALCULATION IN ORDER TO GET POINTS FOR THIS c) (1 point) - Create a Scatter Chart with the monthly maintenance cost y-axis and month # on x-axis for both buses. Include axis title and chart title. What is your analysis of this chart? Discuss in detail. UPLOAD THE EXCEL SPREADSHEET FOR THIS CALCULATION IN ORDER TO GET POINTS FOR THIS TOPIC.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
3 4 5 6 7 8 9 10 11 12 13 A 14 Cost of the Asset 15 Life of the Asset in Years 16 Book Value of the Asset after 5 years 17 Depreciable Basis 18 Yearly depreciation 19 After tax Salvage Value in year...
-
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Mo's Motor Corp. issued $ 380,000 of 7%, 5-year bonds on April 1, 2021. Interest is payable semi-annually on April 1 and October 1. On April 1, 2023,...
-
3 4 5 6 7 8 9 10 11 12 13 14 15 4am-6am 6am - 8am 8am -10am 10am-12pm 12pm-2pm 2pm-4pm 4pm - 6pm 6pm - 8pm 8pm - 10pm Monday 2022 Daily Attendance Trends 50 125 100 90 75 62 125 125 75 Balance S...
-
A city levies property taxes of $2 billion in June 2015for its Fiscal year beginning July 1, 2015. The taxes are due by January 31, 2016. The following (in millions) indicates actual and anticipated...
-
On January 1, 2011, Snider Corporation had the following stockholders equity accounts. Common Stock ($10 par value, 90,000 shares issued and outstanding) ................... $900,000 Paid-in Capital...
-
Barton Chocolates used a promissory note to borrow $ 1,000,000 on July 1, 2015, at an annual interest rate of 6 percent. The note is to be repaid in yearly installments of $ 200,000, plus accrued...
-
What are some of the differences between sole traders and limited companies?
-
The following monthly data are taken from Ramirez Company at July 31: Sales salaries, $300,000; Office salaries, $60,000; Federal income taxes withheld, $90,000; State income taxes withheld, $20,000;...
-
Civil penalties imposed on individual directors by the Court as a result of breach of directors' duties include: 1 Disqualification as company director 2 Civil penalty, defined as 5000 penalty units...
-
1. Using the spreadsheet model from Case 2.1 as a starting point, use Solver to find the optimal set of projects to approve. The solution should maximize the total NPV from the approved projects, and...
-
A car saleswoman wants to know what percentage of people own cars in a small county in Arizona. She first gathers driver's license data from the Motor Vehicle Department, and then she uses a random...
-
The average Romans lifespan 2,000 years ago was 22 years. In1900, a person was expected to live 47.3 years. In 2016, lifeexpectancy is 79.26. Assume you are a 41-year-oldFemale. (Use Table 20.1) (for...
-
How will we uncover and respond to evolving employee expectations?
-
City Feb. Cases March Cases April Cases New York 19 56 189 Los Angeles 6 12 201 Chicago 0 3 14 Houston 19 19 272 Philadelphia 0 1 5 Phoenix 23 78 289 San Antonio 6 9 95 San Diego 3 38 258 Dallas 4 13...
-
Discovery and Assessment steps and activities include: A. Visiting the Employment Seeker at their home B. Interviewing the Employment Seeker's, Family and Friends C. Spending time with Employment...
-
How can process technology enable better coordination between different supply chain partners?
-
Define the terms in this experiment: 1. What is the normal temperature of the water? 2. What is "warm water"? 3. What is "cold" water? 4. What is "growth"? How will growth be measured? 5. Define the...
-
The following information is for Montreal Gloves Inc. for the year 2020: Manufacturing costs Number of gloves manufactured Beginning inventory $ 3,016,700 311,000 pairs 0 pairs Sales in 2020 were...
-
Explain how the existence of a bargain purchase affects the fair value adjustments, both in the year of acquisition and in subsequent years.
-
Compare the accounting for the effects of intercompany transactions for transactions between parent entities and subsidiaries and between companies and associates or joint ventures.
-
Aries Inc. holds a 90% interest in Sharatan Ltd., a corporation based in France. The functional currency of Sharatan (self-sustaining subsidiary) is the euro. Aries's interest in Sharatan was...
-
Generate a regression dataset by sampling a function from a GP prior and then adding some noise. Use ABC to sample from the posterior. Each sample should be generated by first sampling from the GP...
-
For the mixture model where each component is a one-dimensional Gaussian with variance 1 , show that the conditional distribution for the mean of the \(k\) th mixture component is that given by...
-
Implement the Gibbs sampler for the mixture model. Compute \(\hat{R}\) and the autocorrelation of the component means \(\mu_{k}\). How many samples are required for convergence? How much should the...
Study smarter with the SolutionInn App