Procrastinators Anonymous (PA) is hosting their annual convention this coming ye
ID: 2729550 • Letter: P
Question
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
5. Create a CVP chart (see conference notes) for requirement 2 (ticket price of $35). Properly label all facets of the chart. (How is this put in excel?)
Rental of banquet facility
$2,500
Entertainment for banquet
$1,200
Cost of meal
$12
Decorations
$400
Printing costs
$500
Favors per attendee
$2
Explanation / Answer
Calculation of CVP analysis:
Sales = 35 units
-variable (12+2) =14units
Contribution = 21 units
Break even point = 4600 / 21
= 219
Sales 219 * 35 = 7665
-variable 219*14= 3066
Contribution = 4,600
CVP chart:
Units $
14 3066
21 4600
35 7665
Calculation of CVP analysis:
Sales = 35 units
-variable (12+2) =14units
Contribution = 21 units
Break even point = 4600 / 21
= 219
Sales 219 * 35 = 7665
-variable 219*14= 3066
Contribution = 4,600
CVP chart:
Units $
14 3066
21 4600
35 7665
Calculation of CVP analysis:
Sales = 35 units
-variable (12+2) =14units
Contribution = 21 units
Break even point = 4600 / 21
= 219
Sales 219 * 35 = 7665
-variable 219*14= 3066
Contribution = 4,600
CVP chart:
Units $
14 3066
21 4600
35 7665
Calculation of CVP analysis:
Sales = 35 units
-variable (12+2) =14units
Contribution = 21 units
Break even point = 4600 / 21
= 219
Sales 219 * 35 = 7665
-variable 219*14= 3066
Contribution = 4,600
CVP chart:
Units $
14 3066
21 4600
35 7665
Calculation of CVP analysis:
Sales = 35 units
-variable (12+2) =14units
Contribution = 21 units
Break even point = 4600 / 21
= 219
Sales 219 * 35 = 7665
-variable 219*14= 3066
Contribution = 4,600
CVP chart:
Units $
14 3066
21 4600
35 7665
Calculation of CVP analysis:
Sales = 35 units
-variable (12+2) =14units
Contribution = 21 units
Break even point = 4600 / 21
= 219
Sales 219 * 35 = 7665
-variable 219*14= 3066
Contribution = 4,600
CVP chart:
Units $
14 3066
21 4600
35 7665
Calculation of CVP analysis:
Sales = 35 units
-variable (12+2) =14units
Contribution = 21 units
Break even point = 4600 / 21
= 219
Sales 219 * 35 = 7665
-variable 219*14= 3066
Contribution = 4,600
CVP chart:
Units $
14 3066
21 4600
35 7665
Calculation of CVP analysis:
Sales = 35 units
-variable (12+2) =14units
Contribution = 21 units
Break even point = 4600 / 21
= 219
Sales 219 * 35 = 7665
-variable 219*14= 3066
Contribution = 4,600
CVP chart:
Units $
14 3066
21 4600
35 7665
CVP diagram not copying from Exce.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.