Question

In: Accounting

The annual planning process at Century Office Systems, Inc. had been arduous but produced a number...

The annual planning process at Century Office Systems, Inc. had been arduous but produced a number of important marketing initiatives for the next year. Most notably, company executives had decided to restructure its product-marketing team into two separate groups: (1) Corporate Office Systems and (2) Home Office systems. Angela LeBlanc was assigned responsibility for the Home Office Systems group, which would market the company’s multi-function imaging hardware and software for home and office-at-home use by individuals. Her marketing plan, which included a sales forecast for next year of $35 million, was the result of a detailed market analysis and negotiations with individuals both inside and outside the company. Discussions with the sales director indicated that 40 percent of the company sales force would be dedicated to selling products of the Home Office Systems group. Sales representatives would receive a 17 percent commission on sales of home office systems. Under the new organizational structure, the Home Office systems group would be charged with 40 percent of the budgeted sales force expenditure. The sales director’s budget for salaries and fringe benefits of the sales force and non-commission selling costs for both the Corporate and Home Office Systems groups was $10.5 million. The advertising and promotion budget contained three elements: trade magazine advertising, cooperative newspaper advertising with Century Office Systems, Inc. dealers, and sales promotion materials including product brochures, technical manuals, catalogs, and point-of-purchase displays. Trade magazine ads and sales promotion materials were to be developed by the company’s advertising and public relations agency. Production and media placement costs were budgeted at $400,000. Cooperative advertising copy for both newspaper and radio use had budgeted production costs of $175,000. Century Office Systems, Inc.’s cooperative advertising allowance policy stated that the company would allocate 5 percent of company sales to dealers to promote its office systems. Dealers always used their complete cooperative advertising allowances. Meetings with manufacturing and operations personnel indicated that the direct costs of material and labor and direct factory overhead to produce the Home Office System product line represented 50 percent of sales. The accounting department would assign $600,000 in indirect manufacturing overhead (for example, depreciation, maintenance) to the product line and $550,000 for administrative overhead (clerical, telephone, office space, and so forth). Freight for the product line would average 8 percent of sales. 6 LeBlanc’s staff consisted of two product managers and a marketing assistant. Salaries and fringe benefits for Ms. LeBlanc and her staff were $500,000 per year.

a. Prepare a pro forma income statement for the Home Office Systems group given the information provided.

b. Prepare a pro forma income statement for the Home Office Systems group given annual sales of only $20 million.

c. At what level of dollar sales will the Home Office Systems group break even?

Solutions

Expert Solution


Related Solutions

The annual planning process at Century Office Systems, Inc. had been arduous but produced a number...
The annual planning process at Century Office Systems, Inc. had been arduous but produced a number of important marketing initiatives for the next year. Most notably, company executives had decided to restructure its product-marketing team into two separate groups: (1) Corporate Office Systems and (2) Home Office Systems. Angela Blake was assigned responsibility for the Home Office Systems group, which would market the company's word-processing hardware and software for home and office-at-home use by individuals. Her marketing plan, which included...
In the past century, there have been a number of different exchange rate systems within the...
In the past century, there have been a number of different exchange rate systems within the international monetary system, representing the range between fixed-rate and free-float. Based on the lessons learned, as evidenced in your text and class discussions, which of the 10 exchange rate arrangements defined by the International Monetary Fund (see Exhibit 2.4 in your textbook) do you believe is the most sustainable long-run exchange rate system given current global economic conditions? Defend your choice, identifying which types...
What is the key role of the office administrator in the strategic planning process? What are...
What is the key role of the office administrator in the strategic planning process? What are the perspectives used in a balanced scorecard?
1. T F The number of defects on a product produced by a process is distributed...
1. T F The number of defects on a product produced by a process is distributed as a Poisson distribution. 2. T F For large binomially distributed populations and small samples you can use sampling without replacement 3. T F Given a triangular distribution with minimum 2, maximum 8 and mode 7, the probability of being smaller than 7 is greater than 60% 4. T F The hypergeometric distribution describes sampling without replacement 5. T F The relative frequency of...
Scenario: A patient presents to the office for her annual physical.  During the Review of Systems (ROS)...
Scenario: A patient presents to the office for her annual physical.  During the Review of Systems (ROS) portion of the physical, the patient reveals that she has had periodic shortness of breath, primarily during exertive activities.  The patient also stated her level of physical activity is minimal to none and she described her diet as “take out or from freezer.”  Based off this scenario and the following lab results, answer the questions: Diagnostic / Lab Results Date Type Notes Provider Verified 12/17/2008 Path/Lab...
Scenario: A patient presents to the office for her annual physical.  During the Review of Systems (ROS)...
Scenario: A patient presents to the office for her annual physical.  During the Review of Systems (ROS) portion of the physical, the patient reveals that she has had periodic shortness of breath, primarily during exertive activities.  The patient also stated her level of physical activity is minimal to none and she described her diet as “take out or from freezer.”  Based off this scenario and the following lab results, answer the questions: Diagnostic / Lab Results Date Type Notes Provider Verified 12/17/2008 Path/Lab...
Century Inc. had three types of items in inventory, A, B, and C. Data pertaining to...
Century Inc. had three types of items in inventory, A, B, and C. Data pertaining to these items are given below:                                                                      A                               B                C____                Cost                                                     $28,400                    $35,000           $32,000 Replacement Cost                               29,000                 32,500             30,000 Selling Price                                          30,000                 40,000             50,000 Cost to complete and Sell                        4,000                   6,000               8,000 Normal Profit Margin as sale %              15%                     20%                  15% Required: 1.         Calculate the value of inventory under...
You have been hired by Patterson Planning Corp., an events planning company that recently had a...
You have been hired by Patterson Planning Corp., an events planning company that recently had a fire in which some of the accounting records were damaged. In reviewing the fixed asset records, you find three depreciation schedules that are not labeled. They are listed in the following table. One of the assets has a depreciation rate of $4.30 per hour. Year Schedule A Schedule B Schedule C 1 $8,000.00 $10,125.00 $8,600.00 2 4,800.00 13,500.00 6,450.00 3 2,880.00 13,500.00 7,310.00 4...
You have been hired by Patterson Planning Corp., an events planning company that recently had a...
You have been hired by Patterson Planning Corp., an events planning company that recently had a fire in which some of the accounting records were damaged. In reviewing the fixed asset records, you find three depreciation schedules that are not labeled. They are listed in the following table. One of the assets has a depreciation rate of $4.40 per hour. Year Schedule A Schedule B Schedule C 1 $6,000.00 $10,125.00 $8,800.00 2 3,600.00 13,500.00 6,600.00 3 2,160.00 13,500.00 7,480.00 4...
You have been hired by Patterson Planning Corp., an events planning company that recently had a...
You have been hired by Patterson Planning Corp., an events planning company that recently had a fire in which some of the accounting records were damaged. In reviewing the fixed asset records, you find three depreciation The systematic periodic transfer of the cost of a fixed asset to an expense account during its expected useful life. schedules that are not labeled. They are listed in the following table. One of the assets has a depreciation rate of $4.50 per hour....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT