Verizon LTE 2:35 PM Back ACTG 4B Team Project 1.doc Activity-Based Team Project #1 (20 points) Costing Directions: Each team will be responsible for completing the case detailed below these instructions. This project should be done using Excel. Parts 1, 2, 2A, and 3 should be performed on separate spreadsheets in your Excel workbook. Part 3 should be an embedded Word document, since it is a memo. I will demonstrate how to embed a document and provide a brief description of what a memo should look like. Each team will submit the finished product via e-mail as an attachment. The project due date is noted on your class timeline. Note: The project is due via email by midnight on the due date. You need to use formulas and cell references whenever possible. If you do not use formulas or cell references, I will deduct points. Part 1 of the assignment requires you to determine the cost of a unit of coffee (Mona Loa and Malaysian) using the traditional overhead allocation method. A unit of coffee is a one pound bag. The unit cost will include direct materials, direct labor, and manufacturing overhead (as determined using the predetermined overhead rate). You NEED to use Excel formulas whenever possible. Basically, the only time you will not use formulas is when you enter given information. Part 2 of the assignment requires you to determine the cost of a unit of coffee (Mona Loa and Malaysian) using the activity-based costing method. As with the traditional method, you will need to show direct materials, direct labor and manufacturing overhead (as determined using ABC). Once again, use formulas wherever you can. Part 2A is a comparison of both methods. Link the numbers to Parts 1 and 2 whenever possible. Show a side- by-side comparison of unit product costs calculated under each method (show the unit product cost of each type of coffee using both traditional and ABC costing). Unit product costs include direct materials, direct labor and manufacturing overhead costs on a per unit basis. Further, determine the changes in the profit margins for each bag of coffee under both methods (the sales price mark up % is Dashboard Calendar To Do Notifications Inbox