70.2K

Verified Solution

Link Copied!

Cost incurred: Actual inputs x actual prices Actual inputs x standard prices Standard inputs allowed for actual output x standard prices Saving & Submitting Solution 1 Save file to desktop. > 1 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions Cype the numbers in, you will be marked wrong. Requirement Compute the price, efficiency, and flexible-budget variances for direct materials and direct manufacturing labor. a. Use the ABS function when calculating variances, and use the drop-down selections for F (favorable) or U (un describing the variances. eady Accessibility: Investigate ? a. b. Q A a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. Navigate back to the activity window - screen where you downloaded the initial spreadsheet Click Choose button under step 3; locate the file you just saved and click Open Click Upload button under step 3 C. 71F Mostly cloudy C:...LL. INSTRUCTIONS (8) 2 W S # ENTERANSWERS 3 E $ 4 + R % Direct Materials UL Search $200,000 214,000 225,000 5 T Direct Manufacturing Labor B 9 $90,000 86,000 80,000 & Y E 7 16 + 100% * U W 8 C R EV

Jse the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructiona ype the numbers in, you will be marked wrong. Requirement Compute the price, efficiency, and flexible-budget variances for direct materials and direct manufacturing labor. a. Use the ABS function when calculating variances, and use the drop-down selections for F (favorable) or U (ur) describing the variances. Saving 8 Submitting Solution 1 Save fie to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Uplond and submit your file to be graded. a Navigate back to the activity window - screen where you downioaded the initial spreadsheet. b. Click Choose button under step 3; locate the file you just saved and click Open c Click Upload button under step 3 Jse the blue shaded areas on the ENTERANSWERS tab for inputs: Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions type the numbers in, you will be marked wrong. Requirement Compute the price, efficiency, and flexible-budget variances for direct materials and direct manufacturing labor. a. Use the ABS function when calculating variances, and use the drop-down selections for F (favorable) or U (ur describing the variances. Saving \& Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCELPROJECTS 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open c. Click Upload button under step 3 Direct Manufacturing d 3 Direct Materials F/U Labor F/U (1) Price variance (2) Efficiency variance (3) Flexible-budget variance \begin{tabular}{|l|l|l|l|} \hline Direct Materials & F/U & \\ \hline & & \\ \hline \end{tabular} 1777 298

Answer & Explanation Solved by verified expert

See Answer