please show how calculations are done through excel

Cell Styles Format 76 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates, H12 x x AB 1 Standard Costs and Variances 2 Calculate missing direct material variables 4 Last month, Talley Corporation purchased and used the same quantity of material in producing its product, speed bumps for traffic control 6 Review the data in the ENTERANSWERS tab. 8 Use the blue shaded areas on the EnterAnswers tab for inputs. 9 Always use cell references and formulas where appropriate to receive full crec 10 11 Requirement 12 1 Complete the table by filling in the missing Information. a. Use the ABS function when calculating variances, and use the drop down select 15 Saving & Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS b. Save your solution in the folder you just created; add-solution date to end of file name 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open Click Upload button under step 3 d. Click Submit button under step 4 ASMASSNARARE Viewing Results 1 Click on Results tab in MyAccounting Lab 2 Click on the Assignment you were working on 3 Click on Project link this will bring up your Score Card 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback INSTRUCTIONS ENTERANSWERS E E 70 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for C10 1 (Always use cell references and formulas where appropriate to receive full credit.) Large speed bump Medium speed bump 15 $1.00 Direct materials information 4 Standard pounds per unit Standard price per pound Actual quantity purchased and used per unit 7 Actual price paid for material per pound 8 Direct materials price variance 9 Direct materials quantity variance 10 Total direct material variance 11 Number of units produced $1.80 $1,120 $100 $1.80 16 $2.10 $1,920 $480 400 A