AutDSave Excel As gnment Cane Home Insert Draw Page Layout Formulas Data Review View 9 Tell me i8 Share G Comments A IC ' ' II L ab ' L E Insert v Z v A *@ v allbn v 12 Ce v I General vI v v v v v v [av _ , E4 P\" x W , y V 2? 4 Paste o e0 .00 Conditional Format Cell ._ Sun & Find a Analyze Sensitivity 6' B I Q v v H v $ v A] ' '00 in Formatting as Table Styles m Format V O V Filter Select Data E12 :I t A a c D E F G H I J K I o 1 2 3 4 5 Single 6 Double 7 8 Standard/Budget to make one canoe 9 Direct Machine Hours 10 Direct Labor Hours 11 Direct Labor Cost per Hour 12 Direct Materials 1 3 14 Fixed Manufaaurlng Overhead by Department 15 Assembly 16 Finishing 17 Total Manufacturing Overhead 1 8 1 9 For the month of March, planned output is as follows: mm 5 S 375 units 125 units Single 6000 10,000 14.00 120.00 mm 70,000.00 15,150.00 20 la. Calculate a plantwide overhead allocation rate based on direct-machine hours: Double 10,000 14,000 20.00 180.00 a Canoe, 00. makes two kinds of cedar canoes: the single model ls rated for one person, and the double model is rated for two people. The process ls mostly done by hand. The machines used are saws and sanders that are not automated. Indirect costs (manufacturing overhead) are mostly supervisor salaries and some depreciation and rent. overhead allocated direct machine to individual 21 Formula for the allocah'on base: # of units produced divided by hours equals product 22 Allocation base for single canoe 375.000 6 2,250.000 23 Allocation base for double canoe 115.000 10 1,250.000 24 Total allocation base w direct machine hours 25 26 Formula for the allocation rate: overhead allocated times direct machine equals allocation rate I 27 S 96,250.00 3500 5 27.50 Warhead allocated to 28 29 1b. Allocate fixed manufacturing overhead using a plant-wide overhead allocation rate based on direct-machine hours: 30 Formula for allomting fixed warhead: warhead allocated divided by direct machine equals warhead allocated I 31 Allocation to single canoe product line 96,250.000 / 2150 = 5 42.78 32 Allocation to double canoe product line 96,250.000 / 1250 = 5 77.00 33 Total allocation base 5 119 8 total of the allocation 34 35_ 4 ) Canoe, Co ENTERANSWERS + Ready EU'l' 100% AutoSave OFF 3 04 Excel Assignment_ Canoe, Co - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri v 12 A A General Insert v di- x Delete v Paste BIUV V VAv = I V $ ~ % ? Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data E12 4 X V fx B C D E F G H K O 35 1c. Determine the per unit costs for each product 36 Formula used to allocate overhead to individual products total fixed divided by direct machine equals total fixed 37 Allocation to single canoes 96,250.000 2250 38 Allocation to double canoes 96,250.000 1250 39 40 Formula used to calculate unit product cost 41 Single canoe 42 Double canoe 43 44 2a. Calculate a plant-wide overhead allocation rate based on direct-labor hours: 45 Formula for the allocation base: 46 Allocation base for single canoe 47 Allocation base for double canoe 48 Total allocation 49 50 Formula for the allocation rate: 51 52 53 2b. Allocate fixed manufacturing overhead using a plant-wide overhead allocation rate based on direct-labor hours: 54 Formula for allocating fixed overhead: 55 Allocation to single canoe product line 56 to double c al allocation base 59 2c. Determine the per unit costs for each product 60 Formula used to allocate overhead to individual products 61 Allocation to single canoes 62 Allocation to double canoes 63 64 Formula used to calculate unit product cost 65 Single canoe 66 Double canoe 67 68 3a. Calculate a plant-wide overhead allocation rate based on direct-labor $: 69 Formula for the allocation base: 70 Allocation base for single canoe 71 Allocation base for double canoe 72 Total allocation base Canoe, Co. ENTERANSWERS + Ready " - + 100%AutoSave OFF 3 04 Excel Assignment_ Canoe, Co - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri v 12 A A - ab General Insert v di- px Delete v Paste BIUV V VAv = I V $ ~ % ? Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data E12 fx A B C D E F G H K O 75 76 77 3b. Allocate fixed manufacturing overhead using a plant-wide overhead allocation rate based on direct-labor $: 78 Formula for allocating fixed overhead: 79 tion to single canoe product line 80 Allocation to double canoe product line 81 Total allocation base 82 $3 3c. Determine the per unit costs for each product 84 Formula used to allocate overhead to individual products 85 Allocation to single canoes 86 Allocation to double canoes 87 88 Formula used to calculate unit product cost 89 Single canoe 90 Double canoe 91 92 93 Allocation based on DMH Allocation based on DLH Allocation based on DL$ 94 Single Double Single Double Single Double 95 Sales price 645.00 $ 845.00 645.00 $ 845.00 $ 645.00 $ 845.00 96 Cost 97 Profit per unit 98 99 Question: Which allocation method makes the most sense? 100 Feedback 01 102 103 104 105 106 107 108 109 110 111 112 Canoe, Co. ENTERANSWERS + Ready - + 100%