By using the information given below calculate the net income under the traditional costing method. Show your calculations. (No beginning finished goods inventory.) Variable cost of goods sold per unit Fixed cost of goods sold per unit Variable operating expenses per unit Fixed operating expenses per unit Selling price Number of units sold Number of units produced 18,000 20,000 $4.00 $ 3.00 $1.50 $1.25 $12.00

By using the information given below calculate the net income under the traditional costing method. Show your calculations. (No beginning finished goods inventory.) Variable cost of goods sold per unit Fixed cost of goods sold per unit Variable operating expenses per unit Fixed operating expenses per unit Selling price Number of units sold Number of units produced 18,000 20,000 $4.00 $ 3.00 $1.50 $1.25 $12.00

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

Identify each cost below as variable (V), fixed (F), or mixed (M), relative to units sold. Explain your reasons Reason $ M Units Sold a. Total phone cost b. Materials cost per unit C. Manager's salary d. Depreciation cost per unit e. Total utility cost f. Total cost of goods sold 25 150 $ 35 3,000 60 400 3,125 50 200 $ 35 3,000 75 100V, F, or M 250 $ 300 35 35 3,000 3,000 2015 900 1,150 9,375 12,500 F 30 650 6,250 reasons 1. Does not change in total over wide ranges of volume/inversely proportional to the number of units produced while total cost remains constant. 2- It is directly proportional to the number of units produced. The total cost changes as volume changes and in direct proportion. 3-The total cost changes as volume changes, but not in direct proportion.
I se the following information to answer questions 1-6. Selling price per unit Luriable manufacturing cost per unit Fixed manufacturing cost per unit V'ariable selling cost per unit Fixed selling cost per unit Expected production and sales P100 20 30 25 10 1,000 units
Following information is related to Product X of Zempa Company: Current replacement cost Cost to distribute Historical cost Normal profit margin Selling price $230 $42 $215 $36 $245 If lower-of-cost-or-market rule (LCM Rule) is applied, then the value of Product X that would be reported in the balance sheet is: a. $215 b. $230 c. $203 d. $167
Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) Required: a. Assume that only one product is being sold in each of the following four case situations: Unit sold Sales Variable expenses Foxed expenses Operating income (loss) Contribution margin per unit $ Case #1 15,000 180,000 $ 100,000 120,000 50,000 $ $ Case #2 Case #1 Case #3 10,000 Case #2 70,000 $ 32,000 8,000 $ 12,000 $ 10 $ 13 Case #4 b. Assume that more than one product is being sold in each of the following four case situations: (Enter "Contribution margin ratio" in percent. Round your final answers to the nearest whole dollar amount.) Case #3 6,000 300,000 100,000 (10,000) Case #4
Which of the following types of cost is shown in this table of cost data? Cost per Unit $6,000 3,000 2,000 1,500 b. fixed cost Number of Units C. variable cost d. period cost 1 A WN 2 3 4
Skate World is a merchandising company that sells skateboards both at its retail store and its online store. Results for the most recent three months are shown below. Sales in units Sales Cost of goods sold Gross margin Selling and administrative expenses: Advertising expense Shipping expense Salaries and commissions Insurance expense Depreciation expense Total selling and administrative expenses Operating income July August 4,000 4,500 $400,000 $450,000 240,000 270,000 160,000 180,000 21,000 34,000 78,000 6,000 15,000 154,000 21,000 36,000 84,000 6,000 15,000 162,000 $ 6,000 $ 18,000 September 5,000 $ 500,000 300,000 200,000 21,000 38,000 90,000 6,000 15,000 170,000 $ 30,000
Which of the following types of cost is shown in the cost data below? Cost per Number of Unit Units $6,000 3,000 2,000 1,500 a. fixed cost b. mixed cost C. variable cost d. period cost 2. 3. 4.
The following information is available for Bramble Corp.: Sales Cost of goods sold $520000 0 0 0 0 300000 Total fixed expenses A CVP income statement would report contribution gross profit of $220000. contribution gross profit of $260000. Total variable expenses margin of $260000. margin of $370000. $150000 260000
Evaluate the quantity at which revenue equals to costs (break-even point). <use Goal seek> Assumptions: Fixed cost: 5000 Material costs per item: 2.25 Labor costs per item: 6.5 Shipping costs per 100 items: 200 Price per item: 12.99
An analyst is constructing a simple model to determine the gross and net profit of a product, given its profit per unit, quantity sold, and the total costs assigned to the product. The calculation for gross profit is Profit per Unit times Quantity. The calculation for Net Profit is Gross Profit minus Total Costs. A B 1. 2 Profit per Unit 8 3 Quantity |10,100 4 Gross Profit 5 6 Total Costs 6,100 7 8 Net Profit With the values for Profit per Unit, Quantity, and Total Costs shown above, what should the model return for the following calculated cells? Cell Value Gross Profit Net Profit
Considering the data given above, under variable costing and absorption costing, ending inventory would be valued at: Assuming sales price per unit is ₱15, under variable costing and absorption costing, net operating income would be:
Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) Required: a. Assume that only one product is being sold in each of the following four case situations: Unit sold Sales Variable expenses Fixed expenses Operating income (loss) Contribution margin per unit Sales Variable expenses Fixed expenses $ Operating income (loss) Average contribution margin (percentage) Case #1 20,100 241,200 $ 160,800 67,000 $ Case #2 S $ $ Case #1 134,000 42,880 10,720 S 10 S 8,700 20% b. Assume that more than one product is being sold in each of the following four case situations. (Enter "Contribution margin ratio" in percent. Round your final answers to the nearest whole dollar amount.) 534,000 $ Case #3 Case #2 13,400 434,000 282,100 108,500 93,800 Case #4 8,040 S 402,000…