HND财政预算报告outcome 1.docx

1、HND财政预算报告outcome 1Beijing Institute of TechnologySQA HND AssignmentTable of contentsIntroduction .3 Part A.3Part B.5Conclusion 6Reference6Appendix7IntroductionThis report is for Tricol plc which makes a range of furniture and kitchenware. One of the most popular products is the Zupper expandable tab

2、le. It will do some variance analysis in the Part A. It will includes direct material usage, direct material price, direct labor rate direct, labor efficiency and total overhead. Some suggestions will be given following the analysis. In Part B, there will take two methods to analyze the project that

3、 is whether to accept. It will discuss the advantages and disadvantages of the two methods, finding out the best methods that is suit for the company. At last, some other factors such as environment, technology, legal, and customers will be discussed for the managers. Furthermore, some needed append

4、ixes will be followed the report. Part AVariance analysis and reportingOnce the variances have been calculated, they should be analyzed to find what the problems are. The criterion that the rate of variance needs to be analyzed is more than 3%, and according to the Appendix 3, as a result, it needs

5、to analyze all the variances.Direct material usage:According to the Appendix 2, the variance of direct material usage is favorable, which is about 8000 and the rate of direct material usage variance reaches 12.5%. This is a high level and it may due to the two reasons such as higher quality material

6、s and higher grade workforce. The company chooses the higher quality materials could reduce the spoilages during the producing. And it could reduce the inferiors in the finish products. To reduce the materials is as a result. Giving the labor higher workforce may reduce the mistakes by labors during

7、 the producing that will reduce the rejection rate and save the materials.Direct material price According to the Appendix 2, the variance of direct material price is adverse, which is about 5600 and at the rate of 8.75%. There may be two reasons for this result. One is higher quality materials. Beca

8、use of the higher quality, this kind of materials will be more expensive than other low quality materials. It will increase the costs of the materials. Also, the loss of discounts will be another reason to make the material price increase. Tricol may cooperate with a new supplier; company may not ge

9、t the discounts received because of the low reliance. Direct labor rateAccording to the Appendix 2, the variance of direct labor rate is 3520 in adverse, and at the rate of 12.2%. There may be also two reasons for this result. One is salary increase award. Company made the labor rate become 10 per h

10、our, which is higher than standard labor rate for 1 per hour. This could encourage the staffs to work hard and improve their efficiency and reduce the mistakes. Another reason may be the unplanned overtime. For this situation, company may pay more wages to the staffs for their overtime work.Direct l

11、abor efficiencyAccording to the Appendix 2, the variance of direct labor efficiency is adverse with 2880 in the rate of 10%. There are two reasons for this. One is may be the low morale. Because the company let its labors to work overtime for the unplanned goals and the high workforce will make the

12、staffs unsatisfied. The second reason is that there may be shortage of skilled labor, which results in more labor hours and labors to finish the goals. Total overhead According to the Appendix 2, the variance of total overhead is 400 in adverse, and at the rate of 3.51%. It may due to the higher ins

13、urance, and higher administration. Company may spend too much on the insurance of its staffs. Some wages of the managers may be higher. Recommendation for the managementThe direct material usage is a good sign for the company. Company should continue to reduce the spoilages during its producing. How

14、ever, the price of the materials are little higher. It is not a good sign. Company may purchase the lower quality materials from the new supplier. And try the best to get some discount received. The price of materials should be lower than before but quality could not be too lower. This action will r

15、educe the costs in the materials and insurance the low rejection rate. According to the labor, company should not raise the employees wages easily to motivate the staffs and it should not do much the unplanned overtime. Because of the much unplanned overtime, the staffs may against this action and b

16、ecome morale. So, company should reduce the unplanned overtime and use the other ways to encourage its staffs often. However, in order to finish the unplanned overtime, the company may hire some new employees to work. But there is shortage of skilled labor. Company should give them some training to

17、improve their skills. The total overhead is not very good for the company. The insurance and administration may be higher for the company. Company should go to the greatest extent of reducing the costs in the insurance. It may be possible for company get some discount allowed form the insurance comp

18、any. And control the spending in the managing. Part BAssumption The premise of payback period methods Identify all of the costs of initial investment. Assume that they will be paid now. Find the cash inflow for each project. Add up cash flows each year until cost of project covered. Pick the project

19、 with the shortest payback period. If the payback period is only one year then it should be compared with an internal figureThe premise of discounted cash flow techniqueUncertainty does not exist. There is no inflation. The appropriate discount rate to use is known, to avoid unnecessary calculations

20、. When undertaking DCF questions, the discount rates have been computed for you, and are given in the discount tables .Unlimited funds can be raised at a competitive rate.Analyzing payback period methodAccording to the payback period method, the original capital that the company invest is 1,000,000

21、and there are 5 years for the company to get the return that is the budgeted payback period. According to the program, 4 years and 1.5 months that the company will get its all investments. At the last year, company will get the return about 280,000. As a result, based on the period method, the proje

22、ct will be profitable and is worth to invest.Analyzing discounted cash flow techniqueIf the company uses the discounted cash flow technique, according to the peogram, the investment is 1,000,000, and the net present value is 10%. The budgeted payback period is 5 years. After 5 years, the NPV for the

23、 project will be -64,800. It shows that the return is less than the investment. It will be the loss of 64,800 to invest this project. So this project will not be profitable and is not worth to invest.RecommendationAccording to the two methods, it is not difficult to find that the company would bette

24、r to choose the payback period method. The company chooses payback period method could get the profit of 280,000 and less 5 years could get the all investment. And for the discounted cash flow technique, it will cost 5 years and loss 64,800 at last of the project. So, based on the profit, the compan

25、y would better to choose the payback period method.Consideration of other factors First, the environment is one factor that the managers should to consider. Tricol makes a range of furniture and kitchenware. It may make pollute during the producing. If the company does not pay attention to the envir

26、onment, it may get some fine. Technology is one factor that the managers should to consider about. If the company uses the new technology and equipment in the project, it could improve its productivity. And improve its profitability. The company should also think about the legal. The company should

27、insure that the project is not against the legal. If not, company may be punished by the government and even be banded. At last, company should consider its customers. It should consider that its products, making by the project, will be attracted by the customers. If no customers like it, they may g

28、et little profit for the project.ConclusionAs an advisor for the company, this report can help the company make the flex budget and variances and use the two methods to analysis the investment and help the company choose the best method. This will help company make much profit.ReferenceSQA, preparin

29、g Financial Forecast (version 3), China Modern Economic Publishing House, 2004.http:/en.wikipedia.org/wiki/Payback_periodAppendix 1Tricol plc Flexed BudgetFixed Budget2000 UnitsFlexed Budget1600 UnitsActual1600 UnitsVariance F/ADirect material8000064000616002400 FDirect labor3600028800352006400 AVar

30、iable production overheads4000320032000Insurance220022002400200 ADepreciation1500150015000Rent and Rates2500250025000Administration Overheads200020002200200 ATotal01042001086004400 AAppendix 2The calculation of the variances would be:1.Direct material total variance(standard units of actual producti

31、on standard price) (actual quantity actual price)(4kg 1600) 1061600=6400061600=2400 ( F )2.Direct material usage variancestandard price (standard units of actual productionactual units)=10 (4kg 16005600kg)=10 800kg=8000 (F)3.Direct material price variance actual quantity (standard priceactual price) =5600kg (1011) =5600kg 1 =5600 (A)4.Direct labor total variance