Prepare linear programming model in Excel

Case Problem – Workload Balance Chicago Digital Imaging produces photo printers for both the professional and consumer markets. The Chicago Digital Imaging division recently introduced two photo printers that provide color prints rivaling those produced by a professional processing lab. The Chicago Digital Imaging 910 model can produce a 4” X 6” borderless print in approximately 37 seconds. The more sophisticated and faster Chicago Digital Imaging 950 model can even produce a 13” X 19” borderless print. Financial projections show profit contributions of $42 for each Chicago Digital Imaging 910 model and $87 for each Chicago Digital Imaging 950 model. The printers are assembled,... click for more

Can you tell me the constraint formula of the minimum 10,000; 3,000 and 5,000?

Can you tell me the constraint formula of the minimum 10,000; 3,000 and 5,000. I kept getting hung up on that and was at lost for quite some time.

Linear Programming Break-Even Analysis, Sensitivity Analysis and Transportation Problem

Problem 1: Break-Even Analysis A small organization builds TV satellite dishes. The investment in plant and equipment is $200,000. The variable cost per dish is $500. The price of the TV dish is $1000. (Please show your work used to come up with this solution) 1. How many TV satellite dishes would be needed to be sold for the firm to break even? 2. What profit or loss can be anticipated with a demand of 500 dishes? 3. If the demand is 300 dishes, what is the minimum price that the firm must charge to breakeven? Problem 2: Linear Programming Model Development A manufacturer makes two products, doors and windows. Each must be processed through two work areas. Wor... click for more

Find the linear equation

In the real world, what might be a situation where it is preferable for the data to form a relation but not a function? There is a formula that converts temperature in degrees Celsius to temperature in degrees Fahrenheit. You are given the following data points: Fahrenheit Celsius Freezing point of water 32 0 Boiling point of water 212 100 1.Find the linear equation that expresses temperature in degrees Fahrenheit as a function of temperature in degrees Celsius. 2. Find the linear equation that expresses temperature in degrees Celsius as a function of temperature in degrees Fahrenheit. 3. How do the graphs of these two functions differ? Do not just list the functio... click for more

Project Scheduling and PERT/CPM

Hannaford (A solution can be generated by using PERT/CPM) Hannaford distributes a variety of food products that are sold through grocery store and supermarket outlets. The company receives orders directly from the individual outlets, with a typical order requesting the delivery of several cases of anywhere from 20 to 50 different products. Under the organization’s current warehouse operation, warehouse clerks dispatch order-picking personnel to fill each order and have the goods moved to the warehouse shipping area. Because of the high labor costs and relatively low productivity of hand order-picking, management has decided to automate the warehouse operation by installing a computer-con... click for more