Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

AutoSave or Studrnt Ch. 14 Oper.Performancr FLEX Fxorl with Hw Exral Alfahrid,Sa

ID: 2573470 • Letter: A

Question

AutoSave or Studrnt Ch. 14 Oper.Performancr FLEX Fxorl with Hw Exral Alfahrid,Salch Mohammed S Filr Home Insert Draw Pagr laynut Formulas Data Rrview Viw Tell me what you want to do A20 vM Master Budget Actual Units sold 105000 101000 ales $652,C00 St08,000 ariable Mtg. casts $35,000 340,000 8 Varlable SG&A; Expenses $21,000 $24,000 Fined Mly, cos1s $109,000 $121,000 11 Fixrd SG&A; Fxrpnses $122.00 $140,000 12 Complete chart below 13 Show all computation:s 14 15 Master Master Plan Sales Volume Variance Flex Budget Variance aty/Usage Flexible BudgetVariance Plan/ Budget Actual Total Difference 16 Units sold Sales $ 17 Variable Mfg. costs Variable SG&A; Expense 21 Contribution Margin 24 25 26 Fixed Mfg. Costs Fixed SG&A; Exepnses Total Fixed Costs & Expenses Operating Income CH.14 Oper Flex Excel Ch14 HW Sheet3 Sheet ENG 248 PM US 11/16/2017 2 Type here to search

Explanation / Answer

Actual A Master Budget M Flexible Budget F Master plan variance Sales Volume variance M-F Flex Budget variance A-F Units sold 101000 105000 101000 4000 4000 Sales 608000 652000 627162 44000 U 24838 U 19162 U (652000/105000*101000) Less; Variable Manufacturing cost 340000 358000 344362 18000 F 13638 F 4362 F (358000/105000*101000) Variable SG & A expenses 24000 21000 20200 3000 U 800 F 3800 U (21000/105000*101000 Contribution Margin 244000 273000 262600 29000 U 10400 U 18600 U Fixed man cost 121000 109000 109000 12000 U 0 None 12000 U Fixed SG & A cost 140000 122000 122000 18000 U 0 None 18000 U Total fixed cost 261000 231000 231000 30000 U 0 30000 U operating Income -17000 42000 31600 59000 U 10400 U 48600 U