Develop and show in one table the (use Exhibit 23.1 as an example) the "performance report for the month of April". Include your static budget and flexible budget figures for all categories in this table. (if use excel, please provide the formula )

'ChickPea Delight' operates fast food restaurants in the food courts of shopping malls. Its main product is a serving of falafel that requires ground chick peas (direct material) and food preparation (direct labor). The April budget for ChickPea Delight's Corvallis restaurant was: Sales 30,600 servings at $4.50 each Standard food cost of $0.75 per serving (1/3 pound @ $2.25 per pound) Standard direct labor of $0.50 per serving (1/30th hour @ $15.00 per hour) Fixed occupancy expenses (rent and equipment) of $8,000 Actual April performance of the Corvallis restaurant was: Sales 27,000 servings at $4.80 each Food cost of $18,490 for 8,600 pounds Direct labor cost of $15,675 for 1,100 hours Fixed occupancy expenses of $8,200 In early May, the manager received the following financial performance report: ChickPea Delight - Corvallis Performance Report - Month of April Category Actual Budgeted Variance $129,600 (18,490) (15,675) (8,200) $87,235 Revenues Food Cost Labor Cost Occupancy Profit $137,700 (22,950) (15,300) (8,000) $91,450 $8,100 U 4,460 F 375 U 200 U $4,215 U Exhibit 23.1 Flexible Budgets and Performance Evaluation TUMI Production Department Performance Report For Month of July Based on Static Budget Original Static Budget Budget Actual Variance Volume. 11,000 10,000 Variable costs Direct materials.. $108,000 $100,000 $ 8,000 U Direct labor 70,000 60,000 10,000 U Variable overhead.. 81,000 80,000 1,000 U Fixed costs. 53,000 52,000 1.000 U Totals $312,000 $292,000 $20,000 U *Flexible budget manufacturing costs: (Actual level x Budgeted per bag cost) Direct materials (11,000 bags x 2 pounds x $5) Direct labor (11,000 bags x 0.25 labor hour x $24) Variable overhead (11,000 bags x 2 pounds x $4) Based on Flexible Budget Flexible Flexible Budget Budget Variance 11,000 11,000 $108,000 $110,000 $2,000 F 70,000 66,000 4,000 U 81,000 88,000 7,000 F 3,000 52,000 1,000 U $312,000 $316,000 $4,000 F 21200 tot aizvinna Actual