Business, 19.06.2020 02:57 northpolea

Ethan Manufacturing Inc. 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: MonthMaintenance Costs Machine Hours 1$2,750 1,840 2 2,910 1,920 3 3,060 2,000 4 3,170 2,020 5 3,250 2,050 6 3,220 2,030 7 3,160 2,010 8 3,000 1,990 9 2,770 1,850 10 2,370 1,250 11 2,380 1,450 12 2,600 1,740 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.

Answers: 3

Show answers

Answers

Answer from: autumnguidry7628

Month Maintenance Machine Equation MAPE

costs hours error (Abs.)

1 $2,750 1,840 $269 9.78%

2 $2,910 1,920 $197 6.77%

3 $3,060 2,000 $135 4.41%

4 $3,170 2,020 $47 1.48%

5 $3,250 2,050 0 0%

6 $3,220 2,030 $8 0.25%

7 $3,160 2,010 $46 1.46%

8 $3,000 1,990 $184 6.13%

9 $2,770 1,850 $260 9.39%

10 $2,370 1,250 0 0%

11 $2,380 1,450 $210 8.82%

12 $2,600 1,740 $309 11.88%

60.37%

variable cost per unit = (highest activity cost - lowest activity cost) / (highest activity units - lowest activity units) = ($3,250 - $2,370) / (2,050 - 1,250) = $880 / 800 units = $1.10 per unit

fixed cost = $3,250 – ($1.10 x 2,050) = $995

Cost model = $995 + $1.10X

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

MAPE = 60.37% / 12 = 5.03%

Answer from: Quest

The answer is true a pertinent question is an appropriate question.

Answer from: Quest

Move their business to mexico.

Another question on Business

Business, 21.06.2019 22:30

Before contacting the news or print media about your business, what must you come up with first ? a. a media expertb. a big budgetc. a track recordd. a story angle

Answers: 1

Answer

Business, 21.06.2019 23:30

Select the correct answer. the word intestate means that a person has died with or without a will?

Answers: 1

Answer

Business, 22.06.2019 09:40

As related to a company completing the purchase to pay process, is there an accounting journal entry "behind the scenes" when xyz company pays for the goods within 10 days of the invoice (gross method is used for discounts and terms are 2/10 net 30) that updates the general ledger?

Answers: 3

Answer

Business, 22.06.2019 13:10

Trey morgan is an employee who is paid monthly. for the month of january of the current year, he earned a total of $4,538. the fica tax for social security is 6.2% of the first $118,500 earned each calendar year, and the fica tax rate for medicare is 1.45% of all earnings for both the employee and the employer. the amount of federal income tax withheld from his earnings was $680.70. his net pay for the month is .

Answers: 1

Answer

You know the right answer?

Ethan Manufacturing Inc. produces floor mats for automobiles. The owner, Joseph Ethan, has asked you...

Questions