G Following are sales and other operating data for the three products made and sold by Marine Enterprises:Marine EnterprisesSalesManufacturing costs:FixedVariableSelling and administrative expenses:FixedVariableTotal costsNet income (loss)ProductProduct BExpected change in revenueExpected change in VOHExpected change in Sell & Admin.Expected change in Operating IncomeSubmit All PartsABсTotal$153,000 $90,400 $247,500 $490,900In view of the net loss shown for Product B, company management is considering dropping that product.All variable costs are direct costs and would be eliminated if Product B were dropped; all fixed costs areindirect costs and would not be eliminated. Assume that the space used to produce Product B would be leftidle.$14,600 $34,100 $29,600 $78,300110,700 33,300 132,100 276,100Would you recommend the elimination of Product B? Give supporting computations.Select an answer5,20032,100 9,30046,60012,2602,260 4.800 5.200$132,760 $104,300 $176,200 $413,260$20,240 ($13,900) $71,300 $77,640

Operating earnings are a type of financial measurement that shows how much money a business makes…

Following are sales and other operating data for the three products made and sold by Marine Marine Enterprises Sales Manufacturing costs: Fixed Variable Selling and administrative expenses: Fixed Product A B с Total $153,000 $90,400 $247,500 $490,900 $14,600 $34,100 $34,100 $29,600 $78,300 110,700 33,300 132,100 276,100 5,200 32,100 9,300 46,600

Following are sales and other operating data for the three products made and sold by Marine Marine Enterprises Sales Manufacturing costs: Fixed Variable Selling and administrative expenses: Fixed Product A B с Total $153,000 $90,400 $247,500 $490,900 $14,600 $34,100 $34,100 $29,600 $78,300 110,700 33,300 132,100 276,100 5,200 32,100 9,300 46,600

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

II. George Corporation has the following information for the current year: Selling price per unit Variable costs per unit Fixed costs Required: Prepare a cost-volume-profit graph identifying the following items: Total fixed costs line Total variable costs line Total costs line Total revenues line Breakeven point in sales dollars Breakeven point in units A. B. C. D. E. F. G. H. Dollars (S) Profit area Loss area 6,000 5,000 4,000 3,000 2,000 1,000 S 10.00 6.00 S $1,000.00 0 100 200 300 400 Qty (# Units) 500
Net Income Planning Selected operating data for Oakbrook Company in four independent situations are shown below. Fill in the blanks for each independent situation. Sales Variable expense Fixed expense Net income (loss) before tax Units sold Unit contribution margin Contribution margin ratio $ $ A $350,000 0 a. 0 b. $25,000 30,000 $5.20 $ B 0 C. $ $ $111,000 $62,000 $15,000 0 d. $7.00 C 0 e. 0 f. $ $53,200 $28,800 0.4 D $520,000 0 g. $178,000 $(22,000) 0 h.
The following income statements illustrate different cost structures for two competing companies: Income Statements Number of customers (a) Sales revenue (a $200) Variable cost (ax $140) Contribution margin Fixed cost Net income Company Name Hill 200 $40,000 N/A 40,000 (28,000) $12,000 Creek 200 $40,000 (28,000) 12,000 0 $12,000 Required a. Reconstruct Hill's income statement, assuming that it serves 400 customers when it lures 200 customers away from Creek by lowering the sales price to $120 per customer. b. Reconstruct Creek's income statement, assuming that it serves 400 customers when it lures 200 customers away from Hill by lowering the sales price to $120 per customer. Complete this question by entering your answers in the tabs below.
Following information is related to Product X of Zempa Company: Current replacement cost $230 Cost to distribute $42 Historical cost Normal profit margin Selling price $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.
Halland Ltd prepared its segmented income statement as shown above Sales Variable expense Contribution margin $ Traceable fixed expenses $ Common fixed expenses $ Net profit $ O A. $667,000 O B. $1,385,000 O C Division A Division B Company 800,000 $ 400,000 $ $673,000 $ $ Breakeven point in $ of Halland Ltd is O D. $385,000 400,000 $ 250,000 $ 160,000 $ 90,000 $ 200,000 $1,000,000 80,000 $ 120,000 $ 100,000 $ 40,000 $ 60,000 $ 480,000 520,000 350,000 200,000 150,000
The single-column CVP income statements shown below are available for Wildhorse Company and Blossom Company, Sales Variable costs Contribution margin Fixed costs Net income Wildhorse Wildhorse Co. Blossom $495,000 239,000 256,000 1000 156,000 $100,000 Blossom Co. Degree of Operating Leverage $495,000 (a1) Compute the degree of operating leverage for each company. (Round answers to 2 decimal places, e.g. 1.15.) $ 51,000 444,000 344,000 $100,000 (b) Assuming that sales revenue increases by 10% (due to a 10% increase in the number of units sold), prepare a single-plumn CVP income statement for each company. Wildhorse Company $ tA $ Blossom Company
Remember: Gross profit = SP- CP Activity 1.2 enti Complete the following table: Table 1.2: Finding the cost price, the gross profit or the selling price No Cast price Gross prafit Selling price 1.2.1 R5 600 R8 700 1.2.2 R3 400 30% 1.2.3 R6 800 R12 700 1.2.4 R17 500 R35 000 The owner of an enterprise has to calculate both the gross and the net profit. A business has certain operating expenses thai must be deducied from the gross profit to get the net profit. Examples of operating expenses are: • Salaries Wages • Rent paid/rent expense • Advertisements • Stationery. The cost of advertising the business is one example of an operating expense. Gross profit minaş operating expenses equals net profit."
Understanding CVP relationships Calculate the missing amounts for each of thefollowing firms:Units Selling Variable Costs Contribution Fixed OperatingSold Price per Unit Margin Costs Income (Loss)Firm A 11,200 $24.00 ? $100,800 $41,300 ?Firm B 8,400 ? $18.20 ? 64,500 $32,940Firm C ? 7.30 4.20 10,850 ? (6,750)Firm D 4,720 ? 51.25 41,064 48,210 ?
Required information [The following information applies to the questions displayed below.] Information for Pueblo Company follows: Sales Revenue Less: Total Variable Cost Contribution Margin Weighted average CM ratio Product A Product B $ 60,000 $ 31,490 $ 28,510 Required: Determine Pueblo's (overall) weighted-average contribution margin ratio. Note: Do not round intermediate calculations. % $ 57,000 $ 11,800 $ 45,200
The following income statements illustrate different cost structures for two competing companies: Income Statements Company Name Gibson Jordan Number of customers (a) Sales revenue (a x $200) Variable cost (a x $185) Variable cost (a x $0) Contribution margin 89 89 $ 17,800 $ 17,800 N/A (16,465) N/A 17,800 (16,465) $ 1,335 1,335 Fixed cost Net income 1,335 Required a. Reconstruct Jordan's income statement, assuming that it serves 178 customers when it lures 89 customers away from Gibson by lowering the sales price to $100 per customer. b. Reconstruct Gibson's income statement, assuming that it serves 178 customers when it lures 89 customers away from Jordan by lowering the sales price to $100 per customer.
Crane, Inc. has three divisions: Bud, Wise, and Er. The results of operations for May, 2022 are presented below. Units sold Revenue Less variable costs Less direct fixed costs Less allocated fixed costs Net income Bud 2,700 $63,000 28,800 12,600 5,400 $16,200 Wise 4,500 $45,000 23,400 17,100 9,000 $(4,500) Er 1,800 $36,000 14,400 10,800 3,600 $7,200 Total 9,000 $144,000 66,600 40,500 18,000 $18,900 All of the allocated costs will continue even if a division is discontinued. Crane allocates indirect fixed costs based on the number of units to be sold. Since the Wise division has a net loss, Crane is concerned that it should be discontinued. Crane thinks that if the division is closed, that sales at the Bud division will increase by 12% while sales at the Er division will stay the same.
The following income statements illustrate different cost structures for two competing companies: Income Statements Company Name Baird Adams 88 $ 21,120 (15,840) N/A 88 Number of customers (a) Sales revenue (a X $240) Variable cost (a x $180) Variable cost (a x $0) Contribution margin Fixed cost $ 21,120 N/A 21,120 (15,840) 5,280 Net income $ 5,280 $4 $ 5,280 Required a. Reconstruct Baird's income statement, assuming that it serves 176 customers when it lures 88 customers away from Adams by lowering the sales price to $140 per customer. b. Reconstruct Adams's income statement, assuming that it serves 176 customers when it lures 88 customers away from Baird by lowering the sales price to $140 per customer. Complete this question by entering your answers in the tabs below. Required A Required B Reconstruct Baird's income statement, assuming that it serves 176 customers when it lures 88 customers away from Adams by lowering the sales price to $140 per customer. BAIRD COMPANY Income…