User Account

All Pages

What is the forecast for the annual maintenance cost

Assignment Help Business Management
Reference no: EM132998441

The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The manager believes that the cost of maintaining the tractors increases with their age. The following data was collected.

Age (years) / Yearly Maintenance Cost ($) / Age (years) / Yearly Maintenance Cost ($)

4.5 / 619 / 5.0 / 1194
4.5 / 1049 / 0.5 / 163
4.5 / 1033 / 0.5 / 182
4.0 / 495 / 6.0 / 764
4.0 / 723 / 6.0 / 1373
4.0 / 681 / 1.0 / 978
5.0 / 890 / 1.0 / 466
5.0 / 1522 / 1.0 / 549
5.5 / 987

a. Use Excel's least squares-linear regression module to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor.

b. If a section has 20 three-year-old tractors, what is the forecast for the annual maintenance cost?

Reference no: EM132998441

Questions Cloud

How do we know that we are done with analyzing : How do we know that we are done with analyzing? What criteria will you use?
Effects the validity of the contract : a. Sara plans to have a cafe business. She needs to buy a furniture to be used for the business. The furniture costs RM50,000. Empire Furniture, the supplier, i
How to be successful in college and graduate : You are to write a memo to a Freshman student explaining to them how to be successful in college and graduate in 4 years or less. You are to use business format
Calculate what the value of c : Suppose that X is a student's t distributed random variable. Use Excel to calculate what the value of 'c' is such that for 10 degrees of freedom P(X
What is the forecast for the annual maintenance cost : The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The m
Conduct a sensitivity analysis showing how sensitive project : Conduct a sensitivity analysis showing how sensitive the project is to revenues, fixed costs and to the required rate of return. Explain your results.
Elaborate on the relevance and reliability issues pertaining : Elaborate on the relevance and reliability issues pertaining to the recognition and measurement in accounting.
Several features of the model of ethics and values : Find a current headline that draws on several features of the model of ethics and values to deepen your insight of that issue. Apply the model to guide the ques
What is the inverse demand function : An economic consultant for X Corp, What is the inverse demand function, where in base on the demand function provided we can derived the P?

Reviews

Write a Review

Business Management Questions & Answers

  Governing various funding programs managers oversee

Given the various rules and regulations governing various funding programs managers oversee

  What conditions help managers

What conditions help managers determine which type of distance is most likely to affect the success of an international expansion?

  Create a strategic plan

Identify a current business problem through research. Based on this situation, create a strategic plan to identify the issue, provide a solution to the problem, and associate the scenario to a learning objective from our course.

  What are the city biggest basic and nonbasic activities

What are the city's biggest basic and nonbasic activities? What forms of transportation does the city use?

  Discuss the concept of organizational culture

What are the specific behavioral problems of multidisciplinary groups? Discuss the concept of organizational culture.

  Discuss the success of the software industry in india

Discuss the success of the software industry in India. How do the four factors in Porter's diamond explain the success of this industry over related industries in the country?

  Conduct online research about the current scientific

Conduct online research about the current scientific work being done to develop artificial photosystems. technology that is using sunlight to make food

  Corporate strategy

How a well-constructed corporate strategy create value for a firm.

  Prevailing political and economic conditions

Consider the current situation and prevailing political and economic conditions in Brazil, a BRIC country.

  Explain the importance of accrual accounting

Explain the importance of accrual accounting and proper application of the matching principle for the computation of contribution margins and break-even points

  Describe and explain what are the values created by steve

Describe and explain what are the values created by Steve Jobs to build Apple. Inc. sucessfully to become one of the most valuable innovation company

  Prepare paper on investigating the challenges

Prepare paper on Investigating The Challenges Faced Bysmall And Medium Enterprises' In Malawi, A Case Study Of Sme's In Blantytre, Malawi.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd