NOTE: To underscore the basic CVP relationships, the assignment material ignores income taxes unless stated otherwise.

©2016 DeVry/Becker Educational Development Corp. All Rights Reserved.

The table depicts CVP computations (revenues, variable costs, fixed costs, total costs, operating income, and contribution margin percentage) for four cases, and the student is to complete the missing amounts (noted as “Blank” here). The details of the table are as follows:
Case a
Case b
Case c
Case d

Revenues: 11,000,000 dollars
Fixed costs: 3,000,000 dollars
Variable costs: 7,500,000 dollars
| Production Range in Units | Fixed Costs | Variable Manufacturing Cost per Unit |
| 1–3,000 | $250,000 | $75 |
| 3,001–6000 | $350,000 | $50 |
| 6,001–10,000 | $750,000 | $25 |
| Country | Sales Price to Retail Outlets | Annual Fixed Costs | Variable Manufacturing Cost per Area Rug | Variable Marketing & Distribution Cost per Area Rug |
| Brazil | $250.00 | $7,500,000 | $45.00 | $10.00 |
| Italy | 250.00 | 5,000,000 | 65.00 | 15.00 |
| France | 250.00 | 9,000,000 | 55.00 | 20.00 |

The table depicts selling price, variable costs (manufacturing and marketing), and contribution margin for new customers and upgrade customers. The details of the table are as follows:
Selling price
Variable costs
Contribution margin

Revenues: 600,000 dollars
Cost of goods sold (all variable costs): 300,000 dollars
Gross margin: 300,000 dollars
Operating costs include the following:
Salaries fixed: 140,000 dollars
Sales commissions (12 percent of sales): 72,000 dollars
Depreciation of equipment and fixtures: 10,000 dollars
Store rent (3,500 dollars per month): 42,000 dollars
Other operating costs: 45,000 dollars
For a total of 309,000 dollars
Operating income: 9,000 dollar loss

The details of the spreadsheet are as follows:
Row 3 shows units sold in column D as 20,000
Row 4 shows revenues in column D as 200,000 dollars
Row 5 shows cost of goods sold
Row 6 shows variable manufacturing costs in column C as 110,000 dollars
Row 7 shows fixed manufacturing costs in column C as 40,000
Row 8 shows total cost of goods sold in column D as 150,000
Row 9 shows gross margin in column D as 50,000
Row 10 shows operating costs
Row 11 shows variable marketing costs in column C as 10,000 dollars
Row 12 shows fixed marketing and admin costs in column C as 20,000
Row 13 shows total operating costs in Column D as 30,000
Row 14 shows operating income in Column D as 20,000 dollars
| Monthly Number of Orders | Probability |
| 300,000 | 0.25 |
| 500,000 | 0.45 |
| 700,000 | 0.30 |

Airfare: 1,300 dollars
Hotel accommodations: 2,450 dollars
Meals: 900 dollars
Ground transportation: 100 dollars
Park tickets and other costs: 500 dollars
Total: 5,250 dollars

Lunch and snacks: 130 dollars
Educational supplies: 75 dollars
Other supplies (paper products, toiletries, etc.): 35 dollars
Total: 240 dollars

Rent: 2,100 dollars
Utilities: 400 dollars
Insurance: 250 dollars
Salaries: 1,400 dollars
Miscellaneous: 650 dollars
Total: 4,800 dollars

Variable cost (per bowl):
Direct materials: 3.00 dollars
Direct manufacturing labor: 8.00 dollars
Variable overhead (manufacturing, marketing, distribution, and customer service): 7.50 dollars
Total variable cost per bowl: 18.50 dollars
Fixed costs:
Manufacturing: 20,000 dollars
Marketing, distribution, and customer service: 194,500 dollars
Total fixed costs: 214,500 dollars
Selling price: 35.00 dollars
Expected sales, 22,000 units: 770,000 dollars
Income tax rate: 40 percent

Sales revenue (35 dollars per ornament): 420,000 dollars
Variable cost (20 dollars per ornament): 240,000 dollars
Contribution margin: 180,000 dollars
Fixed costs: 160,000 dollars
Operating income: 20,000 dollars

The details of the unit variable data and annual fixed costs are as follows:
Unit variable data (per pair of shoes)
Selling price: $60.00
Cost of shoes: $37.00
Sales commission: 3.00
Variable cost per unit: $40.00
Annual fixed costs
Rent: $30,000
Salaries: 100,000
Advertising: 40,000
Other fixed costs: 10,000
Total fixed costs: $180,000

Selling price: 7,000 dollars
Variable cost per engine: 2,000 dollars
Annual fixed costs: 5,560,000 dollars
Net income: 900,000 dollars
Income tax rate: 40 percent

The details of the costs and revenues either by using sales agents or by using own sales force are as follows:
Using Sales Agents
The details are given in two columns B and C
Row 5 shows revenues in column C as 35,200,000 dollars
Row 6 shows cost of goods sold
Row 7 shows variable in column B as 13,375,000 dollars
Row 8 shows fixed in column B as 4,125,000 and in column C as 17,500,000
Row 9 shows gross margin in column C as 17,700,000
Row 10 shows marketing costs
Row 11 shows commissions in column B as 7,040,000 dollars
Row 12 shows fixed costs in column B as 4,025,000 and in column C as 11,065,000.
Row 13 shows Operating income in column C as 6,635,000 dollars
Using Own Sales Force
The details are given in two columns D and E
Row 5 shows revenues in column E as 35,200,000 dollars
Row 6 shows cost of goods sold
Row 7 shows variable in column D as 13,375,000 dollars
Row 8 shows fixed in column D as 4,125,000 and in column E as 17,500,000
Row 9 shows gross margin in column E as 17,700,000
Row 10 shows marketing costs
Row 11 shows commissions in column D as 3,520,000 dollars
Row 12 shows fixed costs in column D as 7,545,000 and in column C as 11,065,000.
Row 13 shows Operating income in column C as 6,635,000 dollars

The table depicts the units sold, revenues at 28 dollars and 40 dollars per unit, variable costs at 18 dollars and 30 dollars per unit, contribution margins at 10 dollars and 20 dollars per unit for the standard carrier and deluxe carrier as well as the total units sold, revenues, variable costs, contribution margins, fixed costs, and operating income. The details of the table are as follows:
Units sold
Revenues at 28 dollars and 50 dollars per unit
Variable costs at 18 dollars and 30 dollars per unit
Contribution margins at 10 dollars and 20 dollars per unit
Fixed costs, total: 2,250,000 dollars
Operating income, total: 875,000 dollars

Ticket sales: 15,000 dollars
Cost of dinner: 16,000 dollars
Gross margin: 1,000 dollar loss
Invitations and paperwork: 2,500 dollars
Profit (loss): 3,500 dollar loss

Revenues: 5,000,000 dollars
Variable costs: 3,250,000 dollars
Fixed costs: 1,890,000 dollars
Operating income: negative 140,000 dollars

Peoria
The details are given in two columns B and C
Row 2 shows Selling price in column C as 150.00 dollars
Row 3 shows Variable manufacturing cost per unit in column B as 72.00 dollars
Row 4 shows Fixed manufacturing cost per unit in column B as 30.00 dollars
Row 5 shows Variable marketing and distribution cost per unit in column B as 14.00 dollars
Row 6 shows Fixed marketing and distribution cost per unit in column B as 19.00 dollars
Row 7 shows Total cost per unit in column C as 135.00
Row 8 shows Operating income per unit in column C as 15.00 dollars
Row 9 shows Production rate per day as 400 units
Row 10 shows Normal annual capacity usage as 240 days
Row 11 shows Maximum annual capacity as 300 days
Moline
The details are given in two columns D and E
Row 2 shows Selling price in column E as 150.00 dollars
Row 3 shows Variable manufacturing cost per unit in column D as 88.00 dollars
Row 4 shows Fixed manufacturing cost per unit in column D as 15.00 dollars
Row 5 shows Variable marketing and distribution cost per unit in column D as 14.00 dollars
Row 6 shows Fixed marketing and distribution cost per unit in column D as 14.50 dollars
Row 7 shows Total cost per unit in column E as 131.50
Row 8 shows Operating income per unit in column E as 18.50 dollars
Row 9 shows Production rate per day as 320 units
Row 10 shows Normal annual capacity usage as 240 days
Row 11 shows Maximum annual capacity as 300 days