UrLink Company is a newly formed company specializing in
high-speed Internet service for home and business. The owner, Lenny
Kirkland, had divided the company into two segments: Home Internet
Service and Business Internet Service. Each segment is run by its
own supervisor, while basic selling and administrative services are
shared by both segments.
Lenny has asked you to help him create a performance reporting
system that will allow him to measure each segment’s performance in
terms of its profitability. To that end, the following information
has been collected on the Home Internet Service segment for the
first quarter of 2017.
Budgeted |
Actual |
|||
Service revenue | $25,000 | $26,700 | ||
Allocated portion of: | ||||
Building depreciation | 11,400 | 11,400 | ||
Advertising | 5,300 | 4,600 | ||
Billing | 3,700 | 3,100 | ||
Property taxes | 1,100 | 1,100 | ||
Material and supplies | 1,400 | 1,300 | ||
Supervisory salaries | 9,500 | 9,400 | ||
Insurance | 3,800 | 3,700 | ||
Wages | 3,200 | 3,300 | ||
Gas and oil | 2,300 | 3,500 | ||
Equipment depreciation | 1,400 | 1,100 |
Prepare a responsibility report for the first quarter of 2017 for
the Home Internet Service segment.
URLINK COMPANY |
|||||||
Difference |
|||||||
|
|
Favorable |
|||||
Controllable MarginContribution MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Controllable MarginContribution MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
$ |
$ |
$ |
UnfavorableFavorableNeither Favorable nor Unfavorable FavorableUnfavorableNeither Favorable nor Unfavorable |
|||
Contribution MarginEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Contribution MarginEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
|||||||
Contribution MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Contribution MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
Neither Favorable nor UnfavorableFavorableUnfavorable FavorableUnfavorableNeither Favorable nor Unfavorable |
||||||
Contribution MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Contribution MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
FavorableNeither Favorable nor UnfavorableUnfavorable UnfavorableNeither Favorable nor UnfavorableFavorable |
||||||
Contribution MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Contribution MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
FavorableNeither Favorable nor UnfavorableUnfavorable UnfavorableNeither Favorable nor UnfavorableFavorable |
||||||
Contribution MarginEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Contribution MarginEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
FavorableUnfavorableNeither Favorable nor Unfavorable UnfavorableNeither Favorable nor UnfavorableFavorable |
||||||
Contribution MarginEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Contribution MarginEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
UnfavorableNeither Favorable nor UnfavorableFavorable FavorableUnfavorableNeither Favorable nor Unfavorable |
||||||
Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
|||||||
Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
UnfavorableFavorableNeither Favorable nor Unfavorable FavorableUnfavorableNeither Favorable nor Unfavorable |
||||||
Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
UnfavorableFavorableNeither Favorable nor Unfavorable FavorableUnfavorableNeither Favorable nor Unfavorable |
||||||
Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
Neither Favorable nor UnfavorableFavorableUnfavorable FavorableUnfavorableNeither Favorable nor Unfavorable |
||||||
Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
UnfavorableNeither Favorable nor UnfavorableFavorable FavorableUnfavorableNeither Favorable nor Unfavorable |
||||||
Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
$ |
$ |
$ |
Neither Favorable nor UnfavorableFavorableUnfavorable |
Budget | Actual | variance | |
service revenue | 25000 | 26700 | 1700 F |
variable costs | |||
material and supplies | 1400 | 1300 | 100 F |
wages | 3200 | 3300 | 100 U |
gad and oil | 2300 | 3500 | 1200 U |
Total variable costs | 6900 | 8100 | 1200U |
contribution margin | 18100[25000-6900] | 18600[26700-8100] | 500[1700-1200] |
controllable fixed cost | |||
supervisor salaries | 9500 | 9400 | 100 F |
insurance | 3800 | 3700 | 100 F |
equipment depreciation | 1400 | 1100 | 300 F |
total controllable fixed cost | 14700 | 14200 | 500 F |
controllable margin | 3400[18100-14700] | 4400[18600-14200] | 1000[500+500] |
MARGIN/REVENUE ACTUAL > BUDGETED VARIANCE = FAVORABLE F
MARGIN / REVENUE ACTUAL < BUDGETED VARIANCE = UNFAVORABLE
COST ACTUAL< BUDGETED = FAVORABLE VARIANCE
COST ACTUAL> BUDGETED = UNFAVORABLE VARIANCE
UrLink Company is a newly formed company specializing in high-speed Internet service for home and business....
Culver Company is a newly formed company specializing in
high-speed Internet service for home and business. The owner, Lenny
Kirkland, had divided the company into two segments: Home Internet
Service and Business Internet Service. Each segment is run by its
own supervisor, while basic selling and administrative services are
shared by both segments.
Lenny has asked you to help him create a performance reporting
system that will allow him to measure each segment’s performance in
terms of its profitability. To...
The actual selling expenses incurred in March 2017 by Novak
Company are as follows.
Variable Expenses
Fixed Expenses
Sales commissions
$14,688
Sales salaries
$34,600
Advertising
10,476
Depreciation
6,600
Travel
6,924
Insurance
2,000
Delivery
3,552
(a)
Prepare a flexible budget performance report for March, assuming
that March sales were $173,100. Variable costs and their percentage
relationship to sales are sales commissions 8%, advertising 6%,
traveling 4%, and delivery 2%. Fixed selling expenses will consist
of sales salaries $34,600, Depreciation on delivery...
The actual selling expenses incurred in March 2017 by Novak
Company are as follows.
Variable Expenses
Fixed Expenses
Sales commissions
$14,688
Sales salaries
$34,600
Advertising
10,476
Depreciation
6,600
Travel
6,924
Insurance
2,000
Delivery
3,552
(a)
Prepare a flexible budget performance report for March, assuming
that March sales were $173,100. Variable costs and their percentage
relationship to sales are sales commissions 8%, advertising 6%,
traveling 4%, and delivery 2%. Fixed selling expenses will consist
of sales salaries $34,600, Depreciation on delivery...
Sarasota Company
Clothing Department
Budget Report
For the Month Ended October 31, 2017
Difference
Budget
Actual
Favorable
Unfavorable
Neither Favorable
nor Unfavorable
Sales in units
8,500
10,000
1,500
Favorable
Variable expenses
Sales commissions
$2,380
$2,600
$220
Unfavorable
Advertising expense
850
900
50
Unfavorable
Travel expense
3,910
3,500
410
Favorable
Free samples given out
1,615
1,100
515
Favorable
Total variable
8,755
8,100
655
Favorable
Fixed expenses
Rent
1,700
1,700
–0–
Neither Favorable nor Unfavorable
Sales salaries
1,000
1,000
–0–
Neither Favorable...
Lewis Company’s standard labor cost of producing one unit of
Product DD is 3.20 hours at the rate of $13.80 per hour. During
August, 41,200 hours of labor are incurred at a cost of $14.00 per
hour to produce 12,600 units of Product DD.
(a)
Compute the total labor variance.
Total labor variance
$
UnfavorableNeither favorable nor unfavorableFavorable
(b)
Compute the labor price and quantity variances.
Labor price variance
$
UnfavorableFavorableNeither favorable nor unfavorable
Labor quantity variance
$
UnfavorableNeither favorable...
The standard cost of Product B manufactured by Pharrell Company includes 2.7 units of direct materials at $6.20 per unit. During June, 26,700 units of direct materials are purchased at a cost of $6.05 per unit, and 26,700 units of direct materials are used to produce 9,800 units of Product B. (a) Compute the total materials variance and the price and quantity variances. Total materials variance $enter a dollar amount select an option Neither favorable nor unfavorableUnfavorableFavorable Materials price variance...
Torres Company accumulates the following summary data for the
year ending December 31, 2020, for its Water Division, which it
operates as a profit center: sales—$2,021,500 budget, $2,183,800
actual; variable costs—$1,001,600 budget, $1,044,200 actual; and
controllable fixed costs—$299,100 budget, $302,200 actual.
Prepare a responsibility report for the Water Division for the year
ending December 31, 2020.
TORRES COMPANY
Water Division
Responsibility Report
For the Year Ended December 31, 2020
Difference
Budget
Actual
Favorable
Unfavorable
Neither Favorable
nor Unfavorable
Select an...
During March 2020, Sheffield Tool & Die Company worked on
four jobs. A review of direct labor costs reveals the following
summary data.
Actual
Standard
Job Number
Hours
Costs
Hours
Costs
Total Variance
A257
210
$4,200
218
$4,360
$160
F
A258
440
10,120
429
8,580
1,540
U
A259
300
6,450
298
5,960
490
U
A260
120
2,280
112
2,240
40
F
Total variance
$1,910
U
Analysis reveals that Job A257 was a repeat job. Job A258 was a
rush order...
Exercise 10-15 (Video)
Horatio Inc. has three divisions which are operated as profit
centers. Actual operating data for the divisions listed
alphabetically are as follows.
Compute the missing amounts.
Operating Data
Women’s Shoes
Men’s Shoes
Children’s Shoes
Contribution margin
$302,400
$
(3)
$201,600
Controllable fixed costs
112,000
(4)
(5)
Controllable margin
(1)
100,800
106,400
Sales
672,000
504,000
(6)
Variable costs
(2)
358,400
280,000
Prepare a responsibility report for the Women’s Shoes Division
assuming (1) the data are for the month...
Horatio Inc. has three divisions which are operated as profit
centers. Actual operating data for the divisions listed
alphabetically are as follows.
Compute the missing amounts.
Operating Data
Women’s Shoes
Men’s Shoes
Children’s Shoes
Contribution margin
$363,420
$
(3)
$242,280
Controllable fixed costs
134,600
(4)
(5)
Controllable margin
(1)
121,140
127,870
Sales
807,600
605,700
(6)
Variable costs
(2)
430,720
336,500
Prepare a responsibility report for the Women’s Shoes Division
assuming (1) the data are for the month ended June 30,...