Question: Task #1: Write a brief summary of how each item is computed (see yellow highlighted areas) on the Task #1 Data tab. Please n1 only

 Task #1: Write a brief summary of how each item is

Task #1: Write a brief summary of how each item is computed (see yellow highlighted areas) on the Task #1 Data tab. Please n1 only required to explain how the #s are determined. No calculations are necessary on this tab. Task #2: Calculate the sales price and sales volume variances (Task #2 5V). Complete the yellow sections only. Write a brief sum of the analysis. Discuss both the sales price and the sales volume variance separately and then discuss the sales variances as a \\ product line and in total. Task #3: Calculate the direct price materials and direct materials quantity variance (Task #3 DM); the direct labor rate and direc variance (Task #3 DL); the variable overhead spending and variable overhead efciency variance (Task #3 VMOH); and the xed and xed overhead volume variances (Task #3 FMOH). Write a brief summary on each variance and each combination (for eacl in total). Complete the yellow sections only. The RED TAB Ck T#3 PPR tab is a summary of the production variances (DM, DL, MI used to check your results for Task #3. Cell w20 and w22 on the PPR tab must balance. Use this to check your answers. Task #4: Write a memo to the CEO to explain the results of the variances calculated in this assignment. Indicate the dollar amo (Favorable or Unfavorable) of each separate variance and in total within each category and as a whole. Evaluate the performanl based on these measures. Did they perform better than expected or worse than expected? What would you recommend they information to improve the performance of the business? Task #5: Ethical issue: Du ring your examination of the labor time cards, you notice that employees frequently take longer brea and come in late and leave early. You also notice that employees are working overtime hours on the weekends to complete the Does the behavior of the employees involved constitute a violation of honesty and integrity? What about the manager's respOI employees? Are they competent? Address this issue in your memo to the CEO and recommend a course of action

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!