Acc10707 Garden Supply Company Answers Assessment Answers
- 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.
Required
Prepare a cash budget for the quarter ending 30 September 2018. Note that 1 mark will be deducted for each incorrect posting to the cash budget.
- 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 old 2 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
Required
- 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.
- 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.
- 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.
Required
- If funds can earn 5 per cent, what is the small trucks NPV?
- If funds earn 8 per cent, what is the small trucks NPV?
- Advise management on your recommendation regarding purchase of the small truck subsequent to your NPV calculations.
- What advice would you give management if the required payback period was two years?
Answer:
| Garden Supply Company | |||||||||
| Cash Budget | |||||||||
| For the quarter ending 30 September, 2018 | |||||||||
| Particulars | Amount ($) | ||||||||
| Opening balanace | 1,06,826 | ||||||||
| Add: Receipts | |||||||||
| Proceeds from cash sales | 1,22,104 | ||||||||
| Proceeds from receipt from accounts receivable | 97,546 | ||||||||
| Proceeds from receipt of loan | 20,000 | 2,39,650 | |||||||
| Less: Payments | |||||||||
| Payment for wages | 60,080 | ||||||||
| Payment for purchase of office furniture | 12,109 | ||||||||
| Payment for prepaid expenses | 4,722 | ||||||||
| Payment for administrative expense | 18,818 | ||||||||
| Payments to Accounts Payable | 69,110 | ||||||||
| Prepayments - Other | 1,597 | 1,66,436 | |||||||
| Closing balance | 1,80,040 | ||||||||
| (a) | Calculation of contribution margin: | ||||||||
| Contribution Margin = Sales - Variable Costs | |||||||||
| Particulars | Selling price | Variable cost/unit | Contribution margin | ||||||
| 1 year old | $15 | 10 | $5 | ||||||
| 2 years old | $25 | 16 | $9 | ||||||
| 3 years old | $40 | 25 | $15 | ||||||
| Calculation of sales mix: | |||||||||
| Particulars | Sales mix | Sales mix ratio | |||||||
| 1 year old | 2,45,000 | 0.55 | |||||||
| 2 years old | 1,25,000 | 0.28 | |||||||
| 3 years old | 75,000 | 0.17 | |||||||
| Calculation of weighted average cost margin for each product: | |||||||||
| Particulars | 1 year old | 2 years old | 3 years old | Total | |||||
| Sales mix | 2,45,000 | 1,25,000 | 75,000 | 4,45,000 | |||||
| Selling price | $15 | $25 | $40 | ||||||
| Variable cost/unit | 10 | 16 | 25 | ||||||
| Contribution margin | $5 | $9 | $15 | ||||||
| Weighted average contribution margin for each product | $2.75 | $2.53 | $2.53 | $7.81 | |||||
| Total contribution margin | $34,75,000 | ||||||||
| Less: Fixed expenses | $3,51,900 | ||||||||
| Total profit | $31,23,100 | ||||||||
| Weighted average cost margin for each product | $7.02 | ||||||||
| Calculation of break even point: | |||||||||
| Break even point (in units) | = | Fixed expenses / 7.81 | |||||||
| = | 351900 / 7.81 | ||||||||
| = | 45,058 | ||||||||
| Break even point (in units) product wise | |||||||||
| - 1 year old | = | (351900 / 7.81) x (245000 / 445000) | |||||||
| = | 24,807 | ||||||||
| - 2 years old | = | (351900 / 7.81) x (125000 / 445000) | |||||||
| = | 12,657 | ||||||||
| - 3 years old | = | (351900 / 7.81) x (75000 / 445000) | |||||||
| = | 7,594 | ||||||||
| (b) | Calculation of sales as per revised sales mix | ||||||||
| Particulars | 1 year old | 2 years old | 3 years old | ||||||
| New Sales Mix | 40% | 30% | 30% | ||||||
| Total sales | 4,45,000 | 4,45,000 | 4,45,000 | ||||||
| New Sales | $1,78,000 | $1,33,500 | $1,33,500 | ||||||
| New fixed cost | = | 351900 + 60000 | |||||||
| = | $ 4,11,900 | ||||||||
| Calculation of profit (loss) based on new sales mix | |||||||||
| Particulars | 1 year old | 2 years old | 3 years old | Total | |||||
| Sales mix | 1,78,000 | 1,33,500 | 1,33,500 | 4,45,000 | |||||
| Selling price | $15 | $25 | $40 | ||||||
| Variable cost/unit | 10 | 16 | 25 | ||||||
| Contribution margin | $5 | $9 | $15 | ||||||
| Total contribution margin | $8,90,000 | $12,01,500 | $20,02,500 | $40,94,000 | |||||
| Less: Fixed costs | $ 4,11,900 | ||||||||
| Total profit | $36,82,100 | ||||||||
| Profit as per existing sales mix | = | $31,23,100 | |||||||
| Increase in profit | = | 3682100 - 3123100 | |||||||
| = | $ 5,59,000 | ||||||||
| Advise: | |||||||||
| Since revised sales mix will increase the profit by $559,000, hence the management should opt for new initiative. | |||||||||
| (a) | Calculation of NPV of small truck, if funds can earn 5% | ||||||||
| Year | 0 | 1 | 2 | 3 | 4 | ||||
| Cash flows | -$ 1,26,500 | $ 63,400 | $ 57,400 | $ 47,000 | $ 57,300 | ||||
| PVF @ 5% | 1.00000 | 0.95238 | 0.90703 | 0.86384 | 0.82270 | ||||
| PV | -$ 1,26,500 | $ 60,381 | $ 52,063 | $ 40,600 | $ 47,141 | ||||
| NPV | = | ######## | |||||||
| (b) | Calculation of NPV of small truck, if funds can earn 8% | ||||||||
| Year | 0 | 1 | 2 | 3 | 4 | ||||
| Cash flows | -$ 1,26,500 | $ 63,400 | $ 57,400 | $ 47,000 | $ 57,300 | ||||
| PVF @ 8% | 1.00000 | 0.92593 | 0.85734 | 0.79383 | 0.73503 | ||||
| PV | -$ 1,26,500 | $ 58,704 | $ 49,211 | $ 37,310 | $ 42,117 | ||||
| NPV | = | ######## | |||||||
| (c) | Advise basis NPV | ||||||||
| Management should purchase the small truck as NPV is greater than zero in both the cases. | |||||||||
| (d) | Calculation of payback period | ||||||||
| Year | 0 | 1 | 2 | 3 | 4 | ||||
| Cash flows | -$ 1,26,500 | $ 63,400 | $ 57,400 | $ 47,000 | $ 57,300 | ||||
| Cumulative Cash flows | -$ 1,26,500 | -$ 63,100 | -$ 5,700 | $ 41,300 | $ 98,600 | ||||
| Payback period (in years) | = | 2.12 | |||||||
| Advise basis payback period | |||||||||
| The management should not purchase the truck as actual payback is 2.12 years and required payback is 2 years. | |||||||||
Buy Acc10707 Garden Supply Company Answers Assessment Answers Online
Talk to our expert to get the help with Acc10707 Garden Supply Company Answers Assessment Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
