What is the profit contribution for each bike

Assignment Help Basic Statistics
Reference no: EM13924597

Cycle City Inc., a large bicycle store is placing an order for bicycles with its supplier. Four models can be ordered: the adult racer, the adult Mountain bike, the girl's Sea Sprite, and the boy's Trail Blazer. It is assumed that every bike ordered will be sold, and their profits, respectively, are 32, 28, 25, and 20. The LP model should maximize profit. There are several conditions that the store needs to worry about. One of these is space to hold the inventory. An adult's bike needs two feet, but a child's bike needs only one foot. The store has 500 feet of space. There are 1200 hours of assembly time available. The child's bike need 4 hours of assembly time; the racer needs 5 hours and the mountain bike needs 6 hours. The store would like to place an order for at least 275 bikes.

1. Formulate a model for this problem. Specifically, do the following: Identify the decision variables (make sure that you specify the units for these variables). Specify the objective function and the relevant constraints.

2. The production manager uses a DSS to make decisions about what to do. The maximum attainable profit is required. Develop a simple DSS prototype to solve this problem.

a. How many of each kind of bike should be ordered?
b. What is the total profit realized?
c. What is the profit contribution for each bike?

3. Perform sensitivity analysis to determine: (Remember to change back to original value after each change below).

a. What would the profit be if the store had 100 hours of assembly time?
b. If the profit on the Mountain bike increases to $35, how many of those bikes should be ordered?
c. If we require 5 more bikes in inventory, what will happen to the value of the optimal solution?

4. Write a short memo to the management of Cycle City Inc., explaining

a. Over what range of assembly hours is the dual price applicable?
b. Which resource should the company work to increase, inventory space or assembly time? Explain.

Reference no: EM13924597

Questions Cloud

Examine dimension of culture presented in hofstede framework : Examine the four dimensions of culture presented in Hofstede's framework. What strategies would you recommend in dealing with a different culture that is opposite on each of the dimensions?
Labor of building the monuments : The heads of that state ordered the lower class to do the labor of building the monuments as they sat back and delegated the task and provided the resources to perform the labor. Since most states were stratified societies the laborers had to depe..
Targeted the low-income consumers : This switch was more than likely a collaboration between the government of Brazil and predatory merchant MNC's like McCann World Group that targeted the low-income consumers.
Assume the net working capital will be recovered : Kinky Copies may buy a high-volume copier. The machine costs $170,000 and will be depreciated straight-line over 5 years to a salvage value of $30,000. Kinky anticipates that the machine actually can be sold in 5 years for $37,000.
What is the profit contribution for each bike : The production manager uses a DSS to make decisions about what to do. The maximum attainable profit is required. Develop a simple DSS prototype to solve this problem. a. How many of each kind of bike should be ordered? b. What is the total profit r..
What is the marginal tax rate for a couple filing jointly : Using Exhibit 2.6, what is the marginal tax rate for a couple, filing jointly, if their taxable income is $20,000? $40,000? $60,000? What is their tax bill for each of these income levels?
Ethnographically and ethnologically to enlighten people : Throughout history anthropologist have done much research both ethnographically and ethnologically to enlighten people about the surrounding societies and their cultures.
Implement a security management system : Prepare a 3-slide Microsoft PowerPoint presentation with detailed speaker notes that describes the process you would use to design, develop, and implement a security management system to protect the organization's intranet and Internet access poin..
Which would reduce the amount of additional funds needed : Carter Corporation's sales are expected to increase from $5 million in 2012 to $6 million in 2013, or by 20%. Its assets totaled $2 million at the end of 2012. Carter is at full capacity, so its assets must grow in proportion to projected sales. Unde..

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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