Accounting Excel Problems- Reports & Budgeting, accounting homework help
Accounting Excel Problems- Reports & Budgeting
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.
Present your analysis of the assigned problems in Excel format. Enter non-numerical responses in the same worksheet using textboxes. (Textbook problems & details are attached below).
| Assignment 3 Grading Criteria |
Maximum Points |
|
P20-21A: |
|
| 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 |
| Total: |
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"
