schaffer_BT7e_E4_23A_start_tutorial

xlsx

School

Kent State University *

*We aren’t endorsed by this school

Course

36085

Subject

Accounting

Date

Feb 20, 2024

Type

xlsx

Pages

5

Report

Uploaded by LieutenantDinosaur3611

Activity-Based Costing, Lean Operations, and the Costs of Quality Compute activity rates and apply to jobs Activity Allocation Base Materials handling $12,000 Number of parts Machine setup 3,400 Number of setups Insertion of parts 48,000 Number of parts Finishing 80,000 Finishing direct labor hours Total $143,400 Parts Setups 3,000 10 2,000 Parts Used Job 420 200 2 130 Job 510 425 4 350 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Requirements 1 Compute the cost allocation rate for each activity. 2 Compute the manufacturing overhead cost that should be assigned to Job 420. 3 Compute the manufacturing overhead cost that should be assigned to Job 510. Fuller Company uses ABC to account for its chrome wheel manufacturing process. Company managers have identified four manufacturing activities that incur manufacturing overhead costs: materials handling, machine setup, insertion of parts, and finishing. The budgeted activity costs for the upcoming year and their allocation bases are as follows: Total Budgeted Manufacturing Overhead Cost Fuller Company expects to produce 1,000 chrome wheels during the year. The wheels are expected to use: Finishing Hours Consumed Setups Required Finishing Hours Consumed Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong. For help completing the requirements, watch the video walk through.
Saving & Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open c. Click Upload button under step 3 d. Click Submit button under step 4 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link; this will bring up your Score Summary 4 Within Score Summary window, click on Download (upper right) to download the spreadsheet wit
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
t th feedback
1. Compute the cost allocation rate for each activity. Fuller Company Computation of Cost Allocation Rates Activity Materials handling per part Machine setup per setup Insertion of parts per part Finishing per hour 2. Compute the manufacturing overhead cost that should be assigned to Job 420. Job 420 Manufacturing overhead allocation Activity MOH assigned Materials handling Machine setup Insertion of parts Finishing Total 3. Compute the manufacturing overhead cost that should be assigned to Job 510. Job 510 Manufacturing overhead allocation Activity MOH assigned Materials handling Machine setup Insertion of parts Finishing Total (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) Activity Cost Allocation Rate (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.)