**Presidio, Inc. Mountain Bike Sales Analysis****Overview:**Presidio, Inc. produces one model of mountain bike. The following tasks are required for financial analysis:1. **Complete Presidio's Cost Data Table.**2. **Calculate Presidio's Contribution Margin Ratio and Total Contribution Margin:** - At each sales level indicated in the cost data table, assuming each bike sells for $630.3. **Calculate Net Operating Income (Loss):** - At each of the sales levels, assuming a sales price of $630.**Instructions:**Complete this question by entering your answers in the tabs provided.**Sales Level Analysis:**- **Required 1**- **Required 2**- **Required 3****Table of Contribution Margins for Various Sales Levels:**| Sales Level | 730 Units | 810 Units | 1,402 Units ||---------------|-----------|-----------|-------------|| Total Contribution Margin | | | || Contribution Margin Ratio | | | |*Note: Calculate Presidio’s contribution margin ratio and its total contribution margin at each sales level with a selling price of $630 per bike. Round your contribution margin ratio percentage answers to two decimal places (e.g., 12.34%).***Diagrams and Graphs:**The image includes a table representing sales levels at 730, 810, and 1,402 units. The table requires calculations for the total contribution margin and the contribution margin ratio at each level. Each cell in the table is initially blank, indicating areas where analysis needs to be completed by the user. **Procedure for Completion:**- **Total Contribution Margin:** Calculate by subtracting variable costs from total sales for each sales level.- **Contribution Margin Ratio:** Determine by dividing the total contribution margin by total sales revenue, then express as a percentage.Engage with each tab to fulfill the requirements for comprehensive financial insights. **Presidio, Inc. Mountain Bike Cost Analysis**Presidio, Inc. produces one model of mountain bike. Below is the partial cost analysis for the company, including tasks required to complete the data and financial assessments.**Required Tasks:**1. **Complete Presidio’s Cost Data Table:** - Analyze and finalize the entries in the cost data table provided.2. **Calculate Contribution Margin:** - Determine the contribution margin ratio and total contribution margin for each sales level. - Assume each bike is sold for $630.3. **Calculate Net Operating Income (Loss):** - Assess the net operating income or loss at each sales level with a sales price of $630 per bike.**Instructions:**- Enter your responses in the tabs provided.**Cost Data Table:**| **Bikes Produced and Sold** | **730 Units** | **810 Units** | **1,402 Units** ||-----------------------------|---------------|---------------|-----------------|| **Total Costs** | | | || Variable costs | $189,800 | | || Fixed costs per year | $189,800 | $0 | $0 || | | | || **Cost per Unit** | | | || Variable cost per unit | $0.00 | | || Fixed cost per unit | $0.00 | $536.00 | $0.00 || **Total cost per unit** | $0.00 | $536.00 | $0.00 |**Explanation:**The table above is organized to help determine the costs associated with producing and selling different quantities of mountain bikes. It includes:- **Variable Costs:** Costs that vary directly with the level of production.- **Fixed Costs:** Costs that remain constant regardless of the number of units produced.- **Cost Per Unit:** Computed by dividing the total cost by the number of units produced.**Action Steps:**1. Fill in missing data by calculating costs using given formulas or additional information.2. Use the data to compute contribution margin and assess financial performance at various production levels, leveraging fixed and variable cost insights.

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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Do not give answer in image and hand writing
Jamison Company uses the total cost method of applying the cost-plus approach to product pricing. Jamison produces and sells Product X at a total cost of $1,200 per unit, of which $820 is product cost and $380 is selling and administrative expenses. In addition, the total cost of $1,200 is made up of $680 variable cost and $520 fixed cost. The desired profit is $180 per unit. Determine the markup percentage on total cost.fill in the blank 1 %
produces sports socks. The company has fixed expenses of screenshot attached athnhksgnrwohirnhw roihnw
Please help me
Hazlett & Family is organized into two geographic markets Northern and Southern. The company makes an off-road vehicle for recreation and agricultural use. The vehicle is sold in three models, depending on the power and options. The three models, from least expensive to most expensive, are the H-L, H-LX, and H-LXS. The company's financial staff has prepared the following forecasted income statement for the upcoming fiscal year (in thousands of dollars): Sales revenue Cost of goods sold Gross margin Marketing costs Administrative costs Total marketing and administrative Operating profits Management has expressed special concern with the Southern market because of the extremely poor return on sales. This market was entered a year ago because it seemed like the best opportunity for growth. Hazlett & Family knew that it would take some time to build profitability in the market, but there has been no noticeable change in the low returns over time. H-L H-LX H-LXS The financial staff has also…
Please do not give solution in image format thanku
Question is in the image Required:a) Calculate the weighted average unit contribution margin, assuming a constant sales mix. b) How many units of each printer must be sold to break even? c) i) Explain what is margin of safety ii) Calculate in sales units the margin of safety for IPM, assuming projected sales are 25,000 units?
Crescent Lighting Inc. produces and sells lighting fixtures. An entry light has a total cost of $66 per unit, of which $33 is product cost and $33 is selling and administrative expenses. In addition, the total cost of $66 is made up of $45 variable cost and $21 fixed cost. The desired profit is $12 per unit. Determine the markup percentage on product cost. Round the answer to nearest whole number.
Surf Company can sell all of the two surfboard models it produces, but it has only 412 direct labor hours available. The Glide model requires 2 direct labor hours per unit. The Ultra model requires 4 direct labor hours per unit. Contribution margin per unit is $212 for Glide and $324 for Ultra. (a) Compute the contribution margin per direct labor hour for each product. (b) Determine the best sales mix and the resulting contribution margin. Complete this question by entering your answers in the tabs below. Required A Required B Compute the contribution margin per direct labor hour for each product. Glide Ultra Contribution margin per direct labor hour
Royal Lawncare Company produces and sells two packaged products - Weedban and Greengrow. Revenue and cost information relating to the products follow: \ table[[, Product], [, Weedban,Greengrow], [Selling price per unit,$8.00, $39.00
Adams, Inc. has the following cost data for Product X, and unit product cost using absorption costing when production is 2,000 units, 2,500 units, and 5,000 units. (Click on the icon to view the cost data.) (Click on the icon to view the unit product cost data.) Product X sells for $175 per unit. Assume no beginning inventories. Read the requirements. Data table Begin by selecting the labels and computing the gross profit for scenario a. and then compute the gross profit for scenario b. and c. Absorption costing a. b. C. Gross Profit Reference 2,000 units 2,500 units 5,000 units 42 $ 42 52 52 11 11 Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Total unit product cost Print $ $ 42 S 52 11 10 115 $ Done 8 113 $ 4 109 Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Print Done $42 per unit 52 per unit 11 per unit 20,000 per year
Pharoah Springs produces and sells water filtration systems for homeowners. Information regarding its three models is shown below. Basic Basic Plus Premium Total Units sold 935 510 255 1,700 Selling price $250 $430 $840 Variable cost $195 $285 $410 The company's total fixed costs to produce the filtration systems are $176,960. (a) (b) (c) (d) Determine the number of units of each model that the company must sell to break even. Basic Basic Plus Premium Break-even units units eTextbook and Media Save for Later units units Attempts: 0 of 3 used Submit Answer