ProfitModelSolution

ProfitModelSolution - $0 $80,000 $160,000 $240,000 $120,000...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Profit Model b064ea9c6c04f0769a50e1c5c2258f0c0be698ed.xls Profit Model Inputs Profit Production Unit Price $40 240,000 240,000 20,000 25,000 30,000 35,000 40,000 45,000 50,000 Unit Cost $24 20,000 ($560,000) 20,000 ($80,000) ($200,000) ($320,000) ($440,000) ($560,000) ($680,000) ($800,000) Demand 50,000 25,000 ($360,000) 25,000 ($80,000) $0 ($120,000) ($240,000) ($360,000) ($480,000) ($600,000) 30,000 ($160,000) 30,000 ($80,000) $0 $80,000 ($40,000) ($160,000) ($280,000) ($400,000) Units Produced 40,000 35,000 $40,000 35,000 ($80,000) $0 $80,000 $160,000 $40,000 ($80,000) ($200,000) Demand 40,000 $240,000 Demand 40,000 ($80,000)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $0 $80,000 $160,000 $240,000 $120,000 $0 Model 45,000 $240,000 45,000 ($80,000) $0 $80,000 $160,000 $240,000 $320,000 $200,000 Units Sold 40,000 50,000 $240,000 50,000 ($80,000) $0 $80,000 $160,000 $240,000 $320,000 $400,000 Revenue $1,600,000 55,000 $240,000 55,000 ($80,000) $0 $80,000 $160,000 $240,000 $320,000 $400,000 Variable Cost $960,000 60,000 $240,000 60,000 ($80,000) $0 $80,000 $160,000 $240,000 $320,000 $400,000 Fixed Cost $400,000 Total Cost $1,360,000 Profit $240,000 A B C D E F G H I J K L M N O P 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21...
View Full Document

This note was uploaded on 01/16/2012 for the course DS 3620 taught by Professor Francis during the Spring '11 term at Tennessee Martin.

Ask a homework question - tutors are online