0 Assignment Question for Chapter 3: PROBLEM 3-14 High-Low Method; Scattergraph Analysis [LO2] Travis Metals heats...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
0 Assignment Question for Chapter 3: PROBLEM 3-14 High-Low Method; Scattergraph Analysis [LO2] Travis Metals heats copper ingots to a high temperature by placing them in a large oven. The heated ingots are then run through a shaping machine that forms them into wire. Due to the length of time it takes the oven to heat up, it is never turned off. When the ingots are placed in the oven the temperature is raised to a higher level. Once they are done being heated the oven temperature is turned back down until a new batch of ingots is ready to be heated. The following information shows the ingots processed and the power costs over the past 10 months. Meath January February March April May June July August September October Ingots 110 90 30 100 130 120 70 60 50 40 Power Cont $ 5,500 $4,500 $4,400 $5,000 $6,000 $ 5,600 $ 4,000 $3,200 $3,400 $2,400 2. Using the high-low method, estimate a cost formula for power costs. Express the formula in the form Y-a-bX 3. Predict total power costs in a month when 140 ingots are processed. Page 12 Required: 1. Using Microsoft Excel, prepare a scattergraph by plotting ingots processed and power costs on a graph. Use the Add Trendline feature in Excel to plot a line through the points of the graph. Do power costs appear to be related to the number of ingots processed in a month? Explain 0 Assignment Question for Chapter 3: PROBLEM 3-14 High-Low Method; Scattergraph Analysis [LO2] Travis Metals heats copper ingots to a high temperature by placing them in a large oven. The heated ingots are then run through a shaping machine that forms them into wire. Due to the length of time it takes the oven to heat up, it is never turned off. When the ingots are placed in the oven the temperature is raised to a higher level. Once they are done being heated the oven temperature is turned back down until a new batch of ingots is ready to be heated. The following information shows the ingots processed and the power costs over the past 10 months. Meath January February March April May June July August September October Ingots 110 90 30 100 130 120 70 60 50 40 Power Cont $ 5,500 $4,500 $4,400 $5,000 $6,000 $ 5,600 $ 4,000 $3,200 $3,400 $2,400 2. Using the high-low method, estimate a cost formula for power costs. Express the formula in the form Y-a-bX 3. Predict total power costs in a month when 140 ingots are processed. Page 12 Required: 1. Using Microsoft Excel, prepare a scattergraph by plotting ingots processed and power costs on a graph. Use the Add Trendline feature in Excel to plot a line through the points of the graph. Do power costs appear to be related to the number of ingots processed in a month? Explain
Expert Answer:
Answer rating: 100% (QA)
File Paste 128 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 ... View the full answer
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
In a study of the length of time it takes to play Major League Baseball games during the early 2008 season, the variable time of game appeared to be normally distributed, with a mean of 2 hours 49...
-
By measuring the amount of time it takes a component of a product to move from one workstation to the next, an engineer has estimated that the standard deviation is 5 seconds. a. How many...
-
The amount of time it takes light to travel from our Sun to the Earth is approximately _____ minutes. (Input a numerical value) 2) The speed of a future advanced spacecraft is 200,000,000 meters per...
-
Plot the six risks on a probability/impact matrix using the project impact matrix 2023 template. Write one to two sentences stating the rationale for how you determined the quadrant placement for...
-
During 2012, Transit Airlines paid salary expense of $42.4 million. At December 31, 2012, Transit accrued salary expense of $2.2 million. Transit then paid $2.2 million to its employees on January 3,...
-
A student government organization is interested in estimating the proportion of students who favor a mandatory "pass-fail" grading policy for elective courses. A list of names and addresses of the...
-
Hulus Hybrids has the following information for the years ending January 31 2010 and 2009: Requirements 1. Compute the rate of inventory turnover for Hulus Hybrids for the years ended January 31,...
-
Pratt & Whitney, a major aircraft engine manufacturer, wants to re-evaluate the transportation mode it uses to send unfinished parts to its joint-venture facility' in Chengdu, China.6 Annual demand...
-
Presented below are the financial statements of Maple Leaf Company, a public company, for the year ending 31 December 2020. Statement of Financial Position 31 December Assets Cash Accounts receivable...
-
Journalize all these transactions into a general ledger. Transactions May 1 Purchased merchandise from Keys Wholesale on account for $735.30, Invoice No 91 Dated May 1, terms 2/10, n30 May 2...
-
Discuss the possible types of international projects and possible problems that can be faced by international projects. [8 marks]
-
20. Which data structure is used to store elements in a sorted order? a. Stack b. Queue c. Tree d. Heap
-
Marketing Performance Systems : I have learned through the years that measuring marketing performance is critical to the existence of any business...A marketing performance system will allow the...
-
United Auto Workers are going on strike at new car manufacturing plants. At the same time, people are also holding onto their used cars longer due to economic uncertainty. Use the demand and supply...
-
Suppose Die Cast Aluminum Co. is a subcontractor for the auto industry and makes specialized auto parts. There is a bracket it manufactures that it sells for $1.00. The following table shows the...
-
Sunia is a senior lending officer at the ANZ Bank. He would like to develop a model that predicts defaults in loan payment. He insists that his model must include both accounting information and...
-
How does globalization impact cultural diversity and identity around the world?
-
Show that if A is any m n matrix, then Im A = A and AIn = A.
-
Victorian Windows is a small company that builds specialty wooden windows for local builders. For years the company assigned overhead costs to products based on direct labor-hours (DLHs). However,...
-
What adjustment is made for underapplied overhead on the schedule of cost of goods sold? What adjustment is made for overapplied overhead?
-
The principal purpose of the cash budget is to see how much cash the company will have in the bank at the end of the year. Do you agree? Explain.
-
Find the steady-state response of the hydraulic control valve shown in Fig. 4.4 (a) to the forcing functions obtained by replacing \(x(t)\) with \(F(t)\) and \(A\) with \(F_{0}\) in Figs. 1.114....
-
What is the basis for expressing the response of a system under periodic excitation as a summation of several harmonic responses?
-
True or False. The change in momentum is called impulse.
Study smarter with the SolutionInn App