Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,600 pounds of oysters in August. The company’s flexible budget for August appears below:
Quilcene Oysteria | ||
Flexible Budget | ||
For the Month Ended August 31 | ||
Actual pounds (q) | 7,600 | |
Revenue ($4.10q) | $ | 31,160 |
Expenses: | ||
Packing supplies ($0.35q) | 2,660 | |
Oyster bed maintenance ($3,300) | 3,300 | |
Wages and salaries ($2,200 + $0.40q) | 5,240 | |
Shipping ($0.75q) | 5,700 | |
Utilities ($1,230) | 1,230 | |
Other ($500 + $0.01q) | 576 | |
Total expense | 18,706 | |
Net operating income | $ | 12,454 |
The actual results for August appear below:
Quilcene Oysteria | ||
Income Statement | ||
For the Month Ended August 31 | ||
Actual pounds | 7,600 | |
Revenue | $ | 26,900 |
Expenses: | ||
Packing supplies | 2,830 | |
Oyster bed maintenance | 3,160 | |
Wages and salaries | 5,650 | |
Shipping | 5,430 | |
Utilities | 1,040 | |
Other | 1,196 | |
Total expense | 19,306 | |
Net operating income | $ | 7,594 |
Required:
Calculate the company’s revenue and spending variances for August. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
Revenue & Spending Variance = Difference between Flexible Budget and Actual results
Actual Result |
Revenue & Spending Variance |
Flexible Budget |
||||
No. of pounds |
7,600 |
7,600 |
||||
[A] |
[B = Difference between A & C] |
[C = Fixed + (Var x Actual units)] |
||||
Revenues |
$26,900 |
$4,260 |
U |
$31,160 |
||
Expenses: |
||||||
Packing supplies |
$2,830 |
$170 |
U |
$2,660 |
||
Oyster bed maintenance |
$3,160 |
$140 |
F |
$3,300 |
||
Wages & Salaries |
$5,650 |
$410 |
U |
$5,240 |
||
Shipping |
$5,430 |
$270 |
F |
$5,700 |
||
Utilities |
$1,040 |
$190 |
F |
$1,230 |
||
Other |
$1,196 |
$620 |
U |
$576 |
||
Total Expenses |
$19,306 |
$600 |
U |
$18,706 |
||
Net Operating Income |
$7,594 |
$4,860 |
U |
$12,454 |
||
Conceptual notes: |
#1: Flexible Budget data is based on 'budgeted rates' applied on 'actual level/output/units' |
#2: Spending Variance = Difference between 'Actual data' and 'Flexible Budget data' |
#3: Activity Variance = Difference between 'Flexible Budget data' and 'Static/Planned Budget data'. |
* Favourable Variance in case of Revenues occurs when: |
>Actual revenues are MORE than Flexible budget revenues [Spending Variance] |
>Flexible budget revenues are MORE than Static/Planned budget revenues [Activity Variance] |
* Unfavourable Variance in case of Revenues occurs when: |
>Actual revenues are LESS than Flexible budget revenues [Spending Variance] |
>Flexible budget revenues are LESS than Static/Planned budget revenues [Activity Variance] |
* Favourable Variance in case of Expenses/Costs occurs when: |
>Actual expenses/costs are LESS than Flexible budget expense/costs [Spending Variance] |
>Flexible budget expenses/costs are LESS than Static/Planned budget expenses/costs [Activity Variance] |
* Unfavourable Variance in case of Expenses/Costs occurs when: |
>Actual expenses/costs are MORE than Flexible budget expense/costs [Spending Variance] |
>Flexible budget expenses/costs are MORE than Static/Planned budget expenses/costs [Activity Variance] |
Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,600...
Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,600 pounds of oysters in August. The company’s flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (q) 7,600 Revenue ($4.10q) $ 31,160 Expenses: Packing supplies ($0.25q) 1,900 Oyster bed maintenance ($3,200) 3,200 Wages and salaries ($2,400 + $0.45q) 5,820 Shipping ($0.70q) 5,320 Utilities ($1,260) 1,260 Other ($450 + $0.01q) 526 Total expense 18,026 Net...
Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,700 pounds of oysters in August. The company’s flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (q) 7,700 Revenue ($4.10q) $ 31,570 Expenses: Packing supplies ($0.25q) 1,925 Oyster bed maintenance ($3,300) 3,300 Wages and salaries ($2,200 + $0.35q) 4,895 Shipping ($0.75q) 5,775 Utilities ($1,260) 1,260 Other ($470 + $0.01q) 547 Total expense 17,702 Net operating...
Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,600 pounds of oysters in August. The company's flexible budget for August appears below Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (q) 7,600 $ 31,160 Revenue ($4.10q) Expenses: Packing supplies ($0.35q) Oyster bed maintenance ($3,600) Wages and salaries ($2,200 $0.45q) Shipping ($0.65q) Utilities ($1,240) Other ($420 $0.01q) 2,660 3,600 5,620 4,940 1,240 496 18,556 $12,604 Total expense Net operating income...
Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,600 pounds of oysters in August. The company’s flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (q) 7,600 Revenue ($4.15q) $ 31,540 Expenses: Packing supplies ($0.25q) 1,900 Oyster bed maintenance ($3,100) 3,100 Wages and salaries ($2,100 + $0.50q) 5,900 Shipping ($0.75q) 5,700 Utilities ($1,290) 1,290 Other ($420 + $0.01q) 496 Total expense 18,386 Net operating...
Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,600 pounds of oysters in August. The company's flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 7,600 Actual pounds (g) Revenue (4.10q) Expenses: S 31,160 Packing supplies ($0.40g) Oyster bed maintenance ($3,000) Wages and salaries ($2,500 + $0.35g) Shipping ($0.60g) Utilities ($1,270) Other ($490 $0.01q) 3,040 3,000 5,160 4,560 1,270 566 17,596 13,564 Total expense Net operating...
Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,400 pounds of oysters in August. The company’s flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (q) 7,400 Revenue ($4.25q) $ 31,450 Expenses: Packing supplies ($0.35q) 2,590 Oyster bed maintenance ($3,300) 3,300 Wages and salaries ($2,100 + $0.40q) 5,060 Shipping ($0.60q) 4,440 Utilities ($1,210) 1,210 Other ($460 + $0.01q) 534 Total expense 17,134 Net operating...
Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,600 pounds of oysters in August. The company's flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (9) 7,600 $31,920 2,280 3,300 Revenue ($4.209) Expenses: Packing supplies ($0.300) Oyster bed maintenance ($3,300) Wages and salaries ($2,400 + $0.30g) Shipping ($0.709) Utilities ($1,220) Other ($430 + $0.019) Total expense Net operating income 4,680 5, 320 1,220 506...
Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,500 pounds of oysters in August. The company’s flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (q) 7,500 Revenue ($4.15q) $ 31,125 Expenses: Packing supplies ($0.35q) 2,625 Oyster bed maintenance ($3,300) 3,300 Wages and salaries ($2,500 + $0.30q) 4,750 Shipping ($0.65q) 4,875 Utilities ($1,280) 1,280 Other ($400 + $0.01q) 475 Total expense 17,305 Net operating...
Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,200 pounds of oysters in August. The company’s flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (q) 7,200 Revenue ($4.25q) $ 30,600 Expenses: Packing supplies ($0.35q) 2,520 Oyster bed maintenance ($3,400) 3,400 Wages and salaries ($2,200 + $0.30q) 4,360 Shipping ($0.75q) 5,400 Utilities ($1,220) 1,220 Other ($480 + $0.01q) 552 Total expense 17,452 Net operating...
Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7000 pounds of oysters in August. The company's flexible budget for August appears below: The actual results for August appear below: Calculate the company's revenue and spending variances for August. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable and "None" for no effect. Input all amounts as positive values. Quilcene Oysteria Flexible Budget For the Month Ended August 31...