Please Help
Task #1 By Product-Line Profitability Report Economy Stair Lifts Premium Stair Lift:s lexible Actual Lite Commercial Stair Lifts DIRECTIONS: Pull forward the information from 1. INFO ONLYtab and complete the yellow sections. Do not edit the white celumns. Variances Static 0% Static Flexible Actual Variances Static Actual Variances Static Flexible Actual Variances 0% 0% Variable Costs V-COGS DM DL MOH Total V-COGS SG&A IS8,754,523 Budget x sales m Total Variable Costs Contribution margin Fixed Costs F-COGS SG&A, 1$1,783,80 Budgat par monthxsalas mix Total Fixed Costs Operating income Budgeted ndard) DL Hours Per Unit Budgeted [Stondard) DL Cost PerH Applied on Bases of DL Hours Budgeted (Standard) VMOH Cost Per DLH 17.71 4.40$16.22 Budgeted (Standard) FMOH Cost Per DLH 14.82 .63 13.58 6.54 $ .47 HCTUHL Actual Sales Volume, total is WA units Actual Production Volume Actual Soles Price Actual Unit Cost By Product-Line Actual DM % of Cost (100% Variable) Actual DL % of Cost(100% Variable Actual MOH % of Cost[42% Y; 58% Total 2,350 2,400 $274,000,600$2,8004,250 129,500; 735; 1,540 $ 1,985 06.70 140 2,305 265 33% 50% 40% 10% 54% 25% 21% Totals Totol Actual DM in COG3 Total Actual DL in COGS Total Actual MOH in COGS 6,818,175 3,030,300 1573,425 826,875 228,630 3,311,373 11,185,713 VMOH 47.36% in COGS FMOH 52.04% in COGS 165,375 73,013 88,335 42,431 46,444 326,533$2,154.268 156,011 $1,023,268 125,000 47.78% 52.22% 1,023,268 ,125,000 821,673 70,522 Total COGS 17,482,500 1653,750 Totol Actual DM Per Unit Total Actual DL Per Unit Total Acttal VMOH per unit Total Actual FMOH per unit 50,505.00$367.50$831.601,403.35 $67,340.00234.00$385.00436.25 $ 5.568.53$35.1154.5166.33 6,086.47$38 38.38 $ 168.83 Actual DM in Pounds Per Unit al DM Cost Per Pound 100.01 14.13 28.68 42.71 al DL Hours Per al DL Cost Per H I DLH 420 18 11.89 3.69 $12.334.0 Actual VMOH Cost DLH 13.263.13 al FMOH Cost Per DLH $14.43 Task #1 By Product-Line Profitability Report Economy Stair Lifts Premium Stair Lift:s lexible Actual Lite Commercial Stair Lifts DIRECTIONS: Pull forward the information from 1. INFO ONLYtab and complete the yellow sections. Do not edit the white celumns. Variances Static 0% Static Flexible Actual Variances Static Actual Variances Static Flexible Actual Variances 0% 0% Variable Costs V-COGS DM DL MOH Total V-COGS SG&A IS8,754,523 Budget x sales m Total Variable Costs Contribution margin Fixed Costs F-COGS SG&A, 1$1,783,80 Budgat par monthxsalas mix Total Fixed Costs Operating income Budgeted ndard) DL Hours Per Unit Budgeted [Stondard) DL Cost PerH Applied on Bases of DL Hours Budgeted (Standard) VMOH Cost Per DLH 17.71 4.40$16.22 Budgeted (Standard) FMOH Cost Per DLH 14.82 .63 13.58 6.54 $ .47 HCTUHL Actual Sales Volume, total is WA units Actual Production Volume Actual Soles Price Actual Unit Cost By Product-Line Actual DM % of Cost (100% Variable) Actual DL % of Cost(100% Variable Actual MOH % of Cost[42% Y; 58% Total 2,350 2,400 $274,000,600$2,8004,250 129,500; 735; 1,540 $ 1,985 06.70 140 2,305 265 33% 50% 40% 10% 54% 25% 21% Totals Totol Actual DM in COG3 Total Actual DL in COGS Total Actual MOH in COGS 6,818,175 3,030,300 1573,425 826,875 228,630 3,311,373 11,185,713 VMOH 47.36% in COGS FMOH 52.04% in COGS 165,375 73,013 88,335 42,431 46,444 326,533$2,154.268 156,011 $1,023,268 125,000 47.78% 52.22% 1,023,268 ,125,000 821,673 70,522 Total COGS 17,482,500 1653,750 Totol Actual DM Per Unit Total Actual DL Per Unit Total Acttal VMOH per unit Total Actual FMOH per unit 50,505.00$367.50$831.601,403.35 $67,340.00234.00$385.00436.25 $ 5.568.53$35.1154.5166.33 6,086.47$38 38.38 $ 168.83 Actual DM in Pounds Per Unit al DM Cost Per Pound 100.01 14.13 28.68 42.71 al DL Hours Per al DL Cost Per H I DLH 420 18 11.89 3.69 $12.334.0 Actual VMOH Cost DLH 13.263.13 al FMOH Cost Per DLH $14.43
