ACCT Assignment 5

profileMrJinx29
acct300_10-02.xlsx
Home>Business & Finance homework help>Accounting homework help>ACCT Assignment 5

Pr. 10-2

Problem 10-2 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: 0
Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
74
Score: 0% " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
0
Key Code: 2 Total SUM(AV13:AV15)
Instructions 74
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 in the row immediately to the right of an incorrect answer. Notes:
" " represents an unanswered N box - counts as an incorrect.
" " represents a correct blank answer or N answer
1. Schedule of manufacturing costs incurred during June: Total number of answers = sum of above
Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6001 Steps:
No. 6002 Open this sheet and macro sheet
No. 6003 Open old templated, then change color palet to this sheet's
No. 6004 Insert new header - change problem number and reformat
No. 6005 Copy these formulas (column AD) to new sheet.
No. 6006 Update to new edition's names and numbers
Total =IF(sol.!$C$5="OFF","",IF(AE25=""," ",IF(AE25<>sol.!AE25,"*"," ")))
2. Schedule of cost of jobs finished during June:
For B-Boxes
Direct Direct Factory =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Job Materials Labor Overhead Total
No. 6001 Copy Score formula from this template to new sheet.
No. 6002 =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
No. 6003
No. 6005
Total
3. Schedule of cost of goods sold during June:
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6001
No. 6002
No. 6003
Total
4. Schedule of completed jobs on hand, June 30, 2012:
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6005
5. Schedule of unfinished jobs:
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6004
No. 6006
Balance of Work in
Process, June 30
6. Gross profit for June based upon the jobs sold:
Jobs shipped and billed:
No. 6001
No. 6002
No. 6003
Total sales
Cost of goods sold (from schedule above)
Gross profit

sol.

Problem 10-2 * 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," ")
0
Total SUM(AV13:AV15)
Instructions 0
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. ERROR:#DIV/0!
A red asterisk (*) will appear in the row immediately to the right of an incorrect answer. Notes:
" " represents an unanswered N box - counts as an incorrect.
" " represents a correct blank answer or N answer
1. Schedule of manufacturing costs incurred during June: Total number of answers = sum of above
Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6001 $ 9,400 $ 8,800 $ 3,600 $ 21,800 Steps:
No. 6002 11,500 11,880 6,000 29,380
No. 6003 7,600 5,960 4,800 18,360
No. 6004 25,800 21,840 15,000 62,640
No. 6005 16,400 16,600 6,600 39,600
No. 6006 11,920 10,600 4,000 26,520 Open this sheet and macro sheet
Total $ 198,300 Insert new header - change problem number and reformat
Copy these formulas (column AD) to new sheet.
Update to new edition's names and numbers
2. Schedule of cost of jobs finished during June: Copy new error check formulas. For N-boxes
=IF(sol.!$C$5="OFF","",IF(AC25=""," ",IF(AC25<>sol.!AC25,"*"," ")))
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6001 $ 9,400 $ 8,800 $ 3,600 $ 21,800
No. 6002 11,500 11,880 6,000 29,380 For B-Boxes
No. 6003 7,600 5,960 4,800 18,360 =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
No. 6005 16,400 16,600 6,600 39,600 Copy Score formula from this template to new sheet.
Total $ 109,140
3. Schedule of cost of goods sold during June:
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6001 $ 9,400 $ 8,800 $ 3,600 $ 21,800
No. 6002 11,500 11,880 6,000 29,380
No. 6003 7,600 5,960 4,800 18,360
Total $ 69,540
4. Schedule of completed jobs on hand, June 30, 2012:
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6005 $ 16,400 $ 16,600 $ 6,600 $ 39,600
5. Schedule of unfinished jobs:
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6004 $ 25,800 $ 21,840 $ 15,000 $ 62,640
No. 6006 11,920 10,600 4,000 26,520
Balance of Work in
Process, June 30 $ 89,160
6. Gross profit for June based upon the jobs sold:
Jobs shipped and billed:
No. 6001 $ 26,000
No. 6002 36,000
No. 6003 48,000
Total sales $ 110,000
Cost of goods sold (from schedule above) 69,540
Gross profit $ 40,460