kk.Subject :- Accounting Required:1. Calculate the direct materials, direct labor, factory overhead, and total costs for each job started in June.2. Perform the same calculations as in requirement 1, but assume that the direct labor rate per hour increased by 10% in Department 1and 25% in Department 2.Complete this question by entering your answers in the tabs below.Required 1 Required 2Perform the same calculations as in requirement 1, but assume that the direct labor rate per hour increased by 10% inDepartment 1 and 25% in Department 2. (Do not round intermediate calculations. Round your answers to 2 decimal places.)Direct materialsDirect laborFactory overheadTotal job cost$$Job 290613,023.30 x $13,956.80 x5,856.00 x32,836.10 $Job 29074,620.00 $1,755.00 X2,632.50 x9,007.50 $Job 290812,384.00 $1,807.65 x663.00 x14,854.65 $Total30,027.3017,519.459,151.5056,698.25 !Required informationUse the data below to create Pivot Table(s) in Excel.You will use the pivot table(s) to fill out your answers in the requirements (worksheets) in Part 2.Submit your Excel File containing the Pivot Tables in Part 3.Decker Screw Manufacturing Company produces special screws made to customer specifications. During June, the following datapertained to these costs:DepartmentNumber12112DepartmentNumber12- NTN121DepartmentNumber12Summary of Direct Materials.RequisitionsJob RequisitionNumber Number Quantity2906B97664,8502907B97671702908B97681,1202906B97694,7302908B977029Cost perUnit$ 1.3022.009.001.3148.00Summary of Direct Labor Time TicketsJob TicketNumber NumberCost perUnit$ 6.509.00Hours2906 1056-1168 1,1142907 2121-21302908 1169-11892908 2131-12392906 1190-12396.509.006.5014816344822Summary of Factory OverheadApplication RatesBasis of Application Rates$3 per direct labor hour150% of direct labor costDecker had no beginning Work-in-Process Inventory for June. Of the jobs begun in June, Job 2906 was completed and sold onaccount for $30,000, Job 2907 was completed but not sold, and Job 2908 was still in process.Required:

The costs of a job—direct materials, direct labor, and manufacturing overhead—are added up when a…

Decker Screw Manufacturing Company produces special screws made to customer specifications. During June, the following data pertained to these costs: Department Number 1 2 1 1 2 Department Number 1 2 1 2 1 Department Number 1 2 Summary of Direct Materials Requisitions Job Requisition Number Number Quantity 2906 4,850 2907 170 2908 2906 2908 B9766 B9767 B9768 B9769 B9770 1,120 4,730 29 Cost per Unit $ 1.30 22.00 9.00 1.31 48.00 Summary of Direct Labor Time Tickets Job Ticket Cost per Number Number Hours 2906 1056-1168 1,114 2907 2121-2130 2908 1169-1189 2908 2131-1239 2906 1190-1239 148 163 44 822 Unit $ 6.50 9.00 6.50 9.00 6.50 Summary of Factory Overhead Application Rates Basis of Application Rates $3 per direct labor hour 150% of direct labor cost Decker had no beginning Work-in-Process Inventory for June. Of the jobs begun in June, Job 2906 was completed and sold on account for $30,000, Job 2907 was completed but not sold, and Job 2908 was still in process. Required:

Decker Screw Manufacturing Company produces special screws made to customer specifications. During June, the following data pertained to these costs: Department Number 1 2 1 1 2 Department Number 1 2 1 2 1 Department Number 1 2 Summary of Direct Materials Requisitions Job Requisition Number Number Quantity 2906 4,850 2907 170 2908 2906 2908 B9766 B9767 B9768 B9769 B9770 1,120 4,730 29 Cost per Unit $ 1.30 22.00 9.00 1.31 48.00 Summary of Direct Labor Time Tickets Job Ticket Cost per Number Number Hours 2906 1056-1168 1,114 2907 2121-2130 2908 1169-1189 2908 2131-1239 2906 1190-1239 148 163 44 822 Unit $ 6.50 9.00 6.50 9.00 6.50 Summary of Factory Overhead Application Rates Basis of Application Rates $3 per direct labor hour 150% of direct labor cost Decker had no beginning Work-in-Process Inventory for June. Of the jobs begun in June, Job 2906 was completed and sold on account for $30,000, Job 2907 was completed but not sold, and Job 2908 was still in process. Required:

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter20: Activity-based Costing (abc)

Section: Chapter Questions

Problem 1R: Bumblebee Mobiles manufactures a line of cell phones. The management has identified the following...

See similar textbooks

Similar questions

Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?
Bumblebee Mobiles manufactures a line of cell phones. The management has identified the following overhead costs and related cost drivers for the coming year. The following were incurred in manufacturing two of their cell phones, Bubble and Burst, during the first quarter. REQUIREMENT Review the worksheet called ABC that follows these requirements. You have been asked to determine the cost of each product using an activity-based cost system. Note that the problem information is already entered into the Data Section of the ABC worksheet.
to create a model for a production cost report using the weighted average method for the month of May. Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area. You should also include directions (in a text box) for users. After completion of the production cost report using the weighted average method, create a new worksheet and label the tab “FIFO”. Create a production cost report using the same information using the FIFO method. Spartans Bakery has two department: mixing and baking. All products start in the Mixing Department, where materials are added and conversion costs (labor, overhead) are incurred. Once the product is “finished” with regards to the Mixing, it moves to the Baking Department where additional conversion costs are incurred before moving to Finished…
Please complete the following 5 exercises below in either Excel or a word document (but must be single document). You must show your work where appropriate (leaving the calculations within Excel cells is acceptable). Save the document, and submit it in the appropriate week using the Assignment Submission button. 1. Overhead application: Working backward The Towson Manufacturing Corporation applies overhead on the basis of machine hours. The following divisional information is presented for your review: Division A Division B Actual machine hours 26,500 ? Estimated machine hours 20,000 ? Overhead application rate $5.00 $6.00 Actual overhead $120,000 ? Estimated overhead ? $90,000 Applied overhead ? $87,000 Over- (under-) applied overhead ? $8,500 Find the unknowns for each of the divisions. 2. Computationsusing a job order system Spencer Corporation employs a job order cost system. On May 1 the following balances…
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) Churchill Products is considering updating its cost system to an activity-based costing system and is interested in understanding the effects. The company’s cost accountant has identified three overhead cost pools along with appropriate cost drivers for each pool. Cost Pools Costs Activity Drivers Utilities $ 315,000 63,000 machine-hours Scheduling and setup 300,000 600 setups Material handling 795,000 1,590,000 pounds of material The company manufactures three models of water basins (Oval, Round, and Square). The plans for production for the next year and the budgeted direct costs and activity by product line are as follows. Products Oval Round Square Total direct costs (material and labor) $ 80,000 $ 70,000 $ 80,000 Total…
appropriate (leaving the calculations within Excel cells is acceptable). Save the document, and submit it in the appropriate week using the Assignment Submission button. 1. Overhead application: Working backward The Towson Manufacturing Corporation applies overhead on the basis of machine hours. The following divisional information is presented for your review: Division A Division B Actual machine hours 22,500 ? Estimated machine hours 20,000 ? Overhead application rate $4.50 $5.00 Actual overhead $110,000 ? Estimated overhead ? $90,000 Applied overhead ? $86,000 Over- (under-) applied overhead ? $6,500 Find the unknowns for each of the divisions. 2. Computationsusing a job order system General Corporation employs a job order cost system. On May 1 the following balances were extracted from the general ledger; Work in process $ 35,200 Finished goods 86,900 Cost of goods sold 128,700 Work in Process consisted of…
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) Variable and Absorption Costing-Service CompanyJensen's Tailoring provides custom tailoring services. After the company's first year of operations, its owner prepared the following summarized data report: Sales (500 completed jobs) $100,000 Tailoring costs (550 jobs) Direct labor 47,000 Manufacturing overhead Variable 12,000 Fixed 9,000 Operating expenses Variable 5,600 Fixed 5,800 a. Prepare an income statement based on full absorption costing. b. Prepare an income statement based on variable costing. c. Assume that you must decide quickly whether to accept a special one-time order to alter 50 band costumes for $125 per costume.Which income statement…
Please complete the following five exercises below in either Excel or a word document (but must be single document). You must show your work where appropriate (leaving the calculations within Excel cells is acceptable). Save the document, and submit it in the appropriate week using the Assignment Submission button. 1. Overhead application: Working backward The Towson Manufacturing Corporation applies overhead on the basis of machine hours. The following divisional information is presented for your review: Division A Division B Actual machine hours 22,500 ? Estimated machine hours 20,000 ? Overhead application rate $4.50 $5.00 Actual overhead $110,000 ? Estimated overhead ? $90,000 Applied overhead ? $86,000 Over- (under-) applied overhead ? $6,500 Find the unknowns for each of the divisions. 2. Computationsusing a job order system General Corporation employs a job order cost system. On May 1 the following balances…
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) Radz Company has two support departments (Administration and Janitorial) and three producing departments (Fabricating, Assembly, and Finishing). Costs and activities are as follows: Administration Janitorial Fabricating Assembly Finishing direct cost $60000 $55000 $40000 $50000 $25000 number of employees 10 30 40 20 square feet 2000 1000 28000 15000 direct labour hours 5000 6000 1000 machine hours 1000 2000 5000 Administrative services are allocated based on the number of employees; janitorial services are allocated based on square footage. Overhead rates for the Fabricating and Assembly producing departments are based on direct labor hours while for Finishing department rate is based on machine hours. A recent job QW8 had the following…
Directions: Answer the following questions by the due date. Use numerical calculations (if needed) to support your argument. Submit your answers through uploading a Microsoft Word file, Excel file or PDF. Tread-Force Fitness, Inc. assembles and sells elliptical machines. All activity costs are related to labor. Management must remove $2.00 of activity cost from the product in order for it to remain competitive. Activity-based product information for each elliptical machine is as follows: (Hrs per unit) Activity Activity Based Usage x Activity rate / hr = Activity Cost Moving 0.20 $15 $3.00 Motor Assembly 1.50 $20 $30.00 Final Assembly…
You have been hired as a Cost Accountant by Sundial, Inc., which produces sunglasses. Your duties include developing cost standards for materials and labor, designing and implementing cost accounting systems, defining various product and operational costs, analyzing production costs and recommending changes. When the trial period is over, you will have a performance review to demonstrate the completed tasks and gained knowledge. You have read the Cost of Quality Report of Sundial, Inc. and discovered that quality costs constitute 4.2% of sales. The amount is enormous, and your boss asks you to develop a set of measures to reduce it. Sundial, Inc. Cost of Quality Report For the Year Cost of Quality Percent of Sales ($32,000,000) Prevention costs $160,000 0.5% Appraisal costs…
Data Master is a computer software consulting company. Its three major functional areas are computer programming, information systems consulting, and software training. Cynthia Moore, a pricing analyst in the Accounting Department, has been asked to develop total costs for the functional areas. These costs will be used as a guide in pricing a new contract. In computing these costs, Moore is considering three different methods of allocating overhead costs-the direct method, the step method, and the reciprocal method. Moore assembled the following data on overhead from its two service departments, the Information Systems Department and the Facilities Department. Service Departments User Departments Info Systems Facilities Computer Program Consult Training Total Budgeted Overhead $ 50,000 $ 25,000 $ 75,000 $ 110,000 $ 85,000 $ 345,000 Info Systems (hrs.) 400 1,100 600 900 3,000 Facilities (Square feet) 200,000…