Urgenthomework logo
UrgentHomeWork
Live chat

Loading..

Accg200 Cost Volume Profit Analysis Assessment Answers

BikePro Ltd want you to perform a Cost Volume Profit Analysis for their High-End Racing Bike product, the X-800. You
will need to calculate the labour costs, material costs, fixed costs and variable costs and then work out the break-even
volume. You have also been asked to show a forecast for different sales volumes and produce a break-even analysis line chart.
Start by downloading the assessment workbook from iLearn and copying/moving it to an appropriate folder. When you open the workbook it is very important that you Enable Macros/Content. You will then be asked to enter your Student Number (you will not be able to edit it afterwards, so type it in carefully) and then enter your Student Name.
Detailed instructions are provided on the next pages. Please follow each of the instructions precisely and in sequence.
All the grey cells require you to insert some form of calculation, i.e. start with an “=”, just typing in the answer will result in 0 marks. Do not change the structure of the workbook in anyway or put any workings anywhere other than directed.Only use rounding functions where specifically required. The use of named ranges and tables is encouraged, and in certain cases required.
Because we are developing a model that we may wish to use with other products or different values it is very important that all calculations will return a correct answer regardless of the values in the spreadsheet and must still work correctly when the lists of data (Labour Costs, BOM & Inventory) are sorted in a different order.
Double check your answers as you go as one wrong result may affect lots of other results. Use the check boxes in the
Done column to keep track of tasks completed.

Remember to save often. When you are ready to submit, upload the completed Excel File to iLearn (Excel Submission).
You do not need to rename it as your student number will be automatically attached by iLearn, but please ensure that it is an Excel file you submit (Numbers files will not be accepted) and that there are no “non-English” characters in the file name as these files cannot be opened in an English version of Excel.

Answer:

% Super9.5%
Employee NumberAnnualBonus RateBonus AmountSuper Total Package
10026 $ 55,513.000% $ 200.00 $ 5,273.74 $ 60,986.74
10027 $ 47,039.000% $ 200.00 $ 4,468.71 $ 51,707.71
10030 $ 42,349.000% $ 200.00 $ 4,023.16 $ 46,572.16
10032 $ 38,062.000% $ 200.00 $ 3,615.89 $ 41,877.89
10033 $ 53,865.001% $ 738.65 $ 5,117.18 $ 59,720.83
10034 $ 47,964.001% $ 679.64 $ 4,556.58 $ 53,200.22
10035 $ 42,514.000% $ 200.00 $ 4,038.83 $ 46,752.83
10036 $ 34,458.001% $ 544.58 $ 3,273.51 $ 38,276.09
10037 $ 33,670.002% $ 873.40 $ 3,198.65 $ 37,742.05
10038 $ 34,425.002% $ 888.50 $ 3,270.38 $ 38,583.88
10039 $ 39,504.002% $ 990.08 $ 3,752.88 $ 44,246.96
Total  $ 5,19,667.34
Average $ 47,242.49
Highest  $ 60,986.74
Bill of Materials
ProductPart CodeQuantityCategoryProduct DecsriptionSupplierUnit PriceTotal PriceCost Brakdown for:
ZF300GR17512GroupsetCNC brakes 200g BrakesCycle Warehouse96.9$193.80Groupset
X-800AC19142Accessories and tuningNashbar Alpe d Huez PedalsNashbar11.2$22.40Accessories and tuning
ZF300CO23571Contact PointsRockBros CrMo SaddleCycle Warehouse21.39$21.39Contact Points
X-800FR12351FramesetJ&L ForkBikes Plus244.2$244.20Frameset
X-800CO1469180Contact PointsGeneric Foam Tape TapeCycle Warehouse0.18$32.40Wheels
ZF300GR20091GroupsetUltegra CranksNashbar165.36$165.36Total Cost per Unit
X-800WH11002WheelsXR-270/Bitex WheelCycle Warehouse161.03$322.06
X-800CO10991Contact PointsNashbar Carbon BarNashbar66.24$66.24
ZF300CO1469180Contact PointsGeneric Foam Tape TapeCycle Warehouse0.18$32.40
ZF300FR23601FramesetJ&L PlugBikes Plus11.18$11.18
X-800GR17701GroupsetNashbar RDNashbar51.15$51.15
X-800WH29422WheelsTitanium QR SkewersCycle Warehouse5.3$10.60
ZF300FR19341FramesetHeadsetBikes Plus0$0.00
ZF300GR13221GroupsetUltegra RDBackcountry42$42.00
ZF300FR12351FramesetJ&L ForkBikes Plus244.2$244.20
ZF300GR11721GroupsetUltegra FDNashbar26.68$26.68
ZF300CO29042Contact PointsCustom Bar PlugsCycle Warehouse0.81$1.62
ZF300FR10801FramesetJ&L Top Cap & ScrewCycle Warehouse4.25$4.25
ZF300GR12151GroupsetDura Ace ChainNashbar27.52$27.52
X-800WH23732WheelsVeloplugs Rim tapeLBS6.66$13.32
X-800CO29042Contact PointsCustom Bar PlugsCycle Warehouse0.81$1.62
X-800WH12602WheelsCNC V18 Ultra WheelsCycle Warehouse131.2$262.40
X-800WH15732WheelsForte Light TubesPerformance6.33$12.66
ZF300CO10991Contact PointsNashbar Carbon BarNashbar66.24$66.24
X-800FR19341FramesetHeadsetBikes Plus0$0.00
ZF300FR13231FramesetNashbar Carbon FrameNashbar456$456.00
X-800CO21435Contact PointsSpacersBikes Plus0$0.00
X-800AC2716220Accessories and tuningGreaseCycle Warehouse0.09$19.80
X-800FR13231FramesetNashbar Carbon FrameNashbar456$456.00
ZF300GR18361GroupsetUltegra CassetteNashbar48.02$48.02
ZF300WH27782WheelsCNC V16 Super Slim WheelsCycle Warehouse192.6$385.20
ZF300AC15084Accessories and tuningFairing M5 BoltsCycle Warehouse0.46$1.84
ZF300GR25892GroupsetUltegra LeversNashbar117.7$235.40
X-800CO23571Contact PointsRockBros CrMo SaddleCycle Warehouse21.39$21.39
X-800AC19452Accessories and tuningAlloy CR BoltsCycle Warehouse2.28$4.56
X-800GR15504GroupsetUltegra CablesNashbar0$0.00
X-800GR14322GroupsetNashbar LeversNashbar126$252.00
ZF300AC29641Accessories and tuningGeneric FD AdapterCycle Warehouse2.61$2.61
X-800AC27331Accessories and tuningTitanium Stem BoltsCycle Warehouse11.16$11.16
X-800CO16491Contact PointsKCNC Scandium SeatpostCycle Warehouse80.1$80.10
X-800GR17512GroupsetCNC brakes 200g BrakesCycle Warehouse96.9$193.80
X-800FR23601FramesetJ&L PlugBikes Plus11.18$11.18
ZF300WH15732WheelsForte Light TubesPerformance6.33$12.66
ZF300AC2716200Accessories and tuningGreaseCycle Warehouse0.09$18.00
ZF300AC19452Accessories and tuningAlloy CR BoltsCycle Warehouse2.28$4.56
X-800AC15084Accessories and tuningFairing M5 BoltsCycle Warehouse0.46$1.84
X-800CO22021Contact PointsUno 7050 StemCycle Warehouse18.2$18.20
X-800WH28562WheelsForte LCR TyresPerformance21.83$43.66
ZF300FR10811FramesetMr. Ride Seat ClampCycle Warehouse18.56$18.56
X-800GR20091GroupsetUltegra CranksNashbar165.36$165.36
ZF300WH11002WheelsXR-270/Bitex WheelCycle Warehouse161.03$322.06
ZF300GR14061GroupsetUltegra BBBackcountry15.13$15.13
X-800FR10801FramesetJ&L Top Cap & ScrewCycle Warehouse4.25$4.25
ZF300WH28562WheelsForte LCR TyresPerformance21.83$43.66
X-800FR10811FramesetMr. Ride Seat ClampCycle Warehouse18.56$18.56
ZF300GR15504GroupsetUltegra CablesNashbar0$0.00
X-800GR18361GroupsetUltegra CassetteNashbar48.02$48.02
ZF300CO21433Contact PointsSpacersBikes Plus0$0.00
ZF300AC19142Accessories and tuningNashbar Alpe d Huez PedalsNashbar11.2$22.40
ZF300WH23732WheelsVeloplugs Rim tapeLBS6.66$13.32
ZF300CO16491Contact PointsKCNC Scandium SeatpostCycle Warehouse80.1$80.10
X-800AC29641Accessories and tuningGeneric FD AdapterCycle Warehouse2.61$2.61
ZF300WH29422WheelsTitanium QR SkewersCycle Warehouse5.3$10.60
X-800GR14061GroupsetUltegra BBBackcountry15.13$15.13
X-800GR19661GroupsetNashbar FDNashbar34.56$34.56
X-800GR12151GroupsetDura Ace ChainNashbar27.52$27.52
ZF300AC27331Accessories and tuningTitanium Stem BoltsCycle Warehouse11.16$11.16
ZF300CO22021Contact PointsUno 7050 StemCycle Warehouse18.2$18.20
Cost Volume Profit Analysis
Product Name X-800 Variable Costs per UnitBreak-Even Analysis
Unit Sales Price $ 5,000.00Variable Manufacturing CostsContribution Margin per Unit $ 521.49
Total Units Sold 350Direct Material $ 2,468.75Break Even Volume in Units322
Direct Labour $ 1,484.76Break Even Sales Value $ 16,09,630.37
Factory Overhead $ 120.00
Fixed Cost ItemsOther Variable Manufacturing Costs $ 80.00Break Even Variable Costs
Rent $ 51,000.00Total Variable Manufacturing Costs $ 4,153.51Direct Material $ 7,94,754.99
Utilities $ 13,400.00Direct Labour $ 4,77,984.18
Admin Costs $ 22,700.00Variable Selling and Admin CostsVariable Factory Overhead $ 38,631.13
Loan Repayments $ 68,280.00Sales Commissions5.0%Other Variable Manufacturing Costs $ 25,754.09
Insurance $ 12,500.00Variable Admin Costs1.5%Sales Commissions $ 80,481.52
Total Fixed Costs $ 1,67,880.00Total Variable Selling and Admin Costs6.5%Variable Admin Costs $ 24,144.46
Total Variable Costs $ 14,41,750.37
Income Tax
State Tax10.0%Contribution Margin $ 1,67,880.00
Federal Tax5.0%Profit Before Income Tax $ -
Profit Volume Forecast
Increments100
Sales Volume in Units100200300400500600
Total Sales Value $ 5,00,000.00 $ 10,00,000.00 $ 15,00,000.00 $ 20,00,000.00 $ 25,00,000.00 $ 30,00,000.00
Variable Costs
Direct Material $ 2,46,875.00 $ 4,93,750.00 $ 7,40,625.00 $ 9,87,500.00 $ 12,34,375.00 $ 14,81,250.00
Direct Labour $ 1,48,476.38 $ 2,96,952.76 $ 4,45,429.14 $ 5,93,905.53 $ 7,42,381.91 $ 8,90,858.29
Variable Factory Overhead $ 12,000.00 $ 24,000.00 $ 36,000.00 $ 48,000.00 $ 60,000.00 $ 72,000.00
Other Variable Manufacturing Costs $ 8,000.00 $ 16,000.00 $ 24,000.00 $ 32,000.00 $ 40,000.00 $ 48,000.00
Sales Commissions $ 25,000.00 $ 50,000.00 $ 75,000.00 $ 1,00,000.00 $ 1,25,000.00 $ 1,50,000.00
Variable Admin Costs $ 7,500.00 $ 15,000.00 $ 22,500.00 $ 30,000.00 $ 37,500.00 $ 45,000.00
Total Variable Costs $ 4,47,851.38 $ 8,95,702.76 $ 13,43,554.14 $ 17,91,405.53 $ 22,39,256.91 $ 26,87,108.29
Contribution Margin $ 52,148.62 $ 1,04,297.24 $ 1,56,445.86 $ 2,08,594.47 $ 2,60,743.09 $ 3,12,891.71
Contribution Margin less Fixed Costs $ (1,15,731.38) $ (63,582.76) $ (11,434.14) $ 40,714.47 $ 92,863.09 $ 1,45,011.71
Income Tax
State Tax $ - $ - $ - $ 4,071.45 $ 9,286.31 $ 14,501.17
Federal Tax $ - $ - $ - $ 2,035.72 $ 4,643.15 $ 7,250.59
Total Income Tax $ - $ - $ - $ 6,107.17 $ 13,929.46 $ 21,751.76
Profit $ (1,15,731.38) $ (63,582.76) $ (11,434.14) $ 34,607.30 $ 78,933.63 $ 1,23,259.95
Profit as a Percentage-23.15%-6.36%-0.76%1.73%3.16%4.11%
Break-Even Analysis Line Chart Data
Volumes in Units100200300400500600
Total Fixed Costs $ 1,67,880.00 $ 1,67,880.00 $ 1,67,880.00 $ 1,67,880.00 $ 1,67,880.00 $ 1,67,880.00
Total Costs $ 6,15,731.38 $ 10,63,582.76 $ 15,11,434.14 $ 19,65,392.70 $ 24,21,066.37 $ 28,76,740.05
Total Sales $ 5,00,000.00 $ 10,00,000.00 $ 15,00,000.00 $ 20,00,000.00 $ 25,00,000.00 $ 30,00,000.00
Inventory
Part CodeCategoryProduct DescriptionSupplierUnitPrice/UnitWeight (g)Weight (lbs)In StockReorder Qty
FR1323FramesetNashbar Carbon FrameNashbaritem$456.0012322.72270
FR1235FramesetJ&L ForkBikes Plusitem$244.204400.97310
FR2360FramesetJ&L PlugBikes Plusitem$11.187.70.02130
FR1934FramesetHeadsetBikes Plusitem$0.0071.40.16480
FR1080FramesetJ&L Top Cap & ScrewCycle Warehouseitem$4.258.70.02430
FR1081FramesetMr. Ride Seat ClampCycle Warehouseitem$18.569.80.02290
WH1100WheelsXR-270/Bitex WheelCycle Warehouseitem$161.036861.51440
WH2373WheelsVeloplugs Rim tapeLBSitem$6.663.90.01260
WH2942WheelsTitanium QR SkewersCycle Warehouseitem$5.3021.30.05400
WH2856WheelsForte LCR TyresPerformanceitem$21.832030.45260
WH1573WheelsForte Light TubesPerformanceitem$6.3367.40.15110
CO2357Contact PointsRockBros CrMo SaddleCycle Warehouseitem$21.39158.40.35050
CO1649Contact PointsKCNC Scandium SeatpostCycle Warehouseitem$80.101880.41470
CO2143Contact PointsSpacersBikes Plusitem$0.003.50.01360
CO2202Contact PointsUno 7050 StemCycle Warehouseitem$18.20104.50.23350
CO1099Contact PointsNashbar Carbon BarNashbaritem$66.24216.30.48430
CO1469Contact PointsGeneric Foam Tape TapeCycle Warehousecm$0.180.50.0065000
CO2904Contact PointsCustom Bar PlugsCycle Warehouseitem$0.812.20.00490
GR2589GroupsetUltegra LeversNashbaritem$117.702040.45300
GR1322GroupsetUltegra RDBackcountryitem$42.00175.50.39950
GR1172GroupsetUltegra FDNashbaritem$26.6897.90.22190
GR1836GroupsetUltegra CassetteNashbaritem$48.021950.43470
GR1215GroupsetDura Ace ChainNashbaritem$27.52184.30.41650
GR1751GroupsetCNC brakes 200g BrakesCycle Warehouseitem$96.901110.24100
GR2009GroupsetUltegra CranksNashbaritem$165.36564.21.24450
GR1406GroupsetUltegra BBBackcountryitem$15.1361.70.14260
GR1550GroupsetUltegra CablesNashbaritem$0.0051.30.11950
AC1508Accessories and tuningFairing M5 BoltsCycle Warehouseitem$0.461.10.00250
AC1945Accessories and tuningAlloy CR BoltsCycle Warehouseitem$2.280.30.00240
AC2733Accessories and tuningTitanium Stem BoltsCycle Warehouseitem$11.1611.90.03410
AC2964Accessories and tuningGeneric FD AdapterCycle Warehouseitem$2.6122.80.05190
AC1914Accessories and tuningNashbar Alpe d Huez PedalsNashbaritem$11.2096.80.21190
AC2716Accessories and tuningGreaseCycle Warehousegrams$0.090.20.00410
GR1432GroupsetNashbar LeversNashbaritem$126.00214.60.47050
GR1770GroupsetNashbar RDNashbaritem$51.15191.10.42200
GR1966GroupsetNashbar FDNashbaritem$34.5672.10.16300
GR2655GroupsetNashbar CassetteNashbaritem$52.65207.80.46360
AC2170Accessories and tuningRockBros S60 PedalsCycle Warehouseitem$22.9697.90.22190
WH1260WheelsCNC V18 Ultra WheelsCycle Warehouseitem$131.206511.44240
WH2778WheelsCNC V16 Super Slim WheelsCycle Warehouseitem$192.606661.47410
CO1688Contact PointsSpecialised Foam Tape TapeCycle Warehousecm$0.170.50.00440

Buy Accg200 Cost Volume Profit Analysis Assessment Answers Online


Talk to our expert to get the help with Accg200 Cost Volume Profit Analysis Assessment Answers to complete your assessment on time and boost your grades now

The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.


Get Online Support for Accg200 Cost Volume Profit Analysis Assessment Answers Assignment Help Online


Copyright © 2009-2023 UrgentHomework.com, All right reserved.