{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Enable_Macros","Student_Sheet","Instructor_Solutions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Enable_Macros","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,14],[2,0,2,14],[4,0,4,14]]}
["You must enable macros in order for this assignment to function."]
[]
["Please visit the Microsoft Office Support site for documentation and instructions."]
[]
["Contact the World Campus Helpdesk if you continue to have trouble."]

{"sheet":"Student_Sheet","index":1,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,1,1,2],[32,1,33,2],[5,5,7,5],[5,8,7,8],[35,1,37,14],[5,11,7,11],[2,1,4,2],[2,4,2,11],[3,4,3,11],[4,4,4,11],[5,4,8,4],[5,6,8,6],[5,7,8,7],[5,9,8,9],[5,10,8,10],[28,5,28,9]]}
[]
[null,"Flexible Budget Performance Report"]
[null,"Yeager Manufacturing Company manufactures baseball gloves. The company has compiled the following actual and budgeted information for 2017:",null,null,"Yeager Manufacturing Company"]
[null,null,null,null,"Flexible Budget Performance Report"]
[null,null,null,null,"For year ended December 31, 2017"]
[null,null,null,null,null,"Actual","Variance","F/U","Flexible Budget","Variance","F/U","Static       Budget"]
[null,null,"Amount"]
[null,"Actual unit sales during 2017",10357]
[null,"Budgeted unit sales for 2017",10470]
[null,null,null,null,"Revenue"]
[null,"Actual results for 2017",null,null,"     Sales"]
[null,"Actual sales price per unit",40]
[null,"Actual direct materials cost per unit",{"$f":"ROUND(D13,2)","v":4.83},4.8268547058105469,"Variable costs"]
[null,"Actual direct labor cost per unit",{"$f":"ROUND(D14,2)","v":7.88},7.877570629119873,"     Direct materials"]
[null,"Actual factory overhead cost per unit",{"$f":"ROUND(D15,2)","v":2.4900000000000002},2.4853725433349609,"     Direct labor"]
[null,"Actual variable selling expenses per unit",{"$f":"ROUND(D16,2)","v":1.57},1.5696206092834473,"     Factory overhead"]
[null,"Actual fixed factory overhead",119031,null,"Total manufacturing costs"]
[null,"Actual fixed selling and administrative expenses",49189,null,"Variable selling expenses"]
[null,null,null,null,"Total variable costs"]
[null,"Static budget information for 2017"]
[null,"Budgeted sales price per unit",40,null,"Fixed factory overhead"]
[null,"Budgeted direct materials cost per unit",{"$f":"ROUND(D22,2)","v":4.8},4.7991981506347656,"Fixed selling and administrative expenses"]
[null,"Budgeted direct labor cost per unit",{"$f":"ROUND(D23,2)","v":7.09},7.0899972915649414,"Total fixed costs"]
[null,"Budgeted factory overhead cost per unit",{"$f":"ROUND(D24,2)","v":2.02},2.0222263336181641]
[null,"Budgeted variable selling expenses per unit",{"$f":"ROUND(D25,2)","v":1.75},1.7491592168807983,"Total expenses"]
[null,"Budgeted fixed factory overhead",119184]
[null,"Budgeted fixed selling and administrative expenses",49465,null,"Operating income"]
[]
[null,null,null,null,null,"Round all calculations to two decimal places"]
[null,"Required:"]
[null,"1. Prepare a Flexible Budget Performance Report for 2017"]
[]
[null,"Note* Make sure you state whether variances are favorable, F or unfavorable, U"]
[]
[]
[null,"Use the area below to show your work and calculations.\n(*Note: Your instructor may use this area to help review and resolve any incorrect answers)"]

{"sheet":"Instructor_Solutions","index":2,"n_rows":36,"n_cols":29,"rows_kept":36,"cut":false,"hidden":true,"merged":[[32,18,33,19],[35,18,37,31],[5,21,5,28],[6,21,9,21],[6,22,8,22],[6,23,9,23],[6,24,9,24],[6,25,8,25],[6,26,9,26],[6,28,8,28],[29,22,29,26],[3,21,3,28],[4,21,4,28],[6,11,8,11],[6,6,9,6],[6,9,9,9],[6,7,9,7],[6,10,9,10],[4,4,4,11],[6,27,9,27],[1,18,1,19],[2,18,4,19],[29,5,29,9],[3,1,5,2],[1,1,1,2],[33,1,34,2],[6,5,8,5],[6,8,8,8],[6,4,9,4],[3,4,3,11],[5,4,5,11]]}
[]
[null,"Flexible Budget Performance Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flexible Budget Performance Report"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yeager Manufacturing Company manufactures baseball gloves. The company has compiled the following actual and budgeted information for 2017:"]
[null,"Yeager Manufacturing Company manufactures baseball gloves. The company has compiled the following actual and budgeted information for 2017:",null,null,"Yeager Manufacturing Company",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yeager Manufacturing Company"]
[null,null,null,null,"Flexible Budget Performance Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flexible Budget Performance Report"]
[null,null,null,null,"For year ended December 31, 2017",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For year ended December 31, 2017"]
[null,null,null,null,null,"Actual","Variance","F/U","Flexible Budget","Variance","F/U","Static       Budget",null,null,null,null,null,null,null,"Amount",null,null,"Actual","Variance","F/U","Flexible Budget","Variance","F/U","Static       Budget"]
[null,null,"Amount",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual unit sales during 2017",{"$f":"Student_Sheet!C8","v":10357}]
[null,"Actual unit sales during 2017",{"$f":"Student_Sheet!C8","v":10357},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Budgeted unit sales for 2017",{"$f":"Student_Sheet!C9","v":10470}]
[null,"Budgeted unit sales for 2017",{"$f":"Student_Sheet!C9","v":10470},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Student_Sheet!F9=\"\",\"\",Student_Sheet!F9)","v":""},null,null,{"$f":"IF(Student_Sheet!I9=\"\",\"\",Student_Sheet!I9)","v":""},null,null,{"$f":"IF(Student_Sheet!L9=\"\",\"\",Student_Sheet!L9)","v":""}]
[null,null,null,null,"Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual results for 2017",null,null,"Revenue"]
[null,"Actual results for 2017:",null,null,"     Sales",null,null,{"$f":"IF($F12=$I12,\"\",N12)","v":""},null,null,{"$f":"IF($I12=$L12,\"\",O12)","v":""},null,null,null,null,null,null,null,"Actual sales price per unit",{"$f":"Student_Sheet!C12","v":40},null,"     Sales",{"$f":"IF(Student_Sheet!F11=\"\",\"\",Student_Sheet!F11)","v":""},{"$f":"IF(Student_Sheet!G11=\"\",\"\",Student_Sheet!G11)","v":""},{"$f":"IF(Student_Sheet!H11=\"\",\"\",Student_Sheet!H11)","v":""},{"$f":"IF(Student_Sheet!I11=\"\",\"\",Student_Sheet!I11)","v":""},{"$f":"IF(Student_Sheet!J11=\"\",\"\",Student_Sheet!J11)","v":""},{"$f":"IF(Student_Sheet!K11=\"\",\"\",Student_Sheet!K11)","v":""},{"$f":"IF(Student_Sheet!L11=\"\",\"\",Student_Sheet!L11)","v":""}]
[null,"Actual sales price per unit",{"$f":"Student_Sheet!C12","v":40},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual direct materials cost per unit",{"$f":"Student_Sheet!C13","v":4.83}]
[null,"Actual direct materials cost per unit",{"$f":"Student_Sheet!C13","v":4.83},null,"Variable costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual direct labor cost per unit",{"$f":"Student_Sheet!C14","v":7.88},null,"Variable costs"]
[null,"Actual direct labor cost per unit",{"$f":"Student_Sheet!C14","v":7.88},null,"     Direct materials",null,null,{"$f":"IF($F15=$I15,\"\",N15)","v":""},null,null,{"$f":"IF($I15=$L15,\"\",O15)","v":""},null,null,null,null,null,null,null,"Actual factory overhead cost per unit",{"$f":"Student_Sheet!C15","v":2.4900000000000002},null,"     Direct materials",{"$f":"IF(Student_Sheet!F14=\"\",\"\",Student_Sheet!F14)","v":""},{"$f":"IF(Student_Sheet!G14=\"\",\"\",Student_Sheet!G14)","v":""},{"$f":"IF(Student_Sheet!H14=\"\",\"\",Student_Sheet!H14)","v":""},{"$f":"IF(Student_Sheet!I14=\"\",\"\",Student_Sheet!I14)","v":""},{"$f":"IF(Student_Sheet!J14=\"\",\"\",Student_Sheet!J14)","v":""},{"$f":"IF(Student_Sheet!K14=\"\",\"\",Student_Sheet!K14)","v":""},{"$f":"IF(Student_Sheet!L14=\"\",\"\",Student_Sheet!L14)","v":""}]
[null,"Actual factory overhead cost per unit",{"$f":"Student_Sheet!C15","v":2.4900000000000002},null,"     Direct labor",null,null,"",null,null,"",null,null,null,null,null,null,null,"Actual variable selling expenses per unit",{"$f":"Student_Sheet!C16","v":1.57},null,"     Direct labor",{"$f":"IF(Student_Sheet!F15=\"\",\"\",Student_Sheet!F15)","v":""},{"$f":"IF(Student_Sheet!G15=\"\",\"\",Student_Sheet!G15)","v":""},{"$f":"IF(Student_Sheet!H15=\"\",\"\",Student_Sheet!H15)","v":""},{"$f":"IF(Student_Sheet!I15=\"\",\"\",Student_Sheet!I15)","v":""},{"$f":"IF(Student_Sheet!J15=\"\",\"\",Student_Sheet!J15)","v":""},{"$f":"IF(Student_Sheet!K15=\"\",\"\",Student_Sheet!K15)","v":""},{"$f":"IF(Student_Sheet!L15=\"\",\"\",Student_Sheet!L15)","v":""}]
[null,"Actual variable selling expenses per unit",{"$f":"Student_Sheet!C16","v":1.57},null,"     Factory overhead",null,null,"",null,null,"",null,null,null,null,null,null,null,"Actual fixed factory overhead",{"$f":"Student_Sheet!C17","v":119031},null,"     Factory overhead",{"$f":"IF(Student_Sheet!F16=\"\",\"\",Student_Sheet!F16)","v":""},{"$f":"IF(Student_Sheet!G16=\"\",\"\",Student_Sheet!G16)","v":""},{"$f":"IF(Student_Sheet!H16=\"\",\"\",Student_Sheet!H16)","v":""},{"$f":"IF(Student_Sheet!I16=\"\",\"\",Student_Sheet!I16)","v":""},{"$f":"IF(Student_Sheet!J16=\"\",\"\",Student_Sheet!J16)","v":""},{"$f":"IF(Student_Sheet!K16=\"\",\"\",Student_Sheet!K16)","v":""},{"$f":"IF(Student_Sheet!L16=\"\",\"\",Student_Sheet!L16)","v":""}]
[null,"Actual fixed factory overhead",{"$f":"Student_Sheet!C17","v":119031},null,"Total manufacturing costs",null,null,"",null,null,"",null,null,null,null,null,null,null,"Actual fixed selling and administrative expenses",{"$f":"Student_Sheet!C18","v":49189},null,"Total manufacturing costs",{"$f":"IF(Student_Sheet!F17=\"\",\"\",Student_Sheet!F17)","v":""},{"$f":"IF(Student_Sheet!G17=\"\",\"\",Student_Sheet!G17)","v":""},{"$f":"IF(Student_Sheet!H17=\"\",\"\",Student_Sheet!H17)","v":""},{"$f":"IF(Student_Sheet!I17=\"\",\"\",Student_Sheet!I17)","v":""},{"$f":"IF(Student_Sheet!J17=\"\",\"\",Student_Sheet!J17)","v":""},{"$f":"IF(Student_Sheet!K17=\"\",\"\",Student_Sheet!K17)","v":""},{"$f":"IF(Student_Sheet!L17=\"\",\"\",Student_Sheet!L17)","v":""}]
[null,"Actual fixed selling and administrative expenses",{"$f":"Student_Sheet!C18","v":49189},null,"Variable selling expenses",null,null,"",null,null,"",null,null,null,null,null,null,null,null,null,null,"Variable selling expenses",{"$f":"IF(Student_Sheet!F18=\"\",\"\",Student_Sheet!F18)","v":""},{"$f":"IF(Student_Sheet!G18=\"\",\"\",Student_Sheet!G18)","v":""},{"$f":"IF(Student_Sheet!H18=\"\",\"\",Student_Sheet!H18)","v":""},{"$f":"IF(Student_Sheet!I18=\"\",\"\",Student_Sheet!I18)","v":""},{"$f":"IF(Student_Sheet!J18=\"\",\"\",Student_Sheet!J18)","v":""},{"$f":"IF(Student_Sheet!K18=\"\",\"\",Student_Sheet!K18)","v":""},{"$f":"IF(Student_Sheet!L18=\"\",\"\",Student_Sheet!L18)","v":""}]
[null,null,null,null,"Total variable costs",null,null,"",null,null,"",null,null,null,null,null,null,null,"Static budget information for 2017",null,null,"Total variable costs",{"$f":"IF(Student_Sheet!F19=\"\",\"\",Student_Sheet!F19)","v":""},{"$f":"IF(Student_Sheet!G19=\"\",\"\",Student_Sheet!G19)","v":""},{"$f":"IF(Student_Sheet!H19=\"\",\"\",Student_Sheet!H19)","v":""},{"$f":"IF(Student_Sheet!I19=\"\",\"\",Student_Sheet!I19)","v":""},{"$f":"IF(Student_Sheet!J19=\"\",\"\",Student_Sheet!J19)","v":""},{"$f":"IF(Student_Sheet!K19=\"\",\"\",Student_Sheet!K19)","v":""},{"$f":"IF(Student_Sheet!L19=\"\",\"\",Student_Sheet!L19)","v":""}]
[null,"Static budget information for 2017:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Budgeted sales price per unit",{"$f":"Student_Sheet!C21","v":40}]
[null,"Budgeted sales price per unit",{"$f":"Student_Sheet!C21","v":40},null,"Fixed factory overhead",null,null,{"$f":"IF($F22=$I22,\"\",N22)","v":""},null,null,{"$f":"IF($I22=$L22,\"\",O22)","v":""},null,null,null,null,null,null,null,"Budgeted direct materials cost per unit",{"$f":"Student_Sheet!C22","v":4.8},null,"Fixed factory overhead",{"$f":"IF(Student_Sheet!F21=\"\",\"\",Student_Sheet!F21)","v":""},{"$f":"IF(Student_Sheet!G21=\"\",\"\",Student_Sheet!G21)","v":""},{"$f":"IF(Student_Sheet!H21=\"\",\"\",Student_Sheet!H21)","v":""},{"$f":"IF(Student_Sheet!I21=\"\",\"\",Student_Sheet!I21)","v":""},{"$f":"IF(Student_Sheet!J21=\"\",\"\",Student_Sheet!J21)","v":""},{"$f":"IF(Student_Sheet!K21=\"\",\"\",Student_Sheet!K21)","v":""},{"$f":"IF(Student_Sheet!L21=\"\",\"\",Student_Sheet!L21)","v":""}]
[null,"Budgeted direct materials cost per unit",{"$f":"Student_Sheet!C22","v":4.8},null,"Fixed selling and administrative expenses",null,null,{"$f":"IF($F23=$I23,\"\",N23)","v":""},null,null,{"$f":"IF($I23=$L23,\"\",O23)","v":""},null,null,null,null,null,null,null,"Budgeted direct labor cost per unit",{"$f":"Student_Sheet!C23","v":7.09},null,"Fixed selling and administrative expenses",{"$f":"IF(Student_Sheet!F22=\"\",\"\",Student_Sheet!F22)","v":""},{"$f":"IF(Student_Sheet!G22=\"\",\"\",Student_Sheet!G22)","v":""},{"$f":"IF(Student_Sheet!H22=\"\",\"\",Student_Sheet!H22)","v":""},{"$f":"IF(Student_Sheet!I22=\"\",\"\",Student_Sheet!I22)","v":""},{"$f":"IF(Student_Sheet!J22=\"\",\"\",Student_Sheet!J22)","v":""},{"$f":"IF(Student_Sheet!K22=\"\",\"\",Student_Sheet!K22)","v":""},{"$f":"IF(Student_Sheet!L22=\"\",\"\",Student_Sheet!L22)","v":""}]
[null,"Budgeted direct labor cost per unit",{"$f":"Student_Sheet!C23","v":7.09},null,"Total fixed costs",null,null,{"$f":"IF($F24=$I24,\"\",N24)","v":""},null,null,{"$f":"IF($I24=$L24,\"\",O24)","v":""},null,null,null,null,null,null,null,"Budgeted factory overhead cost per unit",{"$f":"Student_Sheet!C24","v":2.02},null,"Total fixed costs",{"$f":"IF(Student_Sheet!F23=\"\",\"\",Student_Sheet!F23)","v":""},{"$f":"IF(Student_Sheet!G23=\"\",\"\",Student_Sheet!G23)","v":""},{"$f":"IF(Student_Sheet!H23=\"\",\"\",Student_Sheet!H23)","v":""},{"$f":"IF(Student_Sheet!I23=\"\",\"\",Student_Sheet!I23)","v":""},{"$f":"IF(Student_Sheet!J23=\"\",\"\",Student_Sheet!J23)","v":""},{"$f":"IF(Student_Sheet!K23=\"\",\"\",Student_Sheet!K23)","v":""},{"$f":"IF(Student_Sheet!L23=\"\",\"\",Student_Sheet!L23)","v":""}]
[null,"Budgeted factory overhead cost per unit",{"$f":"Student_Sheet!C24","v":2.02},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Budgeted variable selling expenses per unit",{"$f":"Student_Sheet!C25","v":1.75}]
[null,"Budgeted variable selling expenses per unit",{"$f":"Student_Sheet!C25","v":1.75},null,"Total expenses",null,null,{"$f":"IF($F26=$I26,\"\",N26)","v":""},null,null,{"$f":"IF($I26=$L26,\"\",O26)","v":""},null,null,null,null,null,null,null,"Budgeted fixed factory overhead",{"$f":"Student_Sheet!C26","v":119184},null,"Total expenses",{"$f":"IF(Student_Sheet!F25=\"\",\"\",Student_Sheet!F25)","v":""},{"$f":"IF(Student_Sheet!G25=\"\",\"\",Student_Sheet!G25)","v":""},{"$f":"IF(Student_Sheet!H25=\"\",\"\",Student_Sheet!H25)","v":""},{"$f":"IF(Student_Sheet!I25=\"\",\"\",Student_Sheet!I25)","v":""},{"$f":"IF(Student_Sheet!J25=\"\",\"\",Student_Sheet!J25)","v":""},{"$f":"IF(Student_Sheet!K25=\"\",\"\",Student_Sheet!K25)","v":""},{"$f":"IF(Student_Sheet!L25=\"\",\"\",Student_Sheet!L25)","v":""}]
[null,"Budgeted fixed factory overhead",{"$f":"Student_Sheet!C26","v":119184},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Budgeted fixed selling and administrative expenses",{"$f":"Student_Sheet!C27","v":49465}]
[null,"Budgeted fixed selling and administrative expenses",{"$f":"Student_Sheet!C27","v":49465},null,"Operating income",null,null,{"$f":"IF($F28=$I28,\"\",N28)","v":""},null,null,{"$f":"IF($I28=$L28,\"\",O28)","v":""},null,null,null,null,null,null,null,null,null,null,"Operating income",{"$f":"IF(Student_Sheet!F27=\"\",\"\",Student_Sheet!F27)","v":""},{"$f":"IF(Student_Sheet!G27=\"\",\"\",Student_Sheet!G27)","v":""},{"$f":"IF(Student_Sheet!H27=\"\",\"\",Student_Sheet!H27)","v":""},{"$f":"IF(Student_Sheet!I27=\"\",\"\",Student_Sheet!I27)","v":""},{"$f":"IF(Student_Sheet!J27=\"\",\"\",Student_Sheet!J27)","v":""},{"$f":"IF(Student_Sheet!K27=\"\",\"\",Student_Sheet!K27)","v":""},{"$f":"IF(Student_Sheet!L27=\"\",\"\",Student_Sheet!L27)","v":""}]
[]
[null,null,null,null,null,"Round all calculations to two decimal places",null,null,null,null,null,null,null,null,null,null,null,null,"Required:",null,null,null,"Round all calculations to two decimal places"]
[null,"Required:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Prepare a Flexible Budget Performance Report for 2017"]
[null,"1. Prepare a Flexible Budget Performance Report for 2017"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note* Make sure you state whether variances are favorable, F or unfavorable, U"]
[null,"Note* Make sure you state whether variances are favorable, F or unfavorable, U"]
[null,null,null,null,null,null,null,null,null,{"$f":"G26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use the area below to show your work and calculations.\n(*Note: Your instructor may use this area to help review and resolve any incorrect answers)"]