preview

Questions On A Company Accountant Design Spreadsheets

Satisfactory Essays
Index Numbers Question Attempted Or Not Page No. Q.1 Attempted 2
Q.2 Attempted 2
Q.3 Attempted 3
Q.4 Attempted 4
Q.5 Attempted 4
Q.6 Attempted 5
Q.7 Attempted 5
Q.8 Attempted 8
Q.9 Attempted 12
Q.10 Attempted 13
Q.11 Attempted 14
Q.12 Attempted 17
Q.13 Attempted 18
Q.14 Attempted 19
Q.15 Attempted 20
Q.16 Attempted 21
Q.17 Attempted 21
Q.18 Attempted 23
Q.19 Attempted 23
Q.20 Attempted 24
References 27

The assignment work submitted by my own and the sources which I used have been acknowledged in the reference list.

Q.1

Q.2
We can do it by go to menu bar in format cells and select currency and then change in numbers

Q.3
In a company accountant design spreadsheets with separate data entry area for further use of data
…show more content…
The essential difference between this inventories systems are following as under.

 The periodic inventory system is generally used for inexpensive goods, while perpetual inventory system is a computerized record of inventory used for expensive goods and by large store.
 Under the periodic inventory business physically counts its inventory periodically to determine the quantities on hand, while under the perpetual system the number of inventory units and dollar amounts are constantly updated.
 In the periodic system the cash register does not keep each & every item that it sells. While in a perpetual system the cash register is a computer terminal that records sales, updates inventory and GST records.
 The small retail stores and restaurants mostly use the periodic system. For example, local restaurants and ice-cream and grocery shops, while large stores, malls and supermarkets use the perpetual inventory system by bar codes to keep up-to-the minute records of their current inventory. For example, Coles and Woolworths supermarkets.
Horngren/Accounting/7e,2013

Q.7
Purchase
Under the Periodic System the journal entry appears like DR: Purchases 700,000 CR: Cash or Accounts
Get Access