for assembly and packaging how did you get the 181.423 and the 17.04
x $29.00 181 181 $5,249 * $ 27.00 $4,887 $4,887 - Price Variance $5,249 $4,887 $362 Unfavorable Total Flexible Budget Variance = $389 nbly and ckaging Actual AO X AP. AQ X SP 181.423 x $17.04 $3,092 181.423 X $ 13.11 $2,378 Effici $2,378 - Price Variance $3,092 - $2,378 $714 Unfavorable Total Flexible Budget Variance = Un S732 Prep Flexible Variances SUR PAGE LAYOUT FORMULAS DATA Danch Part No 2 Solution Excel REVIEW VIEW General Merge Center. $.$. Conditional Format A IV E Cart 5,249 1,935 2,529 468 12,643 11,305 34,129 (151) (215) (281) (52) (1,547) [1,202) (3,448) 5,400 V 200 - $ 27.00 x 180 2,150 / 200 - $ 10.75 X 180 2,810 200 = $ 14.05 x 180 520/ 200 = $ 2.60 X 180 14,190 / 200 - $ 70.95 X 180- 12,507 / 200 = $ 62.54 x 180 37,577 4,860 1,935 2,529 468 12,771 11,256 33.819 memory cation process phone scope ther chips able supplies and tools total or -sembly and packaging nipping tal variable costs ed costs actory rent Machine depreciation utility fee and taxes Supervision Total fixed costs fotal costs Net Income 3,092 191 37,412 470 (21) 12,999) 2,622 / 200 - $ 13.11 x 180 212 / 200 = $ 1.06 X 180 40,411 2,360 191 36,370 400 4000 1500 52 134 400 150 150 0 52 7367 38,148 (2.992) (672) (772) 729 41,140 $ 100 127 729 37,099 $ 17 S Requirement 3: Revenue per unit of product: S Cost per unit of product: 208.20 211.93 $206.20 205 70 x $29.00 181 181 $5,249 * $ 27.00 $4,887 $4,887 - Price Variance $5,249 $4,887 $362 Unfavorable Total Flexible Budget Variance = $389 nbly and ckaging Actual AO X AP. AQ X SP 181.423 x $17.04 $3,092 181.423 X $ 13.11 $2,378 Effici $2,378 - Price Variance $3,092 - $2,378 $714 Unfavorable Total Flexible Budget Variance = Un S732 Prep Flexible Variances SUR PAGE LAYOUT FORMULAS DATA Danch Part No 2 Solution Excel REVIEW VIEW General Merge Center. $.$. Conditional Format A IV E Cart 5,249 1,935 2,529 468 12,643 11,305 34,129 (151) (215) (281) (52) (1,547) [1,202) (3,448) 5,400 V 200 - $ 27.00 x 180 2,150 / 200 - $ 10.75 X 180 2,810 200 = $ 14.05 x 180 520/ 200 = $ 2.60 X 180 14,190 / 200 - $ 70.95 X 180- 12,507 / 200 = $ 62.54 x 180 37,577 4,860 1,935 2,529 468 12,771 11,256 33.819 memory cation process phone scope ther chips able supplies and tools total or -sembly and packaging nipping tal variable costs ed costs actory rent Machine depreciation utility fee and taxes Supervision Total fixed costs fotal costs Net Income 3,092 191 37,412 470 (21) 12,999) 2,622 / 200 - $ 13.11 x 180 212 / 200 = $ 1.06 X 180 40,411 2,360 191 36,370 400 4000 1500 52 134 400 150 150 0 52 7367 38,148 (2.992) (672) (772) 729 41,140 $ 100 127 729 37,099 $ 17 S Requirement 3: Revenue per unit of product: S Cost per unit of product: 208.20 211.93 $206.20 205 70