1. (50 points) Sydney's Spokes is a local bike shop. Sydney has 5 employees. The business does quite well; a favorite in the community. Using the information provided below, prepare the weekly payroll for Sydney's Spokes. Sydney pays 150% for hours worked beyond 40 in a week Sydney matches any IRA and Health Insurance payments made by her employees. The Social Security/Medicare rate is 7.65%. The State Unemployment Tax rate is 1.5%. The Federal Unemployment Tax rate is 0.5% She withholds amounts for federal income tax, as shown above. a. What is the total amount earned by the employees (gross pay)? b. How much will she pay to her employees (net pay)? c. What is the total cost of the payroll to her business? 2. (50 points) Using information provided below and the 2020 balance sheet and income statement for Sydney's Spokes on the following pages, determine the amount of a) excise tax, b) property tax and c) self-employment tax due as a result of the year's business. Excise tax rate: 2% Property tax rate: 1.5% of property, not including resale (baking) inventory. Self-employment tax rate: 15.3% \begin{tabular}{|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Sydney's Spokes } & & \\ \hline \multicolumn{2}{|c|}{ Balance Sheet } & & \\ \hline \multicolumn{2}{|c|}{ December 31, 2020} & & \\ \hline \multicolumn{4}{|l|}{ Assets: } \\ \hline \multicolumn{4}{|l|}{ Current Assets: } \\ \hline Cash & 6,800 & & \\ \hline Bike Inventory & 14,000 & & \\ \hline Supplies & 1,400 & & \\ \hline Total Current Assets & & 22,200 & \\ \hline \multicolumn{4}{|l|}{ Fixed Assets: } \\ \hline Computers & 2,000 & & \\ \hline Furniture & 2,000 & & \\ \hline Total Fixed Assets & & 4,000 & \\ \hline Total Assets & & & 26,200 \\ \hline \multicolumn{4}{|l|}{ Liabilities: } \\ \hline \multicolumn{4}{|l|}{ Currnt Liabilities: } \\ \hline Accounts Payable & 800 & & \\ \hline Wages Payable & 1,200 & & \\ \hline Total Current Liabilities & & 2,000 & \\ \hline \multicolumn{4}{|l|}{ Long-term Liabilities: } \\ \hline Bank Loan & 5,000 & & \\ \hline Total Long-term Liabilities & & 5,000 & \\ \hline Total Liabilities & & & 7,000 \\ \hline Equity & & & 19,200 \\ \hline Total Liabilities \& Equity & & & 26,200 \\ \hline \end{tabular} 3. Sydney wants to adda new bike line to her shop. The bikes will cost her $100 apiece. She is allocating 20% of the fixed costs listed above (wages, utilities, advertising, and insurance) to the new product. a. If she sells the new bikes for $175 each, how many must she sell in a year to break even? b. If she expects to sell 30 of the new bikes each year, how much must she charge for each bike to break-even? c. She believes it is important for her to achieve a net profit percentage of 20% on the new bike sales. If she sells them at the $175 price, how many must she sell to achieve a net profit of 20% on the sale of the new bike line