Open your saved electronic file C3 Excel Practice Sets from Excel based Decisions in Managerial Accounting; in order to keep an unedited, original version of this file (should you need to start over), please first perform a Save As to save a new version of this file and name it C3 Excel Practice Sets [Your Last Name]. Using this ...[Your Last Name] file read and work through pages 3-1 through 3-9 of chapter 3 in Excel-based Decisions in Managerial Accounting, completing all of the Excel-based tasks as instructed and then complete the following:1.Read the Wedgewood Candle Co. information on pages 3-9 through 3-16. Throughout pages 3-9 through 3-16 there are several instances in which you are directed to stop and answer certain questions contained on pages 3-17 through 3-21...it is not necessary for you to answer these questions as part of this homework assignment (or any homework assignment); all requirements of this assignment are strictly detailed within this Word document. 2. Open up your saved electronic file C3 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 3 Excel Homework. 3. With your [Your Last Name] Ch 3 Excel Homework file already open, open your completed C3 Excel Practice Sets [Your Last Name] file and copy all of the worksheets contained therein to your [Your Last Name] Ch 3 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 3 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.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 users 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 worksheet) and then Protect each worksheet (do not set a password). 4. Submit your completed Excel workbook through Canvas Check Figure for 50 4 inch sculpted candles with 12 candles per batch: $5.48