Please show calculations on excel spreadsheet. Thank you
Calculate following
Question | Answer |
Overhead rate (600000/20000) | 30 per labor hour |
Allocated overhead to Job | 225*30 = 6750 |
Total Costs to Job | 9000+1000+6750 = 16750 |
Selling price | 16750*1.1 = 18425 |
Please show calculations on excel spreadsheet. Thank you Read each question carefully! Record your answers in...
please show work on excel spreadsheet with calculations
Problem 3: Job Costing - Two Departments (20 points) Rhett Company has two departments, Machining and Assembly. The following estimates are for the coming year. Machining Assembly Direct manufacturing labor-hours 10,000 50,000 Machine-hours 40,000 10,000 Manufacturing overhead $400,000 $800,000 The machining department uses direct labor hours to allocate overhead while the assembly department uses machine hours. The actual data for Job # 1 is as follows: Machining 50 Assembly 20 Direct manufacturing...
pleas provide excel spreadsheet showing calculations thank
you
Read each question carefully! Make sure that you have answered all parts of each question. Please write your final answers in the spaces provided. Please attach any supporting documents for your answers. Spreadsheets should be well labelled and easy to read. Good Luck! Problem 1 - Master Budget Jensen Manufacturing has the following information relating to their master budget for 2020 Units Sold Selling Price 5,000 units $210 per unit Pounds of...
please help ! struggling
thumbs up for all correct answers
Landen Corporation uses a job-order costing system. At the beginning of the year, the company made the following estimates: Direct labor-hours required to support estimated production Machine-hours required to support estimated production Fixed manufacturing overhead cost Variable manufacturing overhead cost per direct labor-hour Variable manufacturing overhead cost per machine-hour 95,000 47,500 $266,000 2.60 $ 5.20 During the year, Job 550 was started and completed. The following information is available with...
please elaborate on answers. thank you.
Moody Corporation uses a job-order costing system with a plantwide predetermined overhead rate based on machine-hours. A beginning of the year, the company made the following estimates: Machine-hours required to support estimated production Fixed manufacturing overhead cost Variable manufacturing overhead cost per machine-hour 100,000 $ 650,000 $ 3.00 Required: 1. Compute the plantwide predetermined overhead rate, 2. During the year, Job 400 was started and completed. The following information was available with respect to...
Its all one problem, just had to post it in two different
pictures. Thank you!!
Landen Corporation uses a job-order costing system. At the beginning of the year, the company made the following estimates: Direct labor-hours required to support estimated production Machine-hours required to support estimated production Fixed manufacturing overhead cost Variable manufacturing overhead cost per direct labor-hour Variable manufacturing overhead cost per machine-hour 65,000 32,500 $195,000 $ 1.20 $ 2.40 During the year, Job 550 was started and completed....
please answer A, B, C on both 1 & 2 for it is 1 question.
Landen Corporation uses a job-order costing system. At the beginning of the year, the company made the following estimates: Direct Labor-hours required to support estimated production Machine-hours required to support estimated production Fixed manufacturing overhead cost Variable manufacturing overhead cost per direct labor-hour Variable manufacturing overhead cost per machine-hour 140,000 70,000 $784,000 $ 2.09 $ 4.00 During the year, Job 550 was started and completed....
You are required to show your work for this problem by handwriting any supporting calculations and journal entries or t-accounts on your own paper and submitting it after the test is over via the "Show Your Work Submission Link" in Blackboard. Label your work with the question number and label any journal entries with the corresponding letter. Isiah’s Instruments manufactures and sells trombones and uses job costing to assign costs to his products. The company estimated that it would incur...
Problem 2-16 Plantwide Predetermined Overhead Rates; Pricing (L02-1, LO2-2, LO2-3) Landen Corporation uses a job-order costing system. At the beginning of the year, the company made the following estimates: Direct labor-hours required to support estimated production Machine-hours required to support estimated production Fixed manufacturing overhead cost Variable manufacturing overhead cost per direct labor-hour Variable manufacturing overhead cost per machine-hour 1 40,000 70,000 $784, eee $ 2.00 $ 4.00 During the year, Job 550 was started and completed. The following information...
how do I do this spreadsheet in a sense of equations.
Download the Applying Excel form and enter formulas in all cells
that contain question marks.
The Chapter 2 Form worksheet is to be used to create your own
worksheet version of the example in the text.
Enter formulas in the cells that contain question marks. For
example, in cell B25 enter the formula "=B10".
After entering formulas in all of the cells that contained
question marks, verify that the...
Please show your work step by step. Thank you!
4. Miniae Company uses departmental manufacturing overhead rates to apply overhead. Direct labor cost is used to apply manufacturing overhead in Department A and machine hours are used for Department B. Below are estimated costs for Miniae Company Direct Labor Cost Factory Overhead Direct Labor Hours Machine Hours Dept. A $66,000 $79,200 8,000 4,000 Dept. B $33,000 $60,000 9,000 | 15,000 ial costs are given below: Direct Labor Cost Factory Overhead...