In: Accounting
BeachTime Company uses a perpetual inventory system and both an accounts receivable and an accounts payable subsidiary ledger. Balances related to both the general ledger and the subsidiary ledger for the company are indicated in the working papers. Below are a series of transactions for BeachTime Co. for the month of January. Credit sales terms are 2/10, n/30. The cost of all merchandise sold was 57% of the sales price.
Instructions
|
(g) Calculate the following ratios. Include the written formula in words in addition to your calculations and your final answers:
1. Inventory Turnover
2. Days in Inventory
3. Gross Profit Rate
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | |||||||
Posted all journal. However since opening balance not given, Trial, Ledger adjusting entries etc are not possible |
Beach Time | ||||||
Sales Journal | |||||||
Date | Account Debited | Invoice no | Accounts Receivable Dr | Cost of Goods Sold Dr | |||
Sales cr | Inventory Cr | ||||||
Jan 3 | M Knast | 825 | $ 2,900 | $ 1,653 | |||
Jan 3 | C Ryder | 826 | $ 1,800 | $ 1,026 | |||
Jan 11 | D Ghallagher | 827 | $ 1,600 | $ 912 | |||
Jan 11 | V Arnold | 828 | $ 900 | $ 513 | |||
Jan 22 | M Knast | 829 | $ 2,700 | $ 1,539 | |||
Jan 22 | D Ghallagher | 830 | $ 1,300 | $ 741 | |||
Jan 25 | I Tan | 831 | $ 3,500 | $ 1,995 | |||
Jan 25 | C Ryder | 832 | $ 6,100 | $ 3,477 | |||
Total | $ 20,800 | $ 11,856 | |||||
Purchase Journal | |||||||
Date | Account | Date of Invoice | Terms | Debit Inventory Accounts Payable Cr |
|||
Jan 5 | R Drifter | n/30 | $ 5,000 | ||||
Jan 5 | N Sova | n/30 | $ 2,200 | ||||
Jan 16 | T Caper | n/30 | $ 18,000 | ||||
Jan 16 | K Xerxes | n/30 | $ 14,200 | ||||
Jan 16 | R Drifter | n/30 | $ 1,500 | ||||
Jan 27 | T Caper | n/30 | $ 14,500 | ||||
Jan 27 | N Sova | n/30 | $ 1,200 | ||||
Jan 27 | R Drifter | n/30 | $ 3,800 | ||||
Total | $ 60,400 | ||||||
Cash Receipt Journal | |||||||
Date | Account Credit | Cash Dr | Sales Discount Dr | Accounts Receivable Cr | Sales Cr | Other Account Cr | COGS Dr, Inv Cr |
Jan 7 | V Arnold | $ 4,000 | $ 4,000 | ||||
Jan 7 | I Tan | $ 2,000 | $ 2,000 | ||||
Jan 10 | Cash Sale | $ 15,500 | $ 15,500 | $ 8,835 | |||
Jan 13 | M Knast | $ 2,842 | $ 58 | $ 2,900 | |||
Jan 13 | C Ryder | $ 1,470 | $ 30 | $ 1,500 | |||
Jan 20 | Cash Sale | $ 20,100 | $ 20,100 | $ 11,457 | |||
Jan 21 | V Arnold | $ 882 | $ 18 | $ 900 | |||
Jan 31 | Cash Sale | $ 21,300 | $ 21,300 | $ 12,141 | |||
Total | $ 46,794 | $ 106 | $ 11,300 | $ 35,600 | $ - | $ 20,292 | |
Cash Disbursment Journal | |||||||
Date | Ck NO | Payee | Accounts Debited | Cash Cr | Inventory Dr | Other Account Dr | Accounts Payble Dr |
Jan 8 | Inventory | $ 235 | $ 235 | ||||
Jan 12 | Rent Expense | $ 1,000 | $ 1,000 | ||||
Jan 15 | J Sandy | J Sandy, Drawing | $ 800 | $ 800 | |||
Jan 17 | Office Supplies | $ 400 | $ 400 | ||||
Jan 23 | T Caper | T Caper | $ 18,000 | $ 18,000 | |||
Jan 23 | K Xerxes | K Xerxes | $ 13,750 | $ 13,750 | |||
Jan 28 | Office Supplies | $ 200 | $ 200 | ||||
Jan 31 | Salaries and Wages | $ 8,100 | $ 8,100 | ||||
Total | $ 42,485 | $ 235 | $ 10,500 | $ 31,750 | |||
General Journal | |||||||
Date | Account | Debit | Credit | ||||
Jan 9 | Sales Return and Allowance | $ 300 | |||||
Accounts Receivable | $ 300 | ||||||
Jan 18 | Accounts Payable | $ 450 | |||||
Inventory | $ 450 | ||||||
Jan 21 | Accounts Payable | $ 15,000 | |||||
Note Payable | $ 15,000 |