Cost Structure Breakeven Roundup Case Study - Law Assignment Help

Assignment Task

AFM Coursework - Pre-submission checklist: some hints and tips to double check before you press ‘submit’ This is not a comprehensive checklist, but should help you avoid some of the more common omissions or errors.
 

Data sheet Individual data: Double check you have brought forward the correct numbers when linking to your individual data set. Sometimes students can click on the wrong cell and bring in someone else’s figures. FAQ Have you read the FAQ in the assessment section of the learning room? Please ensure you have read this in case it highlights something you may have done incorrectly. All Check excel formulas/linking. On every sheet other than the data sheet, go to the ‘formulas’ tab, click ‘show formulas’ and it will show the formulas in every cell on the page. Do this to check there are no numbers typed in any of the number cells. They should all be formulas or links to other sheets. A brief look should be sufficient to check there are no numbers typed in there anywhere. Put your setting back to normal page view once done (by clicking the ‘show formulas’ button again to deselect it). All Formatting: Check your formats are clear and professional. Consistent use of decimal places, thousand comma separators, titles with underlining & bold, size of fonts appropriate to the text, tables with bold totals and underlining, brackets used for negative numbers, etc. Cost structure Variable vs Fixed costs: Remember to distinguish between variable costs (per item) and fixed costs (fixed for a period). Have a quick look to ensure this is sensible, is every variable cost a ‘cost per item’? Cost structure Fixed costs: Are your fixed costs for the full 6 month period? Make sure you include 6 months worth of fixed costs, not 1 month or a year or an hour. Cost structure What belongs here? Make sure you have not included anything which does not belong, such as capital costs. Check the depreciation video in the pre-work for week 2, and the interest video in the homework for week 2. Cost structure Breakeven roundup: Have you rounded up your breakeven quantity? It doesn’t matter if this leaves you with a small positive profit. You can’t sell part of a kit. Working capital Inventories roundings: On the inventories budget closing balance each month you need to use the ROUND function. You can’t have bits of a kit, they need to be whole items. Remember the ROUND function was covered in seminar week 1. (this is not the same as just showing a number to zero decimal places using formatting.) Working capital Credit terms: check you have applied your credit terms in the right way, and that the CASH PAID and CASH RECEIVED goes into the cash flow. The sales or purchases lines do not. (See seminar week 3&4)

Cash budget IF statements. Make sure you have used the IF function to determine your overdraft interest, and use the ROUND function on this interest line as well. There are marks for doing this. Remember that IF is also used to give a ‘management feeling’ or warning in words (FINE, ALERT etc) depending on whether or not you are overdrawn. There are marks for this too.

Profit predictions Check you have profit predictions for all 4 levels of production: best, worst, expected and breakeven. In addition calculate this for your target profit. Check you have calculated a margin of safety in units and percentage. There are marks for both.

Breakeven graph Number of lines. Read the question! How many lines does it ask you to put on your breakeven graph in this question? Check you have included them all.
Breakeven graph Graph format: Does it have title and axis labels? Does it have the breakeven point indicated? Does it have lines showing the margin of safety? Make sure you include everything the question asks for.

Written summary Guidance: Have you read the guidance notes in red in the template for the written commentary? Please do, and then check that your answer for each section has covered each of the points noted in the guidance, and answers each of the points in the question. Remember to remove the red guidance notes before submitting your commentary.

Written summary What if: Make sure you have done ‘what if’ analysis and included it in your written commentary. Just describe this in the commentary, you don’t need to import screenshots of excel analysis. If you change your master spreadsheet to calculate your ‘What if’, remember to change it back to the original data before you submit it!
Written summary Charts: Ensure you have imported your bar graph and your pie chart into the written summary to support your report. Refer to seminar week 1 if you have forgotten how to do this. Written summary

This Law Assignment has been solved by our Law experts at My Uni Paper. 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 distinctio.