Reference no: EM131372625
INSTRUCTIONS
Part Requirements:
Stage 1
Use the spreadsheet template provided to complete the following requirements.
When using the spreadsheet you are required to provide the links from the General Ledger Accounts to the Live Trial Balance.
1. Link the balances of the General Ledgers to the Live Trial Balance
2. Enter the transactions into the appropriate Special Journals.
3. Important: After each transaction that particular journal should be in balance. If it is not, fix it before recording the next transaction.
4. Do the Bank Reconciliation and enter transactions as required.
5. Post (Link) the transactions from the Special Journals to the appropriate General Ledger Accounts the balances of which should flow to the Live Trial Balance.
6. Important: Posting should be done from the total of each column unless recorded in "Other Account" column.
7. Important: Post the entire journal and check that the Live Trial Balance is in balance before moving to the other journals. If it is not in balance, fix it before moving on.
8. Copy the Live Trial Balance and create a Fixed Trial Balance using Special Paste Values into your worksheet.
9. Do the adjustments into and complete the worksheet
- Note well: the worksheet is a separate document. No linking is permitted from the worksheet to any of the financial statements. It is used as a checking mechanism that ensures your financial statements prepared in step 13 match the worksheet.
10. Journalise the adjustments in the General Journal and post to the General Ledgers. Check that the Live Trial Balance is in Balance before moving to the next transaction. If it is not in balance, fix it before moving on.
11. After all adjustments have been posted the Live trial Balance should be the same as the adjusted trial balance of the worksheet.
12. Copy the Live Trial Balance worksheet and create a Fixed Trial Balance worksheet using Special Paste Values into the worksheet.
13. Use the Fixed Trial balance to help you complete a Profit & Loss statement, Statement of Partners Equity and a Balance Sheet for month of trading.
Stage 2
Write a brief report to Julie and Katy commenting on the financial performance of the business:
- Calculate the following financial ratios and provide comments -
o Current ratio
Industry average is 5:1
Accounting Norm is 3:1
o Quick ratio
Industry average is 4 : 1
Accounting Norm is 1:1
- Calculate and provide a cash flow statement for the first month of trading.
- Using academic references (recorded using Harvard Referencing style) list and briefly explain the registrations and legal requirements that Julie and Katy would have undertaken to establish the business name and partnership.
Adjustments
1. Half of the General Café supplies have been used calculate and record the expense
2. Calculate the outstanding payroll liability
3. Calculate and record the insurance expense
4. Calculate and record the Telephone expense
5. Calculate and record the prepaid rent
6. Calculate and record the depreciation expense for the month
7. A stocktake of the products revealed that there were:
- 6 Highland
- 7 Lowland
- 16 Tea
Attachment:- Requirements ATMC.rar
Distinguish between class variables and instance variables
: Identify the similarities and differences between the Fox and Rabbit classes. Make separate lists of the fields, methods, and constructors, and distinguish between the class variables (static fields) and instance variables.
|
Write a research paper in which you address the retention
: Write a research paper in which you address the retention, separation, and discipline practices of a selected organization, based on information you have gathered and analyzed about the organization.
|
Confidence interval for probability of successfully fooling
: If, in 430 trials, the system was fooled 47 times, give a 95% confidence interval for p = probability of successfully fooling the machine.
|
Calculate and plot the mean and standard-deviation
: Calculate and plot the mean and standard-deviation data for the 20 new samples (Point-9 above) on the X-Bar and S charts using the control limits calculated for the population with the original (μ, σ) values (Point-7 above). Explain, in two or les..
|
Calculate and provide a cash flow statement
: Calculate the outstanding payroll liability - Calculate and record the insurance expense and calculate and record the Telephone expense - Journalise the adjustments in the General Journal and post to the General Ledgers.
|
Give a confidence interval
: Sony's new optical disk system prototype tested and claimed to be able to record an average of 1.2 hours of high-definition TV.- Assume n = 10 trials and σ = 0.2 hour. Give a 90% confidence interval.
|
How is customer-centric organization
: How is a customer-centric organization different from one that is product focused? How does customer centricity impact the areas of finance, human resources, information technology, marketing, research and development, operations, and sales.
|
Which methods are truly identical in fox and rabbit classes
: In reaching a conclusion, you might like to consider the effect of substituting the values of class variables into the bodies of the methods that use them.
|
Confidence interval for the average amount paid
: If this is based on a random sample of 500 customers with standard deviation = $800, give a 95% confidence interval for the average amount paid to any of the 7.6 million bank customers.
|