Explain linear programming model for bicycle manufacturer

Assignment Help Marketing Management
Reference no: EM1334601

Explain Linear programming model for bicycle manufacturer

A bicycle manufacturer is determining its production schedule for the next 6 months. Assume that it costs this company $150 to manufacture each bicycle. At the end of each month, a holding cost of $35 per bicycle left in inventory is incurred. No more than 40 bicycles can be stored in inventory at any point in time. Monthly demands for bicycles are projected to be as follows: 150 in month 1; 175 in month 2; 165 in month 3; 156 in month 4; 169 in month 5; and 178 in month 6. Assume that at the beginning of month 1, 10 completed bicycles are in inventory. Finally, this company can produce up to 170 bicycles per month. Formulate and solve a linear programming model to find a cost-minimizing production schedule that meets all demands on time.

Answer the following questions-

1) Write down the decision variables.

2) Write down the optimization statement for the objective function.

3) Write down the constaints.

4) With Excel Solver, what is the optimal production schedule? (Please hand in a printed copy of the report)

5) By Excel Solver, what is the sensitivity report? (Please hand in a printed copy of the report)

Reference no: EM1334601

Reviews

Write a Review

 

Marketing Management Questions & Answers

  Explain successful e-business entrepreneurs

Explain Successful E-Business Entrepreneurs and identify three e-business entrepreneurs who have been successful in creating and marketing new technologies

  Explain electronic profiling

Explain Electronic Profiling and electronic profiling processes to track visitor website behavior are necessary

  Explain internet explained in this solution

Explain Internet explained in this solution and Governmental officials should not have a choice regarding travel for conferences

  Explain defining web site target users

Explain Defining Web Site Target Users and Research the Internet on the importance of defining user population for a Web site

  Explain retailing changes

What are the top 5 future changes in retailing and their reasons/explanations?

  Valuate the it status of the business using the information

Valuate the IT status of the business using the information you have gathered from your review of the Club IT Web site and interviews with Ruben and the staff

  Explain the solution to computer crimes

Explain the solution to Computer Crimes and types of computer crimes that have been committed by outside intruders or by employees over the past three to five years

  Explain e-marketer communications

Explain E-marketer Communications and what are new communications techniques and capabilities

  Explain expanded html

Explain Expanded HTML and Two paragraphs of text related to course content

  Inflation for good business

Suppose someone argues that inflation is good for business (because businesses receive higher prices) and bad for individuals (who pay the higher prices). Is there any validity to that reasoning? Why or why not?

  Explain why is it important to keep abreast of technology

Explain Why is it important to keep abreast of technology trends when running an eBusiness and Why is benchmarking an important activity in the analysis of eBusiness Web sites

  Explain human resource management-strategic management

Explain Human Resource Management - You are a human resource professional who favors strategic management and who has been very successful in your current position

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