a) Zed and Adrian run a small bicycle shop called "Z to A Bicycles". They must order bicycles for the coming season. Orders for the bicydes must be placed in quantities of twenty (20). The cost per bicycle is R1700 if they order 20, R1650 if they order 40, R1550 if they order 60, and R1340 if they order 80. The bicycles will be sold for R5000 each. Any bicycles left over at the end of the season can be sold (for certain) at R1450 each. If Zed and Adrian run out of bicycles during the season, then they will suffer a loss of "goodwill" among their customers. They estimate this goodwill loss to be R500 per customer who was unable to buy a bicycle. Zed and Adrian estimate that the demand for bicycles this season will be 10, 30, 50, or 70 bicycles with probabilities of 0.2, 0.4, 0.3, and 0.1 respectively. Set-up the cost payoff matrix for this problem.
Q: Happy Dog Inc. produces three types of dog food. Puppy Blend is produced for dogs that are less than…
A: A) Linear programming model is formulated as below: Objective function: Minimize Z = 1X1+1X2+!X3…
Q: Bright Furnitures produces chairs and tables that go through M1 and M2. Making a 1 table and 1 chair…
A: The question is related to Linear Programming.The given problem is of Maximization. The details…
Q: A manufacturer produces both widgets and gadgets. Widgets generate a profit of $50 each and gadgets…
A: to solve this, we need to find the net profit by subtracting the setup cost incurred from the gross…
Q: A company must meet (on time) the following demands:quarter 1—30 units; quarter 2—20 units; quarter…
A:
Q: The manager of the deli section of a grocery superstore has just learned that the department has112…
A: Let h= hamd = deli
Q: A sporting goods store sells footballs, basketballs, and volleyballs. A football costs $7, a…
A: Given Information: Cost of a football = $ 7 Cost of a basketball = $ 15 Cost of a volleyball = $…
Q: A manufacturer produces both widgets and gadgets. Widgets generate a profit of $75 each and gadgets…
A: Given data:
Q: Each robot takes up a square area of 10 feet aside. To the left and to the right of each robot along…
A: The detailed solution is to the given question is given is step 2.
Q: Monte Inc produces two products: bed matresses and box springs. A prior contract requires that the…
A:
Q: A firm making snowblowers produces the augers for each snowblower in batches. Annual demand is for…
A:
Q: A small candy shop is preparing for the holiday season. The owner must decide how many bags of…
A:
Q: a. Write the information given in the question in a tabular format. b. Write the problem in a linear…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Carlo and Anita make mailboxes and toys in their craft shop near Lincoln. Each mailbox requires 1…
A: Given Information: Based on the given information, the linear programming problem can be…
Q: KAB Cycle produces two models bike the Racer (R) and the Stinger (S) and wishes to maximize weekly…
A: LPP or Linear Programming Problem deals with the minimization or maximization of the variable…
Q: A mining company need to decide which of the equipment models to use in a project that will last for…
A: Given Information: -Model A costs $15,000 and requires an annual operational cost of $2,000. The…
Q: Formulate the linear programming model for this situation.
A: Linear programming is the model that is used to achieve the best outcome from the given situation.
Q: A mini zoo is engaged in animal breeding where the animals require three different nutrients…
A: Note: - Since we can answer only up to three subparts we will answer the first three(a, b, and c)…
Q: ts $300 to make, and each requires, on average, 3.2 hours of labor. Each employee works 160 hours…
A: Given: MONTH BEEFEATER FORECAST DEUTSCHLANDER FORECAST NOV-16 650 3048 DEC-16 676 2899…
Q: 1-18 Katherine D'Ann is planning to finance her college education by selling programs at the…
A: Given- Selling Price =$5Fixed cost =$400Variable cost =$3Fee =$1000
Q: 3-2) The optimal quantity of the three products and resulting revenue for Taco Loco is: A) 28 beef,…
A: Given, Max R = 14Z + 13Y + 17Xsubject to:Beef 2Z + 3Y + 4X ? 28Cheese 9Z + 8Y + 11X ? 80Beans 4Z +…
Q: FarmFresh Foods manufactures a snack mix called TrailTime by blending three ingredients: a dried…
A: Given Information: D = Number of ounces of dried fruit mix in the blend N = Number of ounces of nut…
Q: Part a) Write vectors/matrices xBV,XNBV , CBV , CNBV,B,B¯',N,6. Part b) Giapetto has decided to…
A:
Q: Dr. Thompson makes three bean mixes for coffee shops located in the Austin. The three mixes,…
A: Given data, Stock and Cost Details Stock (pounds) Cost Cost/ pounds Arabica 6000 7500…
Q: Two recent graduates have decided to enter the field of microcomputers. They intend to manufacture…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: A company is considering two machines. Machine X has a first cost of $30,000, AOC of $18,000, and S…
A: Annual Worth - The AW method is generally utilized for comparing choices. AW indicates that all…
Q: A manufacturer produces both widgets and gadgets. Widgets generate a profit of $35 each and gadgets…
A:
Q: A manufacturer produces both widgets and gadgets. Widgets generate a profit of $70 each and gadgets…
A:
Q: A store manager estimates that the minimum number of cars needed over the next 3 weeks are 5, 8 and…
A: Dynamic Programming is an approach for solving multi-stage decision problems. When an optimization…
Q: A retired couple supplement their income by making fruit pies, which they sell to a local grocery…
A: Let X1 = Number of apple pies produced. andd X2 = Number of grape pies produced. The Decision…
Q: Based on Zangwill (1992). Murray Manufacturingruns a day shift and a night shift. Regardless of…
A: Given information, cost = 8000 Night shift = 45000 Demand Day 1 - 2000 Night 1 = 3000 Day 2 =…
Q: Cheen Corporation makes two products that are processed in two machines. The objective function and…
A: THE ANSWER IS AS BELOW:
Q: The optimal solution is to produce of the men's model in month 1, of the men's model in month 2,…
A: Production theory refers to the theory that helps in devising methods of production that lead to…
Q: A manufacturer produces both widgets and gadgets. Widgets generate a profit of $45 each and gadgets…
A: Objective Functions and Constraints: Based on the given details, we found the…
Q: A retired couple supplement their income by making fruit pies, which they sell to a local grocery…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Markus, Inc., has harvested 400 tons of lumber from a pine forest located outside of Manchester, 200…
A: Shipping cost From Japan Taiwan Singapore Supply Manchester 250 250 200 400 Seattle 250 200…
Q: A small candy shop is preparing for the holiday season. The owner must déčide deluxe mix and how…
A: Let x be the deluxe mix And, y be the standard mix The profit of 1 bag of deluxe mix=Revenue -Costs…
Q: A manufacturer produces both widgets and gadgets. Widgets generate a profit of $45 each and gadgets…
A: Converting last 2 constraints so that the variables stay on the LHS, 9999y1 - x1 >= 0 9999y2 - x2…
Q: Software EG, a retail company, orders two kinds of software from TeleHard Software. Annually,…
A: Product 1: Annual Demand = D = 800 Purchasing Cost = $30 per unit Holding Cost = H = $5 per unit per…
Q: A manufacturer produces both widgets and gadgets. Widgets generate a profit of $25 each and gadgets…
A:
Q: A linear programming computer package is needed. Edwards Manufacturing Company purchases two…
A: Decision Variable: Suppose-Xij be the no. of units of component i purchased by the company from…
Q: Dr. Thompson makes three bean mixes for coffee shops located in the Austin. The three mixes,…
A: Given data, Types of Beans Shipment amount Cost per shipment Arabica 6000 7500 Robusta…
Q: The manager of a snack section of a grocery superstore has just learned that the department store…
A: Formulate the given problem as shown below: Decision variable Consider,
Q: A small candy shop is preparing for the holiday season. The owner must decide how many bags of…
A: Given Information: D = Number of bags of Deluxe mix S = Number of bags of Standard mix Mix…
Q: A manufacturer produces both widgets and gadgets. Widgets generate a profit of $45 each and gadgets…
A: Given, Profit Margin widgets-$45 Profit Margin gadgets-$55 Set-up cost Margin widgets-$300 Set-up…
Q: you are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it…
A: It is given that; the cost per copy is $0.03, variable cost (VC) = $0.03. Selling price per copy is…
Q: A small candy shop is preparing for the holiday season. The owner must decide how many bags of…
A: Excel Model Preparation:
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?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?In the lawn mower production problem in Example 8.4, experiment with the penalty cost for unsatisfied pickups in week 1. If this cost is sufficiently small, does the company ever produce fewer than seven models in week 1 and allow some week 1 pickups to be unsatisfied?Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
- If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.3-2) The optimal quantity of the three products and resulting revenue for Taco Loco is: A) 28 beef, 80 cheese, and 39.27 beans for $147.27. B) 10.22 beef, 5.33 cheese, and 28.73 beans for $147.27. C) 1.45 Z, 8.36 Y, and 0 Z for $129.09. D) 14 Z, 13 Y, and 17 X for $9.81. 3-3) Taco Loco is unsure whether the amount of beef that their computer thinks is in inventory is correct. What is the range in values for beef inventory that would not affect the optimal product mix? A) 26 to 38.22 pounds B) 27.55 to 28.45 pounds C) 17.78 to 30 pounds D) 12.22 to 28 pounds