Sanford Scientific manufactures GPS devices for a chain of retail stores. (Click the icon to view information about the Magellan XS.) The budgeted and actual amounts for Magellan XS for July 2017 were as follows: (Click the icon to view the budgeted and actual amounts.) (Click the icon to view additional information.) Read the requirements. Requirement 1. Compute the price and efficiency variances for the three categories of direct materials and for direct manufacturing labor in July 2017. Begin by calculating the the price and efficiency variances for the each category of direct materials. (Do not round intermediary calculations. Round the amount you enter into the input cell to the nearest whole dollar. Label each variance as favorable (F) or unfavorable (U). For variances with a $0 balance, make sure to enter "0" in the appropriate field. If the variance is zero, do not select a label. Abbreviation used: Qty = quantity.) Actual Price Actual Input Qty x Efficiency Flexible Costs Incurred Variance Budgeted Price Variance Budget July 2017 Navigation systems Polarized glass Plastic casing Calculate the the price and efficiency variances for the direct labor. (Do not round intermediary calculations. Round the amount you enter into the input cell to the nearest whole dollar. Label each variance as favorable (F) or unfavorable (U). For variances with a $0 balance, make sure to enter "0" in the appropriate field. If the variance is zero, do not select a label.) Actual Price Actual Input Qty x Efficiency Flexible Costs Incurred Variance Budgeted Price Variance Budget July 2017 Direct labor i Data Table Budgeted Amounts Actual Amounts 3,700 4,100 $ 93,240 $ 98,040 3,885 4,085 $ 30,525 $ 28,250 Magellan XS units produced Navigation systems cost Navigation systems Polarized glass cost Sheets of polarized glass used Plastic casing cost Ounces of specialty plastic used Direct manufacturing labor costs Direct manufacturing labor-hours 555 565 $ 31,968 $ 33,275 3,996 4,266 $ 53,280 $ 54,948 2,220 2,280 Print Done