$5\mathrm{.}2.$ Items Sold $$ Use Access and Excel to analyze the types of items sold by the grooming salon and make recommendations to the business owners based on your analysis.

a$.$ Answer similar types of questions as those suggested for services. Adjust accordingly for the differences between an item sold and a service rendered.

b$.$ Include calculations to summarize data and appropriate charts to display.

$5\mathrm{.}3.$ Personnel $$ Sarah currently works as many hours as needed, and takes a small weekly salary. Her goal is to eventually work full$-$time in the salon and make a full$-$time salary.

a$.$ Recognizing that it takes time for a business to build a clientele, discuss the current and projected income levels in terms of ability to support personnel costs.

b$.$ Make recommendations regarding appropriate staffing levels, both current and future.

$5\mathrm{.}4.$ Equipment $$ purchase consideration

a$.$ The grooming salon is in need of purchasing a new stainless steel bathing tub and two blow dryers, at an estimated total cost of $$2,500.$ Since Sarah does not have the capital to purchase the tub outright, she will have to finance the purchase. She tells you that she feels she can afford a monthly payment of no more than $$150.$

b$.$ Begin by researching small business equipment loan rates to get an idea of current rates and terms. Use Excel to calculate various possible rates$/$terms$/$payments$.$ Keep in mind that this is a new business with limited financial history, and has a credit score under $700$ so the business may not be eligible for all financing options.

c$.$ Compare the business equipment loan to the purchase of the equipment on a small business credit card. You will need to research current rates for small business credit cards.

d$.$ Calculate and present various payment options and make a recommendation as to which option you feel would make the most business sense. Give a justification$/$explanation for your recommendation, including interest considerations.