| Subject Code : | ACCG2000 | Country : | Australia |
|---|
Assignment Task:
Scenario
JJ Cycles Ltd produces two high-end bicycle products at two different factories. They need you to create a spreadsheet that can conduct a Cost Volume Profit Analysis for a selected product line. You can assume that sales price, fixed costs, and variable cost per unit are constant. 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 unit 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 and 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. Please note the first 3 worksheets are locked and you will only be able to change the cells specified.
General Guidelines
• All the light grey cells require you to insert a calculation or a cell reference, 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 requested.
• The use of named ranges is encouraged, and in certain cases required but unless stipulated calculations do not need to use named ranges.
• Please do NOT create tables other than where directed.
• Because you are developing a model that we may wish to use for future product lines with different values it is very important that all calculations 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 other results.
This ACCG2000: Accounting and Finance Assignment has been solved by our Accounting and Finance Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
