In: Accounting
Puget Sound Divers is a company that provides diving services such as underwater ship repairs to clients in the Puget Sound area. The company’s planning budget for May appears below:
Puget Sound Divers Planning Budget For the Month Ended May 31 |
||||||||||||||||||||||||||||||
Budgeted diving-hours (q) | 300 | |||||||||||||||||||||||||||||
Revenue ($460.00q) | $ | 138,000 | ||||||||||||||||||||||||||||
Expenses: | ||||||||||||||||||||||||||||||
Wages and salaries ($11,800 + $128.00q) | 50,200 | |||||||||||||||||||||||||||||
Supplies ($6.00q) | 1,800 | |||||||||||||||||||||||||||||
Equipment rental ($2,500 + $21.00q) | 8,800 | |||||||||||||||||||||||||||||
Insurance ($3,900) | 3,900 | |||||||||||||||||||||||||||||
Miscellaneous ($530 + $1.44q) | 962 | |||||||||||||||||||||||||||||
Total expense | 65,662 | |||||||||||||||||||||||||||||
Net operating income | $ | 72,338 | ||||||||||||||||||||||||||||
|
Solution:
Flexible Budget is a budget prepared by taking the actual activity level achieved but at standard cost/price. It is useful to compare the budget with actual level.
q is taken as actual level of activity i.e. 290 diving hours and all the below calculation is based on standard price given in the question.
Puget Sound Drivers |
|
Flexible Budget |
|
For the Month Ended May 31 |
|
Flexible Budget |
|
Revenue ($460*290) |
$133,400 |
Expenses: |
|
Wages and salaries ($11,800 + 128*290) |
$48,920 |
Supplies (6*290) |
$1,740 |
Equipment Rental ($2,500 + $21*290) |
$8,590 |
Insurance ($3,900) |
$3,900 |
Miscellaneous ($530 + 1.44*290) |
$948 |
Total Expense |
$64,098 |
Net Operating Income |
$69,302 |
Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you