How do you calculate the cost variances using (actual, standard, flexible, static) for direct materials and direct labor in the exhibits below?
actual = actual price x actual input x actual output
standard = standard price x actual input x actual output
flexible = standard price x standard input x actual output
static = standard price x standard input x standard output
I am confused on how to get the actual/standard price, input and output? How do you get the price if it's missing in the exhibit?
Exhibit 4 - Actual Costs Quantity Used Input Price Total Cost Direct materials Quantity Units Dollars Per Input Unit Total Actrylic pile fabric 8,345 bolts 34.5600 bolt 288,403 Acrylic eyes 661,248 eyes 0.2100 eye 138,862 Plastic joints 1,937,023 joints 0.1487 joint 288,035 Polyester fiber filling 354,164 pounds 1.5100 pound 534,788 Label 328,447 labels 0.0600 label 19,707 Designer box 315,854 boxes 0.2100 box 66,329 Accessories 330,190 various 0.1894 each 62,538 Total Materials 1,398,662 Direct labor Hours Units Dollars Per Input Unit Total Sewing 189,211 hours 9.59 hour 1,814,533 Cutting and stuffing 104,117 hours 9.59 hour 998,482 Assembly 121,054 hours 9.59 hour 1,160,908 Dressing and packaging 34,615 hours 9.59 hour 331,958 Total Labor 448,997 hours 9.59 hour 4,305,881 Variable manufacturing overhead 1,979,441 Fixed manufacturing overhead 767,228Exhibit 3 - Standard Cost Information Input Units Input Price Standard cost Direct materials Quantity Units Dollars Per Input Unit S per bear Actrylic pile fabric 0.02673 bolts 36 bol 0.9623 Acrylic eyes 2.00 eyes 0.21 eye 0.4200 Plastic joints 5.00 joints 0.15 joint 0.7500 Polyester fiber filling 0.90000 pounds 1.61 pound 1.4490 Label 1.00 label 0.06 label 0.0600 Designer box 1.00 box 0.26 box 0.2600 Accessories 1.00 various 0.14 each 0.1400 Total Materials 4.0413 Direct labor Hours Units Dollars Per Input Unit $ per bear Sewing 0.5 hours 9.30 hour 4.65 Cutting and stuffing 0.3 hours 9.30 hour 2.79 Assembly 0.3 hours 9.30 hour 2.79 Dressing and packaging 0.1 hours 9.30 hour 0.93 Total Labor 1.2 hours 9.30 hour 11.1600 Variable manufactring overhead 1.20 DL hours 3.4900 DL hour 4.1880 Fixed manufacturing overhead 1.20 DL hours 2.1100 DL hour 2.5320 Notes: Normal expected production and sales is 295,000 units The cost of accessories ranges depending on the accessory type (from $0.07 to $0.41). A standard is used to reflect all accessories given their low cost. Variable and fixed overhead costs are allocated to bears based on the standard direct labor costs allowed. Standards are computed at the normal production level of 295,000 bears. Maximum capacity is 350,000 units.Exhibit 1 - Summary of Actuals and Master Budget Actual Master Budget Units sold (# of bears) 331,400 295,000 Revenue Retail 10,389,390 S 12,040,000 Wholesale 1,888,980 2,960,000 Amazon 4,546,808 Total revenue 16,825,178 15,000,000 Direct materials Actrylic pile fabric 288,403 283,873 Acrylic eyes 138,862 123,900 Plastic joints 288,035 221,250 Polyester fiber filling 534,788 427,455 Label 19,707 17,700 Designer box 66,329 76,700 Accessories 62,538 41,300 Total Materials 1,398,662 1,192,178 Direct labor 4,305,881 3,292,200 Variable manufacturing overhead 1,979,441 1,235,460 Fixed manufacutring overhead 767,228 746,940 Variable selling expenses 1,879,779 1,405,500 Fixed selling expenses 5,865,815 5,146,500 Administrative expenses 1,184,801 1,190,000 Operating profit $ (556,430) S 791,222 Note: The above actual operating income does not include the bonuses paid to management
