SPA232 Accounting information system
Students are required to read the below case study and answer the given questions. For answering the given questions students may need to do researches for both theory and practical parts specially for drawing the diagrams.
You will be assessed on below aspects of the assignment:
Word limitation: 2,000 ± 10%
Required academic journal articles: minimum 4 Answering theoretical questions
Drawing requested diagrams comprehensively for each level The final report is due by Sunday of week 14 (5 Pm)
Final Report Layout:
The final report should use an appropriate business report format and include:
1. A title page; include the full name and student number
2. Executive Summary
3. A table of contents (Calibri14 point);
4. Introduction (Calibri12 point);
5. Body – A detailed description on below sections (Calibri 12 point):
c. The Context Diagram
d. The level 0 DFD
e. The level 1 DFD
Sales and Revenue Cycle Production Cycle
Purchase and Expense Cycle Payroll Cycle
f. The Composition Diagram
6. Reference (APA, Times new Roman, 11 point);
Sunshine Fruity Pty Ltd starts juice bar business. It sells fruit and vegetable juices. Staff take orders from customers, serve the produced fresh juices to the customers and collect the money from the customers.
Staff produce juices daily in the store or bottled and stored the produced juices in advance of customer orders based on anticipated demand.
Staff purchase fruits and vegetables, and make payments. Each day staff take out the fruits and vegetables needed for making juices. These fruits and vegetables can be perishable or non-perishable according to their shelf life. For example, fresh vegetables would be perishable in two days where some fruits would be considered to be non-perishable in two days. Staff monitor which fruits and vegetables are running low every two or three days and draw up a list of that which needs to be ordered, based on re-order quantities and re-order levels. Sometimes they may need to readjust their re-order levels. A number of suppliers are used, and there is more than one possible supplier for each type of fruits and vegetables. Most of the ordering is done via the telephone. When deliveries are received, staff check the attached delivery note against the goods received. Most suppliers send an invoice each week and payment is be made.
Sunshine Fruity Pty Ltd pays staff’s wage every two weeks based on time card.
The following four main business activities are performed in the business cycle of Sunshine Fruity Pty Ltd.:
1) Sales and Revenue Cycle
i. Take juice order from customer
ii. Serve fresh juice or botted juice to customer
iii. Collect payment from customer
2) Production Cycle
i. Produce juice
ii. Store bottled juice
3) Purchase and Expense Cycle
i. Order fruit and vegetable based on re-reorder quantities
ii. Receive and check fruit and vegetable
iii. Pay to supplier for fruit and vegetable
4) Payroll Cycle
i. Record working hours
ii. Calculate wages including total and net wages
iii. Pay wage to employee
Answer the below questions and draw the required diagrams.
1) Explain what is meant by the purchase and expenditure cycle as a “mirror image” of the sales and revenue cycle. (5 marks)
2) There are three sub-processes in purchase and expenditure cycle. Please identify risks or threats (possible problems), and controls (minimizing possible problems) of each sub-process. (5 Marks)
3) Draw the context diagram of Sunshine Fruity business based on the above four basic activities. (5 Marks)
4) Draw a level 0 DFD identifying the logical subsystems base on the context diagram of 9) question. (5 Marks)
5) Draw a level 1 DFD based on the level 0 DFD.
5-a) Sale Process (5 Marks)
5-b) Production Process (5 Marks)
5-c) Purchase and Expense Cycle (5 Marks)
5-d) Payroll Cycle (5 Marks)
5-e) Composition (5 Marks)
SPA232 Accounting information system