Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve it in excel Question 1 Kitchen Supply, Inc. (K51), manufactures three types of atware: institutional, standard, and silver. It applies all indirect costs

image text in transcribed

please solve it in excel

image text in transcribed
Question 1 Kitchen Supply, Inc. (K51), manufactures three types of atware: institutional, standard, and silver. It applies all indirect costs according to a predetermined rate based on direct labor-hours. A consultant recently suggested that the company switch to an activity-based costing system and prepared the following cost estimates for year 2 for the recommended cost drivers. Activity Recommended Cost Driver Estimated Cost Estimated Cost Driver Activity Processing orders Number of orders $ 54.000 200 orders Setting up production Number of production runs 216.000 100 runs Handling materials Pounds of materials used 360.000 120,000 pounds Machine depreciation and maintenance Machine-hours 238.000 12,000 hours Performing quality control Number of inspections 72.000 45 inspections Packing Number of units 144.000 480,000 units Total estlmated cost 9.134.000 In addition, management estimated 7,500 direct labor-hours for year 2. Assume that the following cost driver volumes occurred in January, year 2. Institutional Standard Silver Number of units produced 60.000 24.000 9,000 Direct materials costs $39,000 $24,000 $15,000 Direct labor-hours 450 450 600 Number of orders 12 9 6 Number of produetlon runs 3 3 6 Pounds of material 6,000 3,000 Machine-hours 140 80 Number of inspections 3 3 3 Units shipped 60.000 24,000 9,000 Actual labor costs were $15 per hour. Required a. Compute a predetermined overhead rate for year 2 for each cost driver using the estimated costs and estimated cost driver units prepared by the consultant. Also compute a predetermined rate for year 2 using direct labor-hours as the allocation base. b. Compute the production costs for each product for January using direct labor-hours as the allocation base and the predetermined rate computed in requirement (at). c. Compute the production costs for each product for January using the cost drivers recommended by the consultant and the predetermined rates computed in requirement (:1). (Note Do not assume that total overhead applied to products in January will be the same for activity-based costing as it was for the labor-hour-based allocation.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Statement Analysis

Authors: K. R. Subramanyam, John J. Wild

10th edition

73379433, 73379432, 978-0073379432

More Books

Students also viewed these Accounting questions

Question

5. Give examples of binary thinking.

Answered: 1 week ago