Excel Document

Sheet1

Klapore Engineering
Salary Report
Employee	Email Address	Dependants	Hours Worked	Hourly Pay Rate	Gross Pay	Federal Tax	State Tax	Net Pay	Hire Date
Alton, Bob	balton@ms.com	3	74.5	35.25	$ 2,626.13	$ 2,626.13	$ 131.31	$ 2,232.21	9/5/10
Fox, Linda	lfox@ms.com	1	80	33.1	$ 2,648.00	$ 264.80	$ 132.40	$ 2,250.80	10/17/2012
Handfield, Jermaine	mhandfield@ms.com	0	71.75	28.65	$ 2,055.64	$ 205.56	$ 102.78	$ 1,747.29	1/15/16
Jamie, Ben	bjamme@ms.com	2	60	18	$ 1,080.00	$ 108.00	$ 54.00	$ 918.00	5/18/2012
Nacht, Savannah	snacht@ms.com	1	42.25	25.9	$ 1,094.27	$ 109.43	$ 54.71	$ 930.13	5/24/13

Klapore Engineering

mailto:balton@ms.com

Sheet1

Manola Department Stores, Inc.
Six-Month Financial Projection
	January	February	March	April	May	June	Total
Revenue	$ 1,475,000.00	$ 1,406,000.00	$ 1,116,600.00	$ 1,496,000.00	$ 1,102,900.00	$ 1,455,000.00	$ 8,051,500.00
Cost of Goods Sold	$ 206,718.75	$ 263,437.60	$ 222,487.60	$ 290,875.00	$ 206,793.75	$ 214,743.76	$ 1,405,056.46
Gross Margin	$ 1,268,281.25	$ 1,142,562.40	$ 894,112.40	$ 1,205,125.00	$ 896,106.25	$ 1,240,256.24	$ 6,646,443.54
Expenses							$ - 0
Bonus	$ 7,500.00	$ 7,500.00	$ - 0	$ 7,500.00	$ - 0	$ - 0	$ 22,500.00
Salary	$ 367,426.00	$ 351,210.00	$ 296,650.00	$ 374,500.00	$ 276,725.00	$ 286,265.00	$ 1,952,776.00
Bonus	$ 7,500.00	$ 7,500.00	$ - 0	$ 7,500.00	$ - 0	$ - 0	$ 22,500.00
Site Rental	$ 147,650.00	140.600.00	$ 118,660.00	$ 149,000.00	$ 110,290.00	$ 114,500.00	$ 640,100.00
Marketing	$ 1,447.50	$ 49,175.00	$ 41,631.00	$ 82,430.00	$ 38,601.00	$ 40,065.50	$ 253,350.00
Miscellaneous	$ 1,467.50	$ 49,175.00	$ 41,631.00	$ 52,430.00	$ 36,601.50	$ 40,065.50	$ 221,370.50
Total Expenses	$ 525,491.00	$ 597,660.00	$ 498,572.00	$ 665,860.00	$ 462,217.50	$ 480,896.00	$ 3,230,696.50