Chat with AI
Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
Edition 4ISBN: 978-1111581565Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
Edition 4ISBN: 978-1111581565 Exercise 4
PROBLEM DATA
McGrade Industries manufactures a product whose standard direct materials and direct labor unit costs are as follows:
REQUIREMENT
Open the file PRIMEVAR from the website for this book at cengagebrain.com. Enter the input values or formulas to compute the input values. Then enter the formulas where indicated on the worksheet. As a hint, FORMULA1 can be written as =(D8-D9)*D12. Formulas 8-10 should enter an F if the variance is favorable and a U if it is unfavorable. See the discussion of the =IF function in Appendix A of Excel Quick. Enter your name in cell A1. Save the completed file as PRIMEVAR3. Print the worksheet when done. Also print your formulas. Check figure: Material quantity variance (cell B27), $24,000 U.
McGrade Industries manufactures a product whose standard direct materials and direct labor unit costs are as follows:
REQUIREMENT
Open the file PRIMEVAR from the website for this book at cengagebrain.com. Enter the input values or formulas to compute the input values. Then enter the formulas where indicated on the worksheet. As a hint, FORMULA1 can be written as =(D8-D9)*D12. Formulas 8-10 should enter an F if the variance is favorable and a U if it is unfavorable. See the discussion of the =IF function in Appendix A of Excel Quick. Enter your name in cell A1. Save the completed file as PRIMEVAR3. Print the worksheet when done. Also print your formulas. Check figure: Material quantity variance (cell B27), $24,000 U.
Explanation
Verified
Verified
Open the file indicated in the instructi...
Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
