the question is on picture i want answer in excel

In ACACT202A Management Accoux Final Exam Part B V3.pdf X *Homework Help - Q&A from Onl x job costing.doc X + X C a courses.highered.tafensw.edu.au/pluginfile.php/644935/question/questiontext/79709/22/97783/Final%20Exam%20Part%208%20V3.pdf Final Exam Part B V3.pdf 2 /4 C: Service industry, time period used to compute indirect-cost rates Visuals Pty Ltd produces annual reports and marketing materials for large companies. There are three categories of cost in its normal job-costing system: direct materials, direct labour and overhead (both variable and fixed), allocated on the basis of direct labour costs. B C D 1 Visuals has the following budgeted data for 2020: 3 Jan-Mar Total 4 Direct materials $ 450,000 $ 1,360,000 5 Direct labour costs S 300,000 S 500,000 Variable overhead costs as a 60% 6 percentage of direct labour cost 60% 7 Fixed overhead costs 300,000 $ 1,200,000 Visuals Pty Ltd prices each job at 120% of costs. The company has received an order labelled job 335, for 160,000 sales catalogues for the local shopping centre. Actual direct materials costs for this job are $16,000 and actual labour costs are $12,000. Required 1. Calculate the Fixed Overhead rate and Variable Overhead Rate when the Jan- Mar Quarter Budgets are used to allocate overhead costs. (2marks 2. Calculate the Fixed Overhead rate and Variable Overhead Rate when the Total Budgets are used to allocate overhead costs (2 marks) 3. Calculate the total cost of the invoice for job 335: (i). if it is completed in January-March 2020 and the budgeted overhead rate for that quarter is used to allocate overhead costs (2 Marks) + (ii). if it is completed in January-March 2020 and the budgeted overhead rate for the year is used to allocate overhead costs (2 Marks) 4. Recommend, with reasons, the method of costing jobs that is most suitable for pricing purposes at Visuals Pty Ltd. (2 Marks) Desktop OneDrive Bijay This PC Libraries Network Control Panel Recycle Bin 2:24 PM O Tuesday A & A V W EPIC PS 10-Nov-20