ACCOUNTING WORK FOR WAQAS1ACA ONLY
Assignment 3: Excel Problems
At the end of each module, you will apply the module’s concepts by completing comprehensive assignments from the textbook.
Complete problems P21-20A (p. 1121), P21-21A (p. 1122), and P21-22A (p.1123) in your textbook.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowPresent your analysis of the assigned problems in Excel format. Enter non-numerical responses in the same worksheet using textboxes.
If you need assistance with using Microsoft Excel, refer to the tutorials button above to find the Lynda.com section of tutorials. Search for Excel 2007 and Excel 2003 Essential Training.
By Wednesday, September 9, 2015 deliver your assignment to the M4: Assignment 3 Dropbox. Create the file with the following name: LastnameFirstInitial_M4A3.Excel.xls.
|
Assignment 3 Grading Criteria |
Maximum Points |
|
P21-20A: |
|
|
Prepared report for July 2011 which shows the performance of the Dayton store, the Ohio region and the company |
10 |
|
Explained and justified if would investigate the Dayton store on the basis of the report |
5 |
|
Explained if Doggy World should prepare a master budget and discussed the benefits of budgeting |
5 |
|
P21-21A: |
|
|
Prepared Clipboard Office Supply’s budgeted income statement for May and June |
10 |
|
P21-22A: |
|
|
Prepared schedules of budgeted cash collections, budgeted cash payments for purchases and budgeted cash payments for operating expenses |
10 |
|
Prepared a cash budget and identified the cash balance as of June 30, 2011 |
10 |
