Multiple Problems

For Help with Multiple Homework Problems, Ask an Expert

Multiple Problems

# Data Analysis with Spreadsheets w/Lab(TCO 9, 2, 3, 7) You

Customer Question
3. (TCOs 1, 2, and...
3. (TCOs 1, 2, and 4) You currently volunteer at the local community center and have been asked to assist in the coordination of a fundraiser art show auction to benefit the center. You have been tasked with developing a spreadsheet to track the attendees and to calculate the associated cost. Each donor is allowed to bring one guest to the art show. There is capacity for 100 donors plus guest. The spreadsheet needs to be set up when the invitations are distributed so that you can begin recording the reservations as soon as they come in.

The cost of the art show auction is not the same for the donor and the guest. The charge for the donor is \$50, and the charge for a guest is \$45. When the donor responds that he or she plans to attend, you want to add his or her name to the list. If they do not plan to attend, then his or her name isXXXXX fully to the following questions regarding this task:
• A - (TCO 1) Explain how you will structure your worksheet, including the titles, column headings, the formulas to calculate the cost for each donor (which may include the cost for a guest, and to calculate the total cost for the art show auction).
• B - (TCO 2) The facility where the art show auction is to be held will give the company a reduction in price if more than 50 people attend. The price per donor will then be \$45 and per guest will be \$40. Describe how you will set up your worksheet to reflect a change when the total number of attendees hits 50.
• C - (TCO 4) You want the donors who are going to attend and bring a guest to show on the list with a green background. Explain the method you would use to have this automatically occur when you indicate the employee's response.
• D - (TCO 4) You know that the community cent management team will want to periodically check to see who is attending. They will want the list to separate the donors coming alone and those bringing guests. Explain how you might generate this list as requested using your knowledge of Excel.

4. (TCOs 1, 3, and 5) You have just been hired as a bookkeeper for South Beach Rentals. South Beach Rentals, rents beach chairs and umbrellas in sets in the Miami South Beach Area. There are several packages based on the size of the umbrella. The first package consists of two chairs and one regular size umbrella and rents for \$60 dollars for 4 hours or \$100 dollars for the day. The second package includes two chairs and larger umbrella and rents for \$75 dollars for 4 hours or \$125 for the full day. In addition you rent additional chairs for \$20 for 4 hours or \$35 for the day. These can be added to any package. The company offers these packages at three different beachfront hotels. Each hotel has a different charge for using the beachfront property as a rental facility. Hotel 1 charges a flat rate of \$100 a day, regardless of how much business you have. Hotel 2 charges \$5 per half-day rental and \$10 for a full day. Hotel 3 charges \$75 a day, regardless of how much business you have.

As the bookkeeper, you will be responsible for the financial records of the company. You will be recording the number of rentals, types of rentals, and charges for each location. Respond fully to the following questions regarding this task:
• A - (TCO 1) You have decided to develop a worksheet for each hotel site manager to submit each week. It should show total rentals and cost for the week. If the hotel costs exceed the rentals, this should appear on the spreadsheet as a loss and be formatted in red font.
• B - (TCO 5) The managers will e-mail their weekly reports to you on Monday of the following week. You will then produce the summary report. Explain the process for doing this. Give a sample formula to total the number of sales generated by the entire company in a week.
• C - (TCO 5) Each week, you will present the combined report to your boss, who wants to see both the summary and the individual sheets for each hotel location. You want to add a header with the date and your name to each page. What is the easiest way to do this? Explain the process.
• D - (TCO 3) Describe the chart that you would create to accompany the report in Part C. Include formatting considerations to make important facts stand out.

5. (TCOs 2 and 10) Investment and Savings Company presently employs you as a new account specialist. The bank has begun a new marketing campaign aimed at helping the customers grow their savings account balance. The goal of the campaign is to provide the customers with an importunity to have a dollar transferred into their savings for every transaction they complete. As a new account specialist you are dedicated in building long-term relationships with your clients, and you want to be able to answer their questions quickly if they call after receiving the promotional information.

You process new savings account requests for the customers. The interest rate is fixed by the bank, but varies based on the amount deposited. The interest is paid monthly. The biggest challenge you face is teaching customers the time value of money. Respond fully to the following questions regarding this task:
• A - (TCO 2) You have decided to create a spreadsheet that will show the customers how much value their money can earn over time. It is set up so that you enter the amount of deposit, and it finds and returns the correct interest rate. Based on this the spreadsheet, return the future value of the deposit amount and you are able to quickly tell the customer the future value of a deposit made today. Describe the Excel tools used for these tasks, and the information required to obtain the future value of the deposit.
• B - (TCO 10) You would like to build a list of customers who have opened a savings account. You know that this list will grow over time. However, you would like to start by adding the customer's personal information and account information. You want to be able to pull up a customer's account information by either their home address, or by phone number. Although this can be done using Excel, your IT department has recommended using a database such as Microsoft Access. What would be the benefit of doing this with a database instead of a spreadsheet? Would this meet your needs?
• C - (TCO 10) You want to use the Access form wizard to create an input form for your list. Describe the process of creating the form, and the special tools you might use to make it easier to use and less prone to errors.
• D - (TCO 10) You have decided that you would like to be able to pull a list of your clients with the largest balances in the savings account and attempt to get them to open an investment account. Explain how you would obtain a list of accounts with the highest balances and then print the information for your use in making these calls.
Submitted: 5 years ago.Category: Multiple Problems
Show More
Show Less
4/20/2012
replied 5 years ago
Category: Multiple Problems
Satisfied Customers: 5
Verified

Hi, I'm a Moderator for this topic and I wonder whether you're still waiting for an answer. If you are, please let me know and I will do my best to find a Professional to assist you right away. If not, feel free to let me know and I will cancel this question for you. Thank you!

linda_us, Master's Degree
Category: Multiple Problems
Satisfied Customers: 1,402
1,402 Satisfied Customers
Experience: A tutor for Business, Finance, Accounts and other related topics.

linda_us is online now

A new question is answered every 9 seconds

• Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
• Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

## What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

## Meet the Experts:

linda_us

Master's Degree

1,402 satisfied customers

A tutor for Business, Finance, Accounts and other related topics.

F. Naz

B.Com

1,088 satisfied customers

have completed B.Com and CA Finalist

Manal Elkhoshkhany

Bachelor's Degree

912 satisfied customers

Completed by BA degree in 1988 and graduated with a GPA of 4.0

Mr. Gregory White

Master's Degree

874 satisfied customers

M.A., M.S. Education / Educational Administration

Bizhelp

CPA

539 satisfied customers

BA degree and Certified Public Accountant

MyVirtualCPA

Master's Degree

155 satisfied customers

Dimitry K., Esq.

Doctoral Degree

39 satisfied customers

< Previous | Next >

Related Multiple Problems Questions
I need help with 75 questions. I want to compare my answers
I want to compare my answers to a tax professional … read more
Manal Elkhoshkhany
Bachelor's Degree
912 satisfied customers
How much do you charger per question I have 50 questions,
How much do you charger per question I have 50 questions … read more
Steven, M.Acc.
Instructor
Master\u0027s Degree
252 satisfied customers
How i pay you. About that Questions
how i pay you JA: When we are ready I'll take you to the appropriate web page. Customer: ok JA: The Tutor can help you get an A on your homework or ace your next test. Tell us more about what you need… read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,088 satisfied customers
I have a sauce Hobby it is trying to turn into a business I
I have a sauce Hobby it is trying to turn into a business I make a gourmet line of sauces hot sauces and such and I would like to know what I need to do to make my business official and successful in … read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,088 satisfied customers
I have an assignment for Project Management that I need help
I have an assignment for Project Management that I need help with in order to make sure I understand the lesson. I will upload the chart with the project totals, but the questions it asks are below: 1… read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,088 satisfied customers
For writer F. Naz. This assignment is due no later then
For writer F. Naz. This assignment is due no later then Monday 1/1/18. I have attached the assignment page and the rubric below. Please follow directions and show calculations for all problems and if … read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,088 satisfied customers
Scenario: Person 1 - Owns (Owner) a property (Property)
Scenario: Person 1 - Owns (Owner) a property (Property) which is going to be a rental. Person 2 - Enters a lease-to-buy contract (Buyer) for the property held by the Owner. Buyer will not be living in… read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
Need help with Project Manager course work. Specifically,
Need help with Project Manager course work. Specifically, WBS, parametric estimates and PERT charts.… read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,088 satisfied customers
I have some several questions i could use some help with.
I have some several questions i could use some help with. … read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,088 satisfied customers
This is your second interview with a prestigious brokerage
This is your second interview with a prestigious brokerage firm for a job as an equity analyst. You survived the morning interviews with the department manager and the vice president of equity. Everyt… read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,088 satisfied customers
I need help on a finance assignment that is timed and online
I need help on a finance assignment that is timed and online - so would need phone assistance on it… read more
Barbara
Enrolled Agent, Paralegal
3,808 satisfied customers
How does this work? I have a final exam. 3 essay questions 2
3 essay questions 2 short annswer and 10 multiple choice need in 3 hours… read more
David L.
Bachelor\u0027s Degree
6 satisfied customers
Which of the following is not a characteristic of a tax? a.
Which of the following is not a characteristic of a tax? a. The payment to the governmental authority is required by law. b. The payment relates to the receipt of a specific benefit. c. The payment is… read more
Manal Elkhoshkhany
Bachelor's Degree
912 satisfied customers
A department store chain is planning to open a new store.
A department store chain is planning to open a new store. They need to decide how to allocate the 100,000 square feet of available floor space among seven departments. Data on expected performance of … read more
Stephen, MBA
Master's Degree
166 satisfied customers
Suppose that \$ 2000 is loaned at a rate of 12 %, compounded
Suppose that \$ 2000is loaned at a rate of 12 %, compounded quarterly. Assuming that no payments are made, find the amount owed after 4years.Do not round any intermediate computations, and round your a… read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,088 satisfied customers
Stocks are evidence of __________ bonds are evidence of
Stocks are evidence of __________ bonds are evidence of _________. Select one: a. debt, ownership b. ownership, ownership c. debt, debt d. ownership, debt … read more
Manal Elkhoshkhany
Bachelor's Degree
912 satisfied customers
This assignment is due no later then wednesday 12/13 at 6pm.
This assignment is due no later then wednesday 12/13 at 6pm. This assignment is for a healthcare finance class. I have attached the questions and assignment page below. Please read the directions care… read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,088 satisfied customers
I need a solution for this problem GeneralProducts Inc. is
i need a solution for this problem GeneralProducts Inc. is incorporated in Nevada, USA on Jan… GeneralProducts Inc. is incorporated in Nevada, USA on Jan 1st 2013 to take over a local retail chain. Th… read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less