Explore BrainMass



Question 1. Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: Year Demand for Fertilizer (1,000s of bags) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 a) Develop a three-year moving averages to forecast sale. b) Then estimate d

Determine optimal shipping schedules.

I'm studying the transportation models and shipment. Can you please tell me the method to solve the following problem and show me the procedure? A company produces cars in Atlanta, Boston, Chicago, and Los Angeles. The cars are then shipped to warehouses in Memphis, Milwaukee, New York City, Denver, and San Francisco. The num

Two Optimization Problems

Untimed Optimization Assessment, Due 04/17/10 11PM (no extra time given by Blackboard) You have to do two separate things to complete this assessment: 1) Enter answers to numbered questions using online Assessment form (untimed one). 2) Upload the spreadsheets you used in solving the questions on this assessment (no spr

Use QM for windows

Given a transportation problem with the following costs, supply, and demand, find the optimal solution by using the computer: To(cost) From 1 2 3 Supply A $16 $7 S4 100 B 5 3 6 180 C 8 5

Formaulate and solve an integer programming model

Please see the attached file for the fully formatted problems New Offices at Atlantic Management Systems Eliminate Denver in table when solving this problem. See attachment for problem. 1. Formulate and solve an integer programming model to help Atlantic Systems determine how many new offices it should open where the

Transportation modeling problem

A soda producer makes and sells two products, Classic Cola and Diet Cola. If this company spends X1 dollars on promotion of Classic Cola in a particular western city, it can sell 75 X1^0.5 12-packs of Classic Cola each week there. Moreover, if this company spends X2 dollars on promotion of Diet Cola in a particular western

Mathematical modeling question

After graduating from business school, George Clark went to work for a Big Six accounting firm in San Francisco. Since his bobby has always been wine making, when he had the opportunity a few yeas later he purchased 5 acres plus an option to buy 35 additional acres of land in Sonoma Valley in Northern California.. He plans eve

Optimization problem lingo or lindo

I have an optimization problem which is already solved using Excel solver, however, I need it to be solved with in lingo or lindo systems. every thing needed is described in the attached file

Forecast model consumer loan department atCentral Union bank

The consumer loan department at Central Union bank and Trust wants to develop a forecasting model to help determine it's potential loan application volume for the coming year. Because adjustable-rate home mortgages are based on government long-term treasury not rates, the department collected the following data for 3- to 5 - ye

Exponential Smoothing Forecast and Trend Projection

The Mayfair Department Store in Davenport, Iowa, is trying to determine the amount of sales lost while it was shut down during July and August because of damage caused by the Mississippi River flood. Sales data for January through June follow. Month Sales ($1000s) January 185.72 February 167.84 March 205.11 April 210.36

Question about integer programming model

The Texas Consolidated Electronics Company is contemplating a research and development program encompassing eight research projects. The company is constrained from embarking on all projects by the number of available management scientists (40) and the budget available for R&D projects ($300,000). Further, if project 2 is select

Quantitative Methods

A local real estate investor in orlando is considering three alternative investments: a motel, a restaurant , or a theater . Profits from the motel or restaurant will be affected by the availability of gasoline and the number of tourists: profits from the theater will be relatively stable under any conditions. The following pa

Linear Programming Problem

Problem 11-13 A group of college students is planning a camping trip during the upcoming break. The group must hike several miles through the woods to get to the campsite, and anything that is needed on this trip must be packed in a knapsack and carried to the campsite. One particular student, Tina Shawl, has identified eight

Forecast Analysis

The book store sells computers to students at a discount. The book store usually sells the computers at cost or for minimal profit. Each summer all incoming freshman come to a 3 day orientation program. The students usually come in groups of 100 throughout the summer. At the orientation they are usually given information on the

Quantitative Methods - 5 questions about forecasting

I am having trouble with the problems attached. I can't figure out the periods, smoothed forecasting and linear regression. I have attached the problem because the tables/graphs look better on a word document rather than in the full description section. --------------------------------------------------------- 1. Given the

Inventory Control Model

The marginal loss on Washington Reds, a brand of apples from the state of Washington, is $35 per case. The marginal profit is $15 per case. During the past year, the mean sales of Wshington Reds in cases was 45,000 cases, and the standard deviaiton was 4,450. How many cases of Washington Reds should be brought to market? Ass

Transportation Optimization Problem

Steel mills in three cities produce the following amounts of steel weekly location weekly production (tons) Ashville 210 Birmingham 150 columbus 320 these mills supply steel to four cities where manufacturing plants have the following demand city weekly demand Detroit 130 St


I need help with the attached problem about the university bookstore student computer purchase program. Use either MS word or Excel. Thanks!

Forecasting and Moving Averages

The chairperson of the department of management at State University wants to forecast the number of students who will enroll in production and operatiosn management (POM) next semester, in order to determine how many sections to schedule. The cahir has accumulated the following enrollment data for teh past eight semesters: S

Minimin & Minimax Criterion

A company must decide now which of three products to make next year to plan and order proper materials. The cost per unit of producing each product will be determined by whether a new union labor contract passes or fails. The cost per unit for ecah product, given each contract result, is shown in the following payoff table

Nonlinear Programming & Evolutionary Optimization

This is a problem #10, chapter 8 - Nonlinear Programming & Evolutionary Optimization, from the textbook by Cliff Ragsdale, "Spreadsheet Modeling and Decision Analysis". This problem requires the use of Excel and the add-in, called Solver. The course is Excel-based and Solver is the optimization application used for all proble

Detailed Explanation to Integer Programming

1. Solve the following problem: Max X + 2Y s.t. 6X + 8Y < 48 7X + 5Y > 35 X, Y > 0 Y integer a. Find the optimal solution to the LP Relaxation. Round down to find a feasible integer solution. Is this solution optimal? b. Find the optimal solution. 2. The Westfall Company has a contra


I have a problem that needs to be solved using any numerical programming. It has been solved and two examples are provided for validation. The only thing missing is the procedure program. I prefer using the matlab if you can I can pay you any thing you want to solve it. Can you do it. I have the objective function.

Network Flow Models; Transportation Nodes; Optimization in Excel; Solver

The blood bank wants to determine the least expensive way to transport available blood donations from Pittsburg and Staunton to hospitals in Charleston, Raonoke, Richmond, Norfolk, and Suffolk. The supply and demand for donated blood is shown in Figure 5.34 along with the unit cost of shipping along with each possible arc. (a)

Linear Programming : Echelon or Gauss-Jordan Methods and Optimization

At rush hours, substantial traffic congestion is encountered at the traffic intersections shown in the figure. (The streets are one-way, as shown by the arrows.)The city wishes to improve the signals at these corners so as to speed the flow of traffic. The traffic engineers first gather data. As the figure shows, 700 cars per h

LP Problem: maximization of ratings.

An aircraft repair facility currently has four jobs awaiting work. Four teams of mechanics are available. Each team can work on only one of the jobs. Over a period of several months the manager has evaluated the repair teams in a variety of jobs. Evaluations are based on 100 being the maximum evaluation possible. The teams

Linear Programming : Optimization

Quitmeyer Electronics Incorporated manufactures the following six microcomputer peripheral devices: internal modems, external modems, graphics circuit boards, CD drives, hard disk drivers, and memory expansion boards. Each of these technical products requires time, in minutes, on three types of electronic testing equipment, as s

Integer Programming

If we are solving a 0-1 integer programming problem, the constraint x1 &#8804; x2¬ is a ________________constraint.

Maximization : Sensitivity Range

MULTIPLE CHOICE For a maximization problem, assume that a constraint is binding. If the original amount of a resource is 4 lbs., and the range of feasibility (sensitivity range) for this constraint is from 3 lbs. to 6 lbs., increasing the amount of this resource by 1 lb. will result in the: a. same product mix, different tota

Shortest Path and Maximal Flow Problem

Please see the attached file for the fully formatted problems. 1. Shortest Path and Maximal Flow Problem (30%): You are given the following directed network. [NETWORK] a. (Shortest Path Problem 15%) Let the numbers on the arcs represent distances and find the shortest path from node 1 to node 9. b. (Maximal Flow