Create a CVP Chart based on this information. Please explain how you make the chart.
! ! Page Break Page Custom Preview Layout Views Workbook Views Rules Gridlines Formula Bar Headings Split Hide Unhide View Side by Side It Synchronous scrolling Reset Window Position Zoom Macro 100% Zoom to Selection New Window Arrange Freeze All Panes Switch Windows Window - X Selling Price Variable Cost Contribution Main Sales Mine Percent 2200 1100 110D 80% F G H Hair Gel Hair Spray Camb 200. 000 5500 6.00 1 500 100 600 500 400 90 % 4% CVP Income Statement HU 1 Hal Sales-Has Spray Sans Comp 10800254 10. 30 6.70679 To Weighted Average CM Break Even Sales Break Even Units Visbe Code Contribution Margin # 187,570.44 3 321045 1 4 380.00 14 ODO 107,570,44 Pred Costs Nere BE 3 Variable Costs 4 Haircut 5 Direct Maret 160 6 Commission $ 0.00 040 8 VC Per Haircut $ 1100 9 Ancillary Products Golvl Cort 6.00 1 Har Spray Variable Cost 500 2 Comb Variable Cont . 100 a Fixed Costs 14 Sales 50,000.00 15 Adres 3.000.00 16 Utes # 15.000.00 1 14.000.00 18 Booking $ 5000.00 $ 650.00 o Bahroom Products 1.500.00 1 Depron 3.000.00 22 Computer 120000 3 Total Fed Costs # 34,360.00 Nurber Of Products Sold at Beak Even Poin $30,000 Target Income Ha Gel Mai Spray Cob 134 312.50 21860 16 Har Gel HS Total # 242.890,63 Contribution Margin Haro HG HS Comb Weighted Average CM Har Gel Har Sera Contribution Margin Ratio H 99 Har Ged Har Spray Comb Basic Haircut Haircut w Ancillary Products Expanded Services Expanded w Ancillary Products .. o Type here to search ote -a 50W ! ! Page Break Page Custom Preview Layout Views Workbook Views Rules Gridlines Formula Bar Headings Split Hide Unhide View Side by Side It Synchronous scrolling Reset Window Position Zoom Macro 100% Zoom to Selection New Window Arrange Freeze All Panes Switch Windows Window - X Selling Price Variable Cost Contribution Main Sales Mine Percent 2200 1100 110D 80% F G H Hair Gel Hair Spray Camb 200. 000 5500 6.00 1 500 100 600 500 400 90 % 4% CVP Income Statement HU 1 Hal Sales-Has Spray Sans Comp 10800254 10. 30 6.70679 To Weighted Average CM Break Even Sales Break Even Units Visbe Code Contribution Margin # 187,570.44 3 321045 1 4 380.00 14 ODO 107,570,44 Pred Costs Nere BE 3 Variable Costs 4 Haircut 5 Direct Maret 160 6 Commission $ 0.00 040 8 VC Per Haircut $ 1100 9 Ancillary Products Golvl Cort 6.00 1 Har Spray Variable Cost 500 2 Comb Variable Cont . 100 a Fixed Costs 14 Sales 50,000.00 15 Adres 3.000.00 16 Utes # 15.000.00 1 14.000.00 18 Booking $ 5000.00 $ 650.00 o Bahroom Products 1.500.00 1 Depron 3.000.00 22 Computer 120000 3 Total Fed Costs # 34,360.00 Nurber Of Products Sold at Beak Even Poin $30,000 Target Income Ha Gel Mai Spray Cob 134 312.50 21860 16 Har Gel HS Total # 242.890,63 Contribution Margin Haro HG HS Comb Weighted Average CM Har Gel Har Sera Contribution Margin Ratio H 99 Har Ged Har Spray Comb Basic Haircut Haircut w Ancillary Products Expanded Services Expanded w Ancillary Products .. o Type here to search ote -a 50W
