1. Business
  2. Accounting
  3. complete the attached excel sheet using the information provided how...

Question: complete the attached excel sheet using the information provided how...

Question details

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

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 #3Opening 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

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution