Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The cost data for xyz Furniture is for the year 2022 is as follows: Month Number of Tables Produced Factory Utility Expense January 550 $2,063

The cost data for xyz Furniture is for the year 2022 is as follows:

Month Number of Tables Produced Factory Utility Expense
January 550 $2,063
February 710 2,663
March 650 2,438
April 470 1,823
May 512 1,920
June 625 2,344
July 805 3,019
August 750 2,813
September 675 2,531
October 525 1,969
November 875 3,281
December 685 2,569

Required:

a. Using the high-low method, express the company's utility costs as an equation where X represents number of tables produced.

b. Predict the utility costs if 800 tables are produced.

c. Predict the utility costs if 600 tables are produced.

d. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of tables produced and utility expenses.

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

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

0130674842, 978-0130674845

Students also viewed these Accounting questions

Question

What kinds of Multiple Sclerosis exist?

Answered: 1 week ago

Question

=+d) What assumptions have you made to answer part c?

Answered: 1 week ago