Hi tutor, I have been assigned to develop a master budget for airline industry and the airline
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667119c2d508d_194667119c273217.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667119c3516ef_195667119c33eea5.jpg)
Hi tutor,
I have been assigned to develop a master budget for airline industry and the airline we have chosen is Qantas.
In master budget,I have to make following budgets,
1)Sales Budget
2)Production Budget
3)Component Usage Budget
4)Production Cost Budget
I am confused that how I start to work on master budget.To make sale and component budget,we need units,but airline provide service,so what I should consider as a unit.Hence,what for the component budget?
If you can share some template and way of starting, I would be obliged.
I am attaching excel sheet of data which I have extracted from balance sheet.It may help you to guide me.I am also attaching annual report of 2019.
Kindly,do share the template if you have and way of working so I can start.
I have seen some docs regarding templates of master budgets on airline industry on coursehero but I could not access.
Kindly,help me please.Thank You.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667119c3b428d_195667119c38bf8e.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667119c418096_196667119c4025ee.jpg)