expand icon
book Excel Applications for Accounting Principles 4th Edition by Gaylord Smith cover

Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

Edition 4ISBN: 978-1111581565
book Excel Applications for Accounting Principles 4th Edition by Gaylord Smith cover

Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

Edition 4ISBN: 978-1111581565
Exercise 2
PROBLEM DATA
Reliable Smoke Alarms, Inc., has just completed an in-depth study of overhead costs. The firm normally operates between 3,600 and 4,600 labor hours each month. Budgeted costs for this range of activity are presented as follows:
PROBLEM DATA  Reliable Smoke Alarms, Inc., has just completed an in-depth study of overhead costs. The firm normally operates between 3,600 and 4,600 labor hours each month. Budgeted costs for this range of activity are presented as follows:     REQUIREMENT  Open the file FLEXBUD from the website for this book at cengagebrain.com. Enter the 12 formulas in the appropriate cells. FORMULA6 and FORMULA12 will utilize the =IF function discussed in Appendix A of Excel Quick. Enter your name in cell A1. Save your results as FLEXBUD2 and print the worksheet when done. Also print your formulas. Check figure: Total flexible budget difference (cell E43), $152 unfavorable.
REQUIREMENT
Open the file FLEXBUD from the website for this book at cengagebrain.com. Enter the 12 formulas in the appropriate cells. FORMULA6 and FORMULA12 will utilize the =IF function discussed in Appendix A of Excel Quick. Enter your name in cell A1. Save your results as FLEXBUD2 and print the worksheet when done. Also print your formulas. Check figure: Total flexible budget difference (cell E43), $152 unfavorable.
Explanation
Verified
like image
like image

Open the FLEXBUD worksheet. Enter formul...

close menu
Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
cross icon