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
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
Goal Seek: Price to break event for 3500 books: 51.71
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

#### You've reached the end of your free preview.

Want to read all 41 pages?

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