Tripton Ltd operates a package holiday company in Cardiff. The company has a reliable budgeting process from which the following information has been obtained:
| May | June | July | |
| Sales of holidays (units) | 500 | 800 | 1000 |
| Costs: | £ | £ | £ |
| Staff Salaries | 196,000 | 196,000 | 196,000 |
| Food | 7,500 | 12,000 | 15,000 |
| Administration costs | 40,000 | 40,000 | 40,000 |
| Repairs and maintenance | 40,000 | 64,000 | 80,000 |
| Depreciation on office equipment | 20,000 | 20,000 | 20,000 |
| Hotel costs | 75,000 | 102,000 | 120,000 |
| Office rent | 28,000 | 28,000 | 28,000 |
| Agents’ commission | 27,000 | 42,000 | 52,000 |
(a) Using the high-low method, calculate the linear cost equation in the form Y = a+bx for each semi-variable cost included in the budget above.
(10 marks)
(b) Using the linear cost equations, where appropriate, prepare the total budget for the month of August. The company is expecting to make sales of 1,400 holidays.
Click on Buy Solution and make payment. All prices shown above are in USD. Payment supported in all currencies. Price shown above includes the solution of all questions mentioned on this page. Please note that our prices are fixed (do not bargain).
After making payment, solution is available instantly.Solution is available either in Word or Excel format unless otherwise specified.
If your question is slightly different from the above question, please contact us at info@myassignmentguru.com with your version of question.