Calculate the mean absolute percentage error

Assignment Help Accounting Basics
Reference no: EM133155439

Question - Ethan Manufacturing Incorporated produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours:

Month

Maintenance Costs

Machine Hours

1

$ 2,740

1,830

2

2,900

1,910

3

3,050

1,990

4

3,160

2,010

5

3,240

2,040

6

3,210

2,020

7

3,150

2,000

8

2,990

1,980

9

2,760

1,840

10

2,360

1,240

11

2,370

1,440

12

2,590

1,730

Required -

1. What is the cost equation for maintenance costs using the high-low method?

2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1.

Reference no: EM133155439

Questions Cloud

Determine the weighted average number of shares : Determine the weighted average number of shares to determine the basic earnings per share for 2021
Determine the labor rate variance : The labor used was 11,700 hours at an average rate of $20.50 per hour. The actual overhead spending was $96,200. Determine the labor rate variance
Determine the price of the bonds issued on august : Determine the price of the bonds issued on August 1, 2022 using Excel. Remember that the bonds pay semiannual interest. Please label this calculation
How much money will you make in book from the mortgage : After 5 years, market interest rate goes up to 6.5%. How much money will you make in book from the mortgage
Calculate the mean absolute percentage error : Ethan Manufacturing Incorporated produces floor mats for automobiles. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed
Determine the actual setup activity cost driver rate : Based on the information presented above, determine the actual setup activity cost driver rate based on (1) the number of setups
Watchman-Style Situation and Service-Style Situation : Describe a situation in which the Watchman style of policing would be used in the career field.
What size of the deposit peter makes while he is saving : He saves for 18 years, and then converts his savings into an annuity that pays him $300. What size of the deposit Peter makes while he is saving
What is the estimated number of species for the family : What is the distribution of the family and What is the estimated number of species for the family

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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!

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