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

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

The preview shows page 3 - 5 out of 22 pages.
Esther TakahashiBUAD 305 Mon-Wed. 10AM Section 14770 (Excel 2007)Tino's Piano & Organ Co.Income StatementTotal:per Unit:Sales:$93,750 $3,125 VC (Wholesale Cost)$73,500 $2,450 Sales Price$3,125 per organVC (sales commission)$0 $0 Wholesale Cost$2,450 per organVCVC (clerical)$600 $20 Average Monthly Sales30 organs per monthVC (delivery to customer)1500 VC50Contribution Margin$18,150 $2,520 $605 Advertising$700 per monthFCFC (Advertising)$700 Sales salaries$950 per monthFCFC (Sales Salary)$950 Sales commissions5 % of sales per monthVC0 FC (Utilities)$350 Delivery to customer$50 per organVCFC (Insurance)$400 Utilities$350 per monthFCFC (Clerical)$1,000 Depreciation$800 per monthFCFC (Depreciation)$1,100 FC (Executive Salary)$2,500 $7,000.00 Executive Salaries$2,500 per monthFCNet Income$11,150 ($6,395.00)Insurance$400 per monthFCTotal 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 monthFCBreak even in Units:11.57 16Break Even in Dollars$36,157 breakeven units X unit pric$50,000.00
Esther TakahashiBUAD 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 TakahashiBUAD 305 Mon-Wed 10AM Section 14770 (Excel 2007)Tino's Piano & Organ Co. Income StatementTotal:per Unit:a.Sales:$93,750 $3,125 VC (Wholesale Cost)$73,500 $2,450 Sales Price$3,125 per organVC (sales commission)$0 $0 Wholesale Cost$2,450 per organVCVC (clerical)$600 $20 Average Monthly Sales30 organs per monthVC (delivery to customer)1500 VC50Contribution Margin$18,150 $2,520 $605 Advertising$700 per monthFCFC (Advertising)$700 Sales salaries$950 per monthFCFC (Sales Salary)$950 Sales commissions5 % of sales per monthVC0 FC (Utilities)$350 Delivery to customer$50 per organVCFC (Insurance)$400 Utilities$350 per monthFCFC (Clerical)$1,000 Depreciation$800 per monthFCFC (Depreciation)$1,100 FC (Executive Salary)$2,500 $7,000.00 Executive Salaries$2,500 per monthFCNet Income$11,150 ($6,395.00)Insurance$400 per monthFCTotal Sales Revenue:$93,750 $3,125 Clerical$1,000 per month (VC)$20 per organTotal Cost:$78,100 $9,520.00 Depreciation$300 per monthFCBreak even in Units:11.57 16Break Even in Dollars$36,157 breakeven units X unit price$50,000 b.Tino's Piano & Organ Co.Income StatementTotal:per Unit:Sales:$120,000 $3,000 VC (Wholesale Cost)$96,000 $2,400 Sales Price$3,000 per organVC (sales commission)$6,000 $150 Wholesale Cost$2,400 per organVCVC (clerical)$800 $20 Average Monthly Sales40 organs per monthVC (delivery to customer)2000 VC50Contribution Margin$15,200 $2,620 $380 Advertising$700 per monthFCFC (Advertising)$700 Sales salaries$950 per monthFCFC (Sales Salary)$950 Sales commissions5% of sales per monthVC150 FC (Utilities)$350 Delivery to customer$50 per organVCFC (Insurance)$400 Utilities$350 per monthFCFC (Clerical)$1,000 Depreciation$800 per monthFCFC (Depreciation)$1,100
Esther TakahashiBUAD 305 Mon-Wed 10AM Section 14770 (Excel 2007)FC (Executive Salary)$2,500 $7,000.00 Executive Salaries$2,500 per monthFCNet Income$8,200 ($6,620.00)Insurance$400 per monthFCTotal Sales Revenue:$120,000 $3,000 Clerical$1,000 per month (VC)$20 per organTotal Cost:$107,300 $9,620.00 Depreciation$300 per monthFCBreak even in Units:18.42 19Break Even in Dollars$55,263 breakeven units X unit price$57,000 c.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 22 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Davila

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture