preview

Financial Analysis Task 4 Competition Bikes

Decent Essays

Financial Analysis
Task 4
Competition Bikes
Break Even Analysis

To: Vice President Riley
From: CBI Analyst
RE: Summary report

With CBI now making the CarbonLite and Titanium frame bikes, I was directed to perform a cost study and an activity based costing analysis at the San Diego plant. After extensive research I recommend that CBI use an activity based costing method. An activity based costing (ABC) system recognizes the relationship between costs, activities and products, and through this relationship assigns indirect costs to products less arbitrarily than traditional methods (Investopia, 2013). Activity costing requires the use of multiple points of data to build a cost point. First, ABC will identify each activity and …show more content…

See equations below.

Profit=selling price per unit X quantity sold – VC per unit X quantity sold-total fixed costs =(CM)X quantity sold – fixed costs.

Revenue for Titanium is $900 x $450 = 405,000+ CarbonLite $1495 x 250 = 373,750 =778,750
TVC: Titanium $679 X $450 = 305,550 + CarbonLite $1495 X 250 =373,750 Total=$679,300

TCM: $778,750-$679300= $99,450 for Titanium and using the same formula above TCM for CarbonLite is 27,750. This gives us a combined contribution margin of $127,200.

Some management prefers to view the break even points via a percentage, in which case we would need to derive the contribution margin as a ratio. This would be the unit contribution margin/ unit sales price.

Contribution Margin Ratio: $96,950/$778,750 =.13 Titanium $27,750/679300=.04 CarbonLite
This ratio represents the percent in which the selling price per unit surpasses the VC per unit.
Armed with this knowledge, CBI can now have the figures per unit for which they need to break-even; the break-even being that level of operational activity at which the revenue covers the total cost, but with a zero profit. CVP analyzes the changes in profits in regards to changes in the volume of sales, change in profits, and change in costs. This is

Get Access