Presidio, Inc., produces one model of mountain bike. Partial information for the company follows:Required:1. Complete Presidio's cost data table.2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data tableassuming the company sells each bike for $630.3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $630.Complete this question by entering your answers in the tabs below.Required 1 Required 2 Required 3Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost datatable assuming the company sells each bike for $630. (Round your Contribution Margin Ratio percentage answers to 2 decimalplaces (i.e. .1234 should be entered as 12.34%.))Total Contribution MarginContribution Margin Ratio730 Units%810 Units< Required 1%1,402 Units%Required 3 > Presidio, Inc., produces one model of mountain bike. Partial information for the company follows:Required:1. Complete Presidio's cost data table.2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data tableassuming the company sells each bike for $630.3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $630.Complete this question by entering your answers in the tabs below.Required 1 Required 2 Required 3Complete Presidio's cost data table. (Round your Cost per Unit answers to 2 decimal places.)Bikes Produced and Sold 730 Units810 Units1,402 UnitsTotal costsVariable costsFixed costs per yearTotal costsCost per unitVariable cost per unitFixed cost per unitTotal cost per unitS 189,800SS189,800 $0.00 $0 S536.00 SRequired 100.00Required 2 >

The variable cost per unit and total fixed costs remain constant at every level of production. The…

Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $630. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $630. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $630. (Round your Contribution Margin Ratio percentage answers to 2 decimal places (i.e. .1234 should be entered as 12.34%.)) 730 Units Total Contribution Marin 810 Units 1,402 Units

Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $630. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $630. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $630. (Round your Contribution Margin Ratio percentage answers to 2 decimal places (i.e. .1234 should be entered as 12.34%.)) 730 Units Total Contribution Marin 810 Units 1,402 Units

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 20M

See similar textbooks

Similar questions

Presidio, Incorporated, produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $630. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $630. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Complete Presidio's cost data table. Note: Round your Cost per Unit' answers to 2 decimal places. Bikes Produced and Sold Total costs Variable costs Fixed costs per year Total costs Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit 720 Units 890 Units 1,902 Units $ 187,200 187,200 $ 0 $ 0 $ 0.00 Required 1 543.00 $ 0.00 Required 2 >
Presidio, Incorporated, produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $630. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $630. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Complete Presidio's cost data table. Note: Round your Cost per Unit answers to 2 decimal places. Bikes Produced and Sold 730 Units 750 Units 1,260 Units Total costs Variable costs $ 182,500 Fixed costs per year Total costs $ 182,500 $ 0 $ 0 Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit $ 0.00 $ 558.00 $ 0.00
Presidio, Incorporated, produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $640. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $640. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Complete Presidio's cost data table. Note: Round your Cost per Unit answers to 2 decimal places. 730 Units 770 Units Bikes Produced and Sold Total costs Variable costs Fixed costs per year Total costs Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit $ $ $ 182,500 182,500 $ 250.00 250.00 $ 1,304 Units 0 $ 533.00 $ 0.00
Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $630. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $630. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Complete Presidio's cost data table. (Round your Cost per Unit answers to 2 decimal places.) Bikes Produced and Sold 730 Units 910 Units 1,18 Total costs Variable costs 189,800 Fixed costs per year Total costs 189,800 Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit 0.00 S 540.00 $4 0.00
Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $640. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $640. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Complete Presidio's cost data table. (Round your Cost per Unit answers to 2 decimal places.) Bikes Produced and Sold 730 Units 790 Units 1,944 Units Total costs Variable costs $ 189,800 Fixed costs per year Total costs Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit $ 549.00 Required 1 Required 2 Required 3 Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data…
Galaxy Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs), the Conquistador and Hurricane, from a single manufacturing facility. The manufacturing facility operates at 100% of capacity. The following per-unit information is available for the two products: In addition, the following sales unit volume information for the period is as follows: a. Prepare a contribution margin by product report. Compute the contribution margin ratio for each. b. What advice would you give to the management of Galaxy Sports Inc. regarding the profitability of the two products?
Best Windows is a small company that installs windows. Its cost structure is as follows: Selling price from each window installation Variable cost of each window installation Annual fixed costs $ $ $ 160,000 Use (a) the equation method and (b) the contribution method to calculate operating income if Best installs 4,000 windows. Use (a) the Equation method to calculate operating income if Best installs 4,000 windows. Begin by determining the formula to calculate the operating income using the equation method. Then, calculate the operating income. (Abbreviation used: FC = Fixed costs, SP = Selling price, VCU = Variable cost per unit, Q = Quantity of units sold.) X X )-( )-( X X 700 600 X = Operating income = Next, use (b) the contribution method to calculate operating income if Best installs 4,000 windows. Begin by determining the formula to calculate the operating income using the contribution method. Then, calculate the operating income. = Operating income
Required information Morning Dove Company manufactures one model of birdbath, which is very popular. Morning Dove sells all units it produces each month. The relevant range is 0-1,500 units, and monthly production costs for the production of 1,200 units follow. Morning Dove's utilities and maintenance costs are mixed with the fixed components shown in parentheses. Production Costs Direct materials Direct labor Utilities ($100 fixed) Supervisor's salary. Maintenance ($250 fixed) Depreciation Total Cost $ 2,700 8,100 Suppose it sells each birdbath for $26. Required: 580 3,200 530 750 1. Calculate the unit contribution margin and contribution margin ratio for each birdbath sold. 2. Complete the contribution margin income statement assuming that Morning Dove produces and sells 1,400 units. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate the unit contribution margin and contribution margin ratio for each birdbath sold. (Round Variable cost…
Spectrum Corp. makes two products: C and D. The following data have been summarized: (Click the icon to view the data.) Spectrum Corp. desires a 25% target gross profit after covering all product costs. Considering the total product costs assigned to the Products C and D, what would Spectrum have to charge the customer to achieve that gross profit? Round to two decimal places. Begin by selecting the formula to compute the amount that the company should charge for each product. Required sales price per unit Data table Direct materials cost per unit Direct labor cost per unit Indirect manufacturing cost per unit Total costs assigned Print $ $ Product C 600.00 $ 300.00 270.00 1,170.00 S Done - X Product D 2,400.00 200.00 604.00 3,204.00
Bernard Windows is a small company that installs windows. Its cost structure is as follows: Selling price from each window installation $500 Variable cost of each window installation $400 Annual fixed costs $150,000 Use (a) the Equation method and (b) the contribution method to calculate operating income if Bernard installs 2,000 windows. Use (a) the Equation method to calculate operating income if Bernard installs 2,000 windows. Begin by determining the formula to calculate the operating income using the equation method. Then, calculate the operating income. (Abbreviation used: FC = Fixed costs, SP = Selling price, VCU = Variable cost per unit, Q = Quantity of units sold.) ( × ) - ( × ) - = Operating income ( × ) - ( × ) - =
Voice Com, Inc., uses the product cost method of applying the cost - plus approach to product pricing. The costs of producing and selling 5,000 units of cell phones are as follows:Voice Com desires a profit equal to a 13% rate of return on invested assets of $600, 800.a. Determine the amount of desired profit from the production and sale of 5,000 units of cell phones.Sfill in the blank 1b. Determine the product cost per unit for the production of 5,000 of cell phones. If required, round your answer to nearest dollar.Sfill in the blank 2 per unitc. Determine the product cost markup percentage (rounded to two decimal places) for cell phones.fill in the blank 3 %d. Determine the selling price of cell phones. Round to the nearest dollar.
Cullumber Company makes three models of tasers. Information on the three products is given below. Sales Variable expenses Contribution margin Fixed expenses Net income (a) Net income $ (b) Shocker Net Income Tingler $300,000 $500,000 Tingler Net Income $ Total Net Income (c) Why or why not? Compute current net income for Cullumber Company. ta Net income would 151,400 148,600 $ 119,400 S $29,200 Fixed expenses consist of $298,000 of common costs allocated to the three products based on relative sales, as well as direct fixed expenses unique to each model of $30,000 (Tingler), $80,800 (Shocker), and $34,300 (Stunner). The common costs will be incurred regardless of how many models are produced. The direct fixed expenses would be eliminated if that model is phased out. James Watt, an executive with the company, feels the Stunner line should be discontinued to increase the company's net income. Shocker 197,000 303,000 229,800 $73,200 Compute net income by product line and in total for…