# Part A  15 marks  Spreadsheet 1. Learning from assignment 1 and from your own experience,… 1 answer below »

Part A  15 marks  Spreadsheet

1. Learning from assignment 1 and from your own experience, describe three spreadsheet functions that you have used and found them useful. In your answers: Describe how each function is designed or formulated Use Excel spreadsheet to provide examples for each function. Show your demonstration in both normal and formula views with row and column headings. Explain why they are useful to you.

2. VLOOKUP function: Describe its purposes Demonstrate this function by using Excel spreadsheet. Show your demonstration in both normal and formula views with row and column headings.

Part B  25 marks  Inventory management

Bike World recently opened several stores in New South Wales. The owner is considering whether a perpetual or periodic inventory system should be used. The company also has an inventory of a bike model with details below:

Requirements: Explain the essential differences in accounting treatments between perpetual and periodic inventory systems. You have to use journal entries to demonstrate each difference. With the nature of Bike Worlds business, which system would you suggest to the owner? Why? (7 marks) Using a spreadsheet, calculate the ending inventory and Cost of Goods Sold for June, using the average cost, LIFO, and FIFO methods. Present your answers in both normal and formula views with rows and column headings. In the spreadsheet, you are required to have a data section separated from a report section. (10 marks) The company is not doing very well and the owner wants to call funds from potential investors. Based on all the above factors, what inventory method would you suggest to the owner, why? (8 marks)

Part C  20 marks  Bank reconciliation

You are preparing Great Foods financial reports for June 2018, and the 30 June 2018 bank statement has just arrived with the balance of \$30,800. Currently, Great Foods Cash account shows a balance of \$31,560.