A cost analyst is examining the relationship between production volume and total manufacturing costs for a product line. The following data was collected from company records: Production Volume (units) Total Cost ($) 0 500 1,000 1,500 2,000 8,000 13,000 18,000 23,000 28,000 Determine the firm's fixed cost.

A cost analyst is examining the relationship between production volume and total manufacturing costs for a product line. The following data was collected from company records: Production Volume (units) Total Cost ($) 0 500 1,000 1,500 2,000 8,000 13,000 18,000 23,000 28,000 Determine the firm's fixed cost.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter19: Variable Costing (varcost)

Section: Chapter Questions

Problem 4R: To determine the effect of different levels of production on the company’s income, move to cell B7...

See similar textbooks

Similar questions

To determine the effect of different levels of production on the company’s income, move to cell B7 (Actual production). Change the number in B7 to the different production levels given in the table below. The first level, 100,000, is the current level. What happens to the operating income on both statements as production levels change? Enter the operating incomes in the following table. Does the level of production affect income under either costing method? Explain your findings.
Wachowski Company reported these cost data for the year 2017. Use the data to complete the following table. Total prime costs Total manufacturing overhead costs Total conversion costs Total product costs Total period costs
Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?
Scattergraph method Using the data in P4-2 and a piece of graph paper: 1. Plot the data points on the graph and draw a line by visual inspection, indicating the trend shown by the data points. 2. Determine the variable cost per unit and the total fixed cost from the information on the graph. 3. Determine the variable cost to be charged to the product for the year. 4. Determine the fixed cost to be charged to factory overhead for the year. 5. Do these answers agree with the answers to P4-2? Why or why not?
Contribution margin by segment The following information is for LaPlanche Industries Inc.: Determine the contribution margin for (A) Product YY and (B) West Region.
Determine the firm fixed cost? General accounting
Determine the firm fixed cost?
The graphs below represent cost behavior patterns that might occur in a company’s cost structure. The vertical axis represents total cost, and the horizontal axis represents activity output Required:For each of the following situations, choose the graph from the group a–1 that best illustrates the cost pattern involved. Also, for each situation, identify the driver that measures activity output.1. The cost of power when a fixed fee of $500 per month is charged plus an additional charge of $0.12 per kilowatt-hour used.2. Commissions paid to sales representatives. Commissions are paid at the rate of 5 percent of sales made up to total annual sales of $500,000, and 7 percent of sales above $500,000.3. A part purchased from an outside supplier costs $12 per part for the first 3,000 parts and $10 per part for all parts purchased in excess of 3,000 units.4. The cost of surgical gloves, which are purchased in increments of 100 units (gloves come in boxes of 100 pairs).5. The cost of tuition…
Lillibridge & Friends, Incorporated provides you with the following data for its single product: Sales price per unit Fixed costs (per quarter): Selling, general, and administrative (SG&A) Manufacturing overhead Variable costs (per unit): Direct labor Direct materials Manufacturing overhead SG&A Number of units produced per quarter a. Prime cost per unit b. Contribution margin per unit c. Gross margin per unit d. Conversion cost per unit e. Variable cost per unit Required: Compute the amounts for each of the following assuming that the production levels are within the relevant range if the number of units is 500,000 per quarter. Also calculate if the number of units increases to 600,000 per quarter. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. f. Full absorption cost per unit g. Variable production cost per unit h. Full cost per unit $ 140 1,500,000 4,500,000 $ 17 20 18 14 500,000 units 500,000 units 600,000 units 37.00 $ $ 37.00 55.00 $ 55.00
What is the firm's fixed cost on these general accounting question?
What is the constant for the estimating cost equation
Compute the following: Operating income under variable (direct) costing method Operating income under absorption costing method Operating income under throughput costing method