answer the questions in excel

xercise 9-4 - Book - Practice Saved Help Save & Exit Submit B5 Exercise 9-4 - Blank - Excel Zuhaib Mohamed File Home Insert Draw Page Layout Formulas Data Review View Help Chem Office20 Tell me 2 Share Check my work Calibri , , 1 - 11-AA A General $ - %, $ +.000 .00 0 Conditional Formatting Format as Table 17 Cell Styles Insert - Delete - aste E9-4 (Static) Interpreting Direct Materials Price, Quantity Variances [LO 9-3] BIU- 13 Format lipboard Font Alignment Number Styles Cells Editing Perfect Pet Collar Company makes custom leather pet collars. The company expects each collar to require 1.5 feet of leather and predicts leather will cost $2.50 per foot. Suppose Perfect Pet made 60 collars during February. For these 60 collars, the company actually averaged 1.75 feet of leather per collar and paid $2.00 per foot. oints A21 X far A B C D E F G H J K L M M N. o P R s T I U V W Skipped Requirement 2 Direct Materials Price Variance: eBook Required: 1. Compute the standard direct materials cost per unit. 2. Without performing any calculations, determine whether the direct materials price variance will be favorable or unfavorable 3. Without performing any calculations, determine whether the direct materials quantity variance will be favorable or unfavorable 6. Calculate the direct materials price and quantity variances. Requirement 3: Direct Materials Quantity Variance: Hint Requirement : Complete this question by entering your answers in the tabs below. Print Requirements: Reg 1 Req 2 and 3 Reg 6 6 References Calculate the standard direct materials cost per unit. (Round your answer to 2 decimal places.) Requireacat 6: Collar - Direct Materials Standard Direct Materials per Collar AQ= AP - SQ = SP = Direct Materials Quantity Variance: SP (SQ-AQ) Direct Materiale Price Variance: AQ" (SP.AP) Direct Materiale Spending Variance