This mini case must be done in excel with calculation form
Fin 621-E1 due date 4/ 18/ 23 Kristen Larson just graduated at the top of her massage class from the Aveda Institute in Des Moines, IA. Her plan is to move to Sioux City, IA for at least 5 years so she can spend time with her elderly grandparents and gain experience before branching out into a top salon in a large city. Upon graduation, Kristen received a job offer from Belle Touche, an Aveda Salon and Spa in Sioux City, for $60,000 dollars (including salary and insurance). Kristen would have to work Tuesday through Saturday from 9am-6pm for 50 weeks out of the year. The salon would pay for all of Kristen's supplies and equipment, but she would need to put 20% of her tips each day into tipshare for the front desk and clean-up employees. Tips are estimated at $10,000 per year. Kristen also is considering using her $7500 savings to be her own boss, so she can work less ar more flexible hours. For $125 per week (6500 per year), she can rent a room at Salon Volume, but she would have to provide her own supplies, equipment, and insurance. She plans to schedule massages for 25 hours per week at an average rate of $65 per hour and spend 5 hour per week on other business duties (scheduling, bookkeeping, cleaning, purchasing, etc.) for 50 weeks of the year. Tips average 15% of the cost of services and the cancellation rate is 5%. Kristen's estimated costs are detailed below. -Massage Table: $1500 (onetime expense) -Lotions, Oils, Linens, Candles, and Other Supplies: $150 per month -Remaining on her Parent's Health Insurance (she is only 20): $100 per month -Advertising: $60 per month -Liability Insurance: $50 per month If Kristen takes the job at Belle Touche, she will be able to earn 2% interest, on the money in her savings account. If she decides to work for herself, she will have 10 more hours of leisure each week which she values at $20 per hour. Calculate Kristen's annual (1) accounting costs, (2) implicit costs, (3) economic cost, and (4) economic profit for each alternative. Which option should she choose? Why