SOO Computer Store

Product Name Quantity in Stock Reorder Quantity Purchase Price Retail Value Order Needed Purchase Value Retail Value Profit

Asus Vivobook i$5$ laptop $204$ $$500\mathrm{.}00$ $$800\mathrm{.}00$ Yes $$10,000\mathrm{.}00$ $$16,000\mathrm{.}00$ $$6,000\mathrm{.}00$

Acer Aspire $315$ Laptop $154$ $$600\mathrm{.}00$ $$950\mathrm{.}00$ Yes $$9,000\mathrm{.}00$ $$14,250\mathrm{.}00$ $$5,250\mathrm{.}00$

Dell i$515$ series laptop $155$ $$650\mathrm{.}00$ $$1,000\mathrm{.}00$ Yes $$9,750\mathrm{.}00$ $$15,000\mathrm{.}00$ $$5,250\mathrm{.}00$

Dell mouse and keyboard combo $205$ $$35\mathrm{.}00$ $$50\mathrm{.}00$ Yes $$700\mathrm{.}00$ $$1,000\mathrm{.}00$ $$300\mathrm{.}00$

Dell $22$'inch monitors $104$ $$60\mathrm{.}00$ $$100\mathrm{.}00$ Yes $$600\mathrm{.}00$ $$1,000\mathrm{.}00$ $$400\mathrm{.}00$

Dell $24$'inch monitors $104$ $$80\mathrm{.}00$ $$150\mathrm{.}00$ Yes $$800\mathrm{.}00$ $$1,500\mathrm{.}00$ $$700\mathrm{.}00$

HP laser printer $101$ $$200\mathrm{.}00$ $$300\mathrm{.}00$ Yes $$2,000\mathrm{.}00$ $$3,000\mathrm{.}00$ $$1,000\mathrm{.}00$

WD $1$TB SSD $100$ $$50\mathrm{.}00$ $$80\mathrm{.}00$ No $$500\mathrm{.}00$ $$800\mathrm{.}00$ $$300\mathrm{.}00$

Logitech HD Webcam $201$ $$30\mathrm{.}00$ $$50\mathrm{.}00$ Yes $$600\mathrm{.}00$ $$1,000\mathrm{.}00$ $$400\mathrm{.}00$

Spare HDMI and Power Cables $505$ $$10\mathrm{.}00$ $$25\mathrm{.}00$ Yes $$500\mathrm{.}00$ $$1,250\mathrm{.}00$ $$750\mathrm{.}00$

Total Stock $180$

Total Purchase $$2,215\mathrm{.}00$ $$3,505\mathrm{.}00$ $$34,450\mathrm{.}00$ $$54,800\mathrm{.}00$ $$20,350\mathrm{.}00$

Employee List

Employee ID Employee Name Hourly Wage Fedral Tax Pension Plan Parking Fees

SCS$001$ Breton $$20\mathrm{.}0012\%5\mathrm{.}05\%$ $$20\mathrm{.}00$

SCS$002$ Catherine $$21\mathrm{.}0013\%5\mathrm{.}85\%$ $$20\mathrm{.}00$

SCS$003$ Brian $$20\mathrm{.}0012\%5\mathrm{.}05\%$ $$20\mathrm{.}00$

SCS$004$ Tilley $$19\mathrm{.}0011\%5\%$ $$20\mathrm{.}00$

SCS$005$ Surender $$18\mathrm{.}0010\%5\%$ $$20\mathrm{.}00$

SCS$006$ Honey $$23\mathrm{.}0015\%6\%$ $$20\mathrm{.}00$

SCS$007$ Jhonson $$22\mathrm{.}0014\%5\mathrm{.}95\%$ $$20\mathrm{.}00$

SCS$008$ Badu $$22\mathrm{.}0014\%5\mathrm{.}95\%$ $$20\mathrm{.}00$

SCS$009$ Ahmed $$21\mathrm{.}0013\%5\mathrm{.}85\%$ $$20\mathrm{.}00$

SCS$010$ Shinaj $$20\mathrm{.}0012\%5\mathrm{.}05\%$ $$20\mathrm{.}00$

Payroll $($Biweekly$)$

Employee ID Hours worked Overtime Hours Overtime Rate Gross Pay Deductions Net Pay

SCS$001855$ $$30\mathrm{.}00$ $$1,750\mathrm{.}00$ $$318\mathrm{.}38$ $$1,431\mathrm{.}63$

SCS$002800$ $$31\mathrm{.}50$ $$1,680\mathrm{.}00$ $$336\mathrm{.}68$ $$1,343\mathrm{.}32$

SCS$0039010$ $$30\mathrm{.}00$ $$1,900\mathrm{.}00$ $$343\mathrm{.}95$ $$1,556\mathrm{.}05$

SCS$00410020$ $$28\mathrm{.}50$ $$2,090\mathrm{.}00$ $$354\mathrm{.}40$ $$1,735\mathrm{.}60$

SCS$0059515$ $$27\mathrm{.}00$ $$1,845\mathrm{.}00$ $$296\mathrm{.}75$ $$1,548\mathrm{.}25$

SCS$006855$ $$34\mathrm{.}50$ $$2,012\mathrm{.}50$ $$442\mathrm{.}63$ $$1,569\mathrm{.}88$

SCS$007800$ $$33\mathrm{.}00$ $$1,760\mathrm{.}00$ $$371\mathrm{.}12$ $$1,388\mathrm{.}88$

SCS$0089010$ $$33\mathrm{.}00$ $$2,090\mathrm{.}00$ $$436\mathrm{.}96$ $$1,653\mathrm{.}05$

SCS$0099515$ $$31\mathrm{.}50$ $$2,152\mathrm{.}50$ $$425\mathrm{.}75$ $$1,726\mathrm{.}75$

SCS$010800$ $$30\mathrm{.}00$ $$1,600\mathrm{.}00$ $$292\mathrm{.}80$ $$1,307\mathrm{.}20$

with the above data create a balance sheet