The sales variance section will require you to do the calculations in Excel. However, for the cost variances, you will need to import Percy's data from the text file, clean it up, and copy it to the correct places in the provided table. After doing this, the template will show you the individual cost variances one at a time. When submitting your answers on the Armond Dalton site, please round unit amounts to the nearest penny and other amounts to the nearest dollar or whole unit. When submitting your work as an Excel file, use reasonable formatting. To focus on accounting basics, we have made some simplifying assumptions for the variance chapters, including combining the divisions and classifying all overhead costs as either fixed or variable. Determining Sales Variances Q-1. What was the specialty candle division's sales volume variance? Q-2. What was the specialty candle division's sales price variance? Q-3. What is driving the overall sales variance, changes in sales price or sales volume? Calculating the Cost Variances Q-4. What is the overall direct materials quantity variance?