Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exercise 22-18 a,c The controller of Oriole Industries has collected the following monthly expense data for analyzing the cost behavior of electricity costs. Total Total

image text in transcribed
image text in transcribed
Exercise 22-18 a,c The controller of Oriole Industries has collected the following monthly expense data for analyzing the cost behavior of electricity costs. Total Total Machine Hours Electricity Costs $2,160 2,970 3,540 4,640 3,220 4,910 4,120 3,800 5,160 4,340 3,300 6,070 210 570 675 Determine the fixed- and variable-cost components using regression analysis (We recommend the use of Excel.) (Round fixed cost to 3 decimal places e.g. 1.252 and variable cost to S decimal places e.g. 1.25125.) Fixed costs Variable-cost July August September October 4,120 3,800 5,160 570 675 600 360 720 3,300 6,070 Determine the fixed- and variable-cost components using regression analysis (We recommend the use of Excel.) (Round flixed cost to 3 decmal places e-g. 1.252 and varlable cost to 5 decimal places e.g. 1.25125.) Fixed costs Variable-cost What electricity cost does the cost equation estimste for a level of activity of 500 machine hours? (Round answer to 2 decimal places e.g. 1.25. Electricity costs By what amount does this differ from March's observed cost for 500 machine hours? (Round answer to 2 decimal places e.g. 1.25.) Amount differ

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Accounting Uk Gaap Volume 2

Authors: Alan Sangster, Frank Wood

1st Edition

0273718800, 9780273718802

More Books

Students also viewed these Accounting questions

Question

Simplify z11 ,all Variables represent nonnegative Numbers 81z

Answered: 1 week ago

Question

Understand human resources role in performance appraisals

Answered: 1 week ago