Question: Please help!! Task #1: Write a brief summary of how each item is computed (see yellow highlighted areas) on the Task #1 Data tab. Please

 Please help!! Task #1: Write a brief summary of how each

Please help!!

item is computed (see yellow highlighted areas) on the Task #1 Data

tab. Please note that you are only required to explain how the

#s are determined. No calculations are necessary on this tab. Budget and

Task #1: Write a brief summary of how each item is computed (see yellow highlighted areas) on the Task #1 Data tab. Please note that you are only required to explain how the #s are determined. No calculations are necessary on this tab. Budget and Actual Data Results Stair-Lifts Elevators Economy Product-Line Cost, Volume, Price Information Total S 1006 275S2,310683.89 2,002 Budgeted Sales Volume, total is WA Units 2,238 Budgeted Sales Price Budgeted Unit Cost By Product-Line Budgeted DM 56 of Cost (10096 Variable Budgeted DL % of Cost (100% variable) Budgeted MOH % of Cost 275,000 $1,57SS3,275 4,275 S 130,122 S 735 S 1,555 S 1196 Total Budgeted DM in COGS Total Budgeted DL in COGS Total Budgeted MOH in COGS 6,861,385 838,966262,983 3,135,259 $ 11,098,593 8,576,731 625,112105,193 940,578 10,247,614 1,715,346 109,975 403,105 S 2,409,379 ,311,379 933,630 17,153,462 1,645,031 52,048.82374.91 855.28 1,401.0s 98,489 82,464 183,702 $ 1,098,000 478,152 4,478,941 $23,755,586 45.57% Total COGS Total Budgeted DM Per Unit Total Budgeted DL Per Unit Total Budgeted VMOH Per Unit Total Budgeted FMOH Per Unit 65,061.02 $279.34 S 342.11 $420.32 $ 7,082.29 44.01 194.67 S Budgeted (Standard) DM Pounds Per Unit Budgeted (Standard) DM Cost Per Pound 32 43.78 Given How arethe #s inthis row calculated? twrite your answer here) $ 104.10 $ 15.00 $ 30.55 $ Standard) DL Hours Per Unit Standard) DL Cost Per Hour Given How are the #s in this row calculated? 2 - Stair-Lifts Elevators Economy Premium Lite Comm Total S roduct-Line Cost , Volume, Price Information 12 4.40 S 16.22 58 lied on Bases of DL Hours 400 10 15 Given Budgeted (Standard) VMOH Cost Per DLH 6.54 How are the #s in this row calculated? 47 How are the #s in this row calculated? Standard) FMOH Cost Per D 69 ACTUAL: Actual Sales Volume, total is WA units Actual Production Volume Actual Sales Price Actual Unit Cost By Product-Line Actual DM % of Cost (100% Variable) Actual DL 96 of Cost(100% Variable) Actual MOH % of Cost (4296 V; 5896 F) Total 135 140 275 265 2,350 2,400 S 274,000 $1,600S2,800 4,250 ,540 $ 1,985 2,250 706.70 735 $ 1 508 S 129,500 396 5296 9% 100% 2596 21% 100% 7196 25% 7% 103% 10% 100% Totals Total Actual DM in COGS Total Actual DL in COGS Total Actual MOH in COGS 6,818,175 9,090,900 1,573,425 751,752 821,673 826,875 661,500 165,375 79,013 228,690 3,311,973 $11,185,713 105,875 1,166,188 11,024,463 326,533 2,154,268 156,011 $ 1,029,268 170,522S 1,125,000 423,500 4,804,693 S 24,364,443 MOH 47.9696 in COGS 52.0496 in COGS 88,935 2,491 46,444 47.78% 52.22% 1,029,268 1,125,000 Total COGS 17,482,5001,653,750 Total Actual DM Per Unit Total Actual DL Per Unit Total Acttal VMOH per unit Total Actual FMOH per unit S 50,505.00 367.50 831.60 1,409.35 67,340.00 S 294.00 $ 385.00 S 496.25 S5,568.53 35.12 154.51 66.39 72.56 S 6,086.47 38.38 S 168.89 Actual DM in Pounds Per Unit Actual DM Cost Per Pound 26 14.13 S 505 29 28.68 100.01 S 42.71 How are the #s in this row calculated? 14 Actual DL Hours Per Unit Actual DL Cost Per Hour 420 18 How are the#s in this row calculated? Actual DLH Actual VMOH Cost DLH Actual FMOH Cost Per DLH 420 13.26 S 14.49 13 18 3.69 3.19 S 11.89 3.49 How are the Ws in this row calculated? Howare the #s in this row calculated? S-12.99 S-4.0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!