Budgeting
| Hotel | Dining Room | Conference Centre | Total | |
| Capacity | 100 rooms | 100 seats | 200 seats | |
| Selling price/unit | £75 | £35 | £40 | |
| Material costs/unit | £5 laundry | £15 food | £5 refreshments | |
| Other variable costs/unit | £5 cleaning | £10 labour | £1 light & heat |
- Produce a budget that shows the contribution for each of the three services. Rank the three services as to the greatest contributions to profitability. What are the constraints?
- The marketing manager has asked your advice as to whether to accept EITHER 200 people attending a conference and staying for dinner in two sittings but with no hotel accommodation (which will make it very difficult to sell hotel rooms) OR to refuse the conference booking but to maintain the average 60% hotel occupancy, of which half use the dining room.
16.2 Jethro Turnbull Ltd is a privately owned business. It has budgeted for profits (after deducting depreciation of £35,000) of £125,000. Debtors are expected to increase by £20,000, inventory is planned to increase by £5,000 and creditors should increase by £8,000. Capital expenditure is planned of £50,000, income tax of £35,000 has to be paid and loan repayments are due totalling £25,000. What is the forecast cash position of Jethro Turnbull at the end of the budget year, assuming a current bank overdraft of £15,000?
WRITE THIS ESSAY FOR ME
Tell us about your assignment and we will find the best writer for your paper.
Get Help Now!16.3 Bridgeport PLC has produced the following summary profit budget and cash forecast for the next six months. What assumptions can you make about the business based on these figures? What questions would you want to ask in relation to the figures?
| Profit budget
(in £’000) |
Jan | Feb | Mar | Apr | May | Jun |
| Sales | 1000 | 1000 | 1000 | 2000 | 2000 | 2000 |
| Cost of sales | 400 | 400 | 400 | 800 | 800 | 800 |
| Gross profit | 600 | 600 | 600 | 1200 | 1200 | 1200 |
| Overheads | 350 | 350 | 350 | 350 | 350 | 350 |
| Net profit | 250 | 250 | 250 | 850 | 850 | 850 |
| Cash forecast
(in £’000) |
||||||
| Net profit | 250 | 250 | 250 | 850 | 850 | 850 |
| Capital expenditure | -100 | -250 | ||||
| Loan repayment | -400 | |||||
| Cash flow | 150 | 250 | 250 | 600 | 450 | 850 |
Budgetary Control
Hunter-gatherer Ltd produces Widgets. The table below shows the budget and actualunits sold together with standard costs and actual costs for materials andlabour used in the manufacture of Widgets.
Data for July 2008:
Units of finished Widgets sold
Standard material required
(kg per Widget)
Standard material costs per kg
Standard labour hours required
(hours per Widget)
Standard labour costs per hour
Budget
5000
1.5
£12.50
1.2
£14.00
Actual
4500
Actual materials used
1.7 (kg per Widget)
£13.00 Actual material cost per kg
Actual labour hours used
1.3 (hours per Widget)
£13.90 Actual labour cost per hour
Assume that the quantity of materials purchased and the quantity used are identical.
a. Produce a report that compares the original budget with actual costs formaterials and labour in July.
b. Produce a budget versus actual variance report using a flexible budget andcalculate the variances on that basis.
c. Calculate both usage and price variances for each of materials and labour.
d. Explain why variance analysis using a flexible budget may be helpful formanagement
Introducing our Online Essay Writing Services Agency, where you can confidently place orders for a wide range of academic assignments. Our reputable homework writing company specializes in crafting essays, term papers, research papers, capstone projects, movie reviews, presentations, annotated bibliographies, reaction papers, research proposals, discussions, and various other assignments. Rest assured, our content is guaranteed to be 100% original, as every piece is meticulously written from scratch. Say goodbye to concerns about plagiarism and trust us to deliver authentic and high-quality work.



