ACCT Assignment 6
MrJinx29
acct300_11-07ex.xlsxEx. 11-7
| Exercise 11-7 | * represents an incorrect N answer =COUNTIF(A14:H27,"~*") | ||||||||||||||||||||||||||||||
| Name: | 0 | ||||||||||||||||||||||||||||||
| Section: | " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ") | ||||||||||||||||||||||||||||||
| 13 | |||||||||||||||||||||||||||||||
| Score: | 0% | " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ") | |||||||||||||||||||||||||||||
| 0 | |||||||||||||||||||||||||||||||
| Key Code: | 2 | Total SUM(AV13:AV15) | |||||||||||||||||||||||||||||
| Instructions | 13 | ||||||||||||||||||||||||||||||
| Answers are entered in the cells with gray backgrounds. | Percentage =AD6/AD8 | ||||||||||||||||||||||||||||||
| Cells with non-gray backgrounds are protected and cannot be edited. | 0% | ||||||||||||||||||||||||||||||
| A red asterisk (*) will appear below or immediately to the right of an incorrect answer. | Notes: | ||||||||||||||||||||||||||||||
| " " represents an unanswered N box - counts as an incorrect. | |||||||||||||||||||||||||||||||
| Revenue per Account | Cost at low point | Open old templated, then change color palet to this sheet's | |||||||||||||||||||||||||||||
| a. | Cost at high point | Cost at high point | Insert new header - change problem number and reformat | ||||||||||||||||||||||||||||
| Variable Cost per Unit | = | - | = | - | = | per unit. | Units produced at high point | Units produced at high point | Copy these formulas (column AD) to new sheet. | ||||||||||||||||||||||
| - | - | Units produced at low point | Units produced at low point | Update to new edition's names and numbers | |||||||||||||||||||||||||||
| Copy new error check formulas. For N-boxes | |||||||||||||||||||||||||||||||
| Total Fixed Costs | = |
cpence: Calculate the total variable costs for either the high or the low point, and then subtract them from the total costs at that point. | =IF(sol.!$C$5="OFF","",IF(AC25=""," ",IF(AC25<>sol.!AC25,"*"," "))) | ||||||||||||||||||||||||||||
| b. | |||||||||||||||||||||||||||||||
| Total variable cost | = |
cpence: Varibale cost per unit x the number of units. | For B-Boxes | ||||||||||||||||||||||||||||
| Fixed cost | = |
cpence: Calculated above. | =IF(sol.!$C$5="OFF","",IF(AC30<>sol.!AC30,"*"," ")) | ||||||||||||||||||||||||||||
| Total cost | = | ||||||||||||||||||||||||||||||
| Copy Score formula from this template to new sheet. | |||||||||||||||||||||||||||||||
| =IF(sol.!$C$5="OFF","","Score:") | =IF(sol.!$C$5="OFF","",AD10) | ||||||||||||||||||||||||||||||
| =IF(sol.!$C$5="OFF","","*Since some answer boxes are correct when left blank, the beginning score is greater than 0%.") |
sol.
| Exercise 11-7 | * represents an incorrect N answer =COUNTIF(A14:H27,"~*") | ||||||||||||||||||||||||||||||
| Name: | SOLUTION | 0 | |||||||||||||||||||||||||||||
| Section: | " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ") | ||||||||||||||||||||||||||||||
| Score: | See student sheet for student's score | 0 | |||||||||||||||||||||||||||||
| Scoring: | ON | " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ") | |||||||||||||||||||||||||||||
| 4 | |||||||||||||||||||||||||||||||
| Total SUM(AV13:AV15) | |||||||||||||||||||||||||||||||
| Instructions | 4 | ||||||||||||||||||||||||||||||
| Answers are entered in the cells with gray backgrounds. | Percentage =AD6/AD8 | ||||||||||||||||||||||||||||||
| Cells with non-gray backgrounds are protected and cannot be edited. | 100% | ||||||||||||||||||||||||||||||
| A red asterisk (*) will appear below or immediately to the right of an incorrect answer. | Notes: | ||||||||||||||||||||||||||||||
| " " represents an unanswered N box - counts as an incorrect. | |||||||||||||||||||||||||||||||
| Revenue per Account | Cost at low point | Open old templated, then change color palet to this sheet's | |||||||||||||||||||||||||||||
| a. | Cost at high point | Cost at high point | Insert new header - change problem number and reformat | ||||||||||||||||||||||||||||
| Variable Cost per Unit | = | Cost at high point | - | Cost at low point | = | $2,110,000 | - | $1,535,000 | = | $ 23.00 | per unit. | Units produced at high point | Units produced at high point | Copy these formulas (column AD) to new sheet. | |||||||||||||||||
| Units produced at high point | - | Units produced at low point | 70,000 | - | 45,000 | Units produced at low point | Units produced at low point | Update to new edition's names and numbers | |||||||||||||||||||||||
| Copy new error check formulas. For N-boxes | |||||||||||||||||||||||||||||||
| Total Fixed Costs | = | $500,000 cpence: Calculate the total variable costs for either the high or the low point, and then subtract them from the total costs at that point. | =IF(sol.!$C$5="OFF","",IF(AC25=""," ",IF(AC25<>sol.!AC25,"*"," "))) | ||||||||||||||||||||||||||||
| b. | |||||||||||||||||||||||||||||||
| Total variable cost | = | $ 1,380,000 cpence: Varibale cost per unit x the number of units. | For B-Boxes | ||||||||||||||||||||||||||||
| Fixed cost | = | 500,000 cpence: Calculated above. | =IF(sol.!$C$5="OFF","",IF(AC30<>sol.!AC30,"*"," ")) | ||||||||||||||||||||||||||||
| Total cost | = | $ 1,880,000 | |||||||||||||||||||||||||||||
| Copy Score formula from this template to new sheet. | |||||||||||||||||||||||||||||||
| =IF(sol.!$C$5="OFF","","Score:") | =IF(sol.!$C$5="OFF","",AD10) | ||||||||||||||||||||||||||||||
| =IF(sol.!$C$5="OFF","","*Since some answer boxes are correct when left blank, the beginning score is greater than 0%.") |
