Any answer will get a like! I know the excel titles don't match the text information but its what my prof provided! Thanks in advance for any help

B2 AA Gry Obj. 3, 4 Road Gripper Tire Co. manufactures automobile tires. Standard costs and actual costs for direct materials, direct labor, and factory overhead incurred for the manufacture of 4,160 tires were as follows: Excel Actual Costs 101,000 lb. at 56,50 2.000 hrs. at 515.40 Direct materials Direct labor Factory overhead Standard Costs 100,000 lb. at 5640 2,080 hrs, at $15.75 Rates per direct labor hr, based on 100% of normal capacity of 2,000 direct labor hrs. Variable cost $4.00 Fixed cost, $6.00 $8.200 variable cost $12000 fixed cost Each tire requires 0.5 hour of direct labor. Manufacturing Cost Budget For the Month Ended July 31 Cost per Batch of Batches of 100 Standard Cost at Planned Volume (400,000 bottles) X 100 Manufacturing costs Direct labor Direct materials Factory overhead Total GENIE IN A BOTTLE COMPANY Manufacturing Costs Budget Performance Report For the Month Ended July 31 Actual Costs Standard Cost at Actual Volume (406,000 bottles) Cost Variance (Favorable) Unfavorable Batches of 100 Cost per Batch of 100 X Manufacturing costs Direct labor Direct materials Factory overhead Total Ex. 23-3