Write a brief report to julie and katy

Assignment Help Accounting Basics
Reference no: EM131377743

Task - 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.

As at the 1st June, Julie Jones and Katy Perry establish a new businessJK Café &Catering (a partnership with 50% equal share in profits to both regardless of Proprietor's Contribution). They register the new business and open a new bank account with the local branch of Eastside Bank. Note the business is also registered for GST.

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.rar

Verified Expert

The paper talks about accounting aspects. Coffee stores accounting for the month has been prepared in this paper. Journal ledger trail balance income statement balance sheet various other register have been prepared herewith.

Reference no: EM131377743

Questions Cloud

Estimate the viscosity of this oil in micro reyns at 180°f : The specific gravity of an oil at 60°F is 0.887. The oil has a viscosity of 65 SUS at 210°F and a viscosity of 550 SUS at 100°F. Estimate the viscosity of this oil in micro reyns at 180°F.
Identify volcanoes or cluster of volcanoes that are hot spot : Identify two volcanic ranges that are on a subduction zone (other than the Cascades). Identify two volcanoes or clusters of volcanoes that are hot spots.
Review the information on pendleton act of 1883 : From the weekly readings, review the types of budgets presented, and respond to the following scenario: A friend who is a city manager once commented that he liked to put a so-called "radio" item within each budget-an item that would make a lot o..
Explain why erp systems include crm and scm components : Be sure to also explain why ERP systems include CRM and SCM components, and the advantages the company can gain by implementing all of the components for a connected corporation.
Write a brief report to julie and katy : ACC506 - Write a brief report to Julie and Katy commenting on the financial performance of the business and calculate and provide a cash flow statement for the first month of trading.
Define a way that you can revamp or reinvent your business : Netflix's business is video rental, but it used technology to revamp its supply chain to completely disrupt the entire video rental industry.- Define a way that you can revamp or reinvent your business using supply chain technologies.
Give the answer of muliple choice question : Alejandro Martinez is responsible for setting up the pay structure for his company. He believes that newly hired employees should not be paid as much as established employees. Accordingly, what type of pay structure should Mr. Martinez use?
Strategies you recommend to help business continue working : What strategies do you recommend to help the business continue working while the supply chain is disrupted by the strike?
How could customers hurt or help your business : How could customers hurt or help your business? Will your employees agree that customers are the most important part of the business?

Reviews

inf1377743

2/6/2017 3:36:56 AM

I simply needed to accept the open door to thank you at the end of the day for you diligent work on the paper. Additionally, thank you for noting my inquiries. I needed to ensure that I didn't miss a concealed social evaluate or some likeness thereof in the assignment, which the inquiry suggested. Thanks.

inf1377743

2/6/2017 3:35:51 AM

Writing Guide and requirement 20856365_1Full WRITING GUIDE.pdf 20856359_1Abbr WRITING GUIDE.pdf 20856356_1Quality Checklist.docx Please understand that I've depended on you for my Term assignments, I have already asked for extension to our decided deadline of yesterday midnight. Rodger Mk 2 Samsang Riccardo Mk 3 See >> SL Invent << Tab.. Pink colour tab 30-Jun Item Number Item On Hand $ 101501 Rodger Mk 2 101502 Samsang 101503 Riccardo Mk 3 Total 0.00 G/Led 1030 Out of balance -

inf1377743

2/6/2017 3:33:07 AM

? Katyprovided catering services for Sippy Animal Rescue on credit and invoiced them for $330.00 - invoice # JKCC0003. A new policy offering discounts for early payment has been implemented – 2/7, n/30.(Don’t forger Subsidiary ledgers) ? The café has revenue from daily sales of $4,400.00 Julie and Katy bank $2,400.00 and keep $1000.00 each as drawings. ? Paid half of the amount owing to Coco Suppliers using Cheque # 0006 ? Employed new staff (Herbert Smith & Vera Smith) to be paid later in the month. Mon Tue Wed Thu Fri Sat Sun 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 SECOND WEEK Julie and Katy recognise that there is a market for the sales of gourmetcoffee productsand coffee machines through their café. They have been advised to split the gourmet products into three categories and use a periodic inventory system on a First in First out (FIFO) basis. The coffee machines will use a perpetual inventory system on a weighted average basis.

inf1377743

2/6/2017 3:32:33 AM

Julie phoned Your Insurance Ltd and arranged for insurance of the new business and paid for oneyear’s coverage drew a cheque # 0004 amount $1,372.80. Purchased general supplies of $110.00 on credit from Coco Supplierswho offer no discounts for early payment. (Don’t forget subsidiary ledger) • Tuesday 2nd June ? Katy drew a cheque # 0005 and paid (Use your own name) $440.00 rent for the first week. ? Katyprovided catering services for Monty’s Cars on credit and invoiced them for $880.00 - invoice # JKCC0001. A new policy offering discounts for early payment has been implemented – 2/7, n/30.(Don’t forger Subsidiary ledgers) • Wednesday 3rd June ? Katyprovided catering services for Sunshine Hospital on credit and invoiced them for $770.00 - invoice # JKCC0002. A new policy offering discounts for early payment has been implemented – 2/7, n/30.(Don’t forger Subsidiary ledgers)

inf1377743

2/6/2017 3:30:03 AM

FIRST WEEK • Monday 1sth June ? Julie deposits cash of $15,000 into the new Bank Account and Katy contributes $2,000 cash and: • Café equipment with a book value of $7,200 • China glass silver and linen book value of $3,600 • Office Equipment book value of $2,200. Asset Method Expected Life Expected Salvage Café Equipment Straight Line 4 Years $0.00 China Glass silver Linen Straight Line 2 Years $0.00 Office Equipment Reducing Balance 3 Years $5.00 (Note as the equipment, china glass silver linen and office equipment have been used in a previous business there is no GST attributed to the contribution). Purchased $1,100 worth of General Café Supplies from Coco Suppliers – issued cheque # 0001. (Asset: 1010) Purchased a computer for $440 – issued cheque #0002. (Office Equipment) Withdrew $50.00 cash from an ATM to establish a petty cash account. (No GST for this transaction) Katy has the telephone installed by Rossini Communications - the contract is for a monthly line rental of $44.00 plus charges for calls made. Cheque # 0003for $132.00 is issued.

inf1377743

2/6/2017 3:29:27 AM

This assignment must be your own individual work, i.e. it is not a group assignment. If it is believed that a student has copied material from another student or any other source without appropriate referencing, the necessary action will be taken under the University’s Student Academic Integrity - Governing Policy: (http://www.usc.edu.au/explore/policies-and-procedures/student-academic-integritygoverning-policy). Please contact your local campus lecturer/tutor if you have any queries. Alternatively, you can post your query to the Discussion Board on the course Blackboard site. Mon Tue Wed Thu Fri Sat Sun 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Note Well: You are to record the transactions from week 1 that you did in Task 2 Part Aplus the rest of the month of Juneusing special journals and running balance accounts instead of the General Journal and “T” account format you used in Part A. The month of June is shown in the calendar above. When you are using the special journals you do not use the General Journal as well! Just the special Journals.

Write a Review

Accounting Basics Questions & Answers

  Company legal and financial responsibility

The extent of the company legal and financial responsibility for this accident, if any, can't be determined at this time.

  You are the beneficiary of a trust fund established by your

you are the beneficiary of a trust fund established by your aunt. your aunt has given you two options to choose from

  Create a tax plan for the future redemption

Create a tax plan for the future redemption of the client's stock owned in the constructioncompany that will not be taxed according to Section 301 of the IRC.

  Frank smith plumbing

Analyzethe case study, "Frank Smith Plumbing." Analyze the "Frank Smith Plumbing's Financial Statement" spreadsheet. Comparethe cost of the truck to the cash flow records

  Describe three issuesproblems that a company could

describe three issuesproblems that a company could encounter when trying to determine the actual cost of a good or

  New equipment after the exchange

Koch exchanges business equipment with an adjusted basis of $40,000 for business equipment with a fair market value of $65,000. If the exchange qualifies for like-kind exchange treatment, what is Koch's adjusted basis for the new equipment after t..

  The-mark construction began operations on december 1 in

on-the-mark construction began operations on december 1. in setting up its accounting procedures the company decided to

  The company engaged in the following stock

Included in the December 31, 2012, Jacobi Company balance sheet was the following shareholders' equity section:

  Find the systematic offset voltage

Find the systematic offset voltage that will appear at the output. (Use the results of Example 9.6.) Assuming that the open-loop gain will remain approximately unchanged from the value found in Example 9.6, find the corresponding value of input of..

  Performance measurement methods

Performance Measurement Methods - Many managers assume that numbers do not lie but, when measuring performance, they often do not tell the whole story

  Page analysis on the projected return on investment

Develop a three to five page analysis on the projected return on investment for your college education and projected future employment. This analysis will consist of two parts.

  Information about project plan

An auto plant costs $100 million to build but can produce a new line of cars that will produce cash flows with a present value of $140 million if the line is successful. Illustrate the option to abandon in (b) using a decision tree.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd