ACCT Assignment 6

profileMrJinx29
acct300_12-01.xlsx
Home>Business & Finance homework help>Accounting homework help>ACCT Assignment 6

Pr. 12-1

Problem 12-1 * 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 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. Proposal to Operate Warehouse Total number of answers = sum of above
November 7, 2012 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.
Differential revenue from alternatives:
Revenue from operating warehouse
Revenue from investment in bonds Steps:
Differential revenue from operating warehouse Open this sheet and macro sheet
Differential cost of alternatives: Open old templated, then change color palet to this sheet's
Costs to operate warehouse Insert new header - change problem number and reformat
Cost of equipment less residual value Copy these formulas (column AD) to new sheet.
Differential cost of operating warehouse Update to new edition's names and numbers
Differential income from operating warehouse Copy new error check formulas. For N-boxes
=IF(sol.!$C$5="OFF","",IF(AC25=""," ",IF(AC25<>sol.!AC25,"*"," ")))
2.
Should the proposal to operate the warehouse be accepted? The differential revenue from processing further to Decaf Columbian is more than the differential cost of processing further.
For B-Boxes
=IF(sol.!$C$5="OFF","",IF(AC30<>sol.!AC30,"*"," "))
3.
Total estimated revenue from operating warehouse Copy Score formula from this template to new sheet.
Total estimated expenses to operate warehouse: =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
Costs to operate warehouse, excluding depreciation
Highland Community College: Enter all costs as positive values.
Highland Community College: Enter all costs as positive amounts.
Cost of warehouse equipment less residual value =IF(sol.!$C$5="OFF","","*Since some answer boxes are correct when left blank, the beginning score is greater than 0%.")
Total estimated income from operating warehouse
Peggy Hussey: This amount could also be determined by adding the differential income from operating the warehouse to the investment income forgone.

sol.

Problem 12-1 * 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. Proposal to Operate Warehouse Total number of answers = sum of above
November 7, 2012 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.
Differential revenue from alternatives:
Revenue from operating warehouse $ 4,800,000
Revenue from investment in bonds 540,000 Steps:
Differential revenue from operating warehouse $ 4,260,000 Open this sheet and macro sheet
Differential cost of alternatives: Insert new header - change problem number and reformat
Costs to operate warehouse $ 2,625,000
Highland Community College: Enter all costs as positive amounts.		 Copy these formulas (column AD) to new sheet.
Cost of equipment less residual value 800,000
Differential cost of operating warehouse 3,425,000
Differential income from operating warehouse $ 835,000
2.
Should the proposal to operate the warehouse be accepted? Yes The differential revenue from processing further to Decaf Columbian is more than the differential cost of processing further.
Copy Score formula from this template to new sheet.
=IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
3.
Total estimated revenue from operating warehouse $ 4,800,000 =IF(sol.!$C$5="OFF","","*Since some answer boxes are correct when left blank, the beginning score is greater than 0%.")
Total estimated expenses to operate warehouse:
Costs to operate warehouse, excluding depreciation $ 2,625,000
Highland Community College: Enter all costs as positive values.

Highland Community College: Enter all costs as positive amounts.		 Cost of warehouse equipment less residual value 800,000 3,425,000
Total estimated income from operating warehouse $ 1,375,000
Peggy Hussey: This amount could also be determined by adding the differential income from operating the warehouse to the investment income forgone.