Question
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
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 #3Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started