Managerial Accounting Excel Assignment #1 Job Order Costing You have just been hired as an intern management accountant for Wagner Chocolates. Wagner has never done any cost accounting before. Your first duty is to assign costs to the company's signature product, premium hand-crafted chocolates which are sold by the dozen. Company management desires to calculate the average cost of a box of chocolates in order to price the chocolates appropriately. The following information is given to you: Standard Costs: Each box of a dozen chocolates uses 2 pounds of the finest imported dark chocolate. Wagner purchases the chocolate for $4 per pound. Each box requires 15 minutes of direct labor. Wagner's employees are paid an average of $15 an hour. Benefits add another $5 per hour to the direct labor cost. Factory overhead is allocated to the product at a rate of $4 per direct labor hour. Although you could easily calculate the cost of a box of chocolates manually, you know that future assignments will be more complicated, so you decide to set up an excel spreadsheet to do all of your calculations. Assignment: Create an Excel spreadsheet to do this calculation. The first part of the spread sheet should contain only the information given to you, in a neat, organized, well-labeled format. The second part of the spreadsheet should contain formulas to calculate the three components of cost and the total cost per box. You should not enter any numbers in this part of the spreadsheet. Use formulas and cell references here. Make sure your spreadsheet is formatted to fit on one page and that your name is in the body of the spreadsheet. Submit the assignment as an attachment through Black Board