Question

You will be submitting two excel files to Bb for this assignment. REQUIREMENTS: Prepare an analysis of the estimated cost for Adria Manufacturing company's two products contrasting a traditional costing system and an ABC system using the data in the problem data file posted to Blackboard. (This will be your first excel file) Answer Part 3 under the requirements on a separate sheet in your first excel file only. Rename the sheet: Part 3. You do not need to provide an analysis for the What If file. • Complete the "What If Analysis” described below. (This will be your second excel file) DATA BLOCK AREA: Your first step is to set up a Data Block (or data entry) area and enter the data from the problem. You will use this area as a "data entry" area and then "cell reference" this information to complete your analysis report contrasting traditional vs. ABC product cost. You can use the following format for your data block/data entry area (see the highlighted area below). Highlight the data entry area with a #color of your choice. Make sure the color is not too dark and that it looks professional. Adria Manufacturing GENERAL DATA: AX40 XXXXX EX90 XXXXX $ XXXX $ xxxx Annual sales in units Direct materials per unit Direct labor cost per unit Direct labor hours per unit $ XXXX $ XXXX XXX XXX

Answer 1

................................................................................................................................................................................................................................................................................................................................................................................................................