...Costing Method: The excel document title, “JET2 Task 1-4 Workbook” and tabs ‘Task 4 Cost-Volume-Profit’, and “Task 4 Activity Based Costing” is where the information is derived from and recommendations will be made based off of the information in these tabs. The excel document title, “JET2 Task 1-4 Workbook” and tab ‘Task 4 Cost-Volume-Profit’ highlights two unit costs methods: traditional and activity based. Each unit cost method will be analyzed and a recommendation will be made regarding which costing method should be used by Competition Bikes. Traditional method to figure out costs- this method computes the overhead cost of titanium bikes at $239,020 and the overhead costs of carbonlite bikes at $232,380 for a total overhead cost of $471,400 ($239,020 + $232,380= $471,400). Again this information was derived from the excel document titled, “JET2 Task 1-4 Workbook” and by clicking on tab ‘Task 4 Cost-Volume-Profit’ and by viewing the second half of the page, looking at the summary of traditional and carbonlite overhead costs. Once the overhead costs are known the direct costs for each bike will be added to that number. So for titanium bikes the direct cost is $402,300 plus the overhead cost $239,020= $ 641,320 for titanium bikes. For carbonlite bikes the direct cost is $447,000 + $232,380= $679,380. The $641,320 for the titanium bikes is considered the total cost and the $679,380 is considered the total cost for the carbonlite bikes. Take the total cost for each bike...
Words: 1954 - Pages: 8
...JET2 - Financial Analysis - Task 4 JET2 – Task 4 A1. Costing Method Costing is used in business accounting strategies as a way of determining cost of manufacturing a product in relation to the revenue generated by that product. Costing systems determine the overhead of production and then allocate those overhead costs to a business’s product. There are two common methods for allocating these indirect costs to products, traditional costing and activity based costing. Both of these methods assess overhead costs and then attach these costs to products based on certain cost drivers, “a factor that causes cost to incur, such as machine hours, direct labor hours and direct material hours (Johnson 2014).” The first of these methods is Traditional Costing. This costing method drops all overhead costs into one bucket and then disperses them across three drivers, units produced, labor, and machine hours. Although this method works well for lines that are similar and consistent, one of its drawbacks is that this method does not account for customization requirements and overall complexity of the lines. So the company ends up allocating the same cost drivers across all production lines. The second method is Activity Based Costing. Activity based costing on the other hand, utilizes multiple cost pools as it relates to overhead costs based on resources used. Overall, this is a better cost system methodology for the company as it allows for the customization and specialty line...
Words: 2113 - Pages: 9
...RJET 2 Task 4 Competition Bikes Inc (CB) is now making both CarbonLite and Titanium framed bikes and is therefore in need of re-tooling some of the current practices being used. The company currently uses a traditional based costing (TBC), however an activity based costing (ABC) may be more beneficial. Also, the company’s breakeven point with regards to cost volume profit for each bike type is in question, especially since there is the potential for a $50,000 increase to production facility and a 10% materials cost increase. These areas are under evaluation to help the company navigate the new dual product line production. A1: Costing Method A Traditional Based Costing method looks at the cost to produce a product versus the profits it generates and predicts based on one lump sum. An Activity Based Costing method looks at the whole process to make a product, the activity involved to make the product, and is a more accurate breakdown of the true costs to make a product (Marx, C., 2009). Since most companies make products with both manpower and technology, using the TBC system causes an inaccurate forecast of determining the costs to make a product. TBC looks at what is spent to make a product but not why it was spent. The activity based costing (ABC) is more accurate for determining the actual costs that are spent to make a product because it does not assume that a product generates costs. ABC looks at the costs for each activity and assigns financials based on those activities...
Words: 2046 - Pages: 9
...Jorge Felix MBA, Management and Strategy Student ID: 000309831 Mentor: Rose Sklar C 915-497-5423 El Paso, Texas MST Financial Analysis RJET Task 4 To: Mr. Vice President From: Jorge Felix, CBI Analyst RE: Summary report As directed by you, please read below my analysis and recommendations for Competition Bikes Inc. Since the company has retooled and is making both the Carbon Lite and the Titanium frame bikes. I will be analyzing the results of your directed activity-based costing analysis was undertaken in one of the company plants. After the study, a breakeven analysis was completed along with target profit projections. It will be in Company’s best interest to change from a traditional costing system to an activity-based costing system. In this summary report you will find evidence as to why this transformation it’s relevant and important since it will emphasize the differences between traditional costing and activity based costing systems. A1. Costing Method This method is defined as 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. As manufacturing becomes more sophisticated the manufacturing overhead costs usually increase while the direct labor hours or production machine hours decrease. Hence, the direct labor or machine hours are unlikely to be the root cause of the manufacturing overhead (Accounting Coach, 2012) This costing method is called traditional...
Words: 1404 - Pages: 6
...JET2 TASK 2 1 JET 2 TASK 2: Financial Analysis Theo Adams Western Governors University MBA Program JET2 TASK 2 2 (A1) Budget Concerns Investopedia defines Budget as an "estimation of the expenses and revenues over a specific future period of time. Budgets can be made for a group of people, family, person, country, business, government, organization or anything else that makes or spend money. The budget is a micro economic concept that shows the trade-offs made when one good is exchange for another." When looking at the year 9 budget for CB first thing that jumped out at me was the sales goal of 3510 is a 5247450. This is my first immediate concern considering that the storyline has clearly stated it is a down market due to the reductions in monies for sponsored professional riders from their sponsors. This is the main sources sales for the Carbonlite model from CB. The professional riders not having the same resources they had in year 7 when sales went to 4000 from the 3000 sold in year 6. which meant CB's revenue went from 4485000 in year 6 to 5980000 in year 7. This 33.3% jump was followed by 15% drop from 4000 units sold in year 7 to 3400 units sold in year 8. Again this drop was due to the cut in sponsorship money for the professional riders which ended up reflecting at the drop in revenue as well from year 7 to 8 of 5980000 to 4485000. These facts do not seem to warrant an increase in sales from 3400 units to 3510 units and an Increased Revenue to 5247450. Even...
Words: 2595 - Pages: 11
...Running head: JET2 TASK 2 1 JET2 Task 2 Budgeting Bonnie Wilson Western Governors University JET2 TASK 2 A.1. Operational Strengths and Weaknesses A.1. Budget Concerns 2 Revenue from sales is budgeted too high. In year 8 Competition Bikes experienced a 15% decline in sales revenue, and yet for year 9, they have budgeted for a 3.2% increase. This is likely to be an overly optimistic projection and relies heavily on economic factors outside of the company’s control. Inaccuracy in this projection will have a negative impact on the rest of the budget. Advertising is budgeted too low. The year 9 budgeted amount of $28,412 represents a 3.5% increase over year 8, but it is still almost 20% shy of the amount spent on advertising in year 7 when sales were at an all time high. If the company is to have any hope of realizing its revenue projection, then the amount budgeted for advertising is too low. Executive compensation is budgeted too high. In year 7 executive compensation increased by $50,000 dollars. This made sense then because sales had increased by 33%. However, holding that number steady in year 8 when there was a 15% decrease, and again in year 9 when even a 3.2% increase is optimistic, is not a financially sound budgeting decision. Research and development is budgeted too low. The budgeted amount for year 9 is $85,237. While this represents the same 1.6% of sales revenue that Competition Bikes consistently allots, research and development is an investment in the...
Words: 1470 - Pages: 6
...Introduction: In this task you will prepare a presentation for the chief financial officer (CFO) to present to a bank vice president. The bank vice president will decide if the bank will approve a $1,000,000 funding request for the European expansion of Custom Snowboards Inc. currently under consideration. The bank has not confirmed it is willing to consider a $1,000,000 loan. The bank will make its assessment of the risk associated with the loan after your presentation. You will prepare another presentation to present directly to the chief executive officer (CEO) of Custom Snowboards Inc. The presentation will include a recommendation on how to proceed with the expansion plans. The presentations can assume the form of a presentation or a report. You may combine the two or submit them separately. Be sure to enter your first initial and last name on the first worksheet in Custom Snowboards, Inc. Financial Data excel document. Task: Note: Be sure to submit a copy of your Excel workbook when submitting your JET2 Task 5 work. When you enter your first initial and last name at the top of the Income Statement you are given a dataset that is based on your name. The evaluator will need a copy of your data to ensure correct evaluation. Note: Your presentations may be in a variety of formats (e.g., report, multimedia presentation). A. Create a presentation or report for the chief financial officer in which you do the following: 1. Summarize the key points of...
Words: 667 - Pages: 3
...Introduction: In this task you will prepare a presentation for the chief financial officer (CFO) to present to a bank vice president. The bank vice president will decide if the bank will approve a $1,000,000 funding request for the European expansion of Custom Snowboards Inc. currently under consideration. The bank has not confirmed it is willing to consider a $1,000,000 loan. The bank will make its assessment of the risk associated with the loan after your presentation. You will prepare another presentation to present directly to the chief executive officer (CEO) of Custom Snowboards Inc. The presentation will include a recommendation on how to proceed with the expansion plans. The presentations can assume the form of a presentation or a report. You may combine the two or submit them separately. Be sure to enter your first initial and last name on the first worksheet in Custom Snowboards, Inc. Financial Data excel document. Task: Note: Be sure to submit a copy of your Excel workbook when submitting your JET2 Task 5 work. When you enter your first initial and last name at the top of the Income Statement you are given a dataset that is based on your name. The evaluator will need a copy of your data to ensure correct evaluation. Note: Your presentations may be in a variety of formats (e.g., report, multimedia presentation). A. Create a presentation or report for the chief financial officer in which you do the following: 1. Summarize the key points...
Words: 497 - Pages: 2
...[pic]RJET Task 1 | | | | | | | |Help on this Page | |Directions | | | |SUBDOMAINS: 326.1 - MANAGING INTERNAL COST & CONTROLLING FINANCES | |326.2 - MANAGING CAPITAL AND FINANCIAL ASSETS | |326.4 - MANAGING ENTERPRISE RISK & CONTINUITY | |329.4 - MANAGING OPERATIONS | | | |Competencies: 326.1.1: Financial Analysis - The graduate analyzes and benchmarks financial statements, evaluates company | |performance, identifies...
Words: 549 - Pages: 3
...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 year...
Words: 2261 - Pages: 10
...JET2 Financial Analysis Task 4 WGU By Kat-Johnson | Studymode.com Competition Bikes Inc. Storyline Managing Capital & Financial Assets 04/12/2014 WGU JET2 Financial Analysis Task 4 - PASSED To: Vice President The following is a summary report to recommend whether Competition Bikes should change its traditional costing method to activity based costing, and an analysis of the breakeven point with regards to sales units and dollars for both CarbonLite and Titanium bikes. It also discusses the impacts to the breakeven point. The cost-volume-profit evaluation and the traditional vs activity based costing method overhead analysis were used for the review and analysis. Traditional Based Costing vs Activity Based Costing Traditional Based Costing Method (TBC). TBC uses one rate, the overall cost of production, to estimate costs based on the revenue production created. Unlike ABC, manufacturing costs in TBC are only assigned to sold merchandises and do not account for nonmanufacturing costs such as administrative costs. This method is general not as accurate as ABC as it does not account for costs specifics to the level of products. For Competition Bikes, the company can see its manufacturing overhead is $239,020 for the Titanium bikes, and $232,380 for the CarbonLite bikes for a total of $471,400 in overhead costs. This means the unit cost for each is $713 for Titanium bikes, and $1359 for the CarbonLite bikes. Activity Based Costing Method (ABC). ABC determines and...
Words: 2129 - Pages: 9
...| Competition Bikes: Task 1 | | Jamila Mitchell | | Competition Bikes: Task 1 | | Jamila Mitchell | Western Governors University JET2 Financial Analysis Western Governors University JET2 Financial Analysis Competition Bikes: Task 1 Jamila Mitchell Operational Strengths and Weaknesses Horizontal Analysis To evaluate changes in financial statements, a horizontal analysis is necessary so the company can determine whether there is positive or negative growth over time. The changes in percentages is calculated and decisions are made according to the increases or declines. Competition Bikes: Year 7 Overall, year seven was a successful year for the company based on the horizontal analysis of the following financial aspects. Revenue Net sales went from $4,485,000 in year six to $5,980,000 in year seven, an increase of $1,495,000 or a 33.3% increase. The cost of goods sold in year six was $3,294,000, which increased to $4,342,000. This increase of $1,048,000, or 31.8%, was expected considering the increase in net sales. The cost of goods sold remained less than net sales, so this is a strength for the company. While both net sales and cost of goods sold increased, there was still a balance between the two. This shows that the company sold more products at a lower cost, which also attributed to the 37.5% increase in growth profits. Total Selling Expenses Total selling expenses increased from $299,220 in year six to $397,960 in year seven. This was...
Words: 5232 - Pages: 21
...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 proportion...
Words: 3145 - Pages: 13
...JET2 Financial Analysis Task 1 Competition Bikes, Inc. Submitted by: Michelle Beacham Competition Bikes, Inc. is a manufacturer of bicycles for professional and other highly accomplished riders. The bicycle produced is a light weight, shaft driven bicycle that is custom made to fit each cyclist. It has been extremely popular among professional riders; however, recently sponsors have reduced funding to the riders causing a decline in sales volumes. This summary will be evaluating the strengths and weaknesses of the Competition Bikes, Inc., analyzing the working capital of the company, evaluating the internal controls, and Competition Bikes’ compliance with the Sarbanes-Oxley Act. Evaluation of the strengths and weaknesses The first evaluation of strengths and weaknesses of Competition Bikes, Inc. will be a horizontal analysis of the income statement and balance sheet. A horizontal analysis is a comparison of financial information across a particular time period. A comparison of the periods is completed based on a historical base period. For instance, we could compare sales for the current year as compared to the prior year. Each significant variance is investigated to determine the cause of the fluctuation (Accounting Tools, 2015). Gross profit is the difference between “Net Sales” and “Cost of Goods Sold”. Gross profit is up 37.5% in year 6 with a significant decline of 16.3% in year 7. The decline in year 7 is directly attributable to the decline in sales...
Words: 4786 - Pages: 20
...JET2 Task 1 Horizontal Analysis Results Horizontal Analysis is defined as “a procedure in fundamental analysis in which an analyst compares ratios or line items in a company’s financial statements over a certain period of time. The analyst will use his or her discretion when choosing a particular timeline; however, the decision is often based on the investing time horizon under consideration.” (investopedia.com). This data is calculated in both dollars and percentages using data from the balance sheet and income statement. It is an extremely useful tool to evaluate trend situations. The Horizontal Analysis is used to determine Competition Bikes actual financial operating performance from years 6 through 8, with year 6 as the base year. When I looked at the analysis between years 6 and 7, I looked at the financial changes to see what the actual performance was by percentage. The net sales for years 6 and 7 showed a change of $1,495,000 which is a positive increase of 33%. This shows that sales have increased and leads the company to believe that the operating performance was also good and tha customers/dealers really like the product. There was a change of $1,048,000, an increase of 31%, for cost of goods sold. This shows that there is financial strength for the company and also shows that customers/dealers like the products. When looking at cost of goods sold, they should remain lower that the sales increase so that the company can control the cost...
Words: 5924 - Pages: 24
