Hi, could you please fill in the grey areas?
Cost Volume Profit Analysis Fixed Costs $180,900.00 Vary-with-Revenue Costs Sales Commissions 3.0% Other Vary-with-Revenue Costs 1.5% Product Information X-800 ZF300 Total Vary with Revenue Costs 4.5% Unit Sales Price $4,300.00 $8,750.00 Units Sold 540 302 Weighted Average Contribution Margin Break Even Units (weighted) Vary with Unit Costs X-800 ZF300 Direct Material Direct Labor Break Even Variable Costs Other Vary-with-Unit Costs $129.00 $174.00 Direct Material Total Vary with Unit Costs $129.00 $174.00 Direct Labor Other Vary-with-Unit Costs Sales Commissions Break Even Analysis X-800 ZF300 Other Vary-with-Revenue Costs Sales Mix (% of total units sold) Total Variable Costs $0.00 Contribution Margin Per Unit Contribution Margin Break Even Volume in Units/Product Profit Before Tax Break Even Sales ValueLabour Costs for the year % Super 11.5% Employee_Number Employee_Name Gender Product_Line Daily_Rate Days_Per_Month Bonus_Rate Annual_Pay Annual_Super Total_Package S12716 Sam Mason M X-800 $ 351.00 21 4.5% $ 7,371.00 $ 847.67 $ 8,550.36 S12717 Lemin Lu F ZF300 $ 305.00 21 4.5% $ 6,405.00 $ 736.58 |$ 7,429.80 S12720 James Viney M X-800 $ 87.00 21 7.5% $ 6,027.00 $ 693.11 $ 7,172.13 S12722 Will Chang M ZF300 $ 371.00 14 6.0% $ 5,194.00 $ 597.31 $ 6,102.95 S12723 Divika Kapoor F X-800 287.00 21 7.5% $ 6,027.00 $ 593.11 $ 7,172.13 S12724 Bin Wang M ZF300 $ 274.00 21 4.5% $ 5,754.00 $ 661.71 $ 6,674.64 S12725 Andy Forbes F ZF300 S 252.00 21 3.0% $ 5,292.00 $ 608.58 $ 6,059.34 S12726 Tom Peters M ZF300 293.00 21 6.0% $ 6,153.00 $ 707.60 $ 7,229.78 S12727 Elan Forbes M ZF300 $ 381.00 7 4.5% $ 2,667.00 $ 306.71 $ 3,093.72 S12728 Phil Smith M X-800 S 268.00 21 3.0% $ 5,628.00 $ 647.22 $ 6,444.06 S12729 Jason Kerr M ZF300 386.00 21 4.5% $ 8,106.00 $ 932.19 $ 9,402.96 S12730 Chris Powe M ZF300 378.00 21 7.5% $ 7,938.00 $ 912.87 $ 9,446.22 S12733 Jordan Riddle M X-800 $ $66.00 21 4.5% $ 7,686.00 $ 883.89 $ 3,915.76 Total $ 93,693.85 Lowest $ 3,093.72 Highest $ 9,446.22Bill of Materials Product Part Code Quantity |Product Decsription Unit Pr Total_Pr Product Number of Components ZF300 GR1751 2 CNC brakes 200g Brakes $79.05 $158.10 X-800 31 X-800 AC1914 2 Nashbar Alped Huez Pedals $10.50 $21.00 ZF300 33 ZF300 CO2357 1 RockBros CrMo Saddle $20.70 $20.70 X-800 FR123 1 J&L Fork $178.20 $178.20 X-800 01469 2 Generic Foam Tape Tape $0.18 $0.36 ZF300 GR2009 1 Ultegra Cranks $125.61 $125.61 X-800 WH1100 2 XR-270/Bitex Wheel $128.25 $256.50 X-800 CO1099 1 Nashbar Carbon Bar $70.56 $70.56 ZF300 C01469 2 Generic Foam Tape Tape 50.18 60.36 ZF300 FR2360 1 J&L Plug $10.66 $10.66 X-800 GR1770 1 Nashbar RD $43.45 $43.45 X-800 WH2778 2 CNC V16 Super Slim Wheels $153.00 $306.00 ZF300 FR1934 1 Headset $0.00 $0.00 2F300 GR1322 1 Ultegra RD $45.50 $45.50 ZF300 FR1235 1 J&L Fork $178.20 $178.20 ZF300 GR1172 1 Ultegra FC $28.71 $28.71 ZF300 CO2904 2 Custom Bar Plugs $0.93 $1.86 ZF300 FR1080 1 J&L Top Cap & Screw $4.80 $4.80 ZF300 GR1215 1 Dura Ace Chain $27.20 $27.20 X-800 WH2373 2 Veloplugs Rim tape $5.58 $11.16 X-800 CO2904 2 Custom Bar Plugs $0.93 1.86 X-800 WH1573 2 Forte Light Tubes $4.68 59.36 ZF300 C01099 1 Nashbar Carbon Bar $70.56 $70.56 X-800 FR1934 1 Headset SO.0 $0.00 ZF300 R1323 1 Nashbar Carbon Frame $360.00 $360.00 X-800 CO2143 5 Spacers $0.00 50.00 X-800 FR1323 1 Nashbar Carbon Frame $360.00 $360.00 ZF300 GR1836 1 Ultegra Cassette $41.65 $41.65 ZF300 WH2778 2 CNC V16 Super Slim Wheel: $153.00 $306.00 ZF300 AC1508 4 Fairing M5 Bolts 50.46 $1.84 ZF300 GR2589 2 Ultegra Levers $90.95 $181.90 K-800 CO2357 1 RockBros CrMo Saddle $20.70 $20.70 X-800 AC1945 2 Alloy CR Bolts $2.35 $4.70 X-800 GR1550 4 Ultegra Cables $0.00 60.00 X-BOO GR1432 2 Nashbar Levers $102.00 $204.00 ZF300 AC2964 1 Generic FD Adapter $2.7 $2.73 X-800 CO1649 1 KCNC Scandium Seatpost $67.64 $67.64 X-800 GR1751 2 CNC brakes 200g Brakes $79.05 $158.10 X-800 FR2360 1 J& L Plug $10.66 $10.66 ZF300 WH1573 2 Forte Light Tubes $4.68 $9.36