Hello, I need help with this project. In Part 1, Question A I had calculated the beginning Fnished Goods and Begiining Work-in PRocess accounts for year 3 to be:

A.Job AT-360: 4,800 x 155 = 744,000

Job At- 365: 6,200 x 155 = 961,000

4,800/11,000 = 44%

6,200/11,000 = 56%

44%x 15,340,000 = $6,749,600 Manufacturing Overhead

56% x 15,340,000 = $8,590,400 Manufacturing Overhead

Beginning Finished Goods: 744,000+6,749,600+ 680,000= $8,173,600

Beginning Work-in-Process: 961,000+8,590,400 + 947,000 = $10,498,400

Is this correct?

Also for question C I have calculated:

18,609,400 - [ $21x (150,000+2,600+3,400 + 7,500)] =15,175,900

The underapplied overhead for year 3 was 3,433,500.

Graded Project Cost Accounting CONTENTS OBJECTIVE\t2 PURPOSE\t2 PART 1: JOB COSTING 2 PART 2: PROCESS COSTING 4 PART 3: ACTIVITY-BASED COSTING 5 GRADING CRITERIA 6 SUBMITTING YOUR PROJECT 8 PENN FOSTER, INC. 2017 COST ACCOUNTING Graded Project PAGE 1 COST ACCOUNTING OBJECTIVE The objective of this graded project is to allow you to demonstrate your ability to perform cost accounting computations and analysis related to the concepts covered in this course. PURPOSE The purpose of this project is to give you practical experience with financial computations and decision making in the cost accounting field. In this project you'll calculate and analyze costs in the role of a cost accountant. Your assignment is to analyze the financial situations described and make the appropriate reports and computations. Show all calculations or calculator inputs for credit (Round to two digits after the decimal point when necessary). Part 1: Job Costing Crandall Corporation makes portable enclosures for festivals, concerts, and other events. Its products aren't mass producedeach unit is made to customer specifications. Crandall employs a normal job costing system. Direct labor at the company is compensated at a rate of $21 per hour;however, employees receive no pay when they aren't working on jobs. A predetermined rate based on direct labor-hours is used to assign manufacturing overhead to jobs. In the past two years, the company incurred manufacturing overhead costs (adjusted for price-level changes using current prices and wage rates) as follows: Year 1 Direct labor-hours worked Year 2 144,000 118,000 $4,580,000 $5,603,340 2,204,000 3,134,000 Supplies 858,000 1,367,400 Power 620,000 987,420 Heat and light 244,000 210,870 Manufacturing overhead costs incurred: Indirect labor Employee benefits Supervision Depreciation Property taxes and insurance Total manufacturing overhead costs 598,000 721,970 2,370,000 2,370,000 945,000 945,000 $12,419,000 $15,340,000 PENN FOSTER, INC. 2017 COST ACCOUNTING Graded Project PAGE 2 At the start of Year 3, Crandall has two jobs not yet delivered to customers. Job AT-360 was completed on December 15, Year 2. It's scheduled to ship out on January 21, Year 3. Job AT-365 is still in progress. The predetermined rate in Year 2 was $155 per direct labor-hour. Data on direct material costs and direct labor-hours for these jobs in Year 2 was as follows: Job AT-360 Job AT-365 Direct material costs $680,000 $947,000 Direct labor-hours 4,800 hours 6,200 hours During Year 3, Crandall incurred direct material costs and direct labor-hours for all jobs worked in Year 3, including the completion of Job AT-365, as follows: Direct material costs $15,780,000 Direct labor-hours 150,000 Actual manufacturing overhead $18,609,400 To compute the predetermined overhead rate, Crandall uses the previous year's actual overhead rate. At the end of Year 3, three jobs had not been shipped. Data on these jobs is as follows: AT-285 AT-288 AT-292 Direct materials $154,000 $224,500 $112,400 Direct labor-hours 2,600 hours 3,400 hours 7,500 hours Job status Finished Finished In progress A. What was the amount in the beginning Finished Goods and beginning Work-inProcess accounts for Year 3? B. Crandall incurred direct materials costs of $210,000 and used an additional 800 hours in Year 3 to complete Job AT-365. What was the final (total) cost charged to Job AT-365? C. What was the overapplied or underapplied overhead for Year 3? D. Crandall prorates any overapplied or underapplied overhead to Cost of Goods Sold, Finished Goods Inventory, and Work-in-Process Inventory. Prepare a | properly formatted journal entry to prorate the Overapplied or Underapplied Overhead calculated in requirement. As an allocation basis, use the direct labor hours in each account from Year 3. E. A customer requested that Crandall bid on a job to be finished in Year 4. Crandall has estimated that the job will need approximately $156,000 in direct materials and 8,000 direct labor-hours. Due to the condition of the economy, Crandall believes demand for its services will be below average in Year 4, and the CEO therefore would like to bid aggressively, but doesn't want to lose money on the project. Crandall estimated essentially no sales or administrative costs connected with this job. What is the minimum amount the company can bid on the job and not incur a loss? (In order to perform an estimation of the variable portion of overhead, use the high-low method.) PENN FOSTER, INC. 2017 COST ACCOUNTING Graded Project PAGE 3 Part 2: Process Costing Intrepid Industries manufactures sterile parts used in medical equipment. The company uses the weighted-average process costing method to account for production costs. It produces parts in three different departments: Forming, Sterilization, and Assembling. The following information was reported for the Assembling Department for the month of June: Work in process on June 1 had 250,000 units made up of the following: Amount Prior department costs transferred in from the Forming Department Degree of Completion $387,600 100% Direct materials 317,200 100% Direct labor 120,050 40% 67,100 30% Costs added by the Sterilization Department: Manufacturing overhead $504,350 Work in process, June 1 $891,950 During June, 580,000 units were transferred in from the Forming Department at a cost of $1,870,000. The Assembling Department added the following costs: Direct materials $974,800 Direct labor 318,600 Manufacturing overhead 202,000 Total costs added $1,495,400 Assembling finished 480,000 units and transferred them to the Sterilization Department. At June 31, 225,000 units were still in work-in-process inventory. The degree of completion of work-in-process inventory at June 30 was as indicated below: Direct materials 80% Direct labor 65 Manufacturing overhead 30 A. Prepare a correctly formatted (including heading) production cost report (see Exhibit 8.11 as a example report) using the weighted-average method. B. Management wants to lower the costs of manufacturing the parts. It has established the following per unit targets for this product in the Assembling Department: materials, $1.65; labor, $.62; and manufacturing overhead $0.48. Has the product achieved management's cost targets in the Assembling Department? Write a short report to management containing your answer(s). PENN FOSTER, INC. 2017 COST ACCOUNTING Graded Project PAGE 4 C. Prepare a correctly formatted (including heading) production cost report (see Exhibit 8.12 as a example report) using the FIFO method using the data given in Question A with one exception: the beginning direct materials costs as of June 1 listed in work-in-process should be $315,700 instead of $317,200. D. Using data from the FIFO report, write a short report to management addressing the issues raised in Question B. Part 3: Activity-Based Costing Wayfarer Corporation is contemplating changing its cost system to an activity-based costing system and wants to know more about the effects of doing so. The corporation's cost accountant has identified three overhead cost pools along with the cost drivers associated with each pool as follows: Cost Pools Costs Activity Drivers Utilities $5,420,000 Delivery 5,420,000 Assembly 10,940,000 180,000 machine hours 10,000 deliveries 2,000,000 pounds of material The corporation makes three models of kitchen sinks (Deluxe, Premium, and Standard). The plans for production for the next year and the direct costs that have been budgeted for activity by product are listed below: Products Deluxe Premium Standard Total direct costs (material and labor) $850,000 850,000 850,000 Total machine-hours 210,000 95,000 154,000 Total deliveries 310 620 480 Total pounds of material 1,800,000 1,200,000 2,600,000 Total direct labor-hours 12,400 8,500 18,600 Number of units produced 18,000 12,000 24,000 A. The current cost accounting system charges overhead to products on the basis of direct labor-hours. What unit product costs will be reported for the three products assuming the current cost system continues to be used? B. What are the cost driver rates associated with the three cost pools specified by the cost accountant? C. What unit product costs will be reported for the three products if the ABC system suggested by the cost accountant's categorization of cost pools is utilized? PENN FOSTER, INC. 2017 COST ACCOUNTING Graded Project PAGE 5 GRADING CRITERIA The grading of this project is weighted. The weighting percentage shown is applied to the number of points to arrive at the score for that Part. The sum of the scores for all three parts is the total score for the project. Part 1: Job Costing (worth 80 points total - Weighting % = 37.2%) \tSection A Work In Process Inventory (worth 10 points) Finished Goods Inventory (worth 10 points) \tSection B Final (total) cost charged (worth 10 points) \tSection C Over-applied/Under-applied Overhead (worth 10 points) \tSection D Journal entry to prorate Over-applied/Under-applied Overhead (worth 20 points) \tSection E Application of High-Low method (worth 10 points) Minimum amount the company can bid without incurring a loss (worth 10 points) Points x 37.2% = Continued PENN FOSTER, INC. 2017 COST ACCOUNTING Graded Project PAGE 6 Part 2: Process Costing (worth 100 points total - Weighting % = 46.5%) \tSection A Prepare a Production Cost Report - Weighted Average Method (worth 25 points) Formatting of Productions Cost Report (worth 10 points) \tSection B Report to Management - to include reporting on three costs (worth 10 points) Written Communication - Professionally written Report to Management (worth 5 points) \tSection C Prepare a Production Cost Report - FIFO Method (worth 25 points) Formatting of Production Cost Report (worth 10 points) \tSection D Report to Management - to include reporting on three costs (worth 10 points) Written Communication - Professionally written Report to Management (worth 5 points) Points x 46.5% = Part 3: Activity-Based Costing (worth 35 points total - Weighting % = 16.3%) \tSection A Unit product costs for the three products (worth 15 points) \tSection B Cost drivers (worth 5 points) \tSection C Unit product costs for the three products (worth 15 points) Points x 16.3% = Total Score PENN FOSTER, INC. 2017 COST ACCOUNTING Graded Project PAGE 7 SUBMITTING YOUR PROJECT The preferred and fastest way for the project to be graded is by submitting your work online through your Student Portal. Show all of your work for all three parts of the project in one Microsoft Word document. (PDF's, scanned images, Excel spreadsheets inserted in a Word document, etc. will be returned as not graded due to the inability to markup the project electronically.) Submit your project online by uploading the finished/final copy of the Word document to the school. The name of the file should be your student id number followed by an underscore and then the number for this exam. For example, the file name could be 6539412_061425.doc or (.docx). Be sure the file contains the following information in the header: n Your name n Your student ID number n The lesson number (06142500) n Your e-mail address To submit your graded project, follow these steps: 1. Go to http://www.pennfoster.edu. 2. Log in to your student portal. 3. Click on Take Exam next to the lesson you're working on. 4. Follow the instructions provided to complete your exam. Be sure to keep a backup copy of any files you submit to the school! PENN FOSTER, INC. 2017 COST ACCOUNTING Graded Project PAGE 8