Question: How do I plot on Excel using a High-Low method, but I don't know how to put it into Excel and add regression lines on

How do I plot on Excel using a High-Low method, but I don't know how to put it into Excel and add regression lines on the graph I plotted. Please helppp

The Connors Company has assembled the following data pertaining to certain costs that cannot be easily identified as either fixed or variable. Connors Company has heard about a method of measuring cost functions called the high-low method and has decided to use it in this situation.

Cost Hours

$23,000 5,000

$26,000 6,450

$34,600 7,650

$42,000 10,000

$38,000 9,350

What is the estimated total cost at an operating level of 9,000 hours?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Copper Mountain Company has accumulated the following data over a six-month period: Indirect Labor Hours Indirect Labor Costs January ................................... 400 $ 6,000 February...

Excel Cost Estimation Project Assume the following data (where the xxx is the last three digits of your Panther ID): Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,XXX 2 1,400 103,XXX 3...

Month Machine hours (hrs) Maintenance cost($) 1 1,330 102,393 2 1,400 103,393 3 1,500 108,393 4 1,470 108, 393 5 1,620 116, 393 6 1,690 115, 393 7 1,490 107, 393 8 1,310 102, 393 9 1,450 106, 393 10...

Analyzing cost behavior using the high-low method. I need help determining the 2 months to use and help with the following steps for each of the prompts Analyzing Cost Behavior Part 1: Data Set and...

Overview: You are working as a business consultant, helping companies to better manage their costs. One of your clients is Supremo Burritos, a chain of 100 quick service burrito stores across the...

I will upload excel file. The question is in the excel file. Answer it in the same file . And please note the assignment has 3 sheets. so look at them carefully BUSI3320(All sections) Computer...

ORCO , a cooperative of organic family-owned farms outside of Madison, Wisconsin, has recently started a fresh produce club to provide support to the groups member farms and to promote the benefits...

You can submit an Excel file to support calculations, but please ?cut and paste? your solutions into the Word or PDF file. Be sure to show how you did your calculations. ACT 5140 - Accounting for...

Rock paper scissors (also known by other orderings of the three items, with "rock" sometimes being called "stone", or as Rochambeau, roshambo, or ro-sham-bo) is a hand game, usually played between...

A blast furnance burden contains 160 kg Fe203, 54 kg SiO2, 20 kg Al203, 100 kg CaCO3, and 78 kg C. For the smelting of the above burden 266 Nm3 of air is used. The hot metal produced contains 4...

Atmosphere, Incorporated has offered $ 8 6 0 million cash for all of the common stock in ACE Corporation. Based on recent market information, ACE is worth $ 7 1 0 million as an independent operation....

Scilab thank you in advace sovle what you can thanks 3.) Write a Scilab script named HW6 Prob_03.sce, that will calculate the following: A barometer is used to measure atmospheric pressure and is...