Business Analysis and Interpretation

ACC10707 Session 2, 2018 Assessment 3 Questions
Business Analysis and Interpretation 

A garden      supply company has the following business transaction estimates relating      to the third quarter of 2018.

Credit Sales  160960
Cash Sales   122104
Receipts from Accounts Receivable  97546
Wages 60080
Office Furniture 12109
Prepayments   4722
Administrative Expense 18818
Depreciation on Office Furniture  1454
Depreciation on PPE  35000
Provision for doubtful debts  1454
Receipt of Loan 20000
Credit Purchases 85450 
Payments of Accounts Payable 69110
Accrued Wages and other expenses   9854 
Prepayments – Other  1597
The cash balance at 1 July 2018 was $106826.
Prepare a cash budget for the quarter ending 30 September 2018. (15 Marks). Note that 1 mark will be deducted for each incorrect posting to the cash budget.
2. The garden supply company is considering introducing various aged trees to their product range in 2019. They have provided the following information relating to its planned activities.
I year old2 years old 3 years old
Sales mix   245,000 125,000  75,000
Selling price  $15  $25  $40
Variable cost/unit  10  16  25
Total fixed cost = $351,900
a. Calculate the contribution margin, sales mix and weighted average cost margin for each product. Also calculate the break-even point in total units and units per product based on the 2019 data.    (15 marks) 
b. Management is concerned about competition for some of its trees, and wants to alter its sales mix of trees. The total number of trees forecast to be sold remains as per question 2a. This initiative would increase annual fixed costs by $60 000 and alter the sales mix to 40 percent for 1 year old trees, 30 per cent for 2 years old trees and 30 per cent for 3 years old trees . On the available data, would you recommend the initiative? Show workings.   (15 marks)
3. The garden supply company is also considering buying a small truck which costs $126 500 and is expected to earn annual net cash inflows of $63 400, $57 400, $47 000 and $39 900, before it wears out sufficiently to be unreliable and must be sold for an estimated $17 400. (15 Marks)
a. If funds can earn 5 per cent, what is the small trucks NPV?
b. If funds earn 8 per cent, what is the small trucks NPV?
c. Advise management on your recommendation regarding purchase of the small truck subsequent to your NPV calculations.
d. What advice would you give management if the required payback period was two years?
Show calculations for a, b and d.

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Order your essay today and save 25% with the discount code: COCONUTPlace Order