West Manufacturing Corporation accumulated the following data relative to jobs started and finished during 2019. INSTRUCTIONS 1. Create a Data Validation Input Message - The relevant range is between 12 and 16,000 units. Click on cell 17 and add a Data Validation Input Message ost following Click Data then click Data Validation under Data Tools bow in the middle of the and input the following: Standard Yards/unit RO Direct Materals Cost/yard $4.30 Direct Labor Hours/unit Cost/hour $11.75 Hours/unit 1.5 Variable Overhead Cost/hour $2.50 Fred Overhead Standard amount that should be $50,000 applied based on tulos Actuals Direct Materals Total yards Cost/yard Direct Labor Total hours Cost/hour Variable Overhead Total Costs 98.000 $4.10 17,000 $14,10 $37,000 A Settings Allow: Whole numbe - Data: between - Mimum 11.000 Maximum: 16.000 Overhead Total Costs $49.000 Additional information Overhead is applied on the basis of direct 6 8. Input Message Title - "Relevant Range out Mesa "The relevante s 1,to 16.000 units Actual Units Produced 11,500 Error Alert Styles Then Entry Error Message The number of units must be between 11,000 and 16,000 $245 2. Check your data validation by inputting 17,000 into cell 017. You should see yo error message click Rety and enter 12,000 into cell 17. Compute the total material variance 3 SP 3. Compute each of the seven variances. Enter your cell references and formulas the light blue boxes 4. Save and submit your file with the appropriate file name("Your First Name Y Last Name - Excel 29"). 0 Compute the material price variance 1 AP AQ ) - [ SP AQ ) XX $0 $0 Material price variance Unf Compute the material quantity variance. AQ SPL SQX do x Material quantity variance Unf Compute the total labor variance. I ... XX Total labor variance Unf Compute the labor price variance. AH SR . Labor price variance Compute the labor quantity variance. AH SR SH SR $0 $0 Labor quantity variance = Unf