Answer To: 4 questions (1) A full revenue variance analysis, which would include the following: a. All revenue...
Sweety answered on Jul 02 2021
1. Revenue Variance Analysis
1 (a). REVENUE VARIANCE ANALYSIS
Particulars ACTUAL BUDGETED Sales Variance Sale Price / spending
Variance Sale Volume /efficiency
Variance
Unit Sold Price per Unit Total(in $) Unit Sold Price per Unit Total(in $)
Retail 188,898.00 55.00 10,389,390.00 215,000 56.00 12,040,000.00 (1,650,610.00) (188,898.00) (1,461,712.00)
Wholesale 49,710.00 38.00 1,888,980.00 80,000 37.00 2,960,000.00 (1,071,020.00) 49,710.00 (1,120,730.00)
Amazon 92,792.00 49.00 4,546,808.00 0 0 0 4,546,808.00 4,546,808.00 - 0
TOTAL 331,400.00 142.00 16,825,178.00 295,000.00 93.00 15,000,000.00 1,825,178.00 4,407,620.00 (2,582,442.00)
1 (b) & 1(c). APPLICABLE VARIANCE OF VARIABLE SELLING EXPENSE & FIXED SELLING EXPENSE.
Particulars F.Y. 1999 F.Y. 2000 F.Y. 2000 Total
Variance
Actual Actual Flexible Budget
Rate p.u. Total Rate p.u. Total Rate p.u. Total
Unit Sold 271,971 331,400 295,000
Amount (in $) Amount (in $) Amount (in $)
Variable Selling Expenses ($)
Packing and shipping 4.33 1,176,929.00 4.80 1,589,900.00 4.33 1,277,350.00 (312,550.00)
Commissions 0.92 249,330.00 0.38 125,789.00 0.92 271,400.00 145,611.00
Marketing materials 0.28 75,956.00 0.50 164,090.00 0.28 82,600.00 (81,490.00)
Total variable selling exp 5.52 1,502,215.00 5.67 1,879,779.00 5.53 1,631,350.00 (248,429.00)
Fixed Selling Expenses ($)
Salaries 2,726,091.00 3,274,871.00 2,726,091.00 (548,780.00)
Advertising and promotion 2,440,501.00 2,590,944.00 2,440,501.00 (150,443.00)
Total fixed selling exp 5,166,592.00 5,865,815.00 5,166,592.00 (699,223.00)
2.FULL COST VARIANCE
2. FULL COST VARIANCE ANALYSIS
The table below represnet Variance analysis of material cost , labor cost & variable overhead .
Particulars Input
Unit Standard input used per unit sold
standard price(dollar) per Input used
standard price(dollar) per unit produced
Master Budget Actual Standard cost Total cost Variance
Spending/
Price
variance Efficiency/
yield
Variance
Budgeted unit
sold Budgeted cost
(in $) Actual unit
sold Actual Input
used Price per
input used Actual Cost
(in $) Actual unit sold Standard input used per unit sold
Total Input used based on standard input used per unit sold & actual unit sold Standard
price
per input Total standard cost (in $)
Unit Sold of Bear - 0 - 0 - 0 295,000.00 - 0 331,400.00 - 0 - 0 331,400.00 - 0 - 0 - 0 - 0 - 0 - 0
Direct materials
Actrylic pile fabric bolts 0.03 36.00 0.96 283,872.60 8,345.00 34.56 288,403.20 0.03 8,858.32 36.00 318,899.59 30,496.39 12,016.80 18,479.59
Acrylic eyes eyes 2.00 0.21 0.42 123,900.00 661,248.00 0.21 138,862.08 2.00 662,800.00 0.21 139,188.00 325.92 - 0 325.92
Plastic joints joints 5.00 0.15 0.75 221,250.00 1,937,023.00 0.15 288,035.32 5.00 1,657,000.00 0.15 248,550.00 (39,485.32) 2,518.13 (42,003.45)
Polyester fiber filling pounds 0.90 1.61 1.45 427,455.00 354,164.00 1.51 534,787.64 0.90 298,260.00 1.61 480,198.60 (54,589.04) 35,416.40 (90,005.44)
Label label 1.00 0.06 0.06 17,700.00 328,447.00 0.06 19,706.82 1.00 331,400.00 0.06 19,884.00 177.18 - 0 177.18
Designer...