Attached is an excel spreadsheet with questions regarding CVP analysis and budgeting. Could i get some answers for these questions?

Macro Usage Macro Time / Day Assessment BUSS1030 Assignment 1D- Part 1 Student Name: Student Number: Name Sample 234148521 Jay Company provides the following information for their 4 production departments. Department #1 uses machine hours to allocate overhead, Department #2 uses units of production, Department #3 uses direct labour hours & Department #4 uses direct labour cost. Budgeted data Manufacturing overhead cost Units of production Machine hours Direct labour hours Direct labour cost Department #1 $525,000 25,000 15,000 6,000 $324,000 Department #2 $490,000 23,000 18,000 9,000 $264,000 Department #3 $530,000 25,000 11,000 11,000 $324,000 Department #4 $510,000 28,000 15,000 5,000 $360,000 Actual data Manufacturing overhead cost Units of production Machine hours Direct labour hours Direct labour cost Department #1 $457,600 23,280 11,620 8,810 $300,000 Department #2 $517,800 26,910 16,900 10,660 $331,200 Department #3 $524,000 20,170 13,100 10,460 $291,600 Department #4 $537,600 22,160 10,120 6,670 $301,200 REQUIRED: Calculate values for each of the Entry cells. Entry1 Predetermined overhead application rate Entry2 Overhead applied Entry3 Over or Under application of overhead (show under-applications as negative values) Entry4 Entry5 Entry6 Unprotected cells for workings. Entry7 Entry8 Entry9 Entry10 Entry11 Entry12 BUSS1030 Assignment 1D - Part 2 Stroman Company has just published financial results for the current year. The managing director is pleased to report that Stroman's return on assets (ROA) has increased from 10% last year to 14% for the current year. Required: Complete the following table - indicating with reasons how Stroman's ROA would be effected by each of the following events. Collections from customers are normally 0% in the month of sale, and 0% in the second month following the sale. The balance is expected to be uncollectable. All purchases are on account. Management takes full advantage of the 0% discount allowed on purchases paid for by the 10th of the following month. Event (a) Increase in sales Will ROA ... (1) Increase (2) Decrease (3) Either or (4) No effect (b) Decrease in gross profit margin What effect on ROA ? (c) Increase in inventory turnover rate What effect on ROA ? Use the above list-box to provide your choice. Use the above list-box to provide your choice. (e) Repayment of bank loan Your reason / explanation / assumption here. Your reason / explanation / assumption here. Your reason / explanation / assumption here. What effect on ROA ? Use the above list-box to provide your choice. Your reason / explanation / assumption here. What effect on ROA ? Use the above list-box to provide your choice. Cash disbursements for expenses are expected to be $Your reason / explanation / assumption here. for the month of May. The company's cash balance on 1 January was $. Increase Decrease Either increase or decrease No effect What effect on ROA ? Use the above list-box to provide your choice. (d) Decrease in time to collect debtors Purchases for May are budgeted at $ and sales for May are forecasted at $. Reason / Explanation for Indicated Effect and Qualifying Assumption (if needed) Your reason / explanation / assumption here. BUSS1030 Assignment 1D - Part 3 Navajo Trucking (NT) trucks cattle around Australia. Marcus Torsman provides the following information on a potential contract with an association of cattle stations in the Northern Territory. Driver wages per truckload $1,391 Diesel costs per truckload $1,616 Desired before tax profit $55,000 A requirement of the association contract is the use of customised association livestock trailers provided by an Alice Springs dealer. Immediate payment of the full contract amount of $35,000 is not required. The dealer will take payment \"per truckload\" for each of the first 100 truckloads. The unique nature of the association contract has prompted NT's purchase of a policy for 2016. NT will also pay a fee for accidental death during shipping of You have been asked to provide an analysis of the contract & Marcus's proposed bid of per head of cattle. The association assures NT that all truckloads will comprise exactly safety reasons (i.e. both over-loading and under-loading is dangerous). $4,000 insurance $9 per animal. $190 per head 60 cattle for Required: (a) Calculate the contribution margin for each truckload of cattle. Entry1 (b) Calculate the fixed costs for NT for accepting the association contract Entry2 (c) Use your calculations from (a) and (b) to provide a single value to assist analysis Entry3 of the financial feasibility of the association contract. (d) Explain why your choice for Entry3 for Required (c) is appropriate. Your reason / explanation / assumption here. Unprotected cells for workings