Open up your saved electronic file $"$C$2-$ Excel Job Order Costing" from "Excel $-$based Decisions in Managerial Accounting" and copy the $"$DM$"$ and $"$DL$"$ worksheets into a new workbook. Save your new workbook using the following file name: $"[$Your Last Name$]$ Ch $2$ Excel Homework".

With your $"[$Your Last Name$]$ Ch $2$ Excel Homework" file already open, open your completed $"$C$2-$ Excel Practice Sets $-[$Your Last Name$]"$ file and copy all of the worksheets contained therein to your $"[$Your Last Name$]$ Ch $2$ Excel Homework" file; ensure all of the worksheets copied over from the "Practice Sets" file are in front of $($from left to right$)$ the worksheets copied over from the "Job Order Costing" file. Change the names of the just$-$copied$-$over "Practice Sets" worksheets of $"$DM$"$ and $"$DL$"$ to $"$PSDM$"$ and $"$PSDL$".$ Within the $"[$Your Last Name$]$ Ch $2$ Excel Homework" file complete the following requirements:

a$.$ Add a new worksheet and name it "Overhead". Within this new worksheet create a schedule $($using appropriate formatting techniques learned to this point in the course$)$ that depicts the names, cost drivers, estimated quantity of cost driver activity, estimated total overhead dollars, and predetermined manufacturing overhead rate $($POHR$)$ of each of the two departments of Wedgewood Candle Company. Use formulas and cell references only $($no manually input figures allowed$)$ within the cell representing the calculation of the predetermined manufacturing overhead rate.

b$.$ Name each of the eight "Wage per hour" cells $($that actually contain a dollar value$)$ on the $"$DL$"$ worksheet $($Columns C and F$).$ Each cell name should start with the first initial of your first name and the first initial of your last name and then include an appropriate description of the cost to which the dollars within the cell relate $($no space in between any of these three required components$).$ For example, the cell containing the $$7\mathrm{.}00$ for apprentice wages per hour for my submission $($Randy Hucks$)$ could be named "rhapprentice".

c$.$ Add three new worksheets to the workbook, naming them "Sculpted", "Imprinted", and "Additive", respectively, to represent the three new product lines Wedgewood is implementing. Within each of these new worksheets create a Job Cost Sheet for the specialty candle line to which the worksheet relates.

i$.$ Each of these three new Job Cost Sheets should be created to resemble $($but not necessarily identical to$)$ the example Job Cost Sheet provided for Wedgewood Candle Co$.$ and accomplish all of the same calculations performed within the