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

  Preliminary studies indicate that about 40 of those

television viewers often express doubts about the validity of certain commercials. in an attempt to answer their

  Test hypothesis-elevation of tree does not affect diameter

where x1 is the age, x2 is the elevation, x3 is the rainfall, x4 is the specific gravity, and Y is the tree's diameter, test the hypothesis that β2 = 0. That is, test the hypothesis that, given the other three factors, the elevation of the tree does ..

  Find probability that two undergraduates will be selected

If four students are to be randomly selected from this group, find the probability that exactly two undergraduates will be among the four chosen.

  Estimate the sampling distribution of y mean

You can estimate the sampling distribution of y mean (y with a - on top) by repeatedly taking samples of size n with replacement from the list of sample values.

  Test the claim at the 1 level of significance that the

the smoking rate for the entire u.s. population of adults is 32 national institute on drug abuse. suppose that for a

  Correlated groups t-test

A researcher testing the affects of music on studying conducts a within participants design. The results are as follows: music 6,7,6,5,6,8,8, and no music 10,7,8,7,7,9,8

  Altman z score for general motors

Calculate GM's Altman Z-Score. Show your calculations. Based on your calculations, would you agree or disagree with Lutz that GM is over the worst? Explain in detail.

  Formulate as a linear programming (lp) problem

Formulate as a linear programming (LP) problem

  Comparing standard deviations

A real estate agent wants to compare the variation in the selling price of homes on the oceanfront with those 3 blocks away A sample of 21 oceanfront homes sold within the last year revealed the standard deviation of the selling prices was 45,600.

  Determine probability values using normal distribution

Computing the probability values using normal distribution - Find the probability that a regular rat (without the supplement) would solve the maze with a score less than or equal to X = 24 errors?

  What percentage of legal quarters will be rejected

If a vending machine will only accept coins weighing between 5.48g and 5.82g, what percentage of legal quarters will be rejected?

  Find income that separates the top from lower of the incomes

Mean income of $30,000and a standard deviation of $3,000. What is the income that separates the top 25% from the lower 75% of the incomes?

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