CVP 93 - Esther Takahashi BUAD 305 Mon-Wed 10AM Section 14770(Excel 2007 Tino's Piano Organ Co Income Statement Total per Unit Sales $93,750 $3,125

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

This preview shows page 1 - 5 out of 22 pages.

Esther Takahashi BUAD 305 Mon-Wed. 10AM Section 14770 (Excel 2007) Tino's Piano & Organ Co. 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
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%
Esther Takahashi 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. Tino's Piano & Organ Co. 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 $350 per month FC FC (Clerical) $1,000 Depreciation $800 per month FC FC (Depreciation) $1,100
Esther Takahashi BUAD 305 Mon-Wed 10AM Section 14770 (Excel 2007) FC (Executive Salary) $2,500 $7,000.00 Executive Salaries $2,500 per month FC Net Income $8,200 ($6,620.00) Insurance $400 per month FC Total Sales Revenue: $120,000 $3,000 Clerical $1,000 per month (VC) $20 per organ Total Cost: $107,300 $9,620.00 Depreciation $300 per month FC Break even in Units: 18.42 19 Break Even in Dollars $55,263 breakeven units X unit price $57,000 c.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture