QBA Homework 7.xlsx - Cox Electric Breakeven Analysis Revenue per Unit Fixed Costs $0.65 $10,000.00 Material Cost per Unit $0.15 Labor Cost per Unit

QBA Homework 7.xlsx - Cox Electric Breakeven Analysis...

This preview shows page 1 - 16 out of 41 pages.

Cox Electric Breakeven Analysis Revenue per Unit $0.65 Fixed Costs $10,000.00 Material Cost per Unit $0.15 Labor Cost per Unit $0.10 # of units 12000 Formula: P(q) = Rq - FC - (MC)q - (LC)q -$5,200.00
Image of page 1
Image of page 2
Image of page 3
Image of page 4
Image of page 5
Image of page 6
Image of page 7
Image of page 8
Fixed Cost 160000 Data Table: Variable Processing Cost: 6 a book Quanitity -20000 1000 Price per book: 46 1200 1400 # of books 3500 1600 1800 Formula: P(q)=R(q)-FC-VC(q) 2000 2200 Loss(3500): -20000 2400 2600 2800 3000 3200 3400 3600 3800 4000 4200 4400 4600 4800 5000 5200 5400 5600 5800 6000 6200
Image of page 9
Image of page 10
Goal Seek: Price to break event for 3500 books: 51.71
Image of page 11
Image of page 12
Image of page 13
Image of page 14
Revenue per person: 75 Number of Non-member Registrations 127 2288.2500 0.1 0.12 Total Revenue R 9525 80 85 Variable Costs: 90 Registration Cost 8.5 95 Continental Breakfast 4 100 Lunch 7 105 Parking 5 110 Variable cost per person: 24.5 115 Total Variable Costs per person A 3111.5 120 125 % non-member no shows: 0.1 130 # of non-member no shows: 12.7 135 Refund % non-member: 0.5 140 Refund per non-member no show: 37.5 145 Refunds B 476.25 150 155 Variable expense corp member: 24.5 160 # of Corp members: 10 Tickets for Corp members per show: 5 Total Corp members per show: 50 Total Variable Costs per member: 1225 Rental Auditorium 150 3 speakers @ 800 each 2400 Total fixed cost: C 3775 # member no show percent: 0.25
Image of page 15
Image of page 16

You've reached the end of your free preview.

Want to read all 41 pages?

  • Spring '14
  • Danepeterson
  • Total Corp, Order Quantity Price

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture