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?

Reviews

Write a Review

Operation Management Questions & Answers

  How would you describe enrons corporate culture

MGMT 3123 : How would you describe Enron's corporate culture? What behaviors did its employees engage in that gave you this opinion?

  What is the difference between apoptosis and necrosis

What is the difference between apoptosis and necrosis? What is the role of apoptosis in the normal, healthy development of animals?

  Related to leading organizational change published

Prepare a report on a journal article (ANY ARTICLE) related to leading organizational change published during the period 2005-2017.

  Articles on events affecting health care and public funding

What are the articles on events affecting health care and public funding.

  What incentive is there for a company to pay dividends

What incentive is there for a company to pay dividends? What signals does dividend policy provide to investors?

  Entrepreneurs have special considerations businesses

Home-based entrepreneurs have special considerations other businesses don't have. Make your life easier at tax time by keeping ______.

  Make the in-house option least costly

How man solenoids would the automobile company need per year to make the in-house option least costly?

  Small flagstaff job shop where garments are made

Susan Williams runs a small Flagstaff job shop where garments are made. The job shop employs eight workers. Each worker dollar 10 per hour. During the first week of March, each worker worked 45 hours. Together, they produced a batch of 132 garments. ..

  Evaluate the firms rationale for it outsourcing

If a firm has a divisional structure and places extreme pressures on its divisional executives to meet short-term profitability goals?

  What is the average utilization of the service system

You're the manager of a local bank where a teller provides service to customers. On average, the teller takes 5 minutes to serve a customer. What is the average utilization of the service system? What is the probability that no customers are being se..

  New pre and post-money values of the venture

If the entrepreneur is confident the company is currently worth 25% more and needs to raise $500,000, how many shares will he sell? What are the new pre- and post-money values of the venture?

  Hernia surgery and recovery after the hernia surgery

A hospital only provides care to hernia patients. Each patient spends 4 nights at the hospital. This includes preparation of the patient before the hernia surgery and recovery after the hernia surgery. As a new initiative, The hospital tries to adopt..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd