Info in image "ACC PT1" can be used for image "ACC PT2" 2. Change all of the numbers in the data area of your worksheet so that it looks like this:AC1Chapter 3: Applying Excel3Data4Allocation baseMachine-hoursEstimated manufacturing overhead cost2$713,4006.Estimated total amount of the allocation base87,000 machine-hours7Actual manufacturing overhead cost2$695,9008Actual total amount of the allocation base86,000 machine-hoursIf your formulas are correct, you should get the correct answers to the following questions.(a) What is the Predetermined overhead rate? (Round your answer to 2 decimal places.)Predetermined overhead rate$8.20 per machine-hour(b) By how much is the manufacturing overhead underapplied or overapplied?Overappliedmanufacturing overhead$9,300%24 3. Either print or make a copy of your worksheet in your workbook before proceeding. You will need to refer back to this worksheet.Change the estimated total amount of the allocation base to 82,000 machine-hours, but keep everything the same as in Requirement2. The data area of your worksheet should now look like this:AC1Chapter 3: Applying Excel23Data4Allocation baseMachine-hoursEstimated manufacturing overhead cost$713,400Estimated total amount of the allocation base82,000 machine-hours7Actual manufacturing overhead cost$695,9008Actual total amount of the allocation base86,000 machine-hours(a) By how much is the manufacturing overhead underapplied or overapplied?manufacturing overhead

Change the estimated total amount of the allocation base to 82,000 machine-hours, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this: A 1 Chapter 3: Applying Excel 2 Data 4 Allocation base Machine-hours Estimated manufacturing overhead cost $ 713,400 6 Estimated total amount of the allocation base 82,000 machine-hours 7 Actual manufacturing overhead cost $ 695,900 8 Actual total amount of the allocation base 86,000 machine-hours (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead

Change the estimated total amount of the allocation base to 82,000 machine-hours, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this: A 1 Chapter 3: Applying Excel 2 Data 4 Allocation base Machine-hours Estimated manufacturing overhead cost $ 713,400 6 Estimated total amount of the allocation base 82,000 machine-hours 7 Actual manufacturing overhead cost $ 695,900 8 Actual total amount of the allocation base 86,000 machine-hours (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter4: Accounting For Factory Overhead

Section: Chapter Questions

Problem 4P: Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2....

See similar textbooks

Similar questions

eBook Carlton's Kitchen's three cost pools and overhead estimates are as follows: Activity Cost Pool Cost Driver EstimatedOverhead Use perProduct A Use perProduct B Machine Setups Setups $162,000 5,000 4,000 Assembly Number of Parts 68,000 24,000 44,000 Machine Maintenance Machine Hours 150,000 13,000 37,000 Compare the overhead allocation using (A) the traditional allocation method and (B) the activity-based costing method. (Hint: the traditional method uses machine hours as the allocation base.) For those boxes in which you must enter subtractive or negative numbers use a minus sign. Product A Product B Total Overhead (ABC) $fill in the blank 1 $fill in the blank 2 Total overhead (traditional) fill in the blank 3 fill in the blank 4 Difference $fill in the blank 5 $fill in the blank 6
Account Activity and Relationships Each case is independent. Solve for missing data in alphabetical order. (Hint: Refer to Exhibit 18.6, p. 18-17 and the WIP table, p. 18-25.) Case A Case B Case C Case D Sales $425,000 Answer 550,000 Answer Direct materials 75,000 105,000 Answer 105,000 Direct labor 25,000 Answer 100,000 Answer Total direct costs Answer 160,000 Answer 150,000 Conversion cost Answer 130,000 Answer Answer Manufacturing overhead 40,000 Answer 50,000 Answer Current manufacturing costs Answer Answer 475,000 395,000 Work in process, beginning 35,000 50,000 Answer 105,000 Work in process, ending 25,000 Answer 105,000 Answer Cost of goods manufactured Answer 160,000 Answer 410,000 Finished goods inventory, beginning 45,000 40,000 35,000 60,000 Finished goods inventory, ending 30,000 Answer 40,000 Answer Cost of goods sold Answer 175,000 Answer 400,000 Gross profit…
C15Q5 Need help Using the step-down method, allocate support-department costs. Develop overhead rates per direct manufacturing labor-hour for machining and assembly. Allocate the costs of the support departments in the order given in this problem. Use the allocation base for each support department you think is most appropriate. 2. Using the direct method, rework requirement 1. 3. Based on the following information about two jobs, determine the total overhead costs for each job by using rates developed in (a) requirement 1 and (b) requirement 2. Direct Manufacturing Labor–Hours Machining Assembly Job 88 23 2 Job 89 5 22 4. The company evaluates the performance of the operating department managers on the basis of how well they managed their total costs, including allocated costs. As the manager of the Machining Department, which allocation method would you prefer from the results obtained in requirements…
1 2 3 4 5 6 7 8 Chapter 3: Applying Excel Data Allocation base Machine-hours Estimated manufacturing overhead cost $416,000 Estimated total amount of the allocation base 64,000 machine-hours Actual manufacturing overhead cost $403,800 Actual total amount of the allocation base 69,000 machine-hours If your formulas are correct, you should get the correct answers to the following questions. (a) What is the Predetermined overhead rate? (Round your answer to 2 decimal places.) (b) By how much is the manufacturing overhead underapplied or overapplied? Change the estimated total amount of the allocation base to 65,000 machine-hours, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this: 1 2 3 4 5 6 7 8 Chapter 3: Applying Excel Data Allocation base Machine-hours Estimated manufacturing overhead cost $416,000 Estimated total…
(1) calculate the overhead assigned rate (note their order from above): Overhead Cost Items Estimated Overhead Cost Driver Activity Levels Activity Rate Purchasing $70,000 ? ? ? Handling materials $33,350 ? ? ? Machine setups $70,500 ? ? ? Inspections $25,500 ? ? ? Utilities $45,000 ? ? ? (2) calculate the total order cost (again, note their order from above): Activity Cost Drivers Activity Levels Activity Rate Assigned Costs ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Total Order Cost ?
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…
1. Olsen, Inc., manufactures a product that experiences the following activities (in hours): Processing (two departments) 42.0; Inspecting 2.8; Rework 7.0; Moving (three moves) 11.2; Waiting (for the second process) 33.6; Storage (before delivery to customer) 43.4. Compute the MCE for this product
Hello Do you think you can explain how I go about solving the part in bold italic underlined please I need to do this in excel but not sure how to get the result in excel?just step by step explanation of how to solve bold italic underlined parts.Thank you Note that the data provided gives lumenhours per hour of labour, not hours of work required toproduce 1000 lumen hours. So you will need a calculation to find the right numbers. 3.1. Show and explain how to calculate work time requiredin seconds for the last observation. Data necessary for completion: Variable Lumen-hours per hour of labor Time Period 100,000 BC to AD 1992 Year Technology -100000 -100000 Open Fire 17.24 -40000 -40000 Neolithic Lamp 20.00 -1750 -1750 Babylonian Lamp 24.39 1800 1800 Tallow Candle 186.22 1845 1845 Whale Oil Lamp 204.08 1855 1855 Town Gas Lamp 336.70 1875 1875 Early Gas Lamp 3067.48 1895 1895 Welscbach Mantle 12048.19 1920 1920 Carbon…
Now that your worksheet has been saved as JOB2, fill in the appropriate data for Job 8961. Save the results as JOB8961 and print the completed job cost sheet when done. Check figure: Cost of Job 8961 (cell G31), 16,229.35.
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?
4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how both cost schedules and the income statement will change if the following data change: direct labor is $390,000 and utilities cost $35,000.
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…