I need help with this calculation.

Locate the shaded Goal Seek Step 14 area in the worksheet (starting in cell A 33). Read through the data in rows 34 and 35 to see that Holly has a salary of $1,234.00, the current Fed Tax % is blank, and there is a formula ( =B35 * C35) in cell D35 to calculate the amount of Fed Tax Holly needs to pay when you set the Tax Rate % in cell C35.

Use the goal seeking process to find what the Fed Tax % would be if Holly had to pay $502.00 in Federal Tax.

Correct any spelling or grammar errors (like capitalization) in the worksheet. (All words in the two title lines are spelled correctly.)

Change the name of the worksheet tab to Supplemental Problem (2 points).

Working with the cells in TOTAL SALES BY DEPARTMENT, place the appropriate type of chart, on its own chart sheet that shows the labels and percentages of each departments total sales compared to the 100% total of all for departments sales. Format your table so that information is logical and appropriately proportioned. Name your Chart tab.

LAZOR LECTRONICS STORE SALES
Payroll Information - Week 7
Department	Sales Rep	Weekly sales	Base Wages	Commission Wages	Gross Wages	Ferderal Tax	Net Pay
Stereo	Al	900	300
	Bill	1200	300
	Sam	1100	300
	Joe	1400	300
T.V.s	Holly	900	300
	Sue	2000	300
	George	400	300
	Mary	1000	300
CamCorders	Josie	3000	300
	Erika	200	300
	Amy	700	300
	Amanda	900	300
Compruters	Tim	1500	300
	JT	2500	300
	Bob	975	300
	Dave	990	300
Assumptions
Commission Rate =		20%	of all weekly sales greater than $1000
Fed Tax Rate=	28%
TOTAL AND AVERAGE SALES BY DEPARTMENT
Department	Total	Average
Stereo
T.V.s
Camcorder
Computers
Goal Seek Step 14
Sales Rep	Salary	Fed Tax %	Fed Tax Amount
Holly	$1,234.00		$ -