E-commerce Control Procedures | Open Source eCommerce

Requirements: E-commerce Control Procedures

E-commerce Control Procedures to questions should vary in length according to the nature of the question and be in a format similar to that demonstrated in the text and study guide. Check E-commerce Control Procedures | Open Source eCommercespreadsheet requirements carefully.

The work you submit must be your own. In the past a few students have received heavy penalties for submitting assignments which were not entirely their own work.

Record your name, student ID number and page number as a footer on every page. Remember, your work will not be returned to you so it is imperative that you retain copies. Complete solutions will be provided to you with your grade and comments by the assessor.

Follow the assignment requirements above very closely. Provide references throughout and a bibliography.  Check the spreadsheet requirements and the spreadsheet advice included on the Interact web site.

  • Content assessed: Topics 5 -10

Key generic skills: Analytical, problem-solving, spreadsheeting, written communication.

Note assignment requirements set out above. Follow these closely.

Assignment 2 covers topics 5, 6, 7, 8, 9 and 10.

Assignment 2 – Consists mainly of questions from Horngren, C.T., Sundem, G.L., Stratton, W.O. Burgstahler, D., & Shatzberg, J. Introduction to management accounting, (15th edition 2011), and another text by Horngren.  Horngren, C. T.,  Harrison, W. T. & Oliver M.S., (2012). Internal control and cash. Accounting (9th ed.,) Prentice Hall,  provided with these study materials as Reading 5.  Present your solutions in the same sequence as listed below.

Question 1

 E7-15  E-commerce Control Procedures

See Reading 5 in the learning materials

Source: Horngren, C. T., Harrison, W. T. & Oliver M.S.,  (2012). Internal control and cash. Accounting (9th ed., pp. 386 of Reading 5). Prentice Hall.

Question 2

E7-18  D.J. Harrison

Reading 5 of the learning materials.

Source: Horngren, C. T., & Harrison, W. T. (2012). Internal control and cash. Accounting (9th ed., pp. 387-388 of Reading 5). Prentice Hall.

Answer all parts. Solve using a spreadsheet. Include the normal view and formula view and include an IF function to check balances.

Question 3

1-4 (give examples), 1-17, 1-23 (give examples), 2-5, 2-18

Source: Horngren, et al. (2011). Introduction to management accounting (15th ed., pp. 46 & 83). Pearson.

Question 4

1-47 Ethical Issues

Source: Horngren, et al. (2011). Introduction to management accounting (15th ed., p. 50). Pearson.

Question 5

2-52 CVP

Source: Horngren, et al. (2011). Introduction to management accounting (15th ed., p. 90). Pearson.

Solve using a spreadsheet. Include a spreadsheet graph similar to Exhibit 2-7, p. 67 of the text. See the spreadsheet examples in the Spreadsheet Advice section of Interact and the study modules on this topic.

Question 6

5-2, 5-14, 5-17.

Source: Horngren, et al. (2011). Introduction to management accounting (15th ed., p. 226). Pearson.

Question 7

5-30 Identification of Relevant Costs

Source: Horngren, et al. (2011). Introduction to management accounting (15th ed., p. 227). Pearson.

Question 8

6-3, 6-5, 6-18, 6-22

Source: Horngren, et al. (2011). Introduction to management accounting (15th ed., p. 266-267). Pearson.

Question 9

Decision making

Please be frank and creative in answering the following questions.

a (i)

Suppose you’re on a TV game show, and you’re given the choice of three doors. Behind one door is a brand new car, behind the others, nothing. You pick a door. The TV host, who knows what’s behind the doors, chooses another door and opens it to show you that it has nothing. Should you change your decision?

Don’t think about this too deeply just yet. Do you feel (intuit?) that you should change your choice? Answer initially without researching the question. What is the thinking behind your answer. Conduct a survey of ten of your friends/colleagues to give their opinion. Copy and paste the question. Include in your answer a table setting out the results of this survey. Also create a simple chart with Excel to present the results of your survey.

a (ii) After you answer the first part of this question, search the Internet for the Monty Hall problem. Provide your own explanation of the correct solution. Why do so many get the wrong answer? Did you?

b. A man goes to see his medical doctor to find out whether or not he has a deadly disease. The test is positive. The test is 95% accurate and one in one thousand men of his age has this disease. What is the probability he has the disease? He decides to seek a second opinion but the results are exactly the same. When this question was put to a group of doctors, 80% of them answered “95%”. He now plans to sell up all his assets, tell his boss what he really thinks of her, quit his job on the spot and live in the Maldives in the time he has left. Is this a rational decision? Explain.

  1. Suppose an urn contains 100 marbles, 75 red and 25 black. A marble is drawn at random from the urn and you are asked to guess what colour you believe the marble to be. The marble is then shown, replaced, and the urn’s contents again randomised. The aim is to maximise the number of correct guesses. Before reading any further, what strategy would you employ? What would you guess?

Assume 4 red come out in a row. What would your next guess be? Why?

  1. Creatively discuss the rationality of human decision making using these and other examples. Use the Internet as a source (about 300 words for this section).

E-commerce Control Procedures | Open Source eCommerce

Question 10

7-36 Cash Budget

Source: Horngren, et al. (2011). Introduction to management accounting (15th ed., p. 314). Pearson.

Spreadsheet your answer with the correct structures.

After you have completed your answer create a second version by changing all the data. Paste the normal view for both versions and one formula view.

Question 11 

8-29 Direct-Material Variances 

Source: Horngren, et al. (2011). Introduction to management accounting (15th ed., p. 350). Pearson.

Solve using a spreadsheet. Make and paste a second version of the normal view with some changed data. Use the IF function. Paste the formula view once only.

Question 12

11-47 NPV, ARR and Payback.

Source: Horngren, et al. (2011). Introduction to management accounting (15th ed., p. 479). Pearson.

 Solve using a spreadsheet. Use the Excel NPV function. As usual, paste a formula view.

Question 13

 Write a business report on the significance of two of the following to managers and the function of accounting.

(a) Spreadsheets
(b) Black Swans (Taleb)
(c) “Gray” ethical areas in accounting. See http://danariely.com/tag/ethics/
(d) Six Sigma

About 300-400 words each. Use the Internet as a resource. Give examples.

Rationale

See the rationale for assignment 1.

Key generic skills: Analytical, problem-solving, spreadsheet modelling, critical thinking and written communication.

Note assignment requirements set out above. Follow these closely.

Assignment 2 covers topics 5, 6, 7, 8, 9 and 10.

Marking criteria

Your assignment will be marked as a whole with recognition being given to application of knowledge, quality thinking and skills. For some questions students have a chance to demonstrate some creativity, or provide their own examples or give evidence of wider reading or structure a spreadsheet model in an innovative manner. We also need to avoid the snowballing effects of cumulative errors – that is, an error early in a practical question which carries through. Thus a marking system is used with deductions for errors and omissions. Full marks are a possibility for well structured, complete, quality answers.that comply with assignment requirements including spreadsheet modelling.