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 example Job Cost Sheet of Wedgewood $($extended cost for each line$-$item, total cost of each main manufacturing cost category $($DM$,$ DL$,$ MOH$),$ total cost of a job, and total cost per unit of each unit completed on the job$).$

ii$.$ Each of these three new Job Cost Sheets should be created in a manner to which ONLY the following should be able to be manually entered within the spreadsheet $($all other information should be automatically calculated upon a

user$$s manual entry of these values within designated cells $($READ: there should be an area of the spreadsheet in which there are cells specifically designated for entry of these values$))$:

$$ The $$Candle Height$$ of the particular type of candle ordered on the job,

$$ The $$Quantity Ordered$$ of the particular type of candle on the job, and

$$ The $$Candles per Batch$$

iii. Use the ROUNDUP function to calculate the number of batches in order to

calculate the batch cost properly.

iv$.$ After completing each Job Cost Sheet lock all cells of the spreadsheet with the

exception of the three manual input cells within each Job Cost Sheet $($or$,$ if the cells of the spreadsheet are already locked, then unlock the three manual input cells within each Job Cost Sheet w