Create a handwritten/manual solution AND a spreadsheet solution to the following problem. Scan or use your phone to capture an image and paste a copy of your manual solution in your assignment submission. Also paste a spreadsheet solution showing the row and column headings and the formula view. Your report should be completely formula driven.

Design your spreadsheet to meet the assignment requirements. In particular, check the spreadsheet requirements and the Spreadsheet Advice PDF.

The problem is adapted from P7-13 in your text page 202.

Required:

A. Calculate the materials price variance (on purchase) and materials usage variance. What is the actual direct labour rate per hour?

Answer the requirements using both a manual and spreadsheet solution. In your spreadsheet, include the IF function to determine Favourable and Unfavourable variances.