Reference no: EM132106903

Part A - Spreadsheet

1. Accountants often use accounting software for data management, why do they still use spreadsheets? What are the disadvantages of using spreadsheets?

2. In designing a spreadsheet, why should the report section be completely separated from the data section?

3. Use spreadsheets to demonstrate:
- IF functions,
- Negative numbers in brackets,
- Names to reference cells (e.g. Net Profit = Sales less Expenses).
Show your demonstration in both normal and formula views with row and column headings.(5 marks)

You are required to provide at least one reference from the reading resource in Interact2 and two other references.

Part B - Inventory management
Fashion Haven recently opened a retail clothing shop in Australia. The owner is considering whether a perpetual or periodic inventory system should be used. The company also has an item of inventory with details below:

Requirements: Write a business report (about 600 words) critically addressing the issues below:
- Explain the essential differences between perpetual and periodic inventory systems. With the nature of Fashion Haven's business, which system would you suggest to the owner? Why?
- Using a spreadsheet, calculate the Ending Inventory and Cost of Goods Sold for May, using the average cost, LIFO, and FIFO methods. Present your answers in both normal and formula views with rows and column headings.
- Taking into account the context of the firm's operation and the current purchase price, what method would you suggest to the owner, why?

Part C -Bank reconciliation

You are preparing Golf Club's financial reports for June 2017, and the 30 June 2017 bank statement has just arrived with the balance of $29,930. Currently, Golf Club's Cash account shows a balance of $30,690.

Additional information:

Requirements:
1. Suggest one item that can decrease the bank balance, and one item that can decrease the cash balance. The value for both items must be the same.
2. With the new balances, prepare Golf Club's Bank Reconciliation at 30 June 2017 from the above data. Provide your handwritten solution - scan or use your phone to copy and paste the image in your assignment. You can use a free scanning app such as Camscanner, OfficeLens, or Google Drive.
3. Record any required journal entries from the bank reconciliation.

Part D -Bad debt management and financial decision

Find the Coca-Cola Amatil Limited financial report

You are an investment advisor with accounting expertise. Write a business report, addressing issues below:
- What was the bad debt method that the company used? How much was their bad debt expense for the year 2017?
- Is there any other method of estimating bad debt? What are their differences?
- Analyse the company financial information through at least three ratios and two charts. For any ratios used, justify why these ratios are relevant to your analysis.
- Comment on the company report on sustainability.
- In your report, you have to provide your advice as to whether your client should invest in the company or not.

Presentation

You are required to provide a quality presentation of the total assignment including referencing throughout and bibliography. Details are listed under the presentation and spreadsheet requirement sections.

Attachment:- acc - assignment.rar