Local growers and makes applesauce and apple juice

Assignment Help Operation Management

Reference no: EM132299641

The Sonoma Apple Products Company purchases apples from local growers and makes applesauce and apple juice. It costs $0.80 to produce a jar of applesauce and $0.60 to produce a bottle of apple juice. The company has a policy that at least 20 percent but no more than 60 percent of its output must be applesauce.

The company wants to meet but not exceed the demand for each product. The marketing manager estimates that the demand for applesauce is a maximum of 5,000 jars, plus an additional 3 jars for each $1 spent on advertising for applesauce. The maximum demand for apple juice is estimated to be 4,000 bottles, plus an additional 5 bottles for every $1 spent on advertising for apple juice.

The company has $16,000 to spend on producing and advertising its two products. Applesauce sells for $1.75 per jar, and apple juice sells for $1.75 per bottle.

A. Enter the model in Excel and use the Solver to find the optimal solution. After solving, create the answer & sensitivity report. Turn in your Excel file or screen shots pasted on paper (pdf or doc)

Reference no: EM132299641

Questions Cloud

Is there one best style of management : Is there one best "style" of management? Why or why not? Can you think of situation where management doesn't matter to organization? Explain.

Features of industrial relations-employment relations : Discuss the main features of industrial relations/employment relations in Japan along with its examples from Japan.

Opportunities generated for your entrepreneurship : Define pattern recognition and describe how you would apply this to opportunities generated for your entrepreneurship

Discuss the law requirements : Discuss the law's requirements. Include information regarding what the law does, how it is executed, and the execution gaps of your selected organization.

Local growers and makes applesauce and apple juice : The Sonoma Apple Products Company purchases apples from local growers and makes applesauce and apple juice.

Describe two features in project management software : Identify and describe two features in project management software that you feel would be most useful in managing your project.

Types of constraints in developing selection program : Types of Constraints in Developing a Selection Program

Define organizational citizenship behaviors : What are organizational citizenship behaviors? Define organizational citizenship behaviors.

Effectiveness of the career changer program : What outcomes should AMP collect to determine the effectiveness of the Career Changer Program?

User Account

All Pages