Ok so I'm getting lost solving this problem, I'm actually trying to learn the material for a test coming up. So if someone could review the work I've already done in excel, as well as inform me of the equations I need to solve the final two problems? I don't understand how to find the final two answers needed in excel and really need to understand all the formulas I'll be using on the test.

SA 18-1: Activity-based costing, manufacturing Ming Cookie Company uses activity-based costing to allocate factory overhead. Four activities and their activity rates are as follows: Activity Cooking Inspecting Material control Setup Ming plans to make 10,000 units each of two different products, cookies and crackers. The activity-base usage quantities for each product is as follows Activity Rate $45 per cooking hour $80 per inspection $28 per move $500 per setup Cooking 1,200 1.200 2,400 Inspecting 80 240 320 Material control 50 150 200 Setup 10 50 60 Cookies Crackers Total a. Open the Excel file SA18-1 b. Determine the activity-based cost for the cookies and crackers. c. When you have completed the assignment, perform a "save as," replacing the entire file name with the following SA18-1_[your first name initial]_your last name) In problem SA 18-1, what is the setup activity cost for cookies? a. $500 b. $5,000 c.$25,000 d. None of these choices Cookies Crackers Activity Base Activity Base Activit Usage x Activity RateActivity Cost Usage X Activity RateActivity Cost Cooking Inspecting Material control Setup 1,200 80 50 10 $45 $80 $28 $500 1,200 240 150 50 $54,000 6,400 1,400 $45 $80 $28 $500 $54,000 19,200 4,200 Total factory overhead Budgeted units of production Factory overhead per unit $66,800 $102,400 a. Enter the Activity Base Usage and Activity Rate for each activity, by product (cookies and crackers) as provided in the text b. In cell F4, enter the formula to determine the Activity Cost. Copy this formula from cell F4 to cells F5:F7 and cells L4:L7 c. In cell F8, enter the formula to sum the Total Factory Overhead for the cookies. Copy this formula to cell L8 d. Enter in cells F9 and L9, the budgeted units of production for each product. e In cell F10 enter the formula to determine the Factorv overhead ner unit Conv this formula to cell 1 10