This is what I have complete so far, requesting help with question 6-8.
Data:
Dishwashing Inc. manufactures dishwashers. lhe company had originally used direct labor hours as the cost driver to develop one predetermined overhead rate. You have been recently hired by this company to review the costing system and realize that maybe a predetermined overhead rate does not give an accurate cost picture. You remember discussing overhead cost issues in MBA641 and want to implement ABC, so you have done some research and come up with the following activity cost pools and cost driver Budgeted Overhead Budgeted Level Activiu cost Pool Cost Cost driver for cost Driver Setting up equipment 480,000 Number of setups 600 Ordering costs 360,000 Number of orders 18,000 Machine costs 924,000 Machine hours 42,000 Receiving costs 400 000 Receiving hours 10,000 Total Budgeted overhead cost $2 164 000 Dishwashing |nc. Produces two models ofdishwashers with the following expected prime costs and activity demands for the year. Model A Model B Direct materials $600,000 $800,000 Direct labor $480,000 $160,000 Units completed 16,000 8,000 Direct labor hours 6,000 2,000 Number of setups 400 200 Number of orders 6,000 12,000 Machine hours 24,000 18,000 Receiving hours 3,000 ?,000 Required: Make sure you show your work or use cell references for all calculations. You will not earn credit if you just type in your answer. Round to the nearest cent. 1. Using the information above calculate the single predetermined overhead rate this company is using based on direct labor hours as the cost driver. Predetermi ned overhead rate: 2. If the company uses the predetermined overhead approach to apply manufacturing overhead, compute the unit manufacturing overhead costs applied to each Model. Model A Model B Manufacturing overhead applied using direct labor hours 5 1,623,000.00 S 541,000.00 3. Determine the unit cost for direct material and direct labor for each ofthe models. Model A Model B Direct Material unit cost $ 3?.50 $ 100.00 Direct Labor unit cost $ 30.00 $ 20.00 4. If the company uses the predetermined overhead approach to apply manufacturing overhead. Compute the unit manufacturing costs for each Model. Model A Model B Unit manufacturing cost using the predetermined overhead approach $ 101.44 $ 6?.63 5. Determine the Activity Pool Rates by completing the chart below if the company uses ABC. Unit manufacturing cost using the predetermined overhead approach $ 101.44 $ 6?.63 5. Determine the Activity Pool Rates by completing the chart below if the company uses ABC. Budgeted Overhead Budgeted Level Activi cost Pool Cost Cost driver for cost Driver Activi Pool Rate Settin u e ui ment 480,000 Number of setups 600 .00 Ordering costs .l 360,000 Number of orders 18,000 520.00 Machine costs 924,000 Machine hours 42,000 522.00 Receiving costs 400,000 Receiving hours 10,000 540.00 Total Budgeted overhead cost $2 164 000 6. If the company uses Activity Based Overhead approach to apply manufacturing overhead, compute the unit manufacturing overhead costs applied to each Model. Model A Model B Manufacturing overhead applied using ABC T. If the company uses the ABC overhead approach to apply manufacturing overhead. Compute the unit manufacturing costs for each Model. Model A Model B Unit manufacturing cost using the ABC Approach 8. Write a report that identies factors that explain why the two productc osting systems result in differing costs. Which system do you recommend? Why? In your report you need to explicitly explain the differences in the cost of each model under both methods using the calculations you have determined