Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Open up your saved electronic file C 2 - Excel Job Order Costing from Excel - based Decisions in Managerial Accounting and copy the

Open up your saved electronic file "C2- 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 "C2- 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.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
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Carl S. Warren, James M. Reeve, Jonathan E. Duchac

10th Edition

B010IKDQZM

More Books

Students also viewed these Accounting questions

Question

2. Describe three common types of routine requests.

Answered: 1 week ago