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?

Answers

Answer 1

The estimated total cost at an operating level of 9,000 hours is $43,000. This is calculated by adding the fixed cost of $23,000 to the variable cost of $6.25 per hour multiplied by the number of hours worked (9,000 hours).

To plot on Excel using a High-Low method, you can follow these steps:

In Excel, create a new worksheet and enter the data from the Connors Company in the following format:

Hours | Cost

---|---

5000 | 23000

6450 | 26000

7650 | 34600

10000 | 42000

9350 | 38000

Select the data and then click on the "Insert" tab.

In the "Charts" group, click on the "Scatter" icon and then select the "Scatter with smooth lines and markers" option.

Excel will create a scatter chart with the data points plotted on the graph.

To add the regression line to the graph, right-click on any of the data points and then select the "Add Trendline" option.

In the "Trendline Options" dialog box, select the "Linear" option and then click on the "Display Equation on Chart" and "Display R-squared value on chart" checkboxes.

The regression line will show you the relationship between the cost and the hours worked. The slope of the line will give you the variable cost per hour, and the y-intercept will give you the fixed cost.

In this case, the slope of the line is $6.25 per hour, and the y-intercept is $23,000. This means that the variable cost per hour is $6.25, and the fixed cost is $23,000.

The estimated total cost at an operating level of 9,000 hours is $43,000. This is calculated by adding the fixed cost of $23,000 to the variable cost of $6.25 per hour multiplied by the number of hours worked (9,000 hours).

Total cost = Fixed cost + Variable cost

= 23000 + (6.25 * 9000)

= 43000

To learn more about total cost click here

https://brainly.com/question/31443323

#SPJ11


Related Questions

4.
Contrast the relationship that exists between entrepreneurs and investors in a business
enterprise.​

Answers

Answer:

see below

Explanation:

1. An entrepreneur is the business founder. He or she conceives the business ideas and focuses on growing it.  An investor considers existing business formed by the entrepreneur and focuses on its financial/commercial side.

2. The entrepreneur approaches an investor to finance the business. He draws a business plan and proposals to assure the investor of its viability. The investor approaches an entrepreneur if he is convinced of profits.

3. The entrepreneur manages the business but may also invest in it.  An investor only puts money in the business but is not involved in managing it.

What type of industry would Tim Hortons and McDonalds be classified as?

Answers

they would be classified as restaurants

A Balance Sheet does NOT show your company's (two answers are correct)


financial position over a specific period of time

liabilities

insurance coverage at a specific date in time

assets

Answers

Answer:

I think its the 1st and 3rd ones

Explanation:

When a site is unsafe, it means a. Your personal information may be used in ways you do not want c. Permission to use that site at school is always allowed b. That site is okay to visit often d. All of the above Please select the best answer from the choices provided A B C D

Answers

Answer:A, Your personal information may be used in ways you do not want

Explanation:

If it is a unsafe site than there for your personal information can go places you do not want them to.

When a site is unsafe, it means your personal information may be used in ways you do not want. Thus, option 'A' is the correct option.

What does it mean when a website is unsafe?

External connections to websites with phishing, malware, or unwanted software are known as unsafe domains. Phishing is when a website imitates another one in an effort to fool visitors into divulging personal or financial information. When you visit an insecure website, you run the risk of having your personal information compromised and/or having malicious malware installed on your system.

Additionally, you can fall prey to a phishing attack, or someone else might watch your activity or use your resources for their own gain. If the content you're seeking to view is harmful or misleading, a warning will appear. These websites are frequently referred to as phishing or virus sites. If you clicked on a phishing link, the first thing you should do is immediately unplug your device from the internet.

Learn more about the unsafe website, here:

https://brainly.com/question/27871014

#SPJ5

1. Give the three (3)
business resources​

Answers

Answer:

Financial Resources

Human Resources

Educational Resources

Explanation:

What is the difference between a salary and an hourly wage?​

Answers

Answer:

Explanation:

A salary stays the same amount no matter how many hours you work. An hourly wage, you get paid for each hour you work; you get payed on WHAT you work.

Match the financial statement with its description. To match them, click the Description and then click the Financial Report Name

Answers

Answer:

a-3 / b-2 / c-4 / d-1

Explanation:

Notes to financial statements: Includes a summary of significant accounting policies and explanations of specific items on the financial statements.

The notes are required by the full disclosure principle. Also referred to as footnotes. Provide additional information pertaining to a company's operations and financial position.

Report of independent registered public accounting firm: Attests to the fairness of the presentation of the financial statements.

is a process designed to provide reasonable assurance regarding the reliability of financial reporting.

Management's discussion and analysis of financial condition and results of operations (MD&A): Is written by the company to help investors understand the results of operations and the financial condition of the company.

Disclosure is mandatory where there is a known trend or uncertainty that is reasonably likely to have a material effect on the registrant's financial condition or results of operations

Financial statements: Includes the income statement, balance sheet, statement of stockholders' equity, and statement of cash flows.

are reports prepared by a company's management to present the financial performance and position at a point in time.

Financial statements refer to how company communicates their finance. The financial statement that reflects a company’s profitability is hereby given below.

Financial statements in sheets

The various accounting activities that precedes financial statements are hereby matched below:

A. Statement of retained earnings or owner's equity

Include information of owner's retained earnings and dividends.

B. Income statement - Revenues

Shows revenues and expenses over a period of time.

C. Statement of cash flow

shows money moving in and out, categorized by operations, investing and finance

D. Balance Sheet

A snapshot of a company's assets, liabilities and equity at a specific moment in time.

Therefore, the answers are Statement of retained earnings or owner's equity, Income statement - Revenues, Statement of cash flow, Balance Sheet respectively.

learn more about financial statement: https://brainly.com/question/24498019

The ability to organize and evaluate what you watch, hear, and read is known as

Answers

Answer:

critical thinking skills

Explanation:

the definition is this word

Your factory has a contract to produce a new folding chair. Your role as manager is to find the greatest efficiencies possible throughout the process, so you call a meeting with your planning department. One of your engineers suggests putting more workers on the line but breaking up the tasks into more individual steps. What is your greatest concern regarding this approach? A increased time spent in training B reduced production C poor conditions for workers D cost to hire skilled workers

Answers

Answer:

A

Explanation:

I took the test and it was right

What percent of the federal budget was spent on education in 2019?

Answers

Answer:

The President requests $59.9 billion in discretionary appropriations for the Department of Education in fiscal year 2019, an $8 billion or 12 percent reduction below the 2018 annualized Continuing Resolution (CR) level.

The role of the Federal Reserve Board of Governors is to:
A. loan money to multinational corporations.
B. set discount rates and reserve requirements.
O c. enforce monetary policy on Federal Reserve banks.
O D. establish new Federal Reserve districts.

Answers

The role of the Federal Reserve Board of Governors is to enforce monetary policy on Federal Reserve banks. Hence, Option C is correct.

What is monetary policy?

In macroeconomics, there is a policy whose duty is to make sure that policies that are made by the  Board of Governors have been applied to all the central banks. This policy is known as monetary policy, which manages the flow or supply of money to all the banks.

This policy also manages the interest rate. Just like other policies, monetary policy also has some tools, With the help of these tools, it is easy to manage the policy. Tools are named as operations for the open market, requirements of the reserve, and lastly rate of discount.

Therefore, Option C is correct.

Learn more about monetary policy from here:

https://brainly.com/question/28038989

#SPJ5

Which position in a business manages cash and cash equivalents?


-financial accountant
-controller
-cost accountant
-treasurer

Answers

Answer:

Financial Accountant

Explanation:

What are the 4 steps to branding

Answers

Answer:

Here are four steps to building a successful brand.

1 Define how you want to be perceived. When your customers have finished using your product or service, how do you want them to describe their experience? ...

2 Organize your business based on this promise. ...

3 Communicate your promise. ...

4 Be consistent.

Explanation:

when did Toronto​ pearson​Airport​(Canada) start​ using​ technology​ or​ scanner​

Answers

Answer:

Canada's busiest airport will soon start to use artificial intelligence- powered technology to detect weapons. The technology can detect both metallic and non-metallic weapons ranging from  guns and knives to explosives, according to Liberty Defense Holdings Ltd., a  Vancouver-based company which first marketed the technology.  Known as Hex wave, the technology works by capturing radar images, then using  artificial intelligence to analyze them for concealed weapons in bags or under clothing.   Liberty's CEO, Bill Riker explained, "radar essentially is emitting this form of energy,  it's reflecting off a person and it's identifying any items on a person's body that don't  belong on a body." The technology will start getting deployed at Pearson in the Spring of 2020 in a bid to boost  security, according to the Greater Toronto Airports Authority, which runs Pearson.

The Break-Even Point in your business is when


your company has repaid all of its debt

your company has exceeded its start up expectations

your company makes enough in revenue regularly to cover its expenses

your company repays all of the start up cost funding

Answers

Answer: In this letter you want to make sure that you are being clear and concise, so as to avoid any confusion about what your relationship will be in the future (ended). This means that you want to avoid any potential legal liability, and explain yourself in order to show that you are being fair and reasonable in your request.

Explanation:

I need to submit this today, can you help me?


What are Washington D.C.’s people eating habits?

What are some economic facts about Washington DC?

What are some facts about Washington DC?

Culture and customs of Washington DC?

Travel information (Dubai to Washington DC)?

Answers

Answer:

I'm sure they eat well. have u try looking it up on goggle first

waht do an engineer and an architect do?​

Answers

Create fix, build stuff, and many other things use google you’ll find more info on it too
An engineer builds products and buildings while architects plan out the way the engineers will build for a stable, working build.

Select the best alternative for the following questions:
i. Which of the following transactions are not recorded in book keeping?
a) Sold Goods on Credit.
b)
Introduce capital in the business.
c) Resignation of marketing manager.
d) Drawing cash from business for personal use.
..​

Answers

Answer:

c. the resignation

Explanation:

this would not affect the bottom line of the company and is therefore irrelevant

The correct answer is c

What is the advantage of developing criteria for assessing the effectiveness of business products and processes?
A. Assessment criteria are answers.
B. Assessment criteria are inexpensive.
C. Assessment criteria provide you with a list of relevant things to measure.
D. Assessment criteria provide you with a list of people to contact to learn more about process mentoring.

Answers

Answer:

.Assessment criteria provide you with a list of relevant things to measure.

Explanation:

Assessment criteria provides a list by which one can measure success or failure of a business products and processes.

Answer:

c

Explanation:

A local Barnes and Noble paid a $79.99 net price for each hardbound atlas. The publisher offered a 20% trade discount. What was the publisher’s list price?

Answers

Answer:

i believe it would be 63.99

Explanation:

Based on the information given the publisher’s list price is:$99.99.

Using this formula

List price=Net price/(100%-2=Trade discount)

Where:

Net price=$79.99

Trade discount=20%

Let plug in the formula

List price=$79.99/(100%-20%)

List price =$79.99/80%

List price= $99.99

Inconclusion the publisher’s list price is:$99.99.

Learn more here:https://brainly.com/question/18265503

Sam has take-home pay every month of $800. He anticipates that his expenses will add up to $675 for the month. In a zero-based budget, why is it important that she put the extra $125 in SOME budget category?

Answers

Answer:

see below

Explanation:

The Zero-based budgeting technique assumes there will be no balance bought forward nor balance carried forward. Budget preparation for a particular period must start from zero or scratch. Each expense must be on merit. Income and expenses must match.  In the zero-based budget, the difference between income and expenditure must be zero.

If Sam has an income of $800 and expenses of $675, she has to re-work her costs again to ensure they match her income. The zero-based budget demands she draws her expenses list again and comes up with a way of spending the $125 difference.

Stear Corp. decides to deposit $1,000 in its bank account. This cash was paid from the cash register of the company. What will be the entry made by the accountant in the company’s journal?
A.
Cash in Bank Account (debit) 1,000 Cash Account (credit) 1,000
B.
Cash Account (debit) 1,000 Cash in Bank Account (credit) 1,000
C.
Cash in Bank Account (debit) 1,000 Register Account (credit) 1,000
D.
Deposit Account (debit) 1,000 Cash Account (credit) 1,000

Answers

Answer:

Cash Account (debit) 1,000

Cash in Bank Account (Credit) 1,000

Explanation:

Given

[tex]Amount = \$1,000[/tex]

Required

Write a journal entry

In this case:

The company deposits $1000.

This means that, $1000 will be debited from the company's cash account.

So, the entry for that will be:

Cash Account (debit) 1,000

In the same vein, $1000 will be credited into the company's bank account.

So, the entry for that will be:

Cash in Bank Account (Credit) 1,000

Answer:

A

Explanation:

Research some examples of organizations that experienced bad publicity and how they dealt with it. Write a paper detailing your findings.

Answers

Answer:

did you finish it cuase i got the same one

Explanation:

Admit the error, apologize, and present a solution if you or your company is receiving negative press as a result of anything you did incorrectly. Negative publicity won't disappear if you ignore it.

What do you mean by Negative publicity?

When damaging material is revealed, negative PR or publicity can take many different forms in company and can impact everything from sales to your reputation.

Various forms of unfavorable PR for your company could include: negative coverage of your business in the media, online, in publications, or on television.

In particular, we contend that by raising product awareness, unfavorable publicity might boost sales and purchase likelihood.

Negative publicity should therefore affect products differently depending on whether they are recognized or unknown. This viewpoint is supported by three investigations.

Your brand's reputation can be severely damaged in a matter of minutes by false information, negative reviews, and nasty social media remarks. Even worse, rumors spread swiftly and negatively impact the reputation of your company.

Negative publicity can have a significant impact on how potential customers see your brand. When customers publicly disparage a company, product, or service, this is known as bad publicity.

Bad publicity includes posting or publishing negative evaluations on websites, review pages, and social media accounts.

Learn more about Negative publicity, here

https://brainly.com/question/15561429

#SPJ2

The ______is a financial statement detailing a firm's assets, liabilities, and owners' equity.
A. balance sheet
B. statement of cash flows
C. manufacturing statement
D. income statement

Answers

I had this question before, the answer I got correct is D

The income statement is a financial statement detailing a firm's assets, liabilities, and owner's equity. Thus, option 'D' is the correct option.

What is an income statement?

One of a company's financial accounts, an income statement or profit and loss account, lists the company's revenues and costs for a specific time period. It describes the process through which revenues are converted into net income or net profit.

A period of time is represented by an income statement (as does the cash flow statement). The balance sheet, on the other hand, only depicts one point in time. There are two ways to create an income statement. The Single Step Income Statement calculates the net income by adding up all receipts and deducting all costs.

In order to get at the net income, the Multi-Step income statement makes a number of calculations, beginning with the gross profit and moving on to operational expenditure estimation. then, after taking the gross profit into account, you get income from operations.

Therefore, option 'D' (income statement) is the correct option.

Learn more about income statements, here:

https://brainly.com/question/14308954

#SPJ6

which of the following is a material used for salad making and dessert that need great care to ensure long shelf life?

A. glass
B. aluminium
C. cast iron
D. stainless steel ​

Answers

Answer:

I thoughts B becaisedvfdhjdshjhh

How are technology and technical profession related

Answers

Without technology there would be no technical profession because technology is what technical profession is based off of

Mary is earning a weekly salary of $521.60 as a payroll clerk. She has accepted a new assignment in the tax-processing department. In her new position, she will be paid an annual salary of $30,534.00. How much more would she earn per week in her new position?

Answers

Answer:

$65.60

Explanation:

Mary's current is $521.60.

In her new position, she will be earning $30,534.00.  Her new weekly income will be as follows. Assuming one year has 52 weeks.

New pay = $30,534.00/ 52

New pay =587.20

In her new job, she will earn more by( $587.20 - $521.60.) =$65.60

=$65.60

Why are personal care aides expected to be paid so little in spite of being in such great demand?

Answers

Answer: Because they were the least educated, (something to do with that).

Explanation:

Does anyone know what the definition of expanding manufacturing is?

Answers

Definition - To make your business grown larger or faster by diversifying your current product line

Hope this help :)

In which way are competitors stakeholders in a business?
A. They invest in competition
B. Competitors need to provide services
C. Competitors will want to position itself competitively
D. They enjoy learning about the competition

Answers

Answer:

B

Explanation:

l think so if u get it wrong and am sorry

Other Questions
Solve each system by elimination.1) -10x 3y=-126x + 3y = 0Plz help A case study in Chapter 12 analyzed purchasing power parity for several countries using the price of Big Mac. Go on the Website of "The Economist" newspaper The Big Mac Index and find the data on the Big Mac Index for (December 2021 or later) and save it to your computer. Download and attach the article about the Big Mac Index to your assignment. For actual exchange rates, you may use internet. \begin{tabular}{l|ll} Country & Price of a Big Mac (In local currency) & Predicted Exchal Exange Rate (Per SUS) \\ \hline Hungary & & \\ \hline & & \\ \hline Thailand & & \\ \hline & & \\ \hline China & & \\ \hline \end{tabular} a) [12 marks] Using the data table from "The Economist", fill in the data on local price of the Big Mac and actual exchange rate. Then compute the predicted exchange rate of the local currency per U.S. dollar. (Note that the U.S. price of a Big Mac is $5.81 and in the article U.S currency can be used as base currency, not Canadian dollar). Make sure to show your calculations in the predicted exchange rate column. [Please don't print the entire data table from the website.] For actual exchange rates, you may use internet. [Check the US dollar price of Big Mac on the website to confirm if it is $5.81, if not, use the latest price available\} a) [12 marks] Using the data table from "The Economist", fill in the data on local price of the Big Mac and actual exchange rate. Then compute the predicted exchange rate of the local currency per U.S. dollar. (Note that the U.S. price of a Big Mac is $5.81 and in the article U.S currency can be used as base currency, not Canadian dollar). Make sure to show your calculations in the predicted exchange rate column. [Please don't print the entire data table from the website.] For actual exchange rates, you may use internet. [Check the US dollar price of Big Mac on the website to confirm if it is $5.81, if not, use the latest price available\} b) [7 marks] Summarize the article in one paragraph, highlighting the main points. c) [6 marks] Looking at the exchange rates predicted by the Purchasing Power Parity, how well do you think does the theory of purchasing power parity explain exchange rates? This should be based on the data in your table for selected countries above. The most beautiful place Ive ever seen is Egypt helppooIn 2021, what was the maximum average tax rate for corporations? A) 33% B) 38% C) 39% D) 25% E 21% Sm the highest quality form of deed is the?need no explanation just ans Sharpe ration in the financial market: S = F/ Sharpe ration in the real estate market from Cheng, Lin and Liu (2013-FR):S = F(+()) + (1- ()(t+t) () +2 (1-) + () 3. [5 points] Cheng, Lin and Liu (2017-JRER) develop the mixed-asset portfolio by extending the Modern Portfolio Theory (MPT) as follows, min, , T { w [ (u + ) + (T + (1 - ) + 2 (1 - ) T )][] } . s.tTu + Tu + (1 - - )Briefly discuss the difference between these two models and explain why the real estate should have its own asset allocation model. A fax machine requires an installed subscriber base before the customer can benefit from buying a fax machine. In such industries, which of the following statements are true? Group of answer choices :Entry barriers are low in the emerging phase of the industryEntry barriers are high in the emerging phaseEntry barriers do not change in the industryEntry barriers are high in the late phase of the industry need help please!!! the options are emotional, cognitive, or compassionate empathy Methanol, ethanol, and n-propanol are three common alcohols. When 1.00 g of each of these alcohols is burned in air, heat is liberated as shown by the following data: (a) methanol (CH3OH), 22.6 kJ/g; (b) ethanol (C2H5OH), 29.7 kJ/g; (c) n-propanol (C3H7OH), 33.4 kJ/g. Calculate the heats of combustion of these alcohols in kJ/mol. What did the National Labor Relations Act (NLRA) do? Select one: A. placed a limit on the dues that unions could charge its members B. prevented companies from hiring temporary employees during strikes C. legitimized the rights of employees to engage in collective bargaining and to strike D. allowed employees to use company time to attend union meetings safetyweb is a web-based service that helps parents protect their children's online reputation, privacy, and safety. which of the following approaches to identifying an opportunity was most likely the impetus for safetyweb? What was unique (different) about Aztec farming techniques? *A.)They grew corn and avocados.B.)They were the first to use pesticideC.)They grew crops on man-made floating islands.D.)They farmed on terraces (steps) 36) What is the mass of a 4.259 g/cm substance which takes up 250.00 cm of space? On July 8, Compusoft receives $300,000 from a customer toward a cash sale of $1.20 million for customized computer equipment to be completed on August 1. The remaining $900,000 payment is received upon delivery of the product on August 1. The equipment had a total production cost of $650,000. What journal entries should Compusoft record on July 8 and August 1? Assume Compusoft uses the perpetual inventory system. Here is another revenue and production cost schedule for Paulo Pasta. Quantity Total Cost OSHIR23 0 5 10 15 20 25 30 Total Revenue 0 50 100 150 200 250 300 60 70 95 120 170 230 320 Marginal Revenue a. Calculate marginal revenue. b. Calculate marginal cost. c. What is the profit-maximizing quantity? Marginal Cost Font 3. Identify the type of barrier to entry. a. It made little sense for another competitor to enter the public utility market because it was cost-prohibitive to construct another facility to provide electricity due to market. b. In attempt to run their competitors out of business, Ginny Gymnastics offered lessons at below cost. c. Reebok owns this image below. Reebok d. Paulo Pizza owns 100% of wheat market. e. Max Music develop a new technology in producing sound in a more effective way. f. North County awarded Riza Restaurant with a license to sell fast food at their local airport. 4. This is the revenue and cost schedule for Shelly Shoes, which sells dress shoes in a monopolistically competitive market. Quantity Price 0 10 20 30 35 40 $37 $31 $26 $22 $20 $19 Total Revenue Marginal Revenue Total Cost Marginal Cost $240 $310 $390 $530 $690 $900 Average Cost a. Calculate total revenue and average cost for each quantity. b. Calculate marginal revenue and marginal cost for each quantity. c. What price and quantity will maximize profits for Bradie Brownies? d. When looking at the profit-maximizing level of output, does it achieve allocative efficiency? Pane 5. Below is an oligopoly version of the prisoner's dilemma dealing with two major video game makers Nintendo Raise prices Lower Prices Raise prices No 60 Sony Playstation Nin +90 S000 Se 10 Lower prices NW+10 Nin 30 CHI TI 530 a. If they cooperate, would they choose a high price or low price? b. What happens if they do not cooperate? If they don't, should they choose a high or low price? c. Regardless of what their competitor does, should they raise or lower prices? Where is Loup City Municipal located in relation to the city?A) Northeast approximately 3 miles.B) Northwest approximately 1 mile.C) East approximately 7 miles. We will also discuss the ethical issues below and how to avoid ethical dilemmas. - Behavioral rules Ethics of purpose Ethics of principle Ethics of consequence Deception Misrepresenting ones position Bluffing Falsification Find the first term and the common difference. -2, -9, -16, -23, ... a d= what are some postives about 2020. Hollow spherical iron container with outer diameter 20 cm and thickness 0.4 cm is filled with iced water at 0C. If the outer surface temperature is 5"C, determine the approxi- mate rate of heat loss from the sphere, in kW, and the rate at which ice melts in the container. The heat from fusion of water is 333.7 kJ/kg