A department store sells different models of bicycle. They are currently planning to place an order with their wholesaler. The table below shows the different models of bike, their profits, how much space they takeup in inventory, and how many hours of assembly time are needed.Maxs.t.ModelAdult's trail bikeAdult's city bikeChild's trail bikeChild's city bikestorage spaceassembly timeorder sizeProfit (in $)X₁, X₂, X3, X4 2040242120Inventory Space (in ft) Assembly Time (in hours)22Five hundred forty feet of storage are available for storing the bikes, and 1,250 hours of assembly time is available. The store wishes to place an order for at least 275 bicycles. They are assuminging every bicyclewill be sold. (Let X₁ = number of adult's trail bikes ordered. Let X₂ = number of adult's city bikes ordered. Let X3 = number of child's trail bikes ordered. Let X₁ = number of child's city bikes ordered.)(a) Formulate a linear programming model for this problem that will maximize profit (in dollars).15644

Answered: (a) Formulate a linear programming…

(a) Formulate a linear programming model for this problem that will maximize profit (in dollars). Max s.t. storage space assembly time order size Х1. Хz, Х3, Х420

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section2.5: Ordering With Quantity Discounts And Demand Uncertainty

Problem 7P

See similar textbooks

Similar questions

The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.
The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)
The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?
T-Shirts Unlimited is a retailer that sells every kind of T-shirt imaginable. The different types of T-shirts are stored in departments that all take up the same amount of space. The available warehouse space is shown in the figure below. storage storage storage DOCK AISLE storage storage storage A from–to matrix showing the number of trips to and from each department is given below. From-To Matrix for T-Shirts Unlimited Department Category Trips to andfrom Dock 1 Sports T-Shirts 47 2 Men's T-Shirts 41 3 Women's T-Shirts 61 4 Children's T-Shirts 43 5 Fashion T-Shirts 63 6 Undershirts 58 Help T-Shirts Unlimited decide where to store each type of T-shirt. Fill the blanks with department numbers. (If two answers are acceptable, locate the greater numbers in the top row). enter an appropriate number enter an appropriate number enter an appropriate number…
each Distributors packages and distributes industrial supplies. A standard shipment can be packaged in a class A container, a class K container, or a class T container. A single class A container yields a profit of $10; a class K container, a profit of $8; and a class T container, a profit of $12. Each shipment prepared requires a certain amount of packing material and a certain amount of time. Formulate and solve this problem using LP software. Resources Needed per Standard Shipment Class of Container Packing Material (pounds) Packing Time (hours) A 2 2 K 1 6 T 3 4 Total amount of resource available per week 120 pounds 210 hours Hugh Leach, head of the firm, must decide the optimal number of each class of container to pack each week. He is bound by the previously mentioned resource restrictions but also decides that he must keep his 6 full-time packers employed all 210 hours (6 workers × 35 hours)…
Bag Company produces leather jackets and handbags. A jacket requires of leather and a handbag only . The labor requirements for the two products are 12 and 5 hours respectively. The current weekly supplies of leather and labor are limited to and 1,850 hours. The company sells the jackets for $350 and the handbags for $120. The objective is to determine the production schedule that maximizes the net revenue. In this document, write the mathematical formulation of both the primal and the dual problems. In the Excel file used in problem 1, solve the primal problem and generate a Solver sensitivity report in a new worksheet. In this document, use the Solver sensitivity report to answer the following two questions: What is the maximum purchase price the company should pay for additional leather? What is the maximum amount the company should pay for additional labor?
ProHaul specializes in trans-American shipments for businesses through the delivery of containers. For every container the company loads on its trucks, ProHaul estimates the haul costs $1,000. In addition, containers are weighed and for each pound, there are hauling fees of $0.15. ProHaul plans to charge $0.49 per pound to his customers.How many pounds would a container have to hold in order for the company to Break Even?
Answer Questions a to e, based on the following information You run a small grocery store and have the following fruits in storage: 1000 apples, 1500 oranges, 75 watermelons, 100 peaches, and 125 mangos. You plan to package these fruits into gift sets and sell them during the New Year's Sale. The gift sets will be offered in 3 options. Each option is sold at a different price and subject to the following requirements in terms of the fruits that are in the bag: . Option A-Must contain 6 apples, 6 oranges, and 1 watermelon. Option B-Must contain 2 apples, 4 oranges, 1 peach, and 2 mangos. Option C-Must contain 1 watermelon, 1 peach, and 1 mango. Option A will sell for $100, option B will sell for $130, and option C will sell for $200. Assume that there is no limit on demand and that we allow fractional gift sets for simplicity. Your goal is to maximize revenue. Suppose we would like to formulate this as a LP problem, and have the following decision variables: TA =# of gift set A, B =# of…
Information on a business is given below.Variable Expenses:Raw material expense: 250 TL / pieceAuxiliary equipment expense: 150 TL / pieceElectricity expenses: 100 TL / pieceSpare parts expense: 75 TL / pieceOther variable expenses: 125 TL / pieceFixed costs:Depreciation, interest and insurance expenses: 75 000 TLLabor and personnel expenses: 250 000 TLOther fixed expenses: 115 000 TLProduction capacity: 2000 pcs / monthSale price: 1600 TL / pieceAccording to the above,a) Find the break-even point as the production quantity?b) Find the amount that the business has to produce in order to make a profit of 500 000 TL / month?
VITRAN Bus Services purchases diesel fuel from Domino Gas Supply. In addition to fuel cost, Domino Gas Supply charges VITRAN Bus Services $250 per order to cover the expenses of delivering and transferring the fuel to VITRAN Bus Services storage tanks. The lead time for new shipment from Domino Gas Supply is 10 days, the cost of holding a gallon of fuel in the storage tanks is $0.04 per month, or $0.48 per year and the annual usage of fuel is 150,000 gallons. VITRAN Bus Services buses operate 300 days a year. What is the optimal order quantity for VITRAN Bus Services? How frequently should VITRAN Bus Services order to replenish the gasoline supply?
A company manufactures both mountain bikes and trail bikes. The cost of materials for a mountain bike is $60, and the cost of materials for a trail bike is $40. The cost of labor to manufacture a mountain bike is $80, and the cost of labor to manufacture a trail bike is $60. During a week in which the company has budgeted $1,800 for materials and $2,500 for labor, how many mountain bikes does the company plan to manufacture? mountain bikes
Happy Dog Inc. produces three types of dog food. Puppy Blend is produced for dogs that are less than a year old, Adult Blend for dogs between 1 and 8 years old, and Geriatric Blend for dogs older than 8 years. Each blend, sold in 5 pound bags, has a unique recipe that requires, among other ingredients, exact quantities of certain raw materials. Chicken Fish Meal Soy Flour Demand (in5 lb. bags) Puppy Blend Adult Blend Geriatric Blend Availability of rawmaterial 2.5 lbs. 1.5 lbs. 1.0 lbs. 10,000 lbs. 1.0 lbs. 2.0 lbs. 2.0 lbs. 20,000 lbs. 0.5 lbs. 0.5 lbs. 1.0 lbs. 5,000 lbs. 2000 8000 1000 a. Formulate a linear programming model that produces as many bags of dog food as possible without exceeding the demand or the available supply of raw material.b. Reformulate the linear programming model if the company is now interested in maximizing their profit 1price - raw material cost2 from dog food production. Assume that Puppy Blend sells for $9.50 per bag, Adult Blend…