Book inventory Excel

Homework 10: Ch4

	Cost	Retail
Opening Inventory	$ 421,623.00	$754,156
Purchases	$ 356,213.00	$601,000
Freight	$ 9,120.00
Transfer Ins	$ 3,500.00	$6,420
Transfer Outs	$ 3,100.00	$6,120
Returns to Vendor	$ 14,350.00	$22,500
Gross Sales		$820,400
Customer Returns		$34,000
Markdowns		$89,100
Employee Discounts		$8,400
Alteration Costs		$300
Cash Discounts		$1,500

1- Calculate Maintained Markup% and Gross Margin% given the following figures:

2- Calculate Maintained Markup% and Gross Margin% given the following figures:

	COST	RETAIL
Opening Inventory	$60,000	$80,000
Gross Purchases	$45,000	$65,000
Returns to Vendor	$400	$800
Transfer Ins	$1,200	$2,500
Transfer Outs	$2,000	$2,100
Freight	$600
Markdowns		$6,000
Gross Sales		$65,000
Customer Returns		$8,000
Employee Discounts		$500
Cash Discounts		$1,000
Alteration Costs		$400

3- Calculate: (a) cumulative markup % (b) maintained markup % (c) gross margin %

Given: Cost Retail

Opening inventory $ 32,528 $ 51,800

Gross purchases 16,000 33,460

Returns to vendors 590 1,020

Transfers in 1,200 2,350

Transfers out 1,280 2,525

Freight 790

Markdowns 5,340

Gross sales 35,680

Customer returns 3,640

Employee discounts 250

Cash discounts $875

Alteration costs 150

4- Calculate: (a) cumulative markup %; (b) maintained markup %; (c) gross margin %

Given:

Cost Retail

Opening inventory $17,500 $51,000

Gross purchase $25,000 $63,500

Return to vendors $380 $535

Transfer in $1,250 $2,050

Transfer out $980 $1,730

Freight $650

Gross sales $81,500

Customer returns $2,000

Employee discounts $630

Markdowns $4,300

Cash discounts $1,050

Alteration costs $300