Financial Analysis Task 4

In: Business and Management

Submitted By dewittj
Words 1455
Pages 6
Competition Bikes (CB) is making CarbonLite and Titanium bikes. To streamline cost there need to be an investigation into which practice is most efficient and cost effective for the CB. Competition Bikes is using a traditional based costing (TBC). There needs to be a comparison between the current use of TBC and activity based costing (ABC) to decide which is most beneficial to the company. Also, the breakeven point to cost volume profit needs to be evaluated. There is a potential for a $50,000 increase in production and a 10% material cost increase.
A1 Costing Method
Traditional Based Costing is, “The allocation of manufacturing overhead (indirect manufacturing costs) to products on the basis of a volume metric such as direct labor hours or production machine hours.” (Traditional Costing, 2014) As manufacturing relies more on the combination of manpower and technology and the use of TBC will become more inaccurate. It will not be able to depict the true root cause for manufacturing overhead. The activity based costing (ACT) is a more reliable method of determining actual cost to produce a product. This method looks at the cost of each activity. Then it attaches a financial cost to that activity. Although ABC can be complicated to calculate it is flexible and helps companies determine more accurate budgets and true costs of producing products.
The ABC method does not directly make changes to the cost of producing the product. What it does do is take into account the overhead for manufacturing and nonmanufacturing aspects of product production. Using this new cost method will help CB have a better understanding of what it takes to produce a bike. By having this knowledge the company can possibly identify ways to streamline production and cut waste. This intern can affect the company’s profit and may give the clients a better product at lower cost. If CB decides…...

Similar Documents

Rjet Task 2-Financial Analysis

...Introduction: JET2 Task 2 Summary Report for Budgetary Planning Competition Bikes, Inc. will be reviewed for its various budgets and for its budgetary planning. Budgets are the main planning tool in all businesses that are used by managers to executive management to make decisions for the company. Cash flow is the bloodline of any organization’s operation including operating activities that determine how much cash stays in the organization called revenues and how much is paid out as an expense or liability. Competition Bikes Inc. makes bicycles for professional riders who compete in road races such as triathlons and biathlons. The bikes have an extraordinary success rate and the product consistently finishes in the winners bracket approximately sixty percent of the time. However, due to the recent economic situation Competition Bikes, Inc. has experience a recent decline of approximately 15 percent in its bicycle sales which the trend expecting to continue for the next thirty six months. This review will provide an analysis and provide recommendation for improving budget planning for the company in a summary report Task: Note: submit a copy of your Excel workbook when submitting your JET2 Task 2 work. . A. Prepare a summary report in which you do the following: 1. Discussion of budgetary areas that raise concern in the budget planning. One of the biggest issues when creating budgets is that there is no absolute way of knowing what next......

Words: 2261 - Pages: 10

Financial Analysis Task 2

...Competition Bikes Budgeting and Variance Analysis Report Western Governor’s University Competition Bikes Budgeting and Variance Analysis Report Competition Bikes, Incorporated (Inc.) makes bicycles for professional and other highly accomplished riders who compete in bike races, biathlons, and triathlons. Approximately sixty percent of all race winners have been victorious using bicycles designed by Competitions Bikes, Inc. This extraordinary success rate is a topic of conversation among racers and has led to exponential success for founder Larry Ferguson who formed the company in 2001 in his garage. Competition Bikes is known for quality products and is leader in the market with the CarbonLite products they provide. These results are transparent in the budgets from the last few years; however, the most recent budget contained several unfavorable variances that may be an indication that some changes are needed. Budget planning, identifying unfavorable variance, and correcting those variances can make or break the financial position of a company. The following is a summary report that discussed budgetary areas that raise concern in budget planning; evaluates the flexible budget and its variance; recommends corrections actions for areas of concern based on the variance analysis; and discusses how the concept of management by exception could be applied to the variances. Budget Planning, Allocation of Resources, and Management Control ...

Words: 2352 - Pages: 10

Financial Analysis Task 1

...terms of risk/rewards management has to take into consideration interest payment, the company’s cash flows, dividends payment, the expected return on investment and so on. ("Capital structure decision," 2010) Competition Bikes Inc. has several alternatives for its capital structure mix in financing the Canadian expansion. Below is the data for the capital structure mix. Based on the capital structure analysis we see that Competition Bikes Inc has five different alternatives namely: 1. A capital structure consisting of only 9% bonds. 2. A capital structure consisting of only stocks, 50% preferred and 50% common stock. 3. There is a mix of 20% bond and 80% common stock 4. There is also a mix of 40% bond and 60% common stock. 5. The final mix is 60% bond and 40% common stock. The earnings per share (EPS) is the portion of the company’s profit that is allocated to each share of common stock as defined by the investopedia dictionary. This figure is very important to shareholders as it is used in determining the price per share. In our analysis we will be using the EPS to help us determine the best capital structure as well as the risk and rewards associated with each structure. All five alternatives above has the same capital structure, an important aspect of the EPS is the capital required to generate net income in the calculation of the EPS. Therefore we can decide on an alternative based on the highest value of EPS while paying close attention to risk......

Words: 3528 - Pages: 15

Financial Analysis: Jet 2 Task 4

...JET2 – Task 4 Financial Statement Analysis Managing Internal Cost & Controlling Finances Summary Report In response to a request from the Vice President of Competition Bikes for an analysis and recommendation regarding Activity Base Costing, as well as a request for a break-even analysis with projections of the company’s target profit, I have developed the following report. 1. Costing Method Evaluation Traditional Costing and Activity Based Costing (ABC) are the two systems we will evaluate in relation to Competition Bikes’ operations. To do so, we will need to look at the advantages and disadvantages of both systems. Costing systems are used to help predict the profitability of a product and help establish the cost of a product correlated to the income it generates. Traditional costing allocates overhead according to the amount of a particular cost driver, for example, how many direct labor hours are required to manufacture a product, while activity based costing looks at each activity and assigns a cost to it. Traditional costing separates costs into direct and indirect categories. The costs of labor or of raw materials would be examples of direct costs. Then, traditional costing divides the total cost of a product by the direct labor cost. This gives us the estimated cost of the product per item. However, increasingly in today’s business environment, the proportion of direct costs have fallen in relation to the......

Words: 3145 - Pages: 13

Financial Analysis Task 5

...JET 2 Task 5, Financial Analysis CFO Report Shawn Stokes Western Governors University-Indiana A. CFO Report 1. Summarization of key points that could affect bank officer’s decision The first thing you notice in the HA is the relationship between revenue and the selling expenses. The selling expenses are variable and rise and fall with revenue. In both years they are in lockstep, 3.21% in between Years 12 and 13 and 1.91% in Years 13 and 14. The general and admin expenses show some areas of concern, being generally fixed expenses, they should be consistent from year to year. There are four expense categories that need further research: Admin Salaries, Executive Compensation, Utilities, and Other GA Expenses. Executive Compensation acts more as a variable expense since the compensation is tied to performance. As sales go up, the executives should be rewarded and it shows in the Income Statement. The Utilities Expense may be just a blip in Years 13 and 12 as they rose 7.14%. It is more than likely some inefficient equipment. The decrease in utilities goes hand in hand with the raise in Equipment, in the long term assets located on the Balance Sheet, which occurred in Years 14 and 13. The other two accounts, Admin Salaries and Other GA, need serious attention. Admin has ranges from 4.76-13.64%. Other 31.12-7.59%. The operating income, -11.98 and -19.20%, suffers because of the GA expenses being between 6-7% higher per year. This results...

Words: 2148 - Pages: 9

Financial Analysis Task 1

...Competition Bikes, Inc. will be analyzed by several methods: horizontal analysis, vertical analysis, trend analysis, and ratio analysis. The first is horizontal analysis which “ratios or line items in a company's financial statements are reviewed over a certain period of time. “ (Investopedia.com) The period of time in which this report will be basing its findings are solely on its income statements from year six, seven, eight and nine. As shown in the horizontal analysis file, it is easy to see that Competition Bikes, Inc. had an increase of thirty three percent from year six to year seven while in the following two years (eight and nine), the company experienced a fifteen percent decline in net sales. Additionally, in review of the company’s gross profits, there is an increase between the same years of six and seven, while there is s significant decrease in years seven and eight. Although there could be several factors which may have impacted in their decrease from year seven to eight, it very well may have been caused by an increase on overall production costs, lower sales in general, competition or any combination of these factors. The company’s ability to produce a profit and sustain its profitability levels are vital to its success. One way to review this is to take a look at the company’s ability to turn over inventory (operations) otherwise calculating the number of days its assets are in inventory, working through the sales process and payment is received. For......

Words: 3221 - Pages: 13

Jet2 Task 1 Financial Analysis

...Financial Analysis Task 1 In the following summary report I will provide a closer look at Competition Bikes Inc., by examining the companies’ operational strengths and weaknesses, analyzing the working capital of the company, evaluating the internal controls present in the companies purchasing system and finally I will analyze the companies’ level of compliance with Sarbanes-Oxley requirements. This will be accomplished by taking a very close look at the income statement and balance sheet of the company. A.) Prepare a Summary Report 1.) Evaluate the company’s operational strengths and weaknesses 1a.) Horizontal Analysis: Accountingformanagement.org defines a Horizontal Analysis as, “a technique that shows changes in the amounts of corresponding financial statement items over a period of time.”("Horizontal analysis," 2013) In this section I we will take a look at both the income statement and balance sheet for the company Competition Bikes, Inc. Using the information provided I will perform a horizontal analysis based on years: 8 (current year), 7 (previous year) and year 6 (a past year). From this information I will point of some of the strengths of the company as well as some of the weaknesses. After properly identifying these areas, I will make recommendations on how to either maintain the good progress, or I will make suggestions about what needs to be adjusted in order to correct any weaknesses. Let’s begin by taking a look at......

Words: 10162 - Pages: 41

Financial Analysis Task 3

...Task 3 A1. Recommend a capital structure. Capital structure is defined as " how a firm finances its overall operations and growth by using different sources of funds."(investopedia.com). In order for Competition Bikes Inc to expand to Canada, it has to choose the best method that will maximize shareholder return. In order to do this the company has to have a capital structure that is sufficient enough to be able to increase its cash flow, pay its debts, and have a return on its investments. This method has to also offer an option that will minimize the company's overall cost while providing addition dividends to investors at the least possible risk. To determine this we will use Earnings per share from the table below to see which option is best for the company. Based on the EPS we recommended that the company pursue the option of 50% preferred stock and 50% common stock. This option offers the best balance for the company to maximize its returns and control its debt. It also provides the highest Earnings Per Share for investors while building the financial position of the company. Comparison table for Earnings per share A1a. Justify your recommendation. For the company to expand into Canada it needs to consider different capital acquisition methods in order to fund their expansion. An analysis of the available options is necessary in order for the company to determine the best option. This will allow the company to go forward with its plans and......

Words: 3452 - Pages: 14

Financial Analysis - Jet2 Task 1

...This paper is to be used as a reference only. Do NOT submit as is because it will not pass turnitin. Financial Analysis – JET2 Task 1 A.1.a. Horizontal Analysis Results Comparative Income Statements Revenue - Years 6 and 7: Net sales increased 33.3% showing significant boost of sales compared to prior year. Cost of goods sold also increased by 31.8% related to increased sales volume. Gross profit rose 37.5% commensurate with the substantial increase in net sales. Overall, this data represents a strong increase in revenue. This significant increase in sales/revenue suggests market approval and preference for the product. Revenue - Years 7 and 8: Net sales declined by 15% or close to $900,000. This is a staggering decline compared to prior performance. Cost of goods went down as expected since less volume was manufactured or sold and gross profit declined 16.3%. This decline in revenue is related to the poor economy and subsequent reduction of funding from professional rider’s sponsors. Other considerations should also be investigated such as management decisions or price increases that may have negatively impacted sales/revenue. Selling Expenses – Years 6 and 7: Advertising expenses increased 37.5% which may have contributed to the substantial increase in revenue for this period. Sales commissions, distribution network support, and transportation expenses were up 33.3% likely due to the increase in sales. Selling Expenses – Years 7 and 8: Advertising......

Words: 7025 - Pages: 29

Financial Analysis Jet Task 2

...Requirements for Task 1: A Prepare a summary report in which you do the following: 1) Evaluate the company’s operational strengths and weaknesses based on the following: a) Review the horizontal analysis, analyze the results, and discuss operational areas of concern. “Horizontal analysis of financial statements involves comparison of a financial ratio, a benchmark, or a line item over a number of accounting periods. This method of analysis is also known as trend analysis. Horizontal analysis allows the assessment of relative changes in different items over time. It also indicates the behavior of revenues, expenses, and other line items of financial statements over the course of time.” (Ready Ratios, 2014a) The sections below summarize the results of my horizontal analysis of Competition Bikes, Inc. (CB): Year 7 to Year 8 CB suffered a decrease in Net Sales Revenue of 15% from Year 7 to Year 8, but the course materials explained this as a result of a decline in the overall economy. This is a reasonable explanation and may very well indicate that CB management’s actions or inactions are not to blame for decline. It is encouraging that percentage decreases in Cost of Goods Sold and Selling Expenses, 14.5% and 14.9%, respectively, approximated the 15% decrease in Net Sales indicating no significant change in marginal cost of production and sales. That total General and Administrative Expenses increased by 1.2% is not any cause......

Words: 10434 - Pages: 42

Financial Analysis – Jet2 Task 1

...Financial Analysis – JET2 Task 1 Report for Competition Bikes, Inc. Competition Bikes, Inc was formed in 2001 and manufactures professional and performance bicycles used in a variety of racing events for expert riders. Bicycles produced by this company are ridden by 60% of all race winners and word of mouth has been their main marketing strategy. Competition Bikes is also the first company to use drive shaft technology in their bikes, which sets them apart from their competitors. A horizontal, vertical, trend and ratio analysis of Competition Bikes has been completed and is summarized in the review below. HORIZONTAL, VERTICAL, & TREND ANALYSIS Beginning with a comparison between year 6 and 7, sales in units rose from 3000 to 4000 which was a 33.3% increase in the number of units sold and is reflected in total Net Sales which rose from $4,485,000 to $5,980,000. Consistent with this same increase of 33.3% were sales commissions, distribution network support, transportation out costs, and total selling expenses. The total cost of goods sold increased 31.8%; this helped the company produce their product at a lower cost adding to their overall profit margin. The gross profit margin from year 6 to year 7 increased 37.5%. The company increased both their advertising and research and development 37.5% between year 6 and 7, this can strengthen their market base and aide in the development of new or improved products. Administrative salaries increased 21.4% and......

Words: 5457 - Pages: 22

Financial Analysis - Task 5 Wgu

...Custom Snowboards, Inc. Financial Analysis – Task 5 Slade Dietz Western Governors University Custom Snowboards, Inc. CFO Presentation Due to the growth of total sales and anticipated future growth of sales from Europe, Custom Snowboards, Inc. is considering expanding into the European market. Key points from the company’s income statement, the financial risks and the ability to repay any loan taken must all be considered. The following will summarize the current financial statements of Custom Snowboards, Inc. Key Points Six key points (line items) that could impact the banks decision for loan approval for Custom Snowboards, Inc. for the European expansion are: Profitability: * Net Sales – Net sales rose by .49% ($32,000) from Year 12 to Year 13; however, the company’s net sales declined in Year 14 by 3.40% (-$156,800) from Year 13. The Cost of Goods Sold (COGS) remained constant at 69.6% of the Net Sales in each year. This sales data is important to the banker due to the fact that, even with the decline in sales, the trend analysis shows the company does have an expectation of overall growth in net sales of 3.7% in Year 17 from Year 14. These higher sales will have a direct impact in driving profitability. * Operating Income – The Company did a good job in containing its selling expenses keeping them proportional to the net sales; however, they did not do a good job in managing the General and Admin Expenses from Year 13 to Year 14. Specifically with......

Words: 5702 - Pages: 23

Financial Analysis Task 2

...Concern in the budget planning A budget ca be defined as a summary of an itemized likely income and expenses for a given period or year. It is important for a company to prepare a budget as well as revise them after that period. This will help in to decrease the stress level and any financial surprises that might arise. The data from the flexible budget performance report shows the expected units to be produced is 3510 for December year 9. The concern here is that if competition Bike is expected to produce 3510 units, the budget is for the exact amount which might be a problem later when production starts. There is no allowance made for excess materials in case there is waste. The reason why this is a concern is that production might be halted if there is no available inventory. Another concern is that utilities under selling, general and administrative budget shows that the amount of budget allocated for utilities is 150,000. This is not ideal because when comparing the horizontal analysis comparative income statement, utilities for 2006 was 130,000, in 2007 it is 135,000 and for 2008 it is 150,000. That means there has to be inflation added. My projected amount would be around 160,000. This follows the trend from the three previous years. And the final concern is that there is no allocation of extra for depreciation in other general and administrative expense. The budget for 2009 is 170,000 but following the history or the trend, 2006, 2007and 2008 had an increase...

Words: 2205 - Pages: 9

Jet2 Financial Analysis Task 1

...Following is a comprehensive analysis of the financials of the profitability, competitiveness and overall stability of the Competition Bikes, Inc. based on their finance statements. This analysis provides information based on working capital, horizontal analysis, vertical analysis, ratio analysis and trend analysis. This analysis provides essential information on forecasting budget limits and overhead expenses based on overall sales potential. The analysis is based on the last three fiscal years of data provided by Competition Bicycles, Inc. A.1.A. : Horizontal Analysis A horizontal analysis is used to see variations in account line items from year to year. Strictly speaking, according to Accounting for Management (2014), a horizontal analysis “shows changes in the amounts of corresponding financial statement items over a period of time.” The formula utilized to calculate this change is Dollar change = Comparison Year Balance – Base Year’s Balance. The percent change is, therefore, calculated as the dollar change / Base Year’s Balance and multiplied by 100 for a strict percentage. At Competition Bikes, the numbers tell an interesting story. Sales dramatically increased 33.3% between years 6 and 7 before taking a loss of 15% in years 7 to 8. This still puts Competition Bikes at a solid increase of 13.3% in sales from years 6 to 8. Gross profits show a similar trend, increasing by 37.5% between years 6 and 7, while dropping by 16.3% between years 7 and 8 – the net profit......

Words: 4486 - Pages: 18

Financial Analysis Task 2

...decrease in units sold in comparison to year 7 levels. According to information provided by the company this is due to the economic situation which affects professional rider’s sponsorships. The company also states that this trend (decrease in sponsorship) is expected to continue for another three years (year 9 through 11). Concern 3 – Uncollectable Accounts The cash budget schedules of the company’s master budget fail to specify any level of uncollectable receivables. The company manufactures very high quality and highly specialized goods that are high in cost. Client issues with quality, loss of sponsorship, and economic issues for the distributors can generate unpaid accounts which can turn into uncollectable accounts. Concern 4 – Components and Materials Inventory Levels Although the company is budgeting for nearly 140 unproduced bikes (140 sets of parts and 5,880 strips of carbon fiber) it is budgeting for the labor which may be required to convert these “reserve” bikes into actual bikes. Another issue in this area concerns the parts kits. Because these are very expensive and specialized bicycles, it stands to reason that the component kits are also highly specialized. If older part models sit in inventory too long they may become obsolete and the company may lose the entire value of those kits. This can be due to a new type of gear, an improved material alternative, a new patented design. If the stock is not rotated in a specific manner the......

Words: 660 - Pages: 3