Question

In: Operations Management

In your spreadsheet calculate the estimated the line maintenance expense that would be predicted by the...

In your spreadsheet calculate the estimated the line maintenance expense that would be predicted by the quadratic regression function for each company in the sample . Plot these values on your graph (Connected with line) along with the original data and the orginal regression line.

Phone Services Data Collected from 12 companies

Customers (in 1000s) Line Maint. Expense (in $1000s)
25.3 484.6
36.4 672.3
37.9 839.4
45.9 694.9
53.4 836.4
66.8 681.9
78.4 1,037.0
82.6 1,095.6
93.8 1,563.1
97.5 1,377.9
105.7 1,711.7
124.3 2,138.6

Solutions

Expert Solution

Plot the data on a Scatter chart using Excel chart tools

Add Trendline, by right clicking on any data point on the chart.

Right click on the trend line and click Format trendline.

In the Trendline options, select Polynomial

Check box Display Equation on chart


Related Solutions

What level of line maintenance expense would be expected for a phone company 75,000 customer according...
What level of line maintenance expense would be expected for a phone company 75,000 customer according to quadratic equation estimated regression function? Show how you arrived at this value. Customers (in 1000s), X Line Maintenance Expense (in $1000s), Y X^2 Y^2 XY 25.3 484.6 640.09 234837.16 12260.38 36.4 672.3 1324.96 451987.29 24471.72 37.9 839.4 1436.41 704592.36 31813.26 45.9 694.9 2106.81 482886.01 31895.91 53.4 836.4 2851.56 699564.96 44663.76 66.8 681.9 4462.24 464987.61 45550.92 78.4 1037 6146.56 1075369 81300.8 82.6 1095.6 6822.76...
Your company just purchased a piece of equipment. The maintenance cost of the equipment is estimated...
Your company just purchased a piece of equipment. The maintenance cost of the equipment is estimated at $1,200 for the first year and it is to rise by $200 each year. How much should be set aside now to have enough to cover for the maintenance cost for the next 7 years? Assume payments are made at the end of each year and an interest rate of 4%.
A recession is predicted for a country moderates to low economic growth is predicted. Would you...
A recession is predicted for a country moderates to low economic growth is predicted. Would you adopt a Keynesian or Monetarist approach to formulating policy? Would a combination of the two approaches work? Why or why not?
c) Use your spreadsheet to estimate the position of the Risk line, using any necessary “reality...
c) Use your spreadsheet to estimate the position of the Risk line, using any necessary “reality checks”. In other words, justify or even make a clear statement of the inadequacies of what you have done and the need for further investigation. Estimate the Risk value.
One of the packed absorption columns on your processing line requires significant maintenance with a total...
One of the packed absorption columns on your processing line requires significant maintenance with a total cost of $435,250. With this maintenance, the column is expected to operate for an additional 10 years before requiring additional maintenance that is estimated to cost $263,425. The additional maintenance will further extend the lifetime of the column for another 10 years. The current operating costs for the column are $2,745 per month. As an alternative, your company could purchase a new packed absorption...
A. Assume you own the machinery above. Calculate the annual depreciation expense using the straight-line method....
A. Assume you own the machinery above. Calculate the annual depreciation expense using the straight-line method. Assume all machinery is bought at the first of the year.                                                                                        Machine                                  Cost                 Salvage Value             Useful Life 1) Tractor A                            50,000                20,000                                  5 2) Tractor B                             60,000                  0                                         7 B. Calculate the double-declining annual depreciate expense for each tractor. Calculate years 1 through 7 for both A and B.
Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving...
Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving a seminar on cost estimating. Make the following assumptions: You will charge $995 per person for a two-day class. You estimate that 30 people will attend the class, but you should keep an option to change this input. Your fixed costs include $500 total to rent a room for both days, setup fees of $500 for registration, and $300 for designing a postcard for...
1. Answer the following questions. What is the estimated (predicted) rate of return of the stock...
1. Answer the following questions. What is the estimated (predicted) rate of return of the stock today? ** Thames Inc.'s last dividend was $2 per share. The dividend is expected to grow at 5% per year. ** The stock currently sells for $26.25 per share. Select one: a. 13.0% b. 16.7% c. 5.2% d. 12.6% e. 11.0% 2. Continued from previous question.  What is the expected price of the stock one-year later? ** Thames Inc.'s last dividend was $2 per share....
The expected annual maintenance expense for a new piece of equipment is $10,000. This is Alternative...
The expected annual maintenance expense for a new piece of equipment is $10,000. This is Alternative A. Alternatively, it is possible to perform the maintenance every fifth year at a cost of $50,000 (Alternative B). In either case, maintenance will be performed in the fifth year so that the equipment can be sold for $100,000 at that time. If the MARR is 15% per year (before income taxes), which alternative should be recommended in each of these situations? a) Before...
your firm needs a computerized line boring machine which costs 80,000 and requires 20,000 in maintenance...
your firm needs a computerized line boring machine which costs 80,000 and requires 20,000 in maintenance for each year of its three year life. After three years, the salvage value will be zero. The machine falls into the class 10 equipment category (cca rate 30%). Assume a tax rate of 34% and a discount rate of 10%. What is the projects EAC? A) -2,374 B) -37,539 C) -32,905
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT