Prepare a detailed management report

Reference no: EM132211659

Case Study: TexMex Foods

TexMex Foods operates a plant in Irving, Texas, for manufacturing Taco sauce used in fast food restaurants. The sauce, which is packaged in plastic containers, is made from a special recipe that includes tomato concentrate, onions and chile peppers that TexMex purchases from various suppliers. The plant operates 365 days a year and TexMex uses an annual holding cost rate of 18%.

Tomato Concentrate - TexMex Foods purchases its tomato concentrate from Hunt farms. The company requires 2500 gallons of concentrate per day to manufacture this sauce. Hunt Farms offers customers the following all units price discount schedule:

Number of Gallons Ordered

1 - 9999

10,000 - 49,999

50,000 - 124,999

125,000 - 249,999

250,000 or more

Price per Gallon

$3.12

$3.08

$3.02

$3.01

$2.96

The shelf life of the concentrate is 80 days, and the ordering cost is $750. Orders must be placed in 1000-gallon increments. The company desires a safety stock of 10,000 gallons, and the lead-time for delivery is 10 days. Management wishes to determine the optimal order quantity for the concentrate as well as the reorder point.

Onions - Daily demand of onions follows approximately a normal distribution with a mean of 6000 pounds and a standard deviation of 1000 pounds. Onions cost the company $0.15 per pound, and the ordering cost is $180. Lead time for delivery is four days, and the company desires a service level of 95%. Management wants to determine the optimal order quantity for onions as well as the reorder point.

Chile Peppers - TexMex also needs an estimated 2000 pounds of chile peppers daily. The pepper cost TexMex $0.37 per pound. Order cost, including transportation, is $1500. Lead-time is normally two weeks but may vary somewhat. Because of this variability, the company estimates that the lead-time demand for chile peppers follows approximately a normal distribution with a mean of 28,000 pounds and a standard deviation of 4000 pounds. Management wants to determine the optimal order quantity, reorder point, and safety stock for chile peppers to meet a desired cycle service level of 99.5%

Plastic Containers - TexMex packages the sauce in one-ounce plastic containers it buys from Union Chemical at $0.003 per unit. The ordering cost is $120. TexMex is contemplating leasing a machine to make the containers. The yearly lease cost of the machine is $45,000, and the production setup cost is $260. The machine can produce 1 million containers per day at a per unit cost of $0.0027 (excluding leasing, inventory holding, and production setup costs). The company estimates that it requires 450,000 containers per day. Management wants to determine whether it should continue purchasing containers from Union Chemical or begin in-house production and what the optimal order quantity or production lot size should be.

Prepare a detailed management report addressing each of the concerns facing TexMex Foods. Include in your report supporting graphs and charts as well as appropriate "what-if" analyses.

Reference no: EM132211659

Questions Cloud

What is meant by internal and external communication : A description of succession planning process. What is meant by internal and external communication?

Improving diversity and inclusion at company : Why is Pfizer interested in improving diversity and inclusion at the company?

Create a method to handle user input : Write a program that uses an array to find the Average of 10 double values. Create 1 method to handle user input. Create 1 method to sum and output average.

Some projects that are currently underway in community : Identify some projects that are currently underway in community. identify major activities, and draw a network diagram using Activity- on -Node (AON) Approach

Prepare a detailed management report : Prepare a detailed management report addressing each of the concerns facing TexMex Foods. Include in your report supporting graphs and charts

Significant achievement of the industrial revolution : What was one significant achievement of the industrial revolution? And how this achievement affected the transportation system of the time?

Write a program to reverse a word entered by the user : Write a program the uses stacks and/or queues from c++ standard template library(STL) to reverse a word entered by the user.

Calculate the present value of benefits minus costs : Calculate the present value of benefits minus costs when the social rate of discount is 10 percent. You can use spreadsheet software to do this calculation

Approaches to winning sustainable competitive advantage : Which of the following is not included in proven approaches to winning a sustainable competitive advantage?

User Account

All Pages