Question: Chapter 10: Applying Excel Data Exhibit 10-1: Standard Cost Card Required information The Chapter 10 Form worksheet is to be used to create your own

Chapter 10: Applying Excel Data Exhibit 10-1: Standard Cost Card Required information The Chapter 10 Form worksheet is to be used to create your own worksheet version of the main example in the text. Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell D21 enter the formula " =D6". Notes: In the text, variances are always displayed as positive numbers. To accomplish this, you can use the ABS() function in Excel. For example, the formula in cell B25 would be "=ABS(F21-F22)". - Cells C25 through C27, C34 through C36, and C43 through C45 already contain formulas to compute and display whether variances are Favorable or Unfavorable. Do not enter data or formulas into those cells-if you do, you will overwrite these formulas. - After entering formulas in all of the cells that contained question marks, verify that the amounts match the numbers in the example in the text. Check your worksheet by changing the direct materials standard quantity in cell B6 to 2.9 pounds, the direct labor standard quantity in cell B7 to 0.6 hours, and the variable manufacturing overhead in cell B8 to 0.6 hours. The materials spending variance should now be $1,500U, the labor spending variance should now be $3,720F. and the variable overhead spending variance should now be $60F. If you do not get these answers, find the errors in your worksheet and correct them

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!

please help with the excel formulas Chapter 10: Applying Excel Data Exhibit 10-1: Standard Cost Card Direct materlals Direct labor Variable manufacturing overhead inguts \begin{tabular}{|r|r|} \hline...

i need you to copy and paste the formulas in order for me to paste it on excel. Thank you in advance A B D E F G Chapter 10: Applying Excel Data Exhibit 10-1: Standard Cost Card Inputs Direct...

Chapter 10: Applying Excel Data Exhibit 10-1: Standard Cost Card Enter a formula into each of the cells marked with a ? below Main Example: Chapter 10 Chapter 10: Applying Excel Data Exhibit 10-1:...

Revise the data in your worksheet to reflect the results for the subsequent period as shown below: A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Chapter 10: Applying Excel Data Exhibit 10-1: Standard...

Chapter 10: Applying Excel Data Exhibit 10-1: Standard Cost Card Inputs Direct materials Direct labor Variable manufacturing overhead Standard Quantity 3.0 pounds 0.50 hours 0.50 hours Standard Price...

Chapter 10: Applying Excel Data Exhibit 10-1: Standard Cost Card Inputs Direct materials Direct labor Variable manufacturing over head Standard Quantity 3.0 pounds 0.50 hours 0.50 hours Standard...

Chapter 10: Applying Excel Data Exhibit 10-1: Standard Cost Card Inputs Standard Quantity Standard Price Direct materials 3.0 pounds $4.00 per pound Direct labor 0.50 hours $22.00 per hour Variable...

Chapter 1 0 : Applying Excel Data Exhibit 1 0 - 1 : Standard Cost Card Direct materials Inputs Direct labor Variable manufacturing overhead Actual results: Actual output Actual variable manufacturing...

Describe the process by which plants colonised land and the evidence for the development of increasingly sophisticated ecosystems between the Ordovidian and Devonian.

Following is Hartzbergs latest income statement. The company produced and sold 100,000 units during the year. Sales (100,000 units at $50) $5,000,000 Cost of goods sold: Direct material $1,500,000...

2 Fred is a director of Bray Ltd and holds 500 shares in that company. His wife is also a director and holds 400 shares. He has two children John, aged 19 and Jane, aged 15 who hold 50 shares each....

Elizabeth Island Airways scher. Ellermalogenal airine serving the New England area, recently suffered a major cras. As a result passengers are considered to be shy choose As there comer when making...

belief in the correspondence of own outcomes with the outcomes of others through interdependences, where a persons misbehaviour may bring shame on the whole collective; and

a feeling of involvement in and contribution to the lives of others.

Universalismparticularism. An inclination to apply the rules according to friendship and kinship relations has implications for recruitment and promotion policies in organizations in some African...