Morgan and Regis Consultants Is a Large,international Consulting Organization Required:
(A)As Director of Corporate Budgeting,you Are Required to Send

question 96

Essay

Morgan and Regis Consultants is a large,international consulting organization.The company provides consulting services in the computer and Internet areas.The company also has several divisions that provide manufacturing of various computer parts.The company has five divisions which are all profit centers.Each division includes allocated corporate costs in its annual budget.The budget for the coming year for the Building and Grounds Service department is $6,000,000.Included in this budget is the maintenance of all corporate buildings,depreciation,cleaning,insurance,and all other facility-related maintenance costs.The company uses a weighted method of allocating facility costs based on the type of space maintained by each division.Space ranges from manufacturing warehouses,which are least expensive to maintain,to computer mainframe space,which requires specialized temperature controls,air conditioning,and maintenance.The company has decided to use a weighting system assigning the following relative weights to each type of space: 1 for warehouse,3 for office,and 5 for computer space.Below,find data relating to the five divisions and the square footage of each type of space.Currently,Division 5,the Internet consulting division,is the largest in sales volume and profits for the company,which has been growing at the rate of 20% per year,while divisions 3 and 4 have been struggling due to declining margins on technology products. $$\begin{array} { | l | r | r r | r | } \hline & & {\quad\quad \text { Type of space } } & \\& \text { Office } & \text { Computer } & \text { Warehouse } & \text { Total } \\\hline \text { Weighting } & 3 & 5 & 1 & \\\hline \text { Dwision 1 } & 10000 & 0 & 0 & 10000 \\\hline \text { Dwision 2 } & 31000 & 10000 & 5000 & 46000 \\\hline \text { Dwision 3 } & 15000 & 12000 & 32000 & 59000 \\\hline \text { Dwision 4 } & 15000 & 10000 & 50000 & 75000 \\\text { Division 5 } & 30000 & 30000 & 0 & 60000 \\\hline \text { Total } & 101000 & 62000 & 87000 & 250000 \\\hline\end{array}$$ Required:
(a)As director of corporate budgeting,you are required to send to each division its facility allocation for the coming year.Prepare a schedule showing how the budget of $6,000,000 will be allocated to each division.(b)Describe potential motivational problems brought on by these allocations.(Based on an actual company)

---

Definitions:

Expression

In programming, a combination of variables, operators, and values that represents a single value or outcome.

Multivalued Lookup Field

A field in a database that can store multiple values for a single record, allowing for the creation of relationships between data in different tables.

Table Datasheet View

A view in database software that displays data in rows and columns, similar to a spreadsheet, allowing for easy data entry and management.

Check Box

An interactive graphical control element in forms and interfaces that allows users to make binary choices, typically represented by a square box that can be checked (selected) or unchecked.