Assume that a company wants to separate a mixed cost into its variable and fixed elements...

Assume that a company wants to separate a mixed cost into its variable and fixed elements for cost estimation purposes. It provided the following information:

Month	Units Produced		Mixed Cost
January	1,050	$	11,045
February	1,150	$	11,870
March	1,100	$	11,560
April	1,250	$	12,100
May	950	$	10,800
June	1,280	$	12,210
July	990	$	10,970
August	1,010	$	11,005

Assuming the company produces 1,200 units in September, using least-squares regression, the estimated total amount of the mixed cost would be closest which of the following? (Note: Round your estimate of the variable cost per unit to the nearest penny.)

Multiple Choice

$11,950
$11,908
$12,002
$11,985

Expert Solution

Month	Units Produced	Mixed Costs	Units produced^2	Units Produced*Mixed Costs
January	1050	11045	1102500	11597250
February	1150	11870	1322500	13650500
March	1100	11560	1210000	12716000
April	1250	12100	1562500	15125000
May	950	10800	902500	10260000
June	1280	12210	1638400	15628800
July	990	10970	980100	10860300
August	1010	11005	1020100	11115050
Total	8780	91560	9738600	100952900

Unit Variable Cost (b) =	nΣxy − (Σx)(Σy)
	nΣx2 − (Σx)2

=	8100952900-(878091560)
=	8*9738600-(8780)^2

=	3726400/820400
=	4.54217

Total Fixed Cost (a) =	Σy − bΣx
	n

=	91560-4.542(8780)/8
=	6459.96


b) Equation for utility cost	y=a+bx

a	Fixed cost
b	Unit variable cost
x	Units produced

1200 units cost	6459.96+(4.54217*1200)
	11911

Option B $11908 is the correct answer.

ekkarill92 answered 1 year ago

Assume a merchandising company uses the high-low method to separate any mixed costs into their variable...

Assume a merchandising company uses the high-low method to separate any mixed costs into their variable and fixed elements. It provided the following income statements: May June July Sales in units 4,800 5,000 5,500 Sales $ 168,000 $ 175,000 $ 192,500 Cost of goods sold 86,400 90,000 99,000 Gross margin 81,600 85,000 93,500 Selling and administrative expenses: Advertising 17,000 17,000 17,000 Shipping 16,800 17,500 19,250 Salaries and commissions 29,600 30,000 31,000 Total selling and administrative expenses 63,400 64,500 67,250 Net...

What is the meaning of step-variable cost, step-fixed cost, semi-variable (or mixed) cost, and curvilinear cost?...

What is the meaning of step-variable cost, step-fixed cost, semi-variable (or mixed) cost, and curvilinear cost? Can you explain with one example?

A company’s electricity cost is a mixed cost - partly fixed and partly variable. If during...

A company’s electricity cost is a mixed cost - partly fixed and partly variable. If during the month with the largest electricity use the company used 15,000 machine hours and had an electricity cost of $36,000 and during the month with the smallest electricity use the company used 7,000 machine hours and had an electricity cost of $20,000. 1. Its variable cost per machine hour (as determined by the high-low method) would be ____________ 2. Its fixed cost per month...

1–4 Distinguish between (a) a variable cost, (b) a fixed cost, and (c) a mixed cost.

1–1 What are the three major types of product costs in a manufacturing company?1–2 Define the following: (a) direct materials, (b) indirect materials, (c) direct labor,(d) indirect labor, and (e) manufacturing overhead.1–3 Explain the difference between a product cost and a period cost.1–4 Distinguish between (a) a variable cost, (b) a fixed cost, and (c) a mixed cost.

What Variable cost is: What Fixed cost are: What Mixed cost are: Calculate contribution margin Per...

What Variable cost is: What Fixed cost are: What Mixed cost are: Calculate contribution margin Per unit. 3. methods ONLY need to know 2 of them: NOT the graph method. 21.How to calculate Break even: & definition of break even 22. Calculate marginal safety: 23. CVP income statement is & how to calculate it : 24. What a Master budget is: Why we use budgets & why its useful

1. Define variable cost, fixed cost, and mixed cost. 2. Describe what happens to the net...

1. Define variable cost, fixed cost, and mixed cost. 2. Describe what happens to the net income of a company under each of the following assumptions: (a) Units sold are less than break-even units. (b) Units sold are greater than break-even units. (c) Units sold are equal to the break-even units

Variable, Fixed, and Mixed Costs Classify the following costs of activity inputs as variable, fixed, or...

Variable, Fixed, and Mixed Costs Classify the following costs of activity inputs as variable, fixed, or mixed. Identify the activity and the associated activity driver that allow you to define the cost behavior. For example, assume that the resource input is “cloth in a shirt." The activity would be "sewing shirts," the cost behavior "variable," and the activity driver "units produced." Prepare your answers in the following format: Activity Cost Behavior Activity Driver a. Flu vaccine Assembling Delivering orders Filing...

Describe the concept of cost behavior and the differences between fixed, variable, and mixed costs. Differentiate...

Describe the concept of cost behavior and the differences between fixed, variable, and mixed costs. Differentiate product costs from period costs and direct costs from indirect costs. Compare the different types of income statements and the purposes of each. Please explain to the best of your knowledge one or more of the following: 1- Product Cost . 2- Period Cost.. 3- Opportunity Cost 4- Sunk Cost 5- Shut -down Costs 6- Applied manufacturing overhead.

Business plan for Guest house , describing about Fixed,variable and mixed cost with break even cost,...

Business plan for Guest house , describing about Fixed,variable and mixed cost with break even cost, an example describing about Guest house cost structure?

Classify the costs below as: Product-Direct, Product-Indirect, or Period AND Variable cost, Fixed cost, or Mixed...

Classify the costs below as: Product-Direct, Product-Indirect, or Period AND Variable cost, Fixed cost, or Mixed cost. Below are budgeted income statements at different team levels, use the information to answer the questions below: Number of Teams 15 25 30 Product Direct, Product Indirect or Period Fixed/ Variable Sales $1,500 $2,500 $3,000 Cost of Goods Sold Direct Materials 75 125 150 Direct Labor 150 250 300 Applied Overhead 575 625 650 Gross Profit $700 $1,500 $1,900 Selling...

Question