WGU JDT2 Financial Analysis Task 2

The company started off producing 20,000 units of mountain bikes. We did not change the production quantity. Last year our forecast sales were 24,000 when we only sold 19,866; therefore we thought it would be best to leave production at 20,000 bikes. Having excess inventory, we concluded that 20,000 units should be enough considering our quality has not changed and our advertising will not increase the sales dramatically. Although we had the choice to produce as much as 30,000 units, we felt as though we did not have sufficient money to increase production. We were interested in allocating the money towards marketing as opposed to production. We realized that without awareness, no matter how many units we make, sales would be inefficient.

Use of the flexible budget shows the budgeted operating income given the actual sales. When you compare the flexible budget to the actual budget you are able to compare the total sales and cost incurred given the same units sold. The sales price variance, which is the actual sales less the flexible budgeted sales, was $14,700 favorable. This means that actual sales were higher than budgeted sales at that usage. This is attributable to the increase in service price from $25 to $26.40. Price variance for material usage was $2,100 over the flexible budget projection. This could be attributed to overuse or waste of materials. As expected, the direct labor price variance was $3,375 lower than the flexible budget amount. This is attributed to the manager’s effective use of labor. Operating expenses were also higher than the flexible budget

Although the company did show an increased gross profit of $8,255,000 with $6,358,000 less Net Sales in 2013 versus 2012, that increase is due to the reduction in product Cost of Goods Sold by $14,613,000. Since increases in product price will negatively affect sales, one of management’s primary goals is to keep prices stable. This objective is achieved through implementation of cost cutting programs, investing in more efficient equipment, and automation of more steps in the production process.

Management should note that the level of activity was above what had been planned for the month. This led to an expected increase in profits of $1,100. However, the individual items on the report should not receive much management attention. The favorable variance for revenue and the unfavorable variances for expenses are entirely caused by the increase in activity.

Another concern identified, is the utilities expense budget for utilities in Year 9 which is $150,000. This amount is identified as a fixed amount and is unrelated to actually production activities and manufacturing efficiency. Considering that production levels and activity fluctuates throughout the year, the budget for utilities should be a variable item. An example; from Year 7 to Year 8, the utilities expenses increase by $15,000 and with this detection, ways to reduce this expense should be investigate. Another concern is a duplicated line item under the Selling, General, and Administrative Budget for Utilities and Utilities and Services. Another issue for concern, Total Variable Cost was reported to be lower; however was not enough for the lack of sales combined with an increase in advertising and transportation which resulted in an overall negative result. The low Net Sales directly impacted the Contribution Margin which decreased by $49,397. Overall, these concerns indicate the need for a flexible budget with variance analysis.

A1. Budget Concerns Competition Bikes budget has several areas of concern that need to be address. 1. Units expected to be sold for year nine is 3510. Competition Bikes is predicting that they will sell 3510 Bikes but they only sold 3400 Bikes in year eight down 15% from year seven 4000 units sold. Competitions Bikes has budget to high because the current economic down turn is showing no signs of relief for the next three years. Many of Competition Bikes customers are sponsored riders and many sponsors have pulled their funding to their rides. Competition Bikes has not presents a plan that would support their projections. Competition Bikes should lower there should lower the expected units sold so not to over order raw materials that will

This was favorable, but the Efficiency Variable was 100,000 unfavorable. This suggest that Competition Bike received a great price, but with the unfavorable Efficiency there were a lot of left over materials suggesting the material might not be the best quality. Direct Labor had a 150,000 Unfavorable Variance, but had a 50,000 favorable Efficiency Variance. The labor cost was up due to the high skill level needed for the bike manufacturing. The 50,000 favorable Efficiency Variance enabled the high skill labor to perform the task very efficiently. The Manufacturing Overhead had a 24,000 unfavorable Price Variance, and a 2426 unfavorable Efficiency Variance. The Advertising Cost had a 5,000 unfavorable Price Variance and a 1246 favorable Efficiency Variance. This suggest that Competition Bike spent more on Advertising in order to boost lagging sales, and the favorable Efficiency Variance shows that even though more was spent than budgeted, the money spent was efficient and worth the increase. The Transportation Out had a 3207 unfavorable Price Variance and a 2400 unfavorable Efficiency Variance. This suggest that Transportation cost were up due to increased fuel cost, and this increase in cost resulted in unfavorable Efficiency Variance due to transporting fewer bikes with increase in fuel cost.

Upon reviewing the Competition Bikes Inc. (CBI) Budget Schedules and ProFormas for Year 9, there are a few concerns that should be analyzed. The first is the forecasted sales in units. The forecast for year 9 is 3,510 units, which is a 3.2% increase over the 3,400 units sold in year 8. The storyline mentions the economic downturn, which has led to a decrease in bike sales. It can take some time to recover sales lost during an economic downturn, and given that sales were down 15% between year 7 and year 8, to go from a 15% decrease in sales to a 3.2% increase in sales in the span of only two years may be an unrealistic goal. I would want to see a specific plan in place for

Commutronics had not accumulated enough profits and had no sufficient capital reserves. The company’s registered capital was therefore very low. The withholding tax rate of

Going into 2004, Bob Moyer planned to produce 10,000 bicycles at Mile High Cycles. Construction of his bicycles includes the utilization of three departments, frames, wheel assembly, and final assembly. During this year, Mile High Cycles ended up actually producing 10,800 bicycles to meet higher than expected demand. Bob is curious as to whether or not he was successful in maintaining costs to meet these higher levels of demand.

After closely reviewing the financial and production data, our accounting team has found that your traditional cost allocation is faulty and misleading. The costs of products A and C were over allocated and products B and D were under allocated causing deceptive information on the true profits of the company. Also, product B appears to be

Meanwhile, the sales revenue decreased 6.1%. However, Dirt Bikes' cost increased too quickly to almost 10%. (See Figure 1.5 and 1.6)

After analyzing the results from the previous quarter, it was determined that the prices set for each segment were not sufficient. Product sales priority were also not properly adjusted. With the R&D investments, sales priorities needed to be changed for the main focus to become the most profitable market segments. Prices were not competitive which in turned decreased revenue, market share, and profitability. To become more competitive we altered the prices in each market segment. The Workhorse product was the first to change, the price was lowered to $2500 in an attempt to increase sales; at this price Team 4 was still making a profit on this product, as well as making the price much more competitive. The Workhorse sales priority was also lowered to 3rd in Americas and 4th in APAC and EMEA. This product was not selling as well as we had hoped, and was no longer as profitable as it once was which led to this decision. Next, the Innovator product’s price was adjusted; this involved a price increase to $4100. This price was adjusted to include the new

Also, the gross profit had a lower increase(+9.67%), that means the cost of sales increased more than the revenue increase in term of percentage. There was a 13.16% rose in net operating expense as both selling and distribution costs and administrative expenses increased. One of the reasons why net operating expense increased because the firm had a programme of reinvesting for organic growth which supply chain, IT and store portfolio had improved. The rose of the net operating expense lead to a 2.13% drop in the operating

(Compound value solving for I) at what annual rate would the following have to be investe