Reference no: EM132230474
These instructions should help you set up the linking required for your assignment
Question 1. The first step is to link the balances (even the zero ones) of all the general ledgers to the Live Trial Balance (LTB). Open the LTB worksheet and also a New Window (Go to view and New window May May ). Drag one LTB to the left and the other to the right. Change the Right one to General Ledgers worksheet.
a. Now go to cell C6 of the LTB and type = (equals) then click on cell G19 of the General Ledger and enter. The Balance of the debit Cash at bank Ledger should now be linked to the LTB.
b. Keep linking into the debit column down to and including Store Hire Gowns (cell G150 of GL to cell C16 of LTB.
c. Now we have a Credit account (contra Accum Dep Gowns so go to cell D17 of the LTB and link it to cell G163 of the General Ledgers
d. Continue down so that the balances of Debit ledgers and Credit ledgers are linked to the appropriate side of the LTB
Question 2. Recording Opening balances. This would usually be done using a big General journal entry but we will do it by simply by linking the values from the Chart.
a. Change the left screen from LTB to Chart. In Cash at Bank G/L put in the Date...Opening Balance....OB as shown in Figure 1. Link from cell E11 to Chart D13 and the balance should come across. Note that the LTB has gone out of balance :(:( and will stay out until the last opening balances is done .
Figure 1 Opening Balance
If you are not out of balance you have made a mistake so fix it please.
Question 3. Now we link the Values of our Special Journals to the Ledgers. On the Left hand window go to the Purchases Journal (PJ) worksheet. The Row 22 has the sums of all the columns F to J. To test this type in 55 in cell F9 :(:( and then 55 in cell J9 :):). You can see that they go down to Row 22 see Figure 2 that has had rows 11-18 hidden for this demonstration.
Figure 2 Purchases Journal linking
Those cells in row 22 (Yellow) have to be linked to the general ledgers listed in row 23 (Blue) to complete the Journal to ledger linking.
a. Checking row 23 you will see that Gowns Inventory is the lowest numerically G/l 1030 The next being office equipment 1520 so it is best if you link in that order and continue right through to the highest. It is not that important but it will really help.
b. You will see that in the PJ I have set up the details for posting in cells G3 to I3. You can copy and paste this label into cell B102 of the ledger Then in cell E102 type = and then go to cell G22 of the PJ and enter the link. Change the Blue colour to Pink to remind you it is posted Test that it goes from PJ to LTB by typing 66 in cell G9 of the PJ. Complete the PJ. Take out the test figures you used.
Question 4. Go through each of the journals posting the Yellow to the ledgers changing the Blue to pink as you go.
|
Discussion about the social policy
: In addition to a minimum of eight scholarly references, which may include electronic government documents and reputable websites, your paper should include.
|
|
How would you address the crisis that eboni is experiencing
: As Eboni's social worker, would you include spirituality and religion in your initial assessment? Why or why not? How would you address the crisis that Eboni.
|
|
Evaluating the relationships between variables
: Research studies often compare variables, conditions, times, and/or groups of participants to evaluate relationships between variables or differences.
|
|
Discuss why you may have developed any biases you may have
: Answer the following questions in your discussion answer: What were your IAT results? Why do you think you received these results?
|
|
General ledgers worksheet
: Recording Opening balances. This would usually be done using a big General journal entry but we will do it by simply by linking the values from the Chart
|
|
Identify the age group and developmental stage selected
: In your paper, clearly identify the age group and developmental stage selected. Describe the important physical, emotional, cognitive, and social features.
|
|
Compare the religious traditions of hinduism and buddhism
: Select two of the following elements and compare and contrast the religious traditions of Hinduism and Buddhism: Samsara/Nirvana.
|
|
Discuss the general foundational position of trait theory
: Discuss the general foundational position of trait theory and compare/contrast Cattell's and Eysenck's theories. Examine the assessments derived from each.
|
|
Describe how you would assess the problem orientation
: Describe how you would assess the problem orientation of the client in your selected case study (i.e., how the client perceives the problem).
|