Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

تمرين 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.