FMGT 2294
Assignment – Cost-Volume-Profit
Question 1
Crescent Corporation manufactures multi-function photocopiers that are sold through a network of independent sales agents. These sales agents sell a variety of products to businesses in addition to crescent’s photocopiers. The sales agents are paid a 19% commission on sales, and this commission rate was used when Crescent’s management prepared the following budgeted income statement for the coming year:
|
Sales |
$20,000,000 |
||
|
Cost of goods sold |
|||
|
Variable |
$11,200,000 |
||
|
Fixed |
1,400,000 |
12,600,000 |
|
|
Gross margin |
7,400,000 |
||
|
Selling and administrative expenses: |
|||
|
Commissions |
3,800,000 |
||
|
Fixed advertising expense |
400,000 |
||
|
Fixed administrative expense |
1,600,000 |
5,800,000 |
|
|
Operating income |
$1,600,000 |
||
Since the completion of the above statement, Crescent’s management has learned that the independent sales agents are demanding an increase in the sales commission rate to 22% of sales for the upcoming year. This would be the third increase in commissions in five years. As a result, Crescent management has decided to investigate the possibility of the hiring its own sales staff to replace the independent sales agents.
Crescent’s controller estimates the company will have to hire six salespeople to cover the current market area, and the total annual payroll cost of these employees will be about $350,000, including benefits. The salespeople will also be paid commissions of 12% of sales. Travel and entertainment expenses are expected to be $200,000 for the year. The company will also have to hire a sales manager whose salary and benefits will total approximately $100,000 per year. To make up for promotions that the independent agents have been running on behalf of Crescent, management believes the company’s budget for fixed advertising expenses will increase by $400,000.
Required:
Assuming sales of $20,000,000, construct a budgeted contribution-format income statement for the upcoming year for each of the following activities:
The independent sales agents commission remains unchanged at 19%
The independent sales agents commission increases to 22%
The company employs its own sales force
Calculate Crescent Corporation’s break-even point in sales revenue for the upcoming year assuming the following:
The independent sales agents commission remains unchanged at 19%
The independent sales agents commission increases to 22%
The company employs its own sales force
Refer to your answer to 1(b) above. If the company employs its own sales force, what level of of sales revenue would be necessary to generate the operating income the company would realize if sales are $20,000,000 and the company continues to sell through agents (at a 22% commission rate)?
Determine the sales revenue at which operating income would be the equal regardless of whether Crescent Corporation sells through sales agents ( at 22% commission rate) or employs its own sales force.
Would you recommend the company retain the sales agents at 22% commission or would you recommend that the company employ its own sales force? Provide a detailed explanation to support your recommendation.
In: Accounting
The Federal government (and state and local governments as well) calculate billable rate as:
Billable Rate = Wage Rate + (Approved Overhead + Indirect Costs) Factor x (Wage Rate)
Given the following business costs for the previous year submitted for review and approval to a Federal agency:
| Expense | Cost |
| Direct Labor | $200,000 |
| Vacation pay, profit sharing, health insurance, sick pay | $140,000 |
| Advertising Labor | $17,000 |
| Office Supplies | $25,000 |
| Insurance | $35,000 |
| Rent | $40,000 |
| Entertainment | $14,000 |
| Travel (after required adjustments) | $22,000 |
| Taxes (after required adjustments) | $28,000 |
| Utilities | $12,000 |
a) Determine the approval overhead for this business
b) Determine the billable rate for an engineer that is paid $50/hour.
In: Economics
You are an event management company. Your customers want you to create an event with the 'wow' factor was the brief given to you by North Cypriot Young Businessman Association who were looking to hold a conference followed by an evening of entertainment for 200 guest with overnight accommodation with Palm Beach Hotel. They are going to invite investors from Turkey to make them invest in North Cyprus by the means of Tourism. As an event management company what kind of solutions can you offer them. Design an event and make your customers happy. You have a 100.000 USD budget. Just give a tentative budget doesn’t have to be too detailed. -WRITE MAXIMUM 500 WORDS
In: Operations Management
In a typical hospital, the _________ typically generates between _________ of the revenue for the organization while accounting for 30 to 40% of the total expenses; a significant amount of the costs are related to the use of supplies.
Perioperative department, 50-60% | ||
Emergency room, 30-40% | ||
Intensive care unit, 60-70% | ||
Radiology department, 20-30% |
In: Nursing
Closing Statement Problem Answer the following
questions based upon the information provided herein. Assume you
negotiated the sale as a real estate broker and are entitled to a
six percent commission The offer and acceptance contract calls for
a sales price of $200,000. The buyer has tendered $2,000 for
earnest money. The buyer has received loan approval on an 80% loan
to value ratio loan. The property is presently encumbered with an
existing mortgage with a balance of $130,789.56. The interest on
the loan has been paid through May 31, 2017. The interest rate on
the mortgage is 4.5%. Closing date is to be June 20,2017. All
prorations are based on a 360 day year and 30 day month. The 2016
taxes have not been paid and the 2017 taxes are to be prorated
based on the 2016 taxes which were 52.5 mills on an assessed
valuation of $40,000. A homeowners insurance policy costing $1,200
for a one year period will be purchased by the buyer and paid at
closing. The owners title insurance costing $850, a deed
preparation fee of $60.00, and a termite policy costing $500.00 are
to be paid by the seller. Title insurance costing $950, a credit
report costing $60, and an appraisal fee of $450 will be paid by
the buyer. The buyer's loan fees include a 1 point origination fee
and $800 of additional costs. In addition, the following documents
will be recorded: 1-page deed, 15-page mortgage, and a 1-page
release deed. The broker's fee is payable at closing and revenue
stamps at the usual rate must be paid by the seller and buyer. The
closing fee of $500 will be split 50/50 between the buyer and
seller.
How much would be the sellers share of the revenue stamps?
how much is the total real estate commission paid by the seller?
In: Accounting
Develop a list of revenue streams for a NASCAR racing team.
In: Finance
In: Accounting
The value of a sports franchise is directly related to the amount of revenue that a franchise can generate. The file here represents the value in 2013 (in $millions) and the annual revenue (in $millions) for the 30 Major League Baseball franchises. (Data extracted from www.forbes.com/mlb-valuations/list.) Suppose you want to develop a simple linear regression model to predict franchise value based on annual revenue generated. What are the values for (1) the proportion of variation in value of a sports franchise that is explained by annual revenue , (2) the sum of squares Y , (3) the sum of squares predicted , (4) the sum of squares error , (5) the intercept A , (6) the slope b , (7) the predicted value of a sports franchise (in $millions) that generates $300 millions of annual revenue , and (8) the standard error of estimate ?
| Team | Revenue | Value |
| Baltimore | 206 | 618 |
| Boston | 336 | 1312 |
| Chicago White Sox | 216 | 692 |
| Cleveland | 186 | 559 |
| Detroit | 238 | 643 |
| Kansas City | 169 | 457 |
| Los Angeles Angels | 239 | 718 |
| Minnesota | 214 | 578 |
| New York Yankees | 471 | 2300 |
| Oakland | 173 | 468 |
| Seattle | 215 | 644 |
| Tampa Bay | 167 | 451 |
| Texas | 239 | 764 |
| Toronto | 203 | 568 |
| Arizona | 195 | 584 |
| Atlanta | 225 | 629 |
| Chicago Cubs | 274 | 1000 |
| Cincinnati | 202 | 546 |
| Colorado | 199 | 537 |
| Houston | 196 | 626 |
| Los Angeles Dodgers | 245 | 1615 |
| Miami | 195 | 520 |
| Milwaukee | 201 | 562 |
| New York Mets | 232 | 811 |
| Philadelphia | 279 | 893 |
| Pittsburgh | 178 | 479 |
| St. Louis | 236 | 716 |
| San Diego | 189 | 600 |
| San Francisco | 262 | 786 |
| Washington | 225 | 631 |
In: Statistics and Probability
The value of a sports franchise is directly related to the amount of revenue that a franchise can generate. The file here represents the value in 2013 (in $millions) and the annual revenue (in $millions) for the 30 Major League Baseball franchises. (Data extracted from www.forbes.com/mlb-valuations/list.) Suppose you want to develop a simple linear regression model to predict franchise value based on annual revenue generated. What are the values for (1) the proportion of variation in value of a sports franchise that is explained by annual revenue , (2) the sum of squares Y , (3) the sum of squares predicted , (4) the sum of squares error , (5) the intercept A , (6) the slope b , (7) the predicted value of a sports franchise (in $millions) that generates $300 millions of annual revenue , and (8) the standard error of estimate ?
| Team | Revenue | Value |
| Baltimore | 206 | 618 |
| Boston | 336 | 1312 |
| Chicago White Sox | 216 | 692 |
| Cleveland | 186 | 559 |
| Detroit | 238 | 643 |
| Kansas City | 169 | 457 |
| Los Angeles Angels | 239 | 718 |
| Minnesota | 214 | 578 |
| New York Yankees | 471 | 2300 |
| Oakland | 173 | 468 |
| Seattle | 215 | 644 |
| Tampa Bay | 167 | 451 |
| Texas | 239 | 764 |
| Toronto | 203 | 568 |
| Arizona | 195 | 584 |
| Atlanta | 225 | 629 |
| Chicago Cubs | 274 | 1000 |
| Cincinnati | 202 | 546 |
| Colorado | 199 | 537 |
| Houston | 196 | 626 |
| Los Angeles Dodgers | 245 | 1615 |
| Miami | 195 | 520 |
| Milwaukee | 201 | 562 |
| New York Mets | 232 | 811 |
| Philadelphia | 279 | 893 |
| Pittsburgh | 178 | 479 |
| St. Louis | 236 | 716 |
| San Diego | 189 | 600 |
| San Francisco | 262 | 786 |
| Washington | 225 | 631 |
In: Statistics and Probability
What are the economic drivers for revenue and profitability of a hospital, and what are the potential strategies to maximize profits and returns on investment??
In: Economics