Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please provide the Excel formulas for each spot Functions: IF; Formula: Multiply, Add, Subtract; Cell Referencing E6.13 - Using Excel to Calculate Variances PROBLEM The

please provide the Excel formulas for each spot

image text in transcribed

Functions: IF; Formula: Multiply, Add, Subtract; Cell Referencing E6.13 - Using Excel to Calculate Variances PROBLEM The following information is available for Coady's Chocolates: Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated. Use the IF function to denote if each variance is Favorable or Unfavorable. a. Calculate the direct materials price and quantity variances. Actual production, boxes 3,400 Budgeted production, boxes 3,000 Direct materials standards Pounds of chocolate per box 3 Cost per pound $ 6.00 Actual direct materials Pounds of chocolate purchasec 9,000 Pounds of chocolate used 9,500 Cost per pound 6.10 AQ x AP AQ SP $ Direct Materials Price Variance AQ SP SQ x SP Direct Materials Quantity Variance b. What might have caused the variances you calculated? Coady's Chocolates appears to have purchased a chocolate at a than the standard specified. The chocolate appears to have been processed the standard quality, requiring to complete the production run

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Study Guide/Workbook For Use With Introduction To Managerial Accounting

Authors: Peter Brewer, Ray Garrison, Eric Noreen

3rd Edition

0072835249, 978-0072835243

More Books

Students also viewed these Accounting questions