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.
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:
50
Attachments:
5.docx