Question

In: Operations Management

The Donald Fertilizer Company produces industrial chemical fertilizers. The projected manufacturing requirements (in thousands of gallons)...

The Donald Fertilizer Company produces industrial chemical fertilizers. The projected manufacturing requirements (in thousands of gallons) for the next four quarters are 80, 50, 80, and 130, respectively. A level workforce is desired, relying only on anticipation inventory as a supply option. Stockouts and backorders are to be avoided, as are overtime and undertime.

a. Determine the quarterly production rate required to meet total demand for the year, and minimize the anticipation inventory that would be left over at the end of the year. Beginning inventory is zero.

b. Specify the anticipation inventory that will be produced.

c. Suppose that the requirements for the next four quarters are revised to 80, 130, 50, and 80, respectively. If total demand is the same, what level of production rate is needed now, using the same strategy as part (a)?

Please use excel solution and post the table in formula auditing mode as well so that I may see how the cells were solved. Thank you!

Solutions

Expert Solution

Total Demand = 80 + 50 + 80 + 130 = 340

Level Production = Total Demand / No. of Quarters = 340 / 4 = 85

Hence,

a) Answer = 85

b) We find the anticipation inventory as shown below:

The above table in the form of formulas is shown below for better understanding and reference:

As seen from above, Ending Inventory = Beginning Inventory + Production - Demand

c) Total Demand = 80 + 130 + 50 + 80 = 340

We prepare a table as shown below:

Since there is a shortage in Quarter 2, the new level of production = Total Demand in 1st 2 period / No of periods = (80 + 130) / 2 = 105. This will be the level of production. We get the revised table as:

Answer: 105

-----------------------------------------------------------------------------------------------------------------------

In case of any doubt, please ask through the comment section before Upvote/downvote.

If you liked the answer, please give an upvote. This will be quite encouraging for me, thank-you!!!


Related Solutions

The Watkins Chemical Company produces a chemical compound that is used as a lawn fertilizer. The...
The Watkins Chemical Company produces a chemical compound that is used as a lawn fertilizer. The compound can be produced at a rate of 10,533 pounds per day. Demand for the compound is 0.9 million pounds per year. The fixed cost of setting up for a production run of the chemical is $2,773, and the variable cost of production is $3.23 per pound. The annual holding cost per pound of the chemical amounts to 5% of the value. Assume that...
Valdosta Chemical Company manufactures two industrial chemical products in a joint process. In May, 10,000 gallons...
Valdosta Chemical Company manufactures two industrial chemical products in a joint process. In May, 10,000 gallons of input costing $60,000 were processed at a cost of $150,000. The joint process resulted in 8,000 pounds of Resoline and 2,000 pounds of Krypto. Resoline sells for $25 per pound, and Krypto sells for $50 per pound. Management generally processes each of these chemicals further in separable processes to produce more refined chemical products. Resoline is processed separately at a cost of $5...
A chemical company produces a special industrial chemical that is a blend of three chemical ingredients....
A chemical company produces a special industrial chemical that is a blend of three chemical ingredients. The beginning-year cost per pound, the ending-year cost per pound, and the blend proportions follow. (Round your answers to the nearest integer.) Cost per Pound ($) Ingredient Beginning Ending Quantity (pounds) per 100 Pounds of Product A 1.50 3.45 25 B 8.75 9.90 10 C 0.99 0.90 70 (a) Compute the price relatives for the three ingredients. Item Price Relative A B C (b)...
Variance Company produces Chemical Y. It budgeted to produce 10,000 gallons of Chemical Y in fiscal...
Variance Company produces Chemical Y. It budgeted to produce 10,000 gallons of Chemical Y in fiscal year 2006. It actually produced 11,000 gallons. The production process for Chemical Y has two principal ingredients, Mystery Material M and labor. To produce 1 gallon of Chemical Y under budget requires 10 gallons of Mystery Material M @ $3/gallon and .5 labor hours @$20/labor hour. During 2006, it spent $346,500 to purchase 99,000 gallons of Mystery Material M that Variance Company used in...
The Bartlesville plant of Harmon Company produces an industrial chemical. At the beginning of the year,...
The Bartlesville plant of Harmon Company produces an industrial chemical. At the beginning of the year, the Bartlesville plant had the following standard cost sheet: Direct materials (10 kg @ R1.60 per kg) R16.00 Direct labour (0.75 hour @ R18 per hour) R13.50 Variable overhead (0.75 hour @ R3 per hour) R2.25 Fixed overhead (0.75 hour @ R4 per hour) R3.00 Standard cost per unit R34.75 The Bartlesville plant calculates its overhead rates using practical volume, which is 72 000...
The Bartlesville plant of Harmon Company produces an industrial chemical. at the beginning of the year,...
The Bartlesville plant of Harmon Company produces an industrial chemical. at the beginning of the year, the Bartlesville plant had the following standard cost sheet: Direct material: (10 pounds @ $1.60)           $16.00 Direct labor: (0.75 hours @ $18.00)              $13.50 Variable overhead: (0.75 @ $4.00)                $3.00 Fixed overhead: (0.75 @ $3.00)                     $2.25                                                                        _____ Standard cost per unit                                  $34.75 The Bartlesville plant computes its overhead rates using practical volume, which is 72,000 units. The actual results for the year are as...
A company blends two materials: A and B to produce two types of fertilizers. Fertilizer 1...
A company blends two materials: A and B to produce two types of fertilizers. Fertilizer 1 must be at least 50% of A and sells for $65 per kilo gram. Fertilizer 2 must be at least 70% of B and sells for $48 per kilogram. The price of martial A is $10 per 100 kilo grams and the price of martial B is $14 per 100 kilo grams if they purchased over 10,000 kilo gram the price will be reduced...
A company blends two materials: A and B to produce two types of fertilizers. Fertilizer 1...
A company blends two materials: A and B to produce two types of fertilizers. Fertilizer 1 must be at least 50% of A and sells for $65 per kilo gram. Fertilizer 2 must be at least 70% of B and sells for $48 per kilogram. The price of martial A is $10 per 100 kilo grams and the price of martial B is $14 per 100 kilo grams if they purchased over 10,000 kilo gram the price will be reduced...
A company blends nitrogen and phosphorous to produce two types of fertilizers. Fertilizer 1 must be...
A company blends nitrogen and phosphorous to produce two types of fertilizers. Fertilizer 1 must be at least 50% nitrogen and sells for $55 per pound. Fertilizer 2 must be at least 55% phosphorous and sells for $45 per pound. The company can purchase up to 9000 pounds of nitrogen at $20 per pound and up to 12,000 pounds of phosphorous at $12 per pound. Assuming that all fertilizer produced can be sold, determine the optimal blending plan for the...
Because of the rising costs of industrial accidents, many chemical, mining, and manufacturing firms have instituted...
Because of the rising costs of industrial accidents, many chemical, mining, and manufacturing firms have instituted safety courses. Employees are encouraged to take these courses designed to heighten safety awareness. A company is trying to decide which one of two courses to institute. To help make a decision, eight employees take Course 1 and another eight take Course 2. Each employee takes a test that is graded out of a possible 25 points. The safety test results are shown below....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT