Eynesbury: Quantitative Methods for Business - Business Assignment Help

Assignment Task:

Question 1 – Interest & loan 
 
Sue will need $120,000 to refurbish her house at the corner of the main road into a cake shop in 5 years. She has a saving account which earns 3.47% p.a. compounding quarterly and she is able to deposit $800 into that account at the end of each month for 5 years.  

a) Will Sue have enough money after 5 years? If not, how much is in short? Show all calculations.

b) Even if Sue may not have enough money, she will consider taking a 9-year loan for the required amount because she is keen to have her own business. She talked to the lenders from her local Bank and Credit Union regarding loan options.

(i) The local bank charges 4.35% per year compounding biannually and requires biannually repayments. Calculate the minimum biannually repayment for both principal and interest that Sue would have to make on this loan. If you wish, use EXCEL to calculate the biannual repayment.

(ii)  Use EXCEL to set up an Amortisation Schedule for the loan. Include your completed EXCEL amortisation schedule. The schedule should include the amount of principal and the amount of interest that comprise each payment until the loan is paid off at the end of its term.

(iii) Use your amortisation schedule from part (ii) to calculate the total interest and the total amount paid over the life of the loan.

c) The Credit Union charges Sue 3.95 % p.a. compounding monthly and requires monthly repayments. Also, The Credit Union offers a two-year interest-only option with the 9-year loan. This means that for the first two years, every month Sue would pay only interest on the amount borrowed. Loan repayments consisting of both interest and principal would then commence in year three and continue for 7 years. 

(i) Calculate the monthly repayment that Sue would have to make starting in year three if she wants to pay off the loan in 9 years. If you wish, use EXCEL to calculate the monthly repayment.  EXCEL Instructions: Refer to your own notes taken in class and Topic 4 in the EXCEL booklet for instructions on how to use financial functions to make annuity calculations.

(ii) Calculate the total interest paid on the loan with the two-year interest-only option.

d) Which option should Sue take? As part of your response, you must explain why the option you select is the better of the two alternatives.

Question 2 – Superannuation  
Tom White has just started work at 18 years of age and intends to retire at 55. He will be saving $150 per month during his working life. He invests his money in a superannuation fund paying 8.5% p.a. compounding halfyearly. 

a) How much will he have in this fund when he retires? Provide a clear explanation of why you think this is a future/present value annuity question.

b) On retirement, Tom rolls this money over into an allocated pension paying 6.4% p.a. compounding fortnightly. Calculate how much per fortnight he could withdraw, if the pension were to last 15 years.

c) What is the outstanding balance after 10 years?

d) If an emergency withdrawal of an extra $25,000 was needed at the end of the 5th year, what effect would that have on how long the annuity would last?

Question 3 – Break-Even Analysis 
Cottage Industries Ltd makes baskets. The fixed costs of operating the workshop for a month total of $1,500. Each basket requires materials which cost $6. Each basket takes two hours to make and the business pays the basketmakers $9 an hour. The basketmakers are all on contracts that specify that if they do not work, for any reason, they are not paid. The baskets are sold to a wholesaler for $30 each. In addition, there is a fixed handling fee to all the wholesaler of $55. 

a) Break-even graph 
(i) What is the break-even number of orders? 
(ii) What is the corresponding break-even revenue? 
(iii) Draw a Break-even graph using EXCEL. Present appropriate calculations plus a copy of your EXCEL graph. Indicate on your graph the region corresponding to profits and the region corresponding to losses.

Cottage Industries Ltd expects to sell 500 baskets a month. The business has the opportunity to rent a basket making machine. Doing so would increase the total fixed costs of operating the workshop for a month to $6,000. Using the machine would reduce the labour time to one hour per basket. The basket-makers would still be paid $9 an hour. 

b) How much profit would the business make each month from selling baskets:  

(i) Assuming the business doest not rent the basket-making machine?
(ii) Assuming that it is rented?

c) What is the break-even point if the machine is rented? 

d) What do you notice about the figures you calculated?

Question 4 – What is the best solution? 
A small firm makes three similar animal feed mixes. Product A requires 5 hours of labour, 10 kg of raw material, 4 minutes of mixing using a mix-machine; product B requires 6 hours of labour, 8 kg of raw material, 2 minutes of mixing; and product C requires 4 hours of labour, 5 kg of raw material, 5 minutes of mixing. The firm has 210 hours available during the next period for labour, 200 kg of raw material, and 170 minutes for mixing. Product A contributes $28.40 per unit to profit, product B contributes $25.3 per unit, and product C contributes $27.4 per unit. Determine the optimal mix of products in terms of maximizing contribution to profits for the period.  
 
Requirements: 
a) Define the decision variables;
b) Show the business objective and objective function;
c) List all constraint equations;
d) Create an EXCEL working sheet for the linear programming model;
e) Provide both Answer and Sensitivity reports;
f) Find the range of optimality for the profit coefficient of each variable using the reports generated.

This Business Assignment has been solved by our Business 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.