HomeworkLib
Question

Please input answers as excel formula (for example d27 is = h6) and make explanations legible.

Project Description: In this problem, you will calculate the total economic profit for each of the two altematives and choose the best employment altemative. For the purpose of grading the project you are required to perform the following tasks Points Possible Instructions 1 Start Excel. , In cell D27, by using a cell reference, enter the annual salary under the Belle Touché option. Refer to an appropriate cell among H6-H10 3In cell E27, by using cell references, calculate the annual revenue under the Salon Volume option. Use cells H12-H14. 4 In cell D28, by using cell references, calculate the annual tips under the Belle Touché option. Use cells H7 and HS 5In cell E28, by using cell references, calculate the annual tips under the Salon Volume option. Use cells H21 and E27. .1 In cells D29 and E29, do the following: By using cell references, calculate the annual interest received. Use appropriate cells among H6-H10 and H12-H25, if any. Enter zero into the corresponding answer cell if there is no interest received for any of the options. Note: Do not use the equal sign when entering a numeric value.

In cells D30 and E30, do the following: By using cell references, calculate the annual value of leisure time. Use appropriate cells among H6-H10, and H12-H25, if any Enter zero into the corresponding answer cell if there is no value of leisure time for any of the options. Note: Do not use the equal sign when entering a numeric value. In cell D31, by using cell references, calculate the total economic benefit. Use cells D27-D30. Use the Excel SUM function. Copy the formula from cell D31 across column E. In cells D32 and E32, do the following: By using cell references, enter the annual one-time expenses. Use appropriate cells among H6-HI0, and H12-H25, if any Enter zero into the corresponding answer cell if there are no one-time expenses for any of the options. Note: Do not use the equal sign when entering a numeric value. n cells D33 and E33, do the following: By using cell references, enter annual rental expenses. Use appropriate cells among H6-H10 and H12-H25, if any. Enter zero into the corresponding answer cell if there are no rental expenses for any of the options. Note: Do not use the equal sign when entering a numeric value. 10

In cells D34 and E34, do the following: By using cell references, calculate the total annual amount of regular monthly expenses. Use appropriate cells among H10 and H12-H25, if any. H6- Enter zero into the corresponding answer cell if there are no monthly expenses for any of the options Note: Do not use the equal sign when entering a numeric value. In cells D35 and E35, do the following: By using cell references, calculate the annual cancellation expenses. Use appropriate cells among H6-H10, H22-H25, and D27-E28, if any. Enter zero into the corresponding answer cell if there are no cancellation expenses for any of the options. Note: Do not use the equal sign when entering a numeric value. In cell D36, by using cell references, calculate the annual total economic cost. Use cells D32-D35. Use the Excel SUM function. Copy the formula from cell D36 across column E In cell D37, by using cell references, calculate the annual total economic profit. Use cells D31 and D36. Copy the formula from cell D37 across column E. 13 L4 15In cell D39, determine which option should be chosen based on the annual total economic profift. 16 Save the workbook Close the workbook and then esit Excel. Submit the workbook as directed

Economic Profit Problem 2 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 Touché, an Aveda Salon and Spa in Sioux City, for $70,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 Kristens supplies and equipment but she would need to put 15% of her tips each day into tipshare for the front desk and clean-up employees. Tips are estimated at S25,000 per year Kristen also is considering using her $8,500 savings to be her own boss so she can work less and more flexible hours. For $120 per week (S6,240 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 hours per week on other business duties (scheduling, bookkeeping, cleaning, purchasing, etc.) for 50 weeks of the year. Tips average 20% of the cost of services and the cancellation rate is 7%. Kristens estimated costs are detailed below Massage Table: $1,000 (one time expense) Lotions, Oils, Linens, Candles, and Other Supplies: $200 per month Remaining on her Parents Health Insurance (she is only 20): S150 per month Advertising: $40 per month Liability Insurance: S55 per month If Kristen takes the job at Belle Touche, she will be able to earn 4% 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 $15 per hour Calculate Kristens annual economic profit for each alternative using the template provided. (Please note, each cell may not have an entry for both options.) All relevant values are gathered below

Belle Touché $70,000 $25,000 % of Tips Needed to Put into Tipshare for the Front Desk and Clean-up Employees 15% Savings Amount Interest on Savings Account $8,500 Salon Volume $65 25 50 $6,240 $1,000 $200 $150 Charges for One Hour of Massage Hours of Massage per week Working Weeks in a year Rental Expenses Cost of a Massage Table Lotions, Oils, Linens, Candles, and Other Supplies Expenses per month Remaining on her Parents Health Insurance Expenses per month Advertising Expenses per month Liabilty Insurance Expenses per month Tips as a Percentage of the Cost of Services Cancellation Rate Value of Leisure per hour Additional Leisure Hours per wee!k Number of months per year ear $55 20% $15 10 12

Belle Touché Salon Vohume Salay Total Revenue Kristens Tips Interest Received Value of Leisure Time Total Economic Benefit One-Time Expenses Rental Expenses Total Monthly Expenses Cancellation Expenses Total Economic Cost Total Economic Profit Which option should she choose based on her economic profit? should be chosen based on the economic profit.

business   economics   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Based on Economic profit salon option should be chosen

Salary/Total Revenue 70000 81250
Kristen's tip 21250 16250
interest received 340
Value of leisure time 7500
Total economic benefit 91590 105000
One Time expenses 1000
Rental expenses 6240
Total monthly expenses 445
Cancellation expenses 5687.5
Total economic cost 13372.5
Total economic profit 91590 91627.5
0 0
Add a comment
Know the answer?
Add Answer to:
Please input answers as excel formula (for example d27 is = h6) and make explanations legible....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Please follow directions and make explanations legible. Project Description: In this problem, you will calculate the...

    Please follow directions and make explanations legible. Project Description: In this problem, you will calculate the total economic profit for each of the two altematives and choose the best employment altemative. For the purpose of grading the project you are required to perform the following tasks Points Possible Instructions 1 Start Excel. , In cell D27, by using a cell reference, enter the annual salary under the Belle Touché option. Refer to an appropriate cell among H6-H10 3In cell E27,...

  • Kristen Larson just graduated at the top of her massage class from the Aveda Institute in...

    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 Touché, an Aveda Salon and Spa in Sioux City, for $60,000 dollars (including salary and...

  • Please type the formula of how do you get the answer, For example, D16=E2*D3 Thank you...

    Please type the formula of how do you get the answer, For example, D16=E2*D3 Thank you J35 1 x ✓ fx ADVANCED PROBLEM 6-2 FOR SPREADSHEET APPLICATION Callable bond and call premium. Edward has just purchased a callable bond and wants to determine the bond's potential payoff price if it is called at any time during its callable life. The callable bond is a twenty-year semiannual bond that an issuer can call starting at year ten. It is callable every...

  • Please answer in excel formula format. This is the full question with all the information. Bill...

    Please answer in excel formula format. This is the full question with all the information. Bill Clinton reportedly was paid $15 million to write his book My L . Suppose the book took three years to write. In the time he spent writing, Clinton could have been paid to make speeches. Given his popularity, aume that he could earn $8 million per year (paid at the end of the year) speaking instead of writing. Awame his cost of capital is...

  • PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS...

    PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 Chocolates by Jacki has provided information relating to its current year. The Controller has asked you to complete a First-Stage Allocation to Activity Cost Pools....

  • NOTE PLEASE ALL ANSWERS MUST BE IN EXCEL FORMULA. X 5 ? X . HOME Calculating...

    NOTE PLEASE ALL ANSWERS MUST BE IN EXCEL FORMULA. X 5 ? X . HOME Calculating yield to maturity - Excel FORMULAS DATA REVIEW - Sign In FILE INSERT PAGE LAYOUT VIEW Paste B I U- - - A Alignment Number 8.12 oints Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font Skipped D17 А в E F G H I к eBook Print A Japanese company has a bond outstanding that sells for 91.53 percent of...

  • Please use the excel cells provided. HI A B Problem 9-17 One year ago, your company...

    Please use the excel cells provided. HI A B Problem 9-17 One year ago, your company purchased a machine used in manufacturing for $110,000. You have leamed that a new machine is available that offers many advantages and you can purchase it for $ 150,000 today. It will be depreciated on a straight-line basis over 10 years and has no salvage value. You expect that the new machine will produce a gross margin (revenues minus operating expenses other than depreciation)...

  • PLEASE WITH EXCEL MICROSOFT PROGRAM!!!!!!! Objective: This activity has the purpose of helping students calculate the...

    PLEASE WITH EXCEL MICROSOFT PROGRAM!!!!!!! Objective: This activity has the purpose of helping students calculate the benefit - cost ratio of each alternative and select the best alternative using the software Microsoft Excel. (Objective 4) Student Instructions: Read example to be used to compute the Benefit - Cost ratio. Textbook problem 10 - 4 (Sullivan W., Wicks E., and Patrick C.), page 468: A retrofitted space- heating system is being considered for a small office building. The system can be...

  • I need this answered in Microsoft Excel please GBCoffee Budget Project The GBCoffee Company roasts and...

    I need this answered in Microsoft Excel please GBCoffee Budget Project The GBCoffee Company roasts and sells high quality certified sustainable coffee beans. The final one pound bags of roasted whole coffee beans has two direct materials – coffee beans and packaging. GBCoffee is preparing budgets for the fourth quarter ending December 31, 2019. For each requirement below prepare budgets by month for October, November, and December, and a total budget for the quarter. 1. The previous year’s sales for...

  • You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts

    EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.6 Project Description:You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your new position, you have decided to compile a report that details all aspects of the business, including: employee tax withholding, facility management, sales data, and product inventory. To complete the task, you will duplicate existing formatting, utilize various conditional logic functions, complete an amortization table with financial functions, visualize data with PivotTables, and lastly...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT