A1 Excel Spreadsheet: SA 18-1 M Spreadsheet Tutorials: Accounting Formatting, Activity Based Costing 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 Activity Rate Cooking $45 per cooking hour $80 per inspection Inspecting Material control $28 per move 8 Setup $500 per 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: Cooking Inspecting Material control Setup Cookies 1,200 80 50 10 Crackers 1.200 240 150 50 Total 2,400 320 200 60 a. Open the Excel file SA18-1. b. Determine the activity-based cost for the cookies and crackers. you con the ignment, rform a "save as," replacing the entire file SA18-1_[your first name initial]_[your last name] A B D E F G H I J L 1 Cookies Crackers Activity Base Activity Base 2 Activity Usage x Activity Rate Activity Cost Usage x Activity Rate = Activity Cost 3 4. Cooking 5 Inspecting 6 Material control 7 Setup Total factory overhead Budgeted units of 9 production Factory overhead 10 per unit 11 12 13 a. Enter the Activity Base Usage and Activity Rate for each activity, by product (cookies and crackers) as provided in the text. 14 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:17. 15 c. In cell F8, enter the formula to sum the Total Factory Overhead for the cookies. Copy this formula to cell L8. 16 d. Enter in cells F9 and L9, the budgeted units of production for each product. 17 e. In cell F10, enter the formula to determine the Factory overhead per unit. Copy this formula to cell L 10. 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 with the followin In problem SA 18-1, what is the factory overhead per unit for the crackers? Oa. $6.68 Ob. $102,400 Oc. $66,800 Od. $10.24 Feedback Check My Work Correct Check My Work Previous Next