ACCG200 Excel Assessment 代写 case study

  • 100%原创包过,高质量代写&免费提供Turnitin报告--24小时客服QQ&微信:273427
  • 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.
    ACCG200 Excel Assessment 代写 case study
    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.
    ACCG200 Excel Assessment 代写 case study