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 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,300 | $25,300 | ||
Allocated portion of: | ||||
Building depreciation | 10,500 | 10,500 | ||
Advertising | 4,800 | 3,900 | ||
Billing | 3,800 | 3,000 | ||
Property taxes | 1,100 | 1,200 | ||
Material and supplies | 1,300 | 1,400 | ||
Supervisory salaries | 8,900 | 9,100 | ||
Insurance | 4,400 | 3,200 | ||
Wages | 2,700 | 3,100 | ||
Gas and oil | 2,300 | 3,200 | ||
Equipment depreciation | 1,400 | 1,300 |
(a)
Prepare a responsibility report for the first quarter of 2017 for
the Home Internet Service segment.
CULVER COMPANY Home Internet Services Segment Responsibility Report For the Month Ended March 31, 2017For the Quarter Ended March 31, 2017For the Year Ended March 31, 2017 |
|||||||
Difference |
|||||||
|
|
Favorable |
|||||
Controllable MarginContribution MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
$ | $ | $ |
UnfavorableNeither Favorable nor UnfavorableFavorable |
|||
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 |
Neither Favorable nor UnfavorableFavorableUnfavorable |
||||||
Contribution MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
FavorableNeither Favorable nor UnfavorableUnfavorable |
||||||
Contribution MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
FavorableUnfavorableNeither Favorable nor Unfavorable |
||||||
Contribution MarginEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
FavorableUnfavorableNeither Favorable nor Unfavorable |
||||||
Contribution MarginEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
UnfavorableFavorableNeither 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 CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
UnfavorableFavorableNeither Favorable nor Unfavorable |
||||||
Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
UnfavorableNeither Favorable nor UnfavorableFavorable |
||||||
Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsTotal Variable CostsVariable CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
FavorableUnfavorableNeither Favorable nor Unfavorable |
||||||
Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
FavorableUnfavorableNeither Favorable nor Unfavorable |
||||||
Controllable MarginControllable Fixed CostsEquipment DepreciationGas and OilInsuranceMaterial and SuppliesService RevenueSupervisory SalariesTotal Controllable Fixed CostsWagesBuilding DepreciationAdvertisingBillingProperty Taxes |
$ | $ | $ |
UnfavorableNeither Favorable nor UnfavorableFavorable |
CULVER COMPANY | ||||
Home Internet Services Segment | ||||
Responsibility Report | ||||
For the Quarter Ended March 31, 2017 | ||||
Budget | Actual | Difference Favorable F Unfavorable U | ||
Service Revenue | $ 25,300.00 | $ 25,300.00 | $ - | Neither Favorable nor Unfavorable |
Variable costs: | ||||
Material and supplies | $ 1,300.00 | $ 1,400.00 | $ 100.00 | Unfavorable |
Wages | $ 2,700.00 | $ 3,100.00 | $ 400.00 | Unfavorable |
Gas and oil | $ 2,300.00 | $ 3,200.00 | $ 900.00 | Unfavorable |
Total variable costs | $ 6,300.00 | $ 7,700.00 | $ 1,400.00 | Unfavorable |
Contribution margin | $ 19,000.00 | $ 17,600.00 | $ 1,400.00 | Unfavorable |
Controllable fixed costs: | ||||
Supervisory salaries | $ 8,900.00 | $ 9,100.00 | $ 200.00 | Unfavorable |
Insurance | $ 4,400.00 | $ 3,200.00 | $ 1,200.00 | Favorable |
Equipment depreciation | $ 1,400.00 | $ 1,300.00 | $ 100.00 | Favorable |
Total controllable fixed costs | $ 14,700.00 | $ 13,600.00 | $ 1,100.00 | Favorable |
Controllable margin | $ 4,300.00 | $ 4,000.00 | $ 300.00 | Unfavorable |
Culver Company is a newly formed company specializing in high-speed Internet service for home and business. The owner, L...
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...
Please explain everything you do Exercise 14-11 Riverbed 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...
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...
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...
Ana Carillo and Associates is a medium-sized company located near a large metropolitan area in the Midwest. The company manufactures cabinets of mahogany, oak, and other fine woods for use in expensive homes, restaurants, and hotels. Although some of the work is custom, many of the cabinets are a standard size. One such non-custom model is called Luxury Base Frame. Normal production is 1,000 units. Each unit has a direct labor hour standard of 5 hours. Overhead is applied to...
1) Stefani Company has gathered the following information about its product. Direct materials: Each unit of product contains 4.50 pounds of materials. The average waste and spoilage per unit produced under normal conditions is 1.50 pounds. Materials cost $3 per pound, but Stefani always takes the 5.00% cash discount all of its suppliers offer. Freight costs average $0.30 per pound. Direct labor. Each unit requires 1.70 hours of labor. Setup, cleanup, and downtime average 0.20 hours per unit. The average...