Reference no: EM131322916
Budget Assignment
Refer to the City of Granston Case 11-3 at the end of Chapter 11. Using the ‘Current Year Q-3' data found in Exhibit 2 and Exhibit 3, create a project supply and materials budget based on the information in the case. Your budget must include a one page explanation on the importance of a materials supply budget and the impact of the budget on the supply organization.
City of Granston*
On November 25, Ted Barton, the new purchasing manager at the City of Granston in Canada, was considering a contract extension for two years for the supply of mineral aggregates (rock, sand, and gravel). The contract had to be signed within a week.
CITY OF GRANSTON
The City of Granston had an annual budget of $700 million and employed 9,000 people. There had been a steady population increase over the past two decades. The purchasing department consisted of three support staff, six buyers, and a manager. City budgets were usually adjusted annually to cover the cost of inflation.
THE AGGREGATE INDUSTRY
The city purchased about $3 million worth of aggregates for road construction and repairs and construction projects. The local mineral aggregate sector consisted of three major extracting and processing companies-Lamoulin, Richmond, and Atlantic-and several smaller ones. Lamoulin and Atlantic owned the two dominant concrete production facilities.
The local aggregate industry was near capacity with major construction projects underway and increased demand in export markets.
AGGREGATE PURCHASING
A request for quotation had been issued in 2000 for a three-year agreement for the supply of aggregates, with prices firm for the first three years. If the parties agreed, a two-year option was available, with prices being subject to inflation.
Lamoulin and Richmond were the only two bidders and each received about half of the total contract with each bidder quoting for separate components of the total aggregates contract (see Exhibit 1).
Page 311
EXHIBIT 1 A Selection of Mineral Aggregates Supplied by Lamoulin and Richmond
Prices include delivery and are in $Cdn based on annual estimated requirements.
* Lamoulin
** Richmond
On November 25, both Lamoulin and Richmond sent notice that they were willing to extend the current three-year contract to five years. Both wanted an increase of 2 percent to cover the increased cost of doing business. The suppliers were referring to the Consumer Price Index (CPI) clause in the agreement for price reviews. This clause allowed the supplier an annual price increase based on the change in the CPI. According to the city engineers' department, both suppliers had performed reasonably well during the past three years. Because of a significant slump in the local construction industry, both suppliers had voluntarily lowered their prices by about 3 percent after year one of the contract.
However, in the past few months the local economy had shown signs of revival.
TED BARTON
Ted Barton had become purchasing manager for the City of Granston after having worked in private industry as a supply manager for several decades. He had been selected because the city's administrators wished to integrate supply better into the overall decision processes and to help search for better value for the taxpayer's dollars. Shortly after arriving on his new job, Ted Barton hired a part-time professional to help him develop better metrics for the city's supply function. One of the metrics that concerned Ted was the city's price performance. Thus, he developed a representative basket of 128 city requirements for which the amount used appeared to vary little from year to year. For this basket he asked his assistant to develop a price index, going back three years, starting with a base of 100.0 (see Exhibit 2).
Ted's assistant also developed a list of key cost indicators based on published indices from a variety of sources (see Exhibit 3).
THE DECISION
Ted Barton wondered whether any of the metrics he had recently developed were relevant for his decision on whether to extend the current mineral aggregates contract.
Since a significant number of existing city contracts were also of the multiyear, extendable type, he believed his actions on the aggregate contract might have a bearing on how to deal with other requirements. Having only one week left, he wondered what action to take.
EXHIBIT 2 City of Granston Price Index for a 128-Item Basket of City Requirements
Page 312
EXHIBIT 3 Selected List of Key Cost Indicators
(Johnson, 07/2010, pp. 310-312)
Johnson, P. F., Leenders, M., Flynn, A. (07/2010). Purchasing and Supply Management, 14th Edition [VitalSource Bookshelf version].
Draw a state-transition diagram for a 2-bit up/down counter
: Think of the up/down counter of part A as a clocked sequential circuit of the form given in figure 4.15. Derive the truth table for the combinational logic, giving the next-state functions, N1 and N0, as functions of the present states, S1 and S0,..
|
If difference between two means is not significant
: If the difference between two means is not statistically significant, how certain are you that the independent variable really does not affect the dependent variable?
|
Collect the voice of the customer
: Investigate on the internet the various ways (interviews, focus groups, surveys, etc.) to collect the voice of the customer, and discuss the advantages and disadvantages of each method.
|
Analyze the leadership teams reaction to the failure
: Analyze the leadership team's reaction to the failure, and indicate whether the leadership took sufficient measures to deal with various stakeholder groups impacted by the failure. Provide support for the rationale.Take a position on whether the ..
|
Develop a price index and going back three years
: For this basket he asked his assistant to develop a price index, going back three years, starting with a base of 100.0 (see Exhibit 2).
|
Show state-transition table for the traffic light
: Show a state-transition diagram and a state-transition table for the traffic light. Let the input be the state of the buttons (1 if either button has been pushed, 0 otherwise), and assume that a clock pulse occurs once every 10 seconds. (In other ..
|
Assumption of risk play a part in the type of contract used
: How did assumption of risk play a part in the type of contract used? What type of contract was finally settled upon in this situation? Was this type of contract appropriate for this situation or was there a better type that should have been used?
|
Find out the all india cable demand for the year 2004
: Find out the all India cable demand for the year 2004 and monthly estimated sales of Bengal cables Company - The price factor was not considered important in forecasting all India demand for cables. Will the same be true in estimating demand for ..
|
Enterprise risk management-strategy execution-history-role
: 1. Review the company mission. Determine what is necessary to achieve this mission of a company. What are internal and external considerations for achievement? 2. Identify the risks to the considerations for achivement. In regard to assets, evaluat..
|