Complete the attached EXCEL sheet using the information provided.

HOW DO I MAKE THE STORE A AND STORE B TABLE ON EXCEL AND WHAT DO I INPUT FOR EACH COLUMN

STORE A:

Gross sales

$285,700

Alterations and workroom costs

$2,500

Opening inventory at cost

$119,000

Closing Inventory at cost

$97,000

Purchases at cost

$102,000

Transportation

$3,000

Cash discounts

6.5%

General Overhead

$29,000

Advertising

$7,600

Payroll

$39,000

Rent

$17,000

Customer returns

$34,000

STORE B:

Profit

15%

Operating expenses

39%

Operating Expenses

$105,000

Gross Sales Customer Returns Net Sales Cost of Goods Sold Opening Inventory Net Purchases at cost Inward Freight Alterations & Workroom Costs Total Merchandise Handled at Cost Cash Discounts Closing Inventory at Cost Total Cost of Goods Sold Gross Margin Operating Expenses General Overhead Advertising Salaries Rent Total Operating Expenses Net Profit

Profit Factors Store A Store B Gross Sales Customer Returns Net Sales Cost of Goods Sold Opening Inventory Net Purchases at cost Inward Freight Alterations& Workroom Costs Total Merchandise Handled at Cost Cash Discounts Closing Inventory at Cost Total Cost of Goods Sold Gross Margin Operating Expenses General Overhead Advertisin Salaries Rent NS COGS OE Total Operating E enses Net Profit CASE #3