PLEASE ENSURE TO SHOW THE EXCEL FORMUMLAS A B C D E F G H H J K L M N o Q R S T U 1 Functions IF Formula Multiply, Add, Subtract Cell Referencing 2 3 E6 13 Using Excel to Calculate Variances Student Work Area 4 PROBLEM Required Provide input into cells shaded in yellow in this 5 The following information is available for Coady's Chocolates template Use mathematical formulas with cell references to Answer Field 6 the Problem or work area as indicated Use the IF function to 4 of your score 7 Actual production, boxes 3 400 denote if each variance is Favorable or Unfavorable Formula Multiply Cell reference Use a mathematical formula with cell 8 Budgeted production, boxes 3,000 references to the Problem area 9 Direct materials standards Ansver Field 10 Pounds of chocolate per box 3 a Calculate the direct materials price and quantity variances 4 of your score Formula Subtract Cellreference 11 Cost per pound $ 6 00 Ansver Field Use a mathematical formula with cell 12 Actual direct materials AQ X AP AQ X SP 4 of your score references to this work area, 13 Pounds of chocolate purchased 9,000 $ 54 900 $ Formula Multiply Cellreference 54,000 Use a mathematical formula with cell 14 Pounds of chocolate used 9 500 Answer Field 14 Direct Materials references to the Problem area 15 Cost per pound $ 6 10 4 of your soore Price Variance 16 Formula Multiply Cell reference $ 16 Ansver Field 900 Use a mathematical formula with cell 28 of your score 17 references to the Problem area Unfavorable Answer Field Function IF Cell reference, 18 4 of your score Use the IF function with cell references to the variano 19 AQ SP SQ X SP amounts in this work area to designate if the variance Formula Multiply Cell reference Answer Field Favorable or Unfavorable 20 $ 4 of your score Use a mathematical formula with cell 57 000 $ 54 000 references to the Problem area, 21 Formula Subtract Cell reference Direct Materials Use a mathematical formula with cell references 22 Quantity Variance to this work area 23 $ 3,000 24 Unfavorable Answer Field 28 of your score 25 Function IF Cell reference 26 b What might have caused the variances you calculated Use the IF function with cell references to the variance 27 Answer Field Ansver Field mounts in this work area to designate if the variance is 28 lavorable or Unfavorable 4 of your score 4 of your score Coady's Chocolates appears to have purchased a 29 Drop down Selection Select the Drop down Selection Select the correct correct response from the drop down response from the drop down list OPTIONS 30 list OPTIONS higher quality chocolate at a lower price Higher Price 31 Higher Quaility Lower Price 32 Lower Quaility than the standard specified The lower quality 33 34 Answer Field Chocolate appears to have been processed Ansyer Field 35 4 of your score 4 of your score Drop down Selection Select the correct Drop down Selection Select the correct 36 better than the standard quality, requiring response from the drop down list OPTIONS response from the drop down list OPTIONS 37 More than Higher Quaility 38 Less than Lower Quaility less chocolate to complete the production run 39 40 Answer Field 4 of your score 41 Drop down Selection Select the correct 42 response from the drop down list OPTIONS 43 Less Chocolate More Cocolate 44 45 46 47 48 49 50 A B C D E F G H H J K L M N o Q R S T U 1 Functions IF Formula Multiply, Add, Subtract Cell Referencing 2 3 E6 13 Using Excel to Calculate Variances Student Work Area 4 PROBLEM Required Provide input into cells shaded in yellow in this 5 The following information is available for Coady's Chocolates template Use mathematical formulas with cell references to Answer Field 6 the Problem or work area as indicated Use the IF function to 4 of your score 7 Actual production, boxes 3 400 denote if each variance is Favorable or Unfavorable Formula Multiply Cell reference Use a mathematical formula with cell 8 Budgeted production, boxes 3,000 references to the Problem area 9 Direct materials standards Ansver Field 10 Pounds of chocolate per box 3 a Calculate the direct materials price and quantity variances 4 of your score Formula Subtract Cellreference 11 Cost per pound $ 6 00 Ansver Field Use a mathematical formula with cell 12 Actual direct materials AQ X AP AQ X SP 4 of your score references to this work area, 13 Pounds of chocolate purchased 9,000 $ 54 900 $ Formula Multiply Cellreference 54,000 Use a mathematical formula with cell 14 Pounds of chocolate used 9 500 Answer Field 14 Direct Materials references to the Problem area 15 Cost per pound $ 6 10 4 of your soore Price Variance 16 Formula Multiply Cell reference $ 16 Ansver Field 900 Use a mathematical formula with cell 28 of your score 17 references to the Problem area Unfavorable Answer Field Function IF Cell reference, 18 4 of your score Use the IF function with cell references to the variano 19 AQ SP SQ X SP amounts in this work area to designate if the variance Formula Multiply Cell reference Answer Field Favorable or Unfavorable 20 $ 4 of your score Use a mathematical formula with cell 57 000 $ 54 000 references to the Problem area, 21 Formula Subtract Cell reference Direct Materials Use a mathematical formula with cell references 22 Quantity Variance to this work area 23 $ 3,000 24 Unfavorable Answer Field 28 of your score 25 Function IF Cell reference 26 b What might have caused the variances you calculated Use the IF function with cell references to the variance 27 Answer Field Ansver Field mounts in this work area to designate if the variance is 28 lavorable or Unfavorable 4 of your score 4 of your score Coady's Chocolates appears to have purchased a 29 Drop down Selection Select the Drop down Selection Select the correct correct response from the drop down response from the drop down list OPTIONS 30 list OPTIONS higher quality chocolate at a lower price Higher Price 31 Higher Quaility Lower Price 32 Lower Quaility than the standard specified The lower quality 33 34 Answer Field Chocolate appears to have been processed Ansyer Field 35 4 of your score 4 of your score Drop down Selection Select the correct Drop down Selection Select the correct 36 better than the standard quality, requiring response from the drop down list OPTIONS response from the drop down list OPTIONS 37 More than Higher Quaility 38 Less than Lower Quaility less chocolate to complete the production run 39 40 Answer Field 4 of your score 41 Drop down Selection Select the correct 42 response from the drop down list OPTIONS 43 Less Chocolate More Cocolate 44 45 46 47 48 49 50

Question

PLEASE ENSURE TO SHOW THE EXCEL FORMUMLAS A B C D E F G H H J K L M N o Q R S T U 1 Functions  IF  Formula  Multiply, Add, Subtract  Cell Referencing 2 3 E6 13   Using Excel to Calculate Variances Student Work Area 4  PROBLEM Required  Provide input into cells shaded in yellow in this 5 The following information is available for Coady's Chocolates template  Use mathematical formulas with cell references to Answer Field 6 the Problem or work area as indicated  Use the IF function to 4  of your score 7 Actual production, boxes 3 400 denote if each variance is Favorable or Unfavorable  Formula  Multiply  Cell reference  Use a mathematical formula with cell 8 Budgeted production, boxes 3,000 references to the Problem area  9 Direct materials standards Ansver Field 10 Pounds of chocolate per box 3 a  Calculate the direct materials price and quantity variances 4  of your score  Formula  Subtract  Cellreference  11 Cost per pound $ 6 00 Ansver Field Use a mathematical formula with cell 12 Actual direct materials AQ X AP AQ X SP 4  of your score  references to this work area, 13 Pounds of chocolate purchased 9,000 $ 54 900 $ Formula  Multiply  Cellreference  54,000 Use a mathematical formula with cell 14 Pounds of chocolate used 9 500 Answer Field 14 Direct Materials references to the Problem area  15 Cost per pound $ 6 10 4  of your soore  Price Variance 16 Formula  Multiply  Cell reference  $ 16 Ansver Field 900 Use a mathematical formula with cell 28  of your score  17 references to the Problem area  Unfavorable Answer Field Function  IF  Cell reference, 18 4  of your score  Use the IF function with cell references to the variano 19 AQ   SP SQ X SP amounts in this work area to designate if the variance Formula  Multiply  Cell reference  Answer Field Favorable or Unfavorable  20 $ 4  of your score Use a mathematical formula with cell 57 000 $ 54 000 references to the Problem area, 21 Formula  Subtract  Cell reference  Direct Materials Use a mathematical formula with cell references 22 Quantity Variance to this work area  23 $ 3,000 24 Unfavorable Answer Field 28  of your score  25 Function  IF  Cell reference  26 b  What might have caused the variances you calculated  Use the IF function with cell references to the variance 27 Answer Field Ansver Field mounts in this work area to designate if the variance is 28 lavorable or Unfavorable  4  of your score  4  of your score  Coady's Chocolates appears to have purchased a 29 Drop down Selection  Select the Drop down Selection  Select the correct correct response from the drop down response from the drop down list  OPTIONS 30 list  OPTIONS higher quality chocolate at a lower price Higher Price 31 Higher Quaility Lower Price 32 Lower Quaility than the standard specified  The lower quality 33 34 Answer Field Chocolate appears to have been processed Ansyer Field 35 4  of your score  4  of your score  Drop down Selection  Select the correct Drop down Selection  Select the correct 36 better than the standard quality, requiring response from the drop down list  OPTIONS response from the drop down list  OPTIONS 37 More than Higher Quaility 38 Less than Lower Quaility less chocolate to complete the production run  39 40 Answer Field 4  of your score  41 Drop down Selection  Select the correct 42 response from the drop down list  OPTIONS 43 Less Chocolate More Cocolate 44 45 46 47 48 49 50 A B C D E F G H H J K L M N o Q R S T U 1 Functions  IF  Formula  Multiply, Add, Subtract  Cell Referencing 2 3 E6 13   Using Excel to Calculate Variances Student Work Area 4  PROBLEM Required  Provide input into cells shaded in yellow in this 5 The following information is available for Coady's Chocolates template  Use mathematical formulas with cell references to Answer Field 6 the Problem or work area as indicated  Use the IF function to 4  of your score 7 Actual production, boxes 3 400 denote if each variance is Favorable or Unfavorable  Formula  Multiply  Cell reference  Use a mathematical formula with cell 8 Budgeted production, boxes 3,000 references to the Problem area  9 Direct materials standards Ansver Field 10 Pounds of chocolate per box 3 a  Calculate the direct materials price and quantity variances 4  of your score  Formula  Subtract  Cellreference  11 Cost per pound $ 6 00 Ansver Field Use a mathematical formula with cell 12 Actual direct materials AQ X AP AQ X SP 4  of your score  references to this work area, 13 Pounds of chocolate purchased 9,000 $ 54 900 $ Formula  Multiply  Cellreference  54,000 Use a mathematical formula with cell 14 Pounds of chocolate used 9 500 Answer Field 14 Direct Materials references to the Problem area  15 Cost per pound $ 6 10 4  of your soore  Price Variance 16 Formula  Multiply  Cell reference  $ 16 Ansver Field 900 Use a mathematical formula with cell 28  of your score  17 references to the Problem area  Unfavorable Answer Field Function  IF  Cell reference, 18 4  of your score  Use the IF function with cell references to the variano 19 AQ   SP SQ X SP amounts in this work area to designate if the variance Formula  Multiply  Cell reference  Answer Field Favorable or Unfavorable  20 $ 4  of your score Use a mathematical formula with cell 57 000 $ 54 000 references to the Problem area, 21 Formula  Subtract  Cell reference  Direct Materials Use a mathematical formula with cell references 22 Quantity Variance to this work area  23 $ 3,000 24 Unfavorable Answer Field 28  of your score  25 Function  IF  Cell reference  26 b  What might have caused the variances you calculated  Use the IF function with cell references to the variance 27 Answer Field Ansver Field mounts in this work area to designate if the variance is 28 lavorable or Unfavorable  4  of your score  4  of your score  Coady's Chocolates appears to have purchased a 29 Drop down Selection  Select the Drop down Selection  Select the correct correct response from the drop down response from the drop down list  OPTIONS 30 list  OPTIONS higher quality chocolate at a lower price Higher Price 31 Higher Quaility Lower Price 32 Lower Quaility than the standard specified  The lower quality 33 34 Answer Field Chocolate appears to have been processed Ansyer Field 35 4  of your score  4  of your score  Drop down Selection  Select the correct Drop down Selection  Select the correct 36 better than the standard quality, requiring response from the drop down list  OPTIONS response from the drop down list  OPTIONS 37 More than Higher Quaility 38 Less than Lower Quaility less chocolate to complete the production run  39 40 Answer Field 4  of your score  41 Drop down Selection  Select the correct 42 response from the drop down list  OPTIONS 43 Less Chocolate More Cocolate 44 45 46 47 48 49 50

Accepted Answer

The Answer is in the image, click to view ...

Question

PLEASE ENSURE TO SHOW THE EXCEL FORMUMLAS A B C D E F G H H J K L M N o Q R S

Step by Step Solution

Step: 1

Get Instant Access with AI-Powered Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question