Budget is used as an instrument of planning and control. Hence, analyzing
the variance to budget is essential. This week’s assignment is to analyze the sales budget variance. The attached excel worksheet has budgeted and actual sales data. It also has a template to analyze the sales budget variance. You are expected to input the data and formula in the right column. The columns highlighted in yellow need a formula. Include a narrative in a Word document to reveal your analysis (your final thoughts).
ATTACHMENT PREVIEW Download attachment
SALES BUDGET VARIANCE REPORTBudgetActualProductSaleUnits$/UnitSaleUnits$/UnitA7504.003,0001,1003.503,850B7505.504,1251,0005.705,700C7506.004,5009006.505,850Total11,625Total15,400Price VarianceProductABCVolume VarianceProductABCMix VarianceProductDiferenceABCQuan±ty VarianceSalesValue in $SalesValue in $ActualSale UnitsBudgetPriceActualPriceSale PriceVariancePriceVarianceActualSale UnitsBudgetSale UnitsBudgetPriceSale UnitVarianceVolumeVarianceBudgetMixActualSale atBudgetMixActualSale UnitsBudgetPriceMixVariance
Background image of page 1
View the Answer
ProductABCActualSale atBudgetMixBudgetSale UnitsBudgetPriceDiferencein UnitsQuanTtyVariance
Background image of page 2
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code “Newclient”
The post Budget is used as an instrument of planning and control appeared first on Superb Professors.