Futura Robotics - Journal Accounts - Accounting and Finance Assessment Answer

 Accounting and Finance Assessment Answer

Assessment Task:

Scenario
Futura robotics manufacture custom made robotic components. Each job is unique and costs individually. You are required to create a spreadsheet that records a list of completed jobs and allows the company to cost up new jobs. 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 afterward, so type it in carefully) and then enter your Student Name.

General Guidelines
• With the exception of the Journal Accounts, which are to be selected from the drop-down list, all the light blue cells require you to insert some form of calculation or 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 any way or put any workings anywhere other than directed.

• Only use rounding functions were specifically requested.

• The use of named ranges and tables is encouraged, and where specified may be required. If not specifically required there will be no penalty for not using them, but it may make the formulas more difficult.

• Because you are developing a model that we will wish to use for future years/jobs 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 (e.g. Completed Jobs, & Inventory) are sorted in a different order.

• Double-check your answers as you go as one wrong result may affect other results.

• Remember to save often!

• When you are ready to submit, save, close and upload the correct completed Excel File to iLearn (Excel Submission). You do not need to rename the file as iLearn will automatically attach your student number but please ensure that it is an Excel file you submit, (Numbers files will not be accepted), that it is bigger than 1KB (means you’ve submitted the wrong file) and that there are no “non-English” characters in the file name as these files cannot be opened in an English version of Excel.
Detailed instructions are provided on the next pages. Please follow each of the instructions precisely.

This Accounting and Finance Assessment has been solved by our Accounting and Finance 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 distinction.