Reference no: EM131016110
Using Microsoft Excel
Procrastinators Anonymous (PA) is hosting their annual convention this coming year in Dallas, TX. Although this is not typical of this organization, they wish to plan ahead to determine what the cost of the keynote banquet ticket should be. The ticket cost then can be included in materials that will be sent out prior to the convention. The banquet coordinator has determined the following costs:
Rental of banquet facility - $2,500
Entertainment for banquet - $1,200
Cost of meal - $12
Decorations - $400
Printing costs - $500
Favors per attendee - $2
Requirements:
1. Given the above information and assuming no profit will be made, what ticket price should be set if 500 procrastinators attend? If 750 people attend?
2. If a ticket price of $35 is set, how many procrastinators need to attend for PA to break even on their banquet? If the ticket price was $50? Use the roundup function to round up to the next integer (eg. 344.24 would be 345)
3. If fixed costs can be reduced by 10%, what is the breakeven point (in number of attendees) if the ticket price is $35. Use the roundup function to round up to the next integer.
4. If PA wishes to make a profit of $1,000 on the banquet and the ticket price is $35, how many procrastinators need to attend? Assume that fixed costs do not change from the initial amounts. Use the roundup function to round up to the next integer.
5. Create a CVP chart for requirement 2 (ticket price of $35). Properly label all facets of the chart.
6. Using Goal Seek:
a. How many attendees need to attend for the banquet to net EXACTLY $955 in profit (assuming $35 ticket price)? Format attendees to 5 decimal places.
b. For a breakeven, what should be the EXACT ticket price (do not round) if EXACTLY 455 attendees show up at the banquet. Format the ticket price to 5 decimal places.
Verify that your answers are correct by “plugging” the answers into an income statement
Determine the optimal service level
: Given the following data for a particular product calculate the optimal service level. Sales response rate is 0.15% change in revenue for a 1% change in the service level (fill rate). Trading margin is $14 per item; inventory-carrying cost is 30% per..
|
What is intrinsic value
: Stock X is expected to pay $2 dividend per year for ten years and then a $20 liquidating dividend in the 10th year. The appropriate discount rate is 12%. What is x's intrinsic value?
|
-annuityperpetuity and series of unequal cash flows
: Describe in detail the differences and similarities in calculating the present value and future value of a lump sum, annuity, perpetuity and a series of unequal (multiple) cash flows.
|
The parameters for the retirement plan
: The parameters for the Retirement Plan are that you can use real information or fictional characters. Begin with a little history about the person or family (Age and stage of life). Next I would like to see net worth statement and a cash flow stateme..
|
Procrastinators anonymous is hosting their annual convention
: Procrastinators Anonymous (PA) is hosting their annual convention this coming year in Dallas, TX. Although this is not typical of this organization, they wish to plan ahead to determine what the cost of the keynote banquet ticket should be. Given the..
|
Computer system will require an initial outlay
: A new computer system will require an initial outlay of $150,000, but it will increase the firm’s cash flows by $25,000 a year for each of the next 8 years. Calculate the NPV of the project using an 11% discount rate. Should the project be accepted a..
|
Accelerate their depreciation schedule
: What is the effect of depreciation on the amount of tax owed by a company? What is the effect of a change in the tax code that allows companies to “accelerate their depreciation schedule” (take more depreciation earlier in the life of an asset)?
|
Additional paid-in surplus account-what was cash flow
: The December 31, 2013, balance sheet of Schism, Inc., showed $137,000 in the common stock account and $2,620,000 in the additional paid-in surplus account. The December 31, 2014, balance sheet showed $147,000 and $2,920,000 in the same two accounts, ..
|
What was the firms operating cash flow
: The December 31, 2013, balance sheet of Schism, Inc., showed long-term debt of $1,400,000, $140,000 in the common stock account and $2,650,000 in the additional paid-in surplus account. What was the firm’s operating cash flow during 2014?
|