Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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%

image text in transcribedimage text in transcribed

Hi, could you please fill in the grey areas?

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting IFRS

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield

4th Edition

1119607515, 978-1119607519

More Books

Students also viewed these Accounting questions

Question

Context, i.e. the context of the information presented and received

Answered: 1 week ago