Equipment produces two types of desks, standard and deluxe. Delxe desks have o ime for finishing and polishing After reviewing the hardware and labor required, along with the prC following linear optimization model for profit, where S is the number of standard desks produced an linear optimization model on a spreadsheet and use Solver to find an optimal solution Interpret the the values of the slack variables Maximize Profit= 260 S+340 D 70 S+45 Ds5000 25 Ds750 9S+ 19 Ds500 S20 and Da0 (Availability of pine) (Availability of oak) (Availability of labor) Implement the linear optimization model and find an optimal solution. Interpret the optimal solution atandard desks and deluxe desks. This solution gives the

Equipment produces two types of desks, standard and deluxe. Delxe desks have o ime for finishing and polishing After reviewing the hardware and labor required, along with the prC following linear optimization model for profit, where S is the number of standard desks produced an linear optimization model on a spreadsheet and use Solver to find an optimal solution Interpret the the values of the slack variables Maximize Profit= 260 S+340 D 70 S+45 Ds5000 25 Ds750 9S+ 19 Ds500 S20 and Da0 (Availability of pine) (Availability of oak) (Availability of labor) Implement the linear optimization model and find an optimal solution. Interpret the optimal solution atandard desks and deluxe desks. This solution gives the

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Please solve very soon completely all parts
A company produces a niche hunting blind. Because of the nature of this product, demand varies greatly by season. In fact, demand exceeds production capacity during hunting season (fall,) but is very low in the summer months. To meet the high demand during the fall, the company produces the blind year round, producing more than what is needed in the summer in order to carry over inventory into the peak season. Their production facility can produce at most 60 blinds per month using regular labor at a cost of $125 each. Up to 15 additional blinds can be produced by utilizing overtime labor at a cost of $135 each. The blinds are sold for $225. Because of storage cost and the opportunity cost of capital, each blind held in inventory from one month to the next incurs a cost of $15 per blind. Since demand is uncertain, the company would like to maintain an ending inventory of at least 5 blinds during the warm months (May–September) and at least 15 blinds during the other months…
5/Do not solve it in excel, please.
I need solution of 2.34 as possible as please
QMB Apparel, Inc is a local clothing company that produces two types of shirt: Polo Shirts (P) & Dress Shirts (D). The profit contributions for each shirt and the associated production restrictions (in number of minutes available) are listed below: Polo Shirts (P) Dress Shirts (D) $25 $30 Profit per Unit Cutting Sewing Inspection Polo Shirts (P) Dress Shirts (D) Number of Minutes Available 40 50 1,200 40 1,100 20 1,050 60 70 Using the information in the tables above, what is the optimal amount of Polo Shirts (P) and Dress Shirts (D) that QMB Apparel should produce to maximize it's profits? 40 Polo Shirts (P) & 10 Dress Shirts (D) 5 Polo Shirts (P) & 20 Dress Shirts (D) 30 Polo Shirts (P) & 0 Dress Shirts (D) O0 Polo Shirts (P) & 48 Dress Shirts (D) 010 Polo Shirts (P) & 40 Dress Shirts (D)
Sturgill Manufacturing Inc. needs to predict the numbers of machines and employees required to produce its planned production for the coming year. The plant runs three shifts continuously during the workweek, for a total of 120 hours of capacity per week. The shop efficiency (the percent of total time available for production), which accounts for setups, changeovers, and maintenance, averages 70% with a standard deviation of 5%, which reduces the weekly capacity. Six key parts are produced, and the plant has three different types of machines to produce each part. The machines are not interchangeable as they each have a specific function. The time to produce each part on each machine varies. The mean time and standard deviation (in hours) to produce each part on each machine are shown below: Mean Time Part Type Machine A Machine B Machine C 1 3.5 2.6 8.9 2 3.4 2.5 8 3 1.8 3.5 12.6 4 2.4 5.8 12.5 5 4.2 4.3 28 6…
Tokyo Company needs the resources indicate below to produce its products Product Labor (hr./unit) Material (Ib./unit) Profit (S/unit) $3 2. 2. 3. 4. Tokyo Company has a daily labor capacity of 240 available hours and a daily supply of 400 pounds of material. The general linear programming formulation for this problem is as follows maximize 2 3 + Sxy + 2 subject to Sx + 2 + 4xy s 240 4x + Gry + 3y s 400 Management has developed the following set of goals, arranged in order of their importance to the firm (1) Because of recent labor relations difficulties, management wants to avoid underutilization of normal production capacity (2) Management has established a satisfactory profit level of S500 per day (3) Overtime is to be minimized as much as possible (4) Management wants to minimize the purchase of additional materials to avoid handling and storage problems.
The average basket size per purchase per agent in the fashion category in April is Rp.180.000,-. A third of agents made only 1 purchase that month. A third made 2 purchases that month. The rest made an average of 3.5 purchases that month. What % of agents in April bought fashion? Sales of ABC Fashion category comes from two merchants: Verry Venka (VV) and Vuka Lavak (VL). VV typically constitutes 40% of the fashion sales in ABC. VV's COO came to us and said, "Let's make our relationship stronger. We would like to be the merchant of your agents." VV decided to launch a free shipping promotion for ABC agents during the 2ndhalf of May. The promotion is expected to grow VV's sales at ABC by 45% for the remainder of the month, over current forecasted figures for the rest of May. In addition to that, a third of VL's sales are expected to be shifted to VV. If this happens, by what % will ABC's overall fashion sales exceed target in May? If this happens, what % of fashion sales will come from…
Consider a three-units system presented by the cost function as: C1 = 0.03 P12 + 8.2P1 + 452 C2 = 0.025 P22 + 8.3P2+ 500 C3 = 0.0035 P32 + 7.44P3 + 612 Where P1, P2 and P3 are in MW and the total load demand, PD is 952 (in MW). (a) Compare these three-units system with and without the economic dispatch by drawing the bar graphs for the power of each plants and the total cost in RM/h. (b) Determine the percentage of saving, with and without the optimal economic dispatch. Discuss the answer. (c) Now, P1, P2 and P3 are subjected to the following limits: 50 MW < P1 < 300 MW 100 MW < P2 < 400 MW 100 MW < P3 < 350 MW Compare with the costs in (a). Justify the answer.
Taylor Smith owns a small clothing company, Cuteness for You, that offers an online subscription and personal shopping service targeted at busy families with children aged newborn to five years old. Currently, Taylor has one level of subscription service, the standard service. For $100 a month, the standard service provides its customers a monthly delivery of 10 clothing items carefully chosen to match the child's size, gender, and emerging style. The online clothing subscription market is fairly new but is growing rapidly and thus Taylor is considering extending the product line to increase its market share and profits. Taylor is debating whether to add a premium subscription service featuring profitable high-markup items for $125 per month, a basic subscription service that contains lower-markup popular items priced at $75 per month, or possibly both. Taylor knows that the new product lines provide an opportunity to attract more customers and possibly increase revenues and profit,…
10/Do not solve it in excel , please.