Reference no: EM13921234
Assignment 1. Linear Programming Case Study
Your instructor will assign a linear programming project for this assignment according to the following specifications.
It will be a problem with at least three (3) constraints and at least two (2) decision variables. The problem will be bounded and feasible. It will also have a single optimum solution (in other words, it won't have alternate optimal solutions). The problem will also include a component that involves sensitivity analysis and the use of the shadow price.
You will be turning in two (2) deliverables, a short writeup of the project and the spreadsheet showing your work.
Writeup.
Your writeup should introduce your solution to the project by describing the problem. Correctly identify what type of problem this is. For example, you should note if the problem is a maximization or minimization problem, as well as identify the resources that constrain the solution. Identify each variable and explain the criteria involved in setting up the model. This should be encapsulated in one (1) or two (2) succinct paragraphs.
After the introductory paragraph, write out the L.P. model for the problem. Include the objective function and all constraints, including any non-negativity constraints. Then, you should present the optimal solution, based on your work in Excel. Explain what the results mean.
Finally, write a paragraph addressing the part of the problem pertaining to sensitivity analysis and shadow price.
Excel.
As previously noted, please set up your problem in Excel and find the solution using Solver. Clearly label the cells in your spreadsheet. You will turn in the entire spreadsheet, showing the setup of the model, and the results
Week 8 Assignment 1
Please submit your assignment in a Word file attached with your Excel results. Please make sure to type your answers in your Word file instead of copy pasting them from the Excel worksheet.
Bike Athletic Company is placing an order for bicycles with its supplier. Four models can be ordered: the adult Open Trail, the adult Cityscape, 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 30, 25, 22, and 20. There are several conditions that the company 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 needs 4 hours of assembly time; the Open Trail needs 5 hours and the Cityscape needs 6 hours. The company would like to place an order for at least 275 bikes.
a. Formulate a model for this problem in a Word document. Identify what type of problem this is.
b. Solve your model with either Excel or QM for windows.
c. How many of each kind of bike should be ordered and what will the profit be?Report in the Word document.
d. In the Word document, report the sensitivity analysis and the shadow price results and interpret them.
e. What would the profit and the change in slack variables be if the company had 100 more feet of storage space? Report in a Word document.
f. Starting from the original problem, if the profit on the Cityscape increases to $45, will any of the Cityscape bikes be ordered?Report the new answers and the profit in the Word document.
g. Over what range of assembly hours is the dual price applicable? Report in the Word document.
h. If we require 5 more bikes in inventory, what will happen to the value of the optimal solutioncompare to the original case (both profit and the decision variables)? Report in the Word document.
Submissions should include both completed Excel file results and the completed Word document. Incomplete submissions are not accepted.
Considering the purchase of new computer system
: Nguyen, Inc., is considering the purchase of a new computer system (ICX) for $130,000. The system will require an additional $30,000 for installation. If the new computer system is purchased, it will replace an old system that has been fully deprecia..
|
Examine the contract and evaluate effectiveness of contract
: Examine the contract and evaluate the effectiveness of the contract. If you believe it is an outstanding government contract, what are the specific parts of the contract that make it such an outstanding government contract?
|
Should the couple invest in land and blueberry business
: Fred and Frieda have always wanted to enter the blueberry business. They locate a 50- acre piece of hillside in Maine that is covered with blueberry bushes. Assume that the land can be sold for only $50,000 at the end of 20 years (a capital loss of $..
|
Breakdown of the sections within the body
: Write a five-to seven-page financial statement analysis of a public company, formatted according to APA style as outlined in the Ashford Writing Center. In this analysis you will discuss the financial health of this company with the ultimate goal ..
|
Assign a linear programming project
: Your instructor will assign a linear programming project for this assignment according to the following specifications. It will be a problem with at least three (3) constraints and at least two (2) decision variables. The problem will be bounded an..
|
Discuss key factors that will influence your recommendation
: You work for a compensation consulting firm. Discuss the key factors that will influence your recommendation for each of these three parameters.
|
What a makes sally indifferent between the two plans
: What a makes Sally indifferent between the two plans? As the sales manager, which plan do you select? Give an explanation that shows why this plan is optimal.
|
Calculate the accrued principal and coupon payment
: Suppose you purchase a $1,000 TIPS on January 1, 2013. The bond carries a fixed coupon of 1 percent. Over the first two years, semi annual inflation is 2 percent, 2 percent, 4 percent, and 2 percent, respectively. For each six-month period, calculate..
|
Assuming target capital structure
: Assuming a target capital structure of: 40% debt 20% preferred stock 40% common equity What would be the WACC given the following: all debt will be from the sale of bonds with a coupon of 10% (assume no flotation costs), preferred stock's associated ..
|