Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

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:

m3_excel_problems_1.pdf

m3_excel_problems_2.pdf