The table below shows monthly data collected on production costs and on the number of units produced over a twelve month period. Month Discussion Question July August September October November December January February March April May June Total Production Costs $230,000 250,000 260,000 220,000 340,000 330,000 200,000 210,000 240,000 380,000 350,000 290,000 Level of Activity (Units Produced) 3,500 3,750 3,800 3,400 5,800 5,500 2,900 3,300 3,600 5,900 5,600 5,000 a) Determine the variable cost per unit and the fixed cost using the high-low method. b) What is the equation of the total mixed cost function? c) Based on the High-Low method, what is the total production costs if 6,500 units are produced? d) Prepare the scatter diagram and insert the trendline or line of best-fit. Use a scale of 2 cm to represent 1,000 units on the x-axis & 2 cm to represent $50,000 on the y- axis. e) Using the line of best-fit, determine the company's fixed cost per month and the variable cost per unit. (Use 0 & 5,000 units.) f) Which of the two methods appear more appropriate? Explain your answer.

The table below shows monthly data collected on production costs and on the number of units produced over a twelve month period. Month Discussion Question July August September October November December January February March April May June Total Production Costs $230,000 250,000 260,000 220,000 340,000 330,000 200,000 210,000 240,000 380,000 350,000 290,000 Level of Activity (Units Produced) 3,500 3,750 3,800 3,400 5,800 5,500 2,900 3,300 3,600 5,900 5,600 5,000 a) Determine the variable cost per unit and the fixed cost using the high-low method. b) What is the equation of the total mixed cost function? c) Based on the High-Low method, what is the total production costs if 6,500 units are produced? d) Prepare the scatter diagram and insert the trendline or line of best-fit. Use a scale of 2 cm to represent 1,000 units on the x-axis & 2 cm to represent $50,000 on the y- axis. e) Using the line of best-fit, determine the company's fixed cost per month and the variable cost per unit. (Use 0 & 5,000 units.) f) Which of the two methods appear more appropriate? Explain your answer.

Name: The table below shows monthly data collected on production costs and
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: The table below shows monthly data collected on production costs and on the number of unitsproduced over a twelve month period.MonthJulyAugustDiscussion QuestionSeptemberOctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneTotal ProductionCosts$23

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: Silver Products has presented the following information for the past eight months operations: Month…

A: There are three forms of cost : 1. Variable cost 2. Fixed cost 3. Semi-variable cost The high-low…

Q: To follow is information about the units produced and total manufacturing costs for Pine Enterprises…

A: Formula: Total cost = Variable cost + fixed cost Sum of both variable and fixed cost derives the…

Q: Assume the following information for a company that produced 10,000 units and sold 8,000 units…

A: Variable cost per unit remains constant per unit. Fixed cost is constant in total. Contribution…

Q: The manufacturing costs of Mocha Industries for three months of the year are as follows: Total…

A: Solution:-a Calculation of the variable cost per unit of Using the high-low method as follows…

Q: The manufacturing costs of Calico Industries for 3 months of the year are as follows: Total Cost…

A: Answer with all workings are as follows.

Q: Jason Inc. shows the following manufacturing costs for the first four months of the year:…

A: The objective of the question is to determine the variable costs per unit using the high-low method.…

Q: Frazier Manufacturing Company collected the following production data for the past month: Units…

A: We need to calculate variable cost per unit= (Total cost at high level of activity - Total cost at…

Q: give me all answer

A: Detailed explanation:High Low Method :Highest Overhead cost -----45,500 in AprilLowest Overhead cost…

Q: The manufacturing costs of Mocha Industries for three months of the year are as follows: Total Cost…

A: The high-low method is used to differentiate the mixed cost. The mixed cost is the combination of…

Q: Assume the following information for a company that produced 10,000 units and sold 8,000 units…

A: Absorption costing method is a method of costing in which product cost is calculated by adding…

Q: The following information pertains to the JAG Corporation for the month of July 100,000 units were…

A: Absorption Costing In the Absorption costing techniques the calculation of total cot of goods…

Q: The following information is available for a company's maintenance cost over the last seven months.…

A: A variable cost is one that changes depending on the amount produced or sold by the company.…

Q: The manufacturing costs of Mocha Industries for 3 months of the year are as follows: Total Cost…

A: High-Low method: It is used to split the total costs into fixed costs and variable costs. Following…

Q: Assume the following information for a company that produced 10,000 units and sold 9,000 units…

A: Step 1: Gross margin can be calculated by subtracting the Cost of goods sold (product cost) from the…

Q: The manufacturing costs of Mocha Industries for three months of the year are as follows: Total Cost…

A: Variable costs: These are the costs that vary with the number of units produced. The more the units…

Q: The manufacturing costs of Mocha Industries for three months of the year are as follows: Total Cost…

A: Unit Cost Highest Point June 3,170 100,106 Lowest Point April 1,560 97,208…

Q: Coraline Co. has the following cost and activity data. Month Units Total Cost September 80,000…

A: The High-low method of determining cost variance considers the highest and lowest cost being…

Q: The manufacturing costs of Calico Industries for 3 months of the year are as follows: Total Cost…

A: Variable cost can be calculated as change in total cost divided by change in volume under the high…

Q: During the months of April through September, the following total utility costs were paid at various…

A: Variable cost per unit = (Highest activity cost - Lowest activity cost) / (Highest activity units -…

Q: $ 20 per unit Fixed overhead $ 8,400,000 per year Variable selling and administrative expenses $ 11…

A: Answer : a) Income statement using Variable costing : particular Amount Sales revenue…

Q: The manufacturing costs of Calico Industries for three months of the year are provided below. Total…

A: High Low Method - High Low method is used bifurcate the fixed cost and variable cost from the total…

Q: The manufacturing costs of Calico Industries for three months of the year are provided below:…

A: The high-low method of costing determines the per unit variable cost by dividing the difference…

Q: The manufacturing costs of Callico Industries for three months of the year are provided below: Total…

A: The High-low method is a cost computation technique that separates variable and fixed cost from…

Q: Good units manufactured Value-added hours of manufacturing time Total units manufactured Total hours…

A: Throughput per hour = Total good units manufactured / Total hours of manufacturing time

Concept explainers

Variance Analysis

In layman's terms, variance analysis is an analysis of a difference between planned and actual behavior. Variance analysis is mainly used by the companies to maintain a control over a business. After analyzing differences, companies find the reasons for the variance so that the necessary steps should be taken to correct that variance.

Standard Costing

The standard cost system is the expected cost per unit product manufactured and it helps in estimating the deviations and controlling them as well as fixing the selling price of the product. For example, it helps to plan the cost for the coming year on the various expenses.

Topic Video

Question

The table below shows monthly data collected on production costs and on the number of units
produced over a twelve month period.
Month
July
August
Discussion Question
September
October
November
December
January
February
March
April
May
June
Total Production
Costs
$230,000
250,000
260,000
220,000
340,000
330,000
200,000
210,000
240,000
380,000
350,000
290,000
Level of Activity
(Units Produced)
3,500
3,750
3,800
3,400
5,800
5,500
2,900
3,300
3,600
5,900
5,600
5,000
a) Determine the variable cost per unit and the fixed cost using the high-low method.
b) What is the equation of the total mixed cost function?
c) Based on the High-Low method, what is the total production costs if 6,500 units are
produced?
d) Prepare the scatter diagram and insert the trendline or line of best-fit. Use a scale of 2
cm to represent 1,000 units on the x-axis & 2 cm to represent $50,000 on the y-
axis.
e) Using the line of best-fit, determine the company's fixed cost per month and the variable
cost per unit. (Use 0 & 5,000 units.)
f) Which of the two methods appear more appropriate? Explain your answer.
1/1

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: Note:

VIEW

Step 2: a) Calculation of Variable costs and fixed costs:

VIEW

Step 3: b) Equation of total mixed costs:

VIEW

Step 4: c) Calculation of Total production cost:

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 5 steps

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

The manufacturing cost of Mocha Industries for three months of the year are provided below: Total Cost Production April $106,178 1,820 Units May 111,945 2,550 Units June 120,951 3,690 Units (a) Using the high-low method, determine the variable cost per unit. Round your answers to two decimal places.$fill in the blank 1 per unit (b) Using the high-low method, determine total fixed costs.$fill in the blank 2
Sims Company began operations on January 1. Its cost and sales information for this year follow. Direct materials $ 30 per unit Direct labor $ 50 per unit Variable overhead $ 20 per unit Fixed overhead $ 8,400,000 per year Variable selling and administrative expenses $ 11 per unit Fixed selling and administrative expenses $ 4,000,000 per year Units produced 105,000 units Units sold 75,000 units Sales price $ 360 per unit 1. Prepare an income statement for the year using variable costing.2. Prepare an income statement for the year using absorption costing.
Jason Inc. shows the following manufacturing costs for the first four months of the year. Manufacturing Costs for the First Four Months Months Production in Units Total Costs January 2,500 $33,750 February 1,800 $29,900 March 3,000 $36,500 April 2,600 $34,300 Using the high-low method, determine the variable costs per unit. (Round intermediate calculations and your final answer to two decimal places.) Group of answer choices $14.39 $12.17 $13.50 $5.50
The manufacturing costs of Calico Industries for 3 months of the year are as follows: Total Cost Production (units) April $111,100 276,200 May 82,600 163,200 June 106,300 244,600 Using the high-low method, the variable cost per unit and the total fixed costs are Round your intermediate calculations to two decimal places. a.$2.50 per unit and $4,205, respectively b.$4.50 per unit and $4,205, respectively c.$0.25 per unit and $42,050, respectively d.$0.45 per unit and $21,025, respectively
Part 1 The total costs and output volume of Example Ltd for the preceding six months are given in the following table: Month Output volume Total costs October 85,000 685,000 November 80,000 700,000 December 75,000 715,000 January 65,000 655,000 February 55,000 640,000 March 75,000 730,000 Required: Use the high-low method to express the cost function for the total monthly costs. The output volume expected to be produced in April is 60,000 units. Estimate the total cost in April. Explain whether you will use this cost function to predict the total costs for 82,000 units.
Cost Classification Discussion Question The table below shows monthly data collected on production costs and on the number of units produced over a twelve month period. Month Total Production Costs Level of Activity (Units Produced) July $230,000 3,500 August 250,000 3,750 September 260,000 3,800 October 220,000 3,400 November 340,000 5,800 December 330,000 5,500 January 200,000 2,900 February 210,000 3,300 March 240,000 3,600 April 380,000 5,900 May 350,000 5,600 June 290,000 5,000 Determine the variable cost per unit and the fixed cost using the high-low method. What is the equation of the total mixed cost function? Based on the High-Low method, what is the total production costs if 6,500 units are produced? Prepare the scatter diagram and insert the trendline or line of best-fit. Use a scale of 2 cm to represent 1,000 units on the x-axis & 2 cm to represent…
The manufacturing cost of Mocha Industries for three months of the year are provided below: Total Cost Production April $85, 160 1,600 Units May 89,064 2,240 Units June 95, 225 3,250 Units (a) Using the high - low method, determine the variable cost per unit. Round your answers to two decimal places. $ fill in the blank 1 per unit (b) Using the high-low method, determine total fixed costs. $ fill in the blank 2
Farrow Company reports the following annual results. Contribution Margin Income Statement Per Unit Annual Total Sales (240,000 units) $ 15.00 $ 3,600,000 Variable costs Direct materials 2.00 480,000 Direct labor 4.00 960,000 Overhead 2.50 600,000 Contribution margin 6.50 1,560,000 Fixed costs Fixed overhead 2.00 480,000 Fixed general and administrative 1.50 360,000 Income $ 3.00 $ 720,000 The company receives a special offer for 24,000 units at $12 per unit. The additional sales would not affect its normal sales. Variable costs per unit would be the same for the special offer as they are for the normal units. The special offer would require incremental fixed overhead of $96,000 and incremental fixed general and administrative costs of $103,000. (a) Compute the income or loss for the special offer.(b) Should the company accept or reject the special offer? Compute the income or loss for the special offer. (Round your "Per Unit" answers to 2…
Farrow Company reports the following annual results. Contribution Margin Income Statement Sales (200,000 units) Variable costs Direct materials Direct labor Overhead Contribution margin Fixed costs Fixed overhead Fixed general and administrative Income Per Unit $ 15.00 Annual Total $ 3,000,000 2.00 400,000 4.00 800,000 2.50 500,000 6.50 1,300,000 2.00 1.50 400,000 300,000 $ 3.00 $ 600,000 The company receives a special offer for 20,000 units at $13 per unit. The additional sales would not affect its normal sales. Variable costs per unit would be the same for the special offer as they are for the normal units. The special offer would require incremental fixed overhead of $80,000 and incremental fixed general and administrative costs of $86,000. (a) Compute the income or loss for the special offer. (b) Should the company accept or reject the special offer? Complete this question by entering your answers in the tabs below. Required A Required B Compute the income or loss for the special…
I need help with part D under journal entries recorded my plump corporation. "record the entry to eliminate 60% of the unrealized gross profit on the inventory purchase from Slim"
Norwood Company has the following information for July: Sales $440,000 Variable cost of goods sold 198,000 Fixed manufacturing costs 70,400 Variable selling and administrative expenses 44,000 Fixed selling and administrative expenses 26,400 Determine the following for Norwood Company for the month of July: a. Manufacturing margin $fill in the blank 1 b. Contribution margin $fill in the blank 2 c. Operating income $fill in the blank 3
Sims Company began operations on January 1. Its cost and sales information for this year follow. Direct materials $ 40 per unit Direct labor $ 60 per unit Variable overhead $ 40 per unit Fixed overhead $ 6,600,000 per year Variable selling and administrative expenses $ 11 per unit Fixed selling and administrative expenses $ 4,000,000 per year Units produced 110,000 units Units sold 80,000 units Sales price $ 360 per unit 1. Prepare an income statement for the year using variable costing.2. Prepare an income statement for the year using absorption costing.