Key Data Analytics Problem Su21Data for Summer Corporation's electricity costs is shown below.MonthMachine HoursTotal CostJanuaryFebruaryMarch300$2,500$3,000$3,600$4,500$3,200$4,900$4,100$3,800$5,100$4,200$3.300$6,100350500690AprilMay400June700650JulyAugustSeptemberOctober520680630November350December720Required:Please compute the variable-cost element (slope) and fixed-cost element (intercept) usingregression analysis using the template provided separately. Once your assignment is completed,save your file to your desktop (including your last name in the title), then submit the assignmentto the applicable folder in D2L. Thank you.

Explanation Regarding Calculation: Using Data Analysis Tool under Data in Excel we can get…

Answered: Please compute the variable-cost…

Please compute the variable-cost element (slope) and fixed-cost element (intercept) using regression analysis using the template provided separately. Once your assignment is completed,

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter13: Budgeting And Standard Costs

Section: Chapter Questions

Problem 13.6.2MBA

See similar textbooks

Related questions

Q: f the following statements related to cost ?estimation methods is true .a None of the given answers…

A: Option d is correct The three methods determine a slope and an intercept…

Q: R-squared is a measure of a. The spurious relationship between cost and activity D. The fxed cost…

A: R-Square measures that how much variation of a dependent variable is explained by a independent…

Q: On a graph, the Total Variable costs line appears to be horizontal in nature. True False

A: Cost: In accounting, the cost is related to monetary value spend on raw material, services, and…

Q: Which of the following statements related to cost estimation methods is false? The least-squares…

A: Following is the answer to the given question

Q: High-low and regression cost estimation methods are alike in that they both: Select one: O a. Have a…

Q: Paint Produced

A: Variable cost an be computed as, Variable cost = (Cost at highest activity - Cost at lowest…

Q: Analyze the given vertical analysis and compute for the quick ratio

A: Quick ratio = (Current assets - Inventories - Prepaid expenses) / Current liabilities

Q: Define each of the following terms: d. Modified internal rate of return (MIRR) method

A: Modified Internal Rate of Return (MIRR): The modified internal rate of return (MIRR) method…

Q: Assume that every asset has the same expected return and variance. Furthermore, all assets have the…

A: Variance is a statistical tool used to measure the extent to which the returns are spread from the…

Q: Which of the following is NOT true of regression techniques for estimating costs?

A: Cost: Cost can be defined as the cash and cash equivalent which is incurred against the products…

Q: Distinguish among the shapes of a “normal” yield curve, an “abnormal” curve, and a“humped” curve.

A: The graphical representation of expected return, provided by the company to its investors during the…

Q: Which of the following statements related to cost estimation methods is true ? a . Only high -low…

A: When the total cost for the expenses change or does not change with the change in the output, it…

Q: Which method of forecasting is most widely used? a. Regression analysis. b. Exponential smoothing.…

A: Regression analysis method of forecasting is the most widely used method of forecasting....

Q: f the regression method indicated the intercept = $30 and the slope = $20 for a cost function, the

A: Slope and intercept show a linear relationship between 2 variables.

Q: What is the difference between a linear and a nonlinear cost function? Give an example of each type…

A: Cost Function:Cost function represents the basic change comes in the total cost due to the change in…

Q: Assume that only the specified parameters (that is, variables) change in a sensitivity analysis. The…

Q: xplain the shape of the Markowitz (that is, mean-variance) efficient frontier, specifically what…

A: Markowitz (that is, mean-variance) efficient frontier-It is also known as mean - variance model and…

Q: When using the high-low method, should you base the high and low observations on the dependent…

A: Cost Function:Cost function represents the basic change comes in the total cost due to the change in…

Q: Explain the reasoning underlying the name of the weighted-average method.

A: The reason in underlying the name of the weighted average method is explained as below,

Q: Which method is used to see if a relationship between the cost driver and total cost exists?…

A: Cost drivers means activity units that will cause change in total cost for example, number of…

Q: Explain the concept of iso-expected return lines, iso-variance ellipses, and the critical line and…

A: Minimum variance frontier: It is a frontier that identifies those portfolios that have a minimum…

Q: Compute contribution margin using variable com

A: Variable costing is the method of costing, where only the variable costs are assigned to the cost of…

Q: Differentiate between variance analysis and sensitivity analysis

A: Managers of small businesses can benefit from both variance and sensitivity analyses when trying to…

Q: The regression line in a scatterplot is also known as a(n): O A. R-squared line. O B. high-low line.…

A: A regression line seems to be a line that is used to define how a set of data behaves. In other…

Q: Explain how the high-low method determines:a. The variable portion of a semivariable cost.b. The…

A: This method is used to segregate variable cost and fixed cost. In this method, highest level of…

Q: 2) Which of the following techniques is not used to analyze cost behavior? A) Least-squares…

A: Cost Accounting: It is the process of collecting, recording, analyzing the cost, summarizing cost,…

Q: In describing the cost formula equation, Y = a + bX, which of the following is correct:

A: The cost volume formula is denoted by - Y= a + bx where- “Y” is total cost “a” is the total fixed…

Q: Define each of the following terms:f. Residual value

A: Introduction: Residual value is one of the elements of leasing computation or process. It defines…

Q: Which of the following items would be useful to management in deciding whether to investigate the…

A: Standard costs are the budgeted costs related with the production, manufacturing and selling of…

Q: Which of the following statements related to cost estimation methods is true? The low-high method is…

A: All four methods of cost estimation has its own pros and cons. For quick estimate requirement,…

Q: Which of the following statements related to cost estimation methods is false? O a. The…

A: When some cost is showing combined effect of variable and fixed cost i.e. it is semi variable and…

Q: An easy way to estimate the variable and fixed costs components of a mixed cost is by: 1. a scatter…

A: There are two main cost estimation methods used to estimate amounts of fixed and variable costs are…

Q: Complete the standard cost variance analysis

A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Q: Which of the following statements related to cost estimation methods is false? O a. The most complex…

A: Cost estimation methods means by which method variable costs and fixed costs of the business can be…

Q: Which of the following methods of cost estimation relies on only two data points?A. the high-low…

A: Cost accounting is one of the important branch of accounting, under which costs are being…

Q: Describe the two basic differences between the weighted average and the FIFO method.

A: Inventory: Inventory refers to the stock of goods purchased, utilized and maintained by the company…

Q: Which of the following statements related to cost estimation methods is true? O a. The most complex…

A: Option c is correct.

Q: Which of the following statements is true? Select one: one: a. The most complex of the cost…

A: High-low method: It is the method of estimating the variable cost per unit and the fixed costs by…

Q: List the variable overhead variances, and briefly describe each.

Q: Least-squares regression is a statistical method for identifying cost behavior. True or False True…

A: According to the given question, we are required to give the answer that the statement is true or…

Q: Define a nonlinear cost function.

A: Cost Function: Cost function represents the basic change that comes in the total cost due to the…

Q: Fill in the blanks. a. In multiple linear regression analysis, the independent variables are called…

A: Fill in the blanks: Predictor variable: Predictor variable in a regression in the independent…

Concept explainers

Manufacturing Costs

Manufacturing cost is the total cost of procuring or producing a product. In other words, the manufacturing cost is the cost that an individual or business owner undertakes for the manufacturing of goods.

Question

Key Data Analytics Problem Su21
Data for Summer Corporation's electricity costs is shown below.
Month
Machine Hours
Total Cost
January
February
March
300
$2,500
$3,000
$3,600
$4,500
$3,200
$4,900
$4,100
$3,800
$5,100
$4,200
$3.300
$6,100
350
500
690
April
May
400
June
700
650
July
August
September
October
520
680
630
November
350
December
720
Required:
Please compute the variable-cost element (slope) and fixed-cost element (intercept) using
regression analysis using the template provided separately. Once your assignment is completed,
save your file to your desktop (including your last name in the title), then submit the assignment
to the applicable folder in D2L. Thank you.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

1. Given that selling, distribution and administrative costs associated with the V380PRO brand of WIFI SMART camera bulbs for the quarter were $27,255, $42,400 and $145,600 respectively, prepare an income statement for Sim-Jo-La (V380PRO) for the quarter ended June 30, 2020.
14. Micky2, Inc. sells two products X and Y. Data concerning the company for July follow: Product X: sales - P200,000; variable expense - P50,000; and traceable fixed expenses - P80,000. For Product Y: sales - P300,000, variable expenses - P100,000 and traceable fixed expenses - P150,000. In addition there were common fixed expenses of P70,000 in July. What was the entire company's net income ? P50,000 P70,000 P150,000 P120,000
Calculate the new total Marginal Income and Net Profit/Loss, if an increase in advertising expenseby R100 000 is expected to increase sales by 400 units. INFORMATIONSamcor Limited manufactures tables. The following information was extracted from the budget for the year ended 30 June 2022:1. Total production and sales 2 400 units2. Selling price per table R1 2003. Variable manufacturing costs per table:Direct material R288Direct labour R192Overheads R964. Fixed manufacturing overheads R216 9605. Other costs:Fixed marketing and administrative costs R144 000Sales commission 5%
5. Calculate the direct material from the following information: Direct expenses RO 90,000, Direct labor RO 20,000, manufacturing overheads RO 30,000 and prime cost RO 170,000. a.RO 21,000 b.RO18,000 c.RO 60,000 d.RO 20,000 6. Which of the following are used for calculating economic order frequency? i. Total annual consumption ii. No of order per year iii. Buying cost per order iv. 365 days a.i and ii b.ii and iv c.iii and iv d.i and iv
Consider a firm with a 2010 revenue of S60 million and cost of goods sold of $25 million lf the balance shert amount show $4million of inventory and $1.5 million ofproperty, plant & equipment how many weeks of suppiy does the fim bolat(2 weeksinoneyear)(use 2 decimals)Select oneO a.8.33O b.6.25Oc 13.75O d. 400Oe 12.50
Ma2. Q4 Bundoora Enterprises operates a single-product entity. Data relating to the product for 2020 were as follows: Annual Volume 45,000 Units Selling price per unit $65 Variable manufacturing cost per unit $25 Annual fixed manufacturing costs $155,000 Variable marketing and distribution costs per unit $15 Annual fixed non-manufacturing costs $445,000 a) Calculate and interpret the break-even in units for 2020. b) Calculate and interpret the margin of safety in both units and sales dollars. c) Calculate and interpret the profit achieved in 2020.d) Changes in marketing strategy are planned for 2021. This would increase variable marketing and distribution costs by $15 per unit and reduce fixed non-manufacturing costs by $100,000 per year. Calculate and interpret the units that would need to be sold in 2021 to achieve the same profit as in 2020.
In applying the high-low method, what is the fixed cost? Month Miles Total Cost January 86000 $182000 February 60000 150000 March 78000 178000 April 92000 200000 $22000 $28000 $56250 $32000
. Consider the following information: ITEM SALES(Units) SALES VARIABLE COST A 9000 $54000 5.95 B 12000 60000 3.75 C 15000 60000 3.50 D 25000 75000 1.75 Costs of the period are as follows (salaries $45000, rent $10000, depreciation $8000, furniture and computers $24000, raw materials $ 120,000, insurance $5000, periodic maintenance $4000, interest expense $3000, utilities (fixed) $4000, property tax $3000, advertising $9000 (set at the beginning of the year), and new cars $62000). What is the breakeven point for all items? How many units of item A, B, C, & D are needed to breakeven? Calculate the profit of item A.
3. FedExpress has the following information about its truck fleet miles and operating costs:Year Miles Operating2017 400,000 $256,0002018 480,000 $280,0002019 560,000 $320,000What is the best estimate of total costs using the high-low method if the expected fleet mileage for 2020 is 500,000 miles?A. $288,000.B. $296,000.C. $256,000.D. $320,000. Give workings for your answer
Profitability Analysis Razerian makes production for audio. A total of 500 hours in January 2021 is available per month in this operation beause they face COVID 19, so they must decrease their productive hours. Data concerning the company’s four products appear below: Headphone Earbuds Speaker Bluetooth Home theather Monthly demand in units 80 120 100 140 Hours required in operation per unit 0.6 1.8 0.4 2.5 Unit contribution margin $12 $36 $8 $50 Variable Expenses $8 $20 $5 $30 No fixed costs could be avoided by modifying how many units are produced of any product or even by dropping any one of the products. Question: Within this month, calculate the contribution margin and what should Razerian do if they want to get optimum margin?
Profitability Analysis Razerian makes production for audio. A total of 500 hours in January 2021 is available per month in this operation beause they face COVID 19, so they must decrease their productive hours. Data concerning the company’s four products appear below: Headphone Earbuds Speaker bluetooth Home teather Monthly demand in units 80 120 100 140 Hours required in operation per unit 0.6 1.8 0.4 2.5 Unit contribution margin $12 $36 $8 $50 Variable expenses $8 $20 $5 $30 No fixed costs could be avoided by modifying how many units are produced of any product or even by dropping any one of the products. Within this month, calculate the contribution margin and what should Razerian do if they want to get optimum margin? Suppose that you’re Razerian’s Business Director, what should you take place to get the optimum sales revenue?
Biblio Files CompanyContribution Margin Income StatementFor the Year Ended December 31, 20Y8 Sales $379,000 Variable costs: Manufacturing expense $151,600 Selling expense 15,160 Administrative expense 60,640 (227,400) Contribution margin $151,600 Fixed costs: Manufacturing expense $76,750 Selling expense 8,000 Administrative expense 10,000 (94,750) Operating income $56,850 Sales Mix Biblio Files Company is making plans for its next fiscal year, and decides to sell two new types of bookshelves, Basic and Deluxe. The company has compiled the following estimates for the new product offerings. Type ofBookshelf Sales Priceper Unit Variable Costper Unit Basic $5.00 $1.75 Deluxe 9.00 8.10 The company is interested in determining how many of each type of bookshelf would have to be sold in order to break even. If we think of the Basic and Deluxe products as components of one overall enterprise product called…