The Potter Company makes 2 products: Brooms and Wands. Information about them is as follows: brooms wands units produced 18000 3600 direct material cost per unit $7 $19 Machine hours per unit 4 7 production runs 144 72 Since the process is basically automated, the small amount of labor is simply included in overhead Manufacturing overhead consists of the following machine depreciation $97,200 set up costs $48,600 material handling $38,800 total overhead $184,680 REQUIRED; A) USING JOB ORDER COSTING AND MACHINE HOURS TO ALLOCATE OVERHEAD DETERMINE A1) THE PREDETERMINED OVERHEAD RATE A2) THE COST OF A BROOM A3) THE COST OF A WAND POTTER COMPANY HAS DECIDED TO ADOPT ABC AND ALLOCATE OVERHEAD AS FOLLOWS; MACHINE-HOURS FOR DEPRECIATION PRODUCTION RUNS FOR SETUP COSTS MATERIAL DOLLARS FOR MATERIAL HANDLING REQUIRED: B1) DETERMINE THE COST OF A BROOM B2) DETERMINE THE COST OF A WAND

WORK IN EXCEL THANKS!!