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 are cash equivalents reported in financial statements

The assistant controller discovered that the Bank incorrectly recorded a $3290 check as $329. How are cash equivalents reported in financial statements

  What is the single equivalent rate of discount

To promote the start of the sale, an additional discount of $65 was offered on the first day of the sale. What is the single equivalent rate of discount

  What is ayayais return on assets

Question - The following information is provided for Blossom Company and Ayayai Corp.: What is Ayayai's return on assets (rounded) for 2017

  Determining the super-variable costing

During its first year of operations, the company produced 32,000 units and sold 30,000 units. The company's only product is sold for $249 per unit.

  Prepare the amortization schedule

Using Excel, prepare the amortization schedule and then record all required journal entries that would be made by Barker on the following dates (a) December 31, 2014 (b) March 31, 2015; (c) June 30, 2015; (d) September 30, 2015; and (e) December 3..

  Analyse and interpret financial data and information

Analyse and interpret financial data and information, evaluate relevance and validity and synthesise a range of information in context of business situations.

  Post to the ledger t-accounts

Post to the ledger T-accounts - Apr. 1 Stockholders invested $22,410 cash in exchange for common stock of the corporation

  If bluebird accepts this additional business

Which includes $2.50 variable cost and $1.75 fixed cost. If Bluebird accepts this additional business, the effect on net income will be:$52,500 increase.$15,000 increase.$37,500 increase.$11,250 decrease.$37,500 decrease.

  What is the amount of cash flows from operating activities

What is the amount of cash flows from operating activities reported on the statement of cash flows prepared by the indirect method

  Describe six types of complex business documents

Describe the types of formatting features you may use when creating business documents. Describe six types of complex business documents

  Would you expect demand for audits to increase or decrease

In the time of economic hardship or recession, such as COVID-19, would you expect the demand for audits to increase or decrease

  Find the unadjusted balance of the Investment in BGC

The home office failed to take up a P12,000 credit memo from the branch. Find the unadjusted balance of the Investment in BGC

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