CVP 93 - Esther Takahashi BUAD 305 Mon-Wed 10AM Section...

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

View Full Document Right Arrow Icon
Esther Takahashi BUAD 305 Mon-Wed. 10AM Section 14770 (Excel 2007) Income Statement Total: per Unit: Sales: $93,750 $3,125 VC (Wholesale Cost) $73,500 $2,450 Sales Price $3,125 per organ VC (sales commission) $0 $0 Wholesale Cost $2,450 per organ VC VC (clerical) $600 $20 Average Monthly Sales 30 organs per month VC (delivery to customer) 1500 VC 50 Contribution Margin $18,150 $2,520 $605 Advertising $700 per month FC FC (Advertising) $700 Sales salaries $950 per month FC FC (Sales Salary) $950 Sales commissions 5 % of sales per month VC 0 FC (Utilities) $350 Delivery to customer $50 per organ VC FC (Insurance) $400 Utilities $350 per month FC FC (Clerical) $1,000 Depreciation $800 per month FC FC (Depreciation) $1,100 FC (Executive Salary) $2,500 $7,000.00 Executive Salaries $2,500 per month FC Net Income $11,150 ($6,395.00) Insurance $400 per month FC Total Sales Revenue: $93,750 $3,125 Clerical $1,000 per month $20 per organ (VC) Total Cost: $78,100 $9,520.00 Depreciation $300 per month FC Break even in Units: 11.57 16 Break Even in Dollars $36,157 breakeven units X unit pric $50,000.00
Background image of page 1

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

View Full DocumentRight Arrow Icon
Esther Takahashi BUAD 305 Mon-Wed. 10AM Section 14770 (Excel 2007) Percentage: 100.0% 78.4% 0.0% 0.64% 1.60% 19.4% 2.7% 16.7% 100.0% 83.3%
Background image of page 2
BUAD 305 Mon-Wed 10AM Section 14770 (Excel 2007) Tino's Piano & Organ Co. Income Statement Total: per Unit: a. Sales: $93,750 $3,125 VC (Wholesale Cost) $73,500 $2,450 Sales Price $3,125 per organ VC (sales commission) $0 $0 Wholesale Cost $2,450 per organ VC VC (clerical) $600 $20 Average Monthly Sales 30 organs per month VC (delivery to customer) 1500 VC 50 Contribution Margin $18,150 $2,520 $605 Advertising $700 per month FC FC (Advertising) $700 Sales salaries $950 per month FC FC (Sales Salary) $950 Sales commissions 5 % of sales per month VC 0 FC (Utilities) $350 Delivery to customer $50 per organ VC FC (Insurance) $400 Utilities $350 per month FC FC (Clerical) $1,000 Depreciation $800 per month FC FC (Depreciation) $1,100 FC (Executive Salary) $2,500 $7,000.00 Executive Salaries $2,500 per month FC Net Income $11,150 ($6,395.00) Insurance $400 per month FC Total Sales Revenue: $93,750 $3,125 Clerical $1,000 per month (VC) $20 per organ Total Cost: $78,100 $9,520.00 Depreciation $300 per month FC Break even in Units: 11.57 16 Break Even in Dollars $36,157 breakeven units X unit price $50,000 b. Income Statement Total: per Unit: Sales: $120,000 $3,000 VC (Wholesale Cost) $96,000 $2,400 Sales Price $3,000 per organ VC (sales commission) $6,000 $150 Wholesale Cost $2,400 per organ VC VC (clerical) $800 $20 Average Monthly Sales 40 organs per month VC (delivery to customer) 2000 VC 50 Contribution Margin $15,200 $2,620 $380 Advertising $700 per month FC FC (Advertising) $700 Sales salaries $950 per month FC FC (Sales Salary) $950 Sales commissions 5% of sales per month VC 150 FC (Utilities) $350 Delivery to customer $50 per organ VC FC (Insurance) $400 Utilities
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 02/23/2008 for the course BUAD 305 taught by Professor Davila during the Fall '07 term at USC.

Page1 / 22

CVP 93 - Esther Takahashi BUAD 305 Mon-Wed 10AM Section...

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