MANAGERIAL ACCOUNTING
MANAGERIAL ACCOUNTING
8th Edition
ISBN: 9781264116737
Author: BREWER
Publisher: MCG
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 2, Problem 2AE

This Excel worksheet relates to the Dickson Company example that is summarized in Exhibit 2-5. Download the workbook containing this form from Connect, where you will also find instructions about how to use this worksheet form.Chapter 2, Problem 2AE, This Excel worksheet relates to the Dickson Company example that is summarized in Exhibit 2-5. , example  1

Chapter 2, Problem 2AE, This Excel worksheet relates to the Dickson Company example that is summarized in Exhibit 2-5. , example  2

Chapter 2, Problem 2AE, This Excel worksheet relates to the Dickson Company example that is summarized in Exhibit 2-5. , example  3

You should proceed to the requirements below only after completing your worksheet.
Required:
2. Change the total fixed manufacturing overhead cost for the Milling Department in the Data area back to $390,000, keeping ail of theother data the same as in the original example Determine the selling price for a new job, Job 408, with the following characteristics.You need not bother changing the job number from 407 to 408 in the worksheet. Chapter 2, Problem 2AE, This Excel worksheet relates to the Dickson Company example that is summarized in Exhibit 2-5. , example  4

Expert Solution & Answer
Check Mark
To determine

Selling price: The cost incurred by selling the product in the market is known as the selling price.

Determine the missing figures in the sheet. After finding the missing figures determine the selling price of Job 408 by replacing the current data with the data given in the question.

Answer to Problem 2AE

Solution: The selling price of Job 408 using current data is $4348.75 and the selling price of Job 408 after replacing the current data with the given data is $2800.

Explanation of Solution

This calculation is done in the workbook and it is explained below,

Part -1- The missing figures in the sheet is determined here.

    Chapter 2: Applying Excel
    Data
    Mark-up on job cost75%
    Department
    MillingAssembly
    1Machine hours600003000
    2Direct Labour Hours800080000
    3Total fixed manufacturing overhead cost$3,90,000.00$5,00,000.00
    4Variable manufacturing overhead per machine hour$2.00$ -
    5Variable manufacturing overhead per direct labour hour$ -$ 3.75
    Cost Summary for job 407Department
    MillingAssembly
    6Machine hours904
    7Direct Labour Hours520
    8Direct Materials$800.00$370.00
    9Direct Labour cost$70.00$280.00
    Enter a formula into each of the cells marked with? below
    Step 1: Calculate the estimated total manufacturing overhead cost for each department
    MillingAssembly
    10Total fixed manufacturing overhead (given)$3,90,000.00$5,00,000.00
    11Variable manufacturing overhead per machine hour or direct labour hour (given)$2.00$3.75
    12Total machine hours or direct labour hours (given)6000080000
    13Total Variable manufacturing overhead (11 x 12)$1,20,000.00$3,00,000.00
    14Total manufacturing overhead (10 + 13)$5,10,000.00$8,00,000.00
    Step 2: Calculate the pre-determined overhead rate in each department
    MillingAssembly
    15Total manufacturing overhead (14)$5,10,000.00$8,00,000.00
    16Total machine hours or direct labour hours (given)6000080000
    17Pre-determined overhead rate per machine hour or direct labour hour (15 divided by 16)$8.50$10.00
    Step 3: Calculate the amount of overhead applied to both departments to Job 407
    MillingAssembly
    18Pre-determined overhead rate per machine hour or direct labour hour (17)$8.50$10.00
    19Machine hours or direct labour hours for the job (given)9020
    20Manufacturing overhead applied (18 x 19)$765.00$200.00
    Step 4: Calculate the total job cost for Job 407
    MillingAssembly
    21Direct Materials (given)$800.00$370.00
    22Direct Labour cost (given)$70.00$280.00
    23Manufacturing overhead applied (20)$765.00$200.00
    24Total cost of Job 407 (21 + 22 + 23)$1,635.00$850.00
    Total cost of Job 407 (Milling + Assembly)$2,485.00
    Step 5: Calculate the selling price for Job 407
    MillingAssembly
    25Total cost of Job 407 ( 24)$1,635.00$850.00
    26Mark-up (24 x 75%)$1,226.25$637.50
    27Selling price of Job 407 (25 + 26)$2,861.25$1,487.50
    Total Selling Price (Milling + Assembly)$4,348.75

Part 2 - The selling price of Job 408 by replacing the current data with data given

    Chapter 2: Applying Excel
    Data
    Mark-up on job cost75%
    Department
    MillingAssembly
    1Machine hours600003000
    2Direct Labour Hours800080000
    3Total fixed manufacturing overhead cost$3,90,000.00$5,00,000.00
    4Variable manufacturing overhead per machine hour$2.00$ -
    5Variable manufacturing overhead per direct labour hour$ -$3.75
    Cost Summary for job 408Department
    MillingAssembly
    6Machine hours4010
    7Direct Labour Hours26
    8Direct Materials$700.00$360.00
    9Direct Labour cost$50.00$150.00
    Enter a formula into each of the cells marked with? Below
    Step 1: Calculate the estimated total manufacturing overhead cost for each department
    MillingAssembly
    10Total fixed manufacturing overhead (given)$3,00,000.00$5,00,000.00
    11Variable manufacturing overhead per machine hour or direct labour hour (given)$2.00$3.75
    12Total machine hours or direct labour hours (given)6000080000
    13Total Variable manufacturing overhead (11 x 12)$1,20,000.00$3,00,000.00
    14Total manufacturing overhead (10 + 13)$4,20,000.00$8,00,000.00
    Step 2: Calculate the pre-determined overhead rate in each department
    MillingAssembly
    15Total manufacturing overhead (14)$4,20,000.00$8,00,000.00
    16Total machine hours or direct labour hours (given)6000080000
    17Pre-determined overhead rate per machine hour or direct labour hour (15 divided by 16)$7.00$10.00
    Step 3: Calculate the amount of overhead applied to both departments to Job 408
    MillingAssembly
    18Pre-determined overhead rate per machine hour or direct labour hour (17)$7.00$10.00
    19Machine hours or direct labour hours for the job (given)406
    20Manufacturing overhead applied (18 x 19)$280.00$60.00
    Step 4: Calculate the total job cost for Job 408
    MillingAssembly
    21Direct Materials (given)$700.00$360.00
    22Direct Labour cost (given)$50.00$150.00
    23Manufacturing overhead applied (20)$280.00$60.00
    24Total cost of Job 407 (21 + 22 + 23)$1,030.00$570.00
    Total cost of Job 407 (Milling + Assembly)$1,600.00
    Step 5: Calculate the selling price for Job 408
    MillingAssembly
    25Total cost of Job 407 ( 24)$1,030.00$570.00
    26Mark-up (24 x 75%)$772.50$427.50
    27Selling price of Job 407 (25 + 26 )$1,802.50$997.50
    28Total Selling Price of Job 408 (Milling + Assembly)$2,800.00
Conclusion

Thus, the selling price of Job 408 after replacing the current data with the given data is $2800.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Bob Randall, cost accounting manager for Hemple Products, was asked to determine the costs of the activities performed within the company's Manufacturing Engineering Department. The department has the following activities: creating bills of materials (BOMs), studying manufacturing capabilities, improving manufacturing processes, training employees, and designing tools. The resource costs (from the general ledger) and the times to perform one unit of each activity are provided below. Resource Costs        Activities Unit Time        Driver Salaries $425,000        Creating BOMs 0.6 hr.        No. of BOMs Equipment 92,000        Designing tools 3.7 hrs.        No. of tool designs Supplies 43,000        Improving processes 1.1 hrs.        Process improvement hrs. Total $560,000        Training employees 2.1 hrs.        No. of training sessions            Studying capabilities 2.1 hrs.        Study hours Total machine and labor hours (at practical capacity): Machine…
Bob Randall, cost accounting manager for Hemple Products, was asked to determine the costs of the activities performed within the company’s Manufacturing Engineering Department. The department has the following activities: creating bills of materials (BOMs), studying manufacturing capabilities, improving manufacturing process, training, employees, and designing tools. The resources costs (from the general ledger) and the times to perform one unit of each activity are provided below: Resource Cost Activities Unit Time Driver Salaries $500,000 Creating BOMs 0.5 hr. No. of BOMs Equipment 100,000 Designing Tools 5.4 hr. No. of tools designs Supplies 30,000 Improving processes 1.0 hr. Process improvement hrs Total $630,000 Training employees 2.0 hr. No. of training sessions     Studying capabilities 1.0 hr. Study hrs. Total machine and labor hours (at practical capacity):…
I could use some help answering this with the attached spreadsheet. I finished parts a through c:   Glassman Company acculated the following data for 2019: Milling Department manufacturing overhead $484,000 Finishing Department manufacturing overhead $260,000 Machine hours used         Milling Department 10,000      Finishing Deparment 2000 Labor hours used         Milling Department 1000      Finishing Department 1000   Assume that manufacturing overhead for Glassman Company above consisted of the following activities and costs:   Setup  (1000 setup hours) $288,000 Production scheduling (400 batches) $60,000 Production engineering (60 change orders) $180,000 Supervision (2000 direct labor hours) $56,000 Machine maintenance (12,000 machine hours) $168,000      Total activity costs $752,000 The following additional data were provided for Job 845: Direct materials costs $7000 Direct labor cost (5 milling direct labor hours; 35 finishing direct…

Chapter 2 Solutions

MANAGERIAL ACCOUNTING

Ch. 2 - Prob. 11QCh. 2 - What is underapplied overhead? Overapplied...Ch. 2 - What is a plantwide overhead rate? Why are...Ch. 2 - This Excel worksheet relates to the Dickson...Ch. 2 - This Excel worksheet relates to the Dickson...Ch. 2 - This Excel worksheet relates to the Dickson...Ch. 2 - This Excel worksheet relates to the Dickson...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Sweeten Company bad no jobs in progress at the...Ch. 2 - Harris Fabrics computes its plantwide...Ch. 2 - Luthan Company uses a plant wide predetermined...Ch. 2 - Computing Total Job Costs and Unit Product Costs...Ch. 2 - Computing Total Job Costs and Unit Product Costs...Ch. 2 - Braverman Company has two manufacturing...Ch. 2 - Job-Order Costing for a Service Company Tech...Ch. 2 - Prob. 7ECh. 2 - Newhard Company assigns overhead cost to jobs on...Ch. 2 - Taveras Corporation is currently operating at 50%...Ch. 2 - Prob. 10ECh. 2 - Varying Plantwide Predetermined Overhead Rates...Ch. 2 - Computing Predetermined Overhead Rates and Job...Ch. 2 - Departmental Predetermined Overhead Rates White...Ch. 2 - Prob. 14ECh. 2 - Plantwide and Departmental Predetermined Overhead...Ch. 2 - Plantwide Predetermined Overhead Rates; Pricing...Ch. 2 - Plantwide and Departmental Predetermined Overhead...Ch. 2 - Job-Order Costing for a Service Company Speedy...Ch. 2 - Multiple Predetermined Overhead Rates; Applying...Ch. 2 - Plantwide versus Multiple Predetermined Overhead...Ch. 2 - Plantwide versus Multiple Predetermined Overhead...
Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Text book image
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Text book image
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Text book image
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Text book image
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Text book image
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cost Classifications - Managerial Accounting- Fixed Costs Variable Costs Direct & Indirect Costs; Author: Accounting Instruction, Help, & How To;https://www.youtube.com/watch?v=QQd1_gEF1yM;License: Standard Youtube License