$1.00 Fact Pattern: Question 3:
Your company is planning a party for employees, and you have been asked to set up a spreadsheet to track the attendees and to calculate the associated cost. Each employee is allowed to bring one guest to the party. There are 50 employees in your company. 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 party is not the same for the employee and the guest. The charge for an employee is $50, and the charge for a guest is $45. When the employee responds that he/she plans to attend, you want to add his or her name to the list. If the employee is not coming, then his or her name is not recorded. Respond 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 employee (which may include the cost for a guest, and to calculate the total cost for the party).
B - (TCO 2) The facility where the party is to be held will give the company a reduction in price if more than 50 people attend. The price per employee 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 employees 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 your management team will want to periodically check to see who is attending. They will want the list to separate the employees coming alone, and those bringing guests. Explain how you might generate this list as requested using your knowledge of Excel. (Points: 40)
<!-- ''3'' -->