HND财政预算报告范本英文版

更多公司学院：《中小公司管理全能版》183套讲座+89700份资料《总经理、高层管理》49套讲座+16388份资料《中层管理学院》46套讲座+6020份资料

《国学智慧、易经》46套讲座《人力资源学院》56套讲座+27123份资料《各阶段员工培训学院》77套讲座+324份资料《员工管理公司学院》67套讲座+8720份资料《工厂生产管理学院》52套讲座+13920份资料《财务管理学院》53套讲座+17945份资料

《销售经理学院》56套讲座+14350份资料《销售人员培训学院》72套讲座+4879份资料IntroductionTricolplcacompanywhomakesarangeoffurnitureandkitchenware.Andoneofitsmostpopularproductsisthe‘Zupper’expandabletable.Thepurposeofwritingthisreportistodothevarianceanalysis,projectevaluationandtocomparethebudgetandactualdatabyusingthetechnique.FindingsPartAPossibleReasonforVariances1.MaterialDirectMaterial–Total-￡2,400Fmadeup:DirectMaterialUsage–￡0F(Levelofsignificance–usage/totalbudgetedMaterialcosts=8,000/64,000=12.5%>3%,shouldbereviewed)kglessmaterialsareusedthanbudgetedfortheactuallevelofproduction.Possiblereasonmaybeusingthehigher-gradematerialwithlesswastage.Orthenewmachineryuselessmaterialsandincurslesswstage.DirectMaterialPrice–￡5,600A(5,600/64,000=8.75%>3%)Itis￡1perkgmoreexpensivethanplannedPossiblereason:Newmaterialsupplierdoesnotgivediscountsformaterials.Hither-gradematerialshavebeenusedwhichismoreexpensive.2.LabourDirectLabourTotal-￡6,400ADirectLabourRate–￡3,520A(3,520/28,800=12.2%>3%)Onaverage,theactuallabourrateis￡1/hourhigherthanbudgetedPossiblereason:ThewagesettlementishigherthanexpectedThenewmachinerequirestrainingssothatovertimerequiredmorethanexpected.DirectlabourEfficiency-￡A>3%)4.16%Actually,morethan200labourhourshavebeenusedthanbudgeted.Possiblereason:Newmachineryrequiresmorehoursfortraining..Humanresourceissues–theskilledoperativesisnotenough.3．TotalOverhead-￡600FRateis4.70%UnpredictedincreaseininsuranceandAdministrationcostsPossiblereason:Newmachinerybringsmoreexpensiveinsurance,highermaintenanceandadditionaladministrativecosts.PartB1.Keyassumptionsmade:Thereisnotaxationandinflation.Assumedthatthereisnovarygivenreturnmarketrate.ThetotalcostoftheprojectwillbepayableatthestartTheexpectedrevenuefromtheinvestment–thisistheexpectedNetCashFlowafterdeductionofallrelevantcosts2.PaybackPaybackinthiscaseis4.125years(totalinvestment-returnperiodisfiveyears).Sothecompanycangetbacktheinvestment.TheNetPresentValueis￡-64，800.Itindicatesthattheprojectdoesnotappeartobefinanciallyviable.ConclusionPartBThisprojectisavailablebecausethepaybackis4.125years.ButtheNetPresentValue(NPV)isnegative.Sotheprojectisnotavailable.However,weshouldusetheconclusionoftheNetPresentValuebecausetheNetPresentValue(NPV)consideredthetimevalueofmoney.RecommendationsPartARecommendationsformanagementaction:Allthevariancesshouldbeanalysisbecauseallofthemareabove3%,thelevelofsignificance.Particularly,thedirectlabourvariancesneedfurtherinvestigation–whyisthecompanypayingahigherwageratebutthelabourproductivityislowerthanplanned.PartBToconsidertheeffectofthenewfacilitiesoncompany’sownstaff–intermsofemploymentandredeploymentopportunities.Toconsideranychangesinanyotherareas,likesocial,political,economic,legalandtechnologicalfactors.Whetheritispossibleforthecompanytoraisethesufficientfunds–toconsiderifthecurrentcashflowpositioncansupportsuchaninvestment.AppendixPartA1.Table1TricolplcFlexedBudgetforJuneTricolplcFlexedBudgetForJuneFixedBudget2,000unitsFlexedBudget1,600unitsActual1,600unitsVariance￡￡￡￡A/FDirectMaterial10*4*2,000=80,00010*4*1,600=64,00061,6002,400FDirectLabor2*9*2,000=36,0002*9*1,600=28,80035,2006,400AVariableProductionOverheads2*2,000=4,0002*1,600=3,2003,2000Insurancecosts2,2002,2002,400200ADepreciation1,5001,5001,5000RentandRates2,5002,5002,5000AdministrationOverheads2,0002,0002,200200AFixedOverheads8,2008,2008,600400ATotal128,200104,200108,6004,400A2.FurtherVarianceAnalysisThecalculationofthevariancesDirectmaterialtotal:(BudgetedQuantity*BudgetedPrice)–(ActualQuantity*ActualPrice)=(4kg*1,600*￡10perkg)-(5,600kg*￡11perkg)=￡64,000-￡61,600=￡2,400FDirectmaterialusage:Budgetedprice*(BudgetedQuantity–ActualQuantity)=￡10perkg*(4kg*1,600-5,600kg)=￡8,000FDirectmaterialprice:ActualQuantity*(Budgetedprice–Actualprice)=5,600kg*(￡10perkg-￡11perkg)=￡5,600ADirectlabortotal:BudgetedHours*BudgetedRate–Actualhours*ActualRate=(2hours*1600*￡9)-￡35200=￡6,400ADirectlaborrate:ActualHours*(BudgetedRate–ActualRate)=3,520hours*(￡9-￡10)=￡3,520ADirectlaborefficiency:BudgetedRate*(BudgetedHours–ActualHours)=￡9-(2hours*1600-3520hours)=￡2,880ATotaloverhead:(BudgetVariableOverhead+BudgetFixedOverhead)-(ActualVariableOverhead+ActualFixedOverhead)=(£4000+£8200)-(£3200+£8600)=£400FPartB1.PaybackperiodmethodYearYearlynetcashflow￡Cumulativecashflow￡0(1,000,000)(1,000,000)1160,000(840,000)2160,000(680,000)3320,000(360,000)4320,000(40,000)5320,000280,000Netcashbenefits280,000280,000Payback=4+40,000/320,000=4.125years2.Discountcashflowtechnique(netpresentva