1. Create a trial balance for What SUP as of March 31, 2019

You are to create a trial balance in a format identical to that created in this chapter. Include a debit and credit column, totals for each column, and appropriate labels and formatting. Start with blank spreadsheet and once you have created the spreadsheet save the file as ch2-03_student_name (replacing student_name with your name). An alphabetical listingof account information as of March 31, 2019, follows.

Accounts payable ………………………………………………………..80,000.00

Accounts receivable ……………………………………………..………95,000.00

Accumulated depreciation: Building ………………………….........….60,000.00

Accumulated depreciation: Equipment …………………............……17,000.00

Advertising expense .........................................................................15,000.00

Building ..........................................................................................405,000.00

Cash ................................................................................................30,000.00

Common stock ..................................................................................1,000.00

Cost of goods sold ........................................................................345,000.00

Depreciation expense .......................................................................5,000.00

Equipment ......................................................................................98,000.00

Inventory ......................................................................................120,000.00

Land .............................................................................................115,000.00

Long-term debt ............................................................................500,000.00

Other expense .................................................................................4,000.00

Payroll expense ............................................................................72,000.00

Prepaid expenses .........................................................................14,000.00

Retained earnings ......................................................................135,000.00

Sales revenue ............................................................................550,000.00

Supplies .......................................................................................10,000.00

Utilities expense ..........................................................................15,000.00

a. Print the completed worksheet in Value view, with your name and date printed in the lower left footer and file name in the lower right footer.

b. Print the completed worksheet in Formula view, retaining gridlines and row and column headings, with your name and date printed in the lower left footer and file name in the lower right footer.

2. Modify What SUP Sales Worksheet

Using the student file Ch2-04.xlsx, add appropriate formulas to the exist-ing Fanatic SUP Sales worksheet to calculate price, total sales for each SUP for the week, and total sales for all Fanatic SUP. Complete this worksheet in a manner consistent with the Weekly Badfish SUP Sales worksheet completed in this chapter.

a. Print the completed worksheet in Value view, with gridlines and row and column headings and with your name and date printed in the lower left footer and file name in the lower right footer.

b. Print the completed worksheet in Formula view, retaining gridlines and row and column headings, with your name and date printed in the lower left footer and file name in the lower right footer.