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: |
WhatsApp us