cpt_109_lesson_22_solution

cpt_109_lesson_22_solution - Organization of a conference...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Organization of a conference Per pers. Total Estimated income Participants 500.00 0.00 Place: Lausanne Video sales 30.00 0.00 Date: 1/15/2007 Total income 0.00 Participants: 50 Estimated fixed costs Conference room 3,000.00 Video production 2,500.00 Target set Promotion 8,000.00 Estimated profit Travel and subsistence 2,000.00 0.00 Total fixed costs 0.00 Estimated variable costs Documentation 22.00 0.00 Coffee break 8.00 0.00 Lunch 28.00 0.00 Total variable costs 0.00 Create the above table and fill in the required calculations. We shall use the table as a basis for using the "Goal Seek" analysis tool.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Search of the break-even point with a Goal Seek analysis Autumn 2006 BOS2-E Week 11 Course Excel 2003 B C D E F G H 2 Organization of a conference Per pers. Total 3 4 Estimated income 5 Participants 500.00 16,419.49 6 Place: Lausanne Video sales 30.00 985.17 7 Date: 1/15/2007 Total income 17,404.66 8 Participants: 32.84 9 Estimated fixed costs 10 Conference room 3,000.00 11 Video production 2,500.00 12 Target set Promotion 8,000.00 13 Estimated profit Travel and subsistence 2,000.00 14 0.00 Total fixed costs 15,500.00 15 16 Estimated variable costs 17 Documentation 22.00 722.46 18 Coffee break 8.00 262.71 19 Lunch 28.00 919.49 20 Total variable costs 1,904.66
Background image of page 2
GRAND HOTEL DES BAINS BREAKDOWN OF RESERVATIONS BY ORIGIN
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This homework help was uploaded on 04/19/2008 for the course CPT CPT 109 taught by Professor A.sisini during the Fall '08 term at Franklin CH.

Page1 / 13

cpt_109_lesson_22_solution - Organization of a conference...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online