Compose an email including all of the following information. You will address the email to your advisory board.

This should be a business email summarizing the tortilla distribution plan and results, and should include tables of the variance analyses alongside your discussions. Remember to support all statements and decisions.

1. Discuss the variable OH variances you have calculated and give possible explanations for

them.

2. Discuss the fixed OH variances you have calculated and give possible explanations for them

3. As actual sales over the three months were 5,500 packages at the one location. What does your team want to do with the tortilla distribution going forward, based on your analysis?

( pictures provided includes the data that is needed to answer the questions) Thanks!

2. Is fixed overhead underallocated or overallocated? By what amount? a. Use the ABS function when calculating the underallocated or overallocated amount. (AWass use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab you will be marked wrong.) Flexible Budget: Budgeted Input Allocated: Budgeted \begin{tabular}{|c|c|c|c|} \hline & ActualInputQuantityx & QuantityAllowedforActualOutputxInputQuantityxActualRate & InputQuantityAllowedIorActualOutputx \\ \hline$20,735 & $15,060 & $1,350 & $1,350 \\ \hline \end{tabular} Spending variance Efficiency variance Flexible-budget variance \begin{tabular}{|r|c|} \hline$$ & U/F \\ \hline$5,707.74 & F \\ \hline$1,560 & U \\ \hline$4,201.74 & F \\ \hline \end{tabular} 2. Is fixed overhead underallocated or overallocated? By what amount? a. Use the ABS function when calculating the underallocated or overallocated amount. (AWass use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab you will be marked wrong.) Flexible Budget: Budgeted Input Allocated: Budgeted \begin{tabular}{|c|c|c|c|} \hline & ActualInputQuantityx & QuantityAllowedforActualOutputxInputQuantityxActualRate & InputQuantityAllowedIorActualOutputx \\ \hline$20,735 & $15,060 & $1,350 & $1,350 \\ \hline \end{tabular} Spending variance Efficiency variance Flexible-budget variance \begin{tabular}{|r|c|} \hline$$ & U/F \\ \hline$5,707.74 & F \\ \hline$1,560 & U \\ \hline$4,201.74 & F \\ \hline \end{tabular}