w2Acct

profilenosnpe
Using_Performance_Reports_to_Inform_Organizational_Decisions.xlsx

Sheet1

Sweet Cupcake Bakery Performance Report-Production Department For the Month ended April 2019
1 2 3 4 5
STATIC BUDGET ACTUAL VARIANCE (2-1) FLEXIBLE BUDGET(at $15,000) Variance (2-5)
Cost for Manufacturing
Indirect Labor $25,500 $35,000 10,500 U $49,500 $
Supplies $35,000 $31,000 4,000 U $21,000 $10,000 F
Utilities $18,000 $22,000 4,000 U $18,750 $3,250 F
Total $78,500 $88,000 18,500 U $89,250 $13,250 F
INDIRECT LABOR $3.30
SUPPLIES $1.40
UTILITIES $2.20