a) What is the optimal solution and what is the value of the objective function b) Which constraints are binding and which constraint show extra capacity?c) 100 hours of manufacturing time became available .Evaluate the effect? Explain Report Created: 9/16/2012 1:05:22 PMTarget Cell (Max)OriginalValueFinal ValueCellSES4 profitName16440Adjustable CellsOriginalValueFinal ValueNamenumber of units$B$3 Economy$C$3 number of units standardSD$3 number of units deluxeCell80120ConstraintsCellNameCell ValueFormulaStatusSlack$E$6 Fan motors$E$7 cooling coils200 $E$6<=SG$6 Binding320 $E$7<=SG$7 BindingNotSE$8 Manuf time2080 SE$8<=$G$8 Binding???? The production requirements per unit are as follows:Number ofFansManufacturingTime (hours)Number ofCooling CoikEconomyStandard12Deluxe14Max63E + 955 + 135DSA.IE +IE +IDs 200 Fan motors4D = 32 0 Cooling coils14D = 2400 Manufacturing time1S +25 +SE + 125 +E. S. D = 0

Let E, S, and D represent economy, standard, and deluxe. Given data is Objective function: Max…

a) What is the optimal solution and what is the value of the objective function b) Which constraints are binding and which constraint show extra capacity? c) 100 hours of manufacturing time became available .Evaluate the effect? Explain

a) What is the optimal solution and what is the value of the objective function b) Which constraints are binding and which constraint show extra capacity? c) 100 hours of manufacturing time became available .Evaluate the effect? Explain

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

Jill is concerned that the latest short term demand forecast for dog grooming at her Fifteenth Street Dog Salon, is higher than her salon capacity. As she doesn't want to turn business away, she must find a solution to optimizing the capacity levels at her business. Discuss how she should approach this short term problem and suggest long term capacity management methods to eliminate this problem in the future.
1. What capacity decisions should Delta make regarding facilities, equipment, workforce, products/services, working hours, or other resources required to run business processes?
II. TALENT MANAGEMENTPlusCoop is a company that manages co-working space rentals, or popular known as co-working spaces. Established since 2014, PlusCoop offers rental services a workspace intended for freelancers, entrepreneurs, and business operators small medium. The space offered consists of 3 types:1. 4 units of communal workspace - large space, maximum capacity of 40 people, rental mechanism per day (24hours) and per person.2. 20 units of exclusive workspace - enclosed space, maximum capacity of 2 people per room, rental mechanismper month and per room.3. 4 units of conference room - large room, maximum capacity of 20 people, rental mechanism per day, withprojector and screen facilities. Armed with wi-fi facilities, whiteboard, free coffee-tea station, and a strategic location in the city center, During 4 years of operation, PlusCoop has succeeded in becoming a very popular co-working space by their target consumers. However, the pandemic that hit Indonesia in 2019 resulted in…
3. Jonathan owns and operates 5 car window tinting shops in the Rio Grande Valley area. Each tint shops has 4 car stalls. Jonathan only operate 3 stalls at a time, leaving the other stall vacant. Based on his latest revenue reports, he is averaging 2 customers at a time receiving tint while the 3rd stall is empty. Each tint shop is open 12 hours per day. Each car or truck requires 2 hours of work A) what is Jonathan daily design capactity? B) what is Jonathan daily effective capcity? C) what is Jonathan actual out per day D) what is Jonathan utilization rate E) what is Jonathan effective utilization rate
5. Common resources versus private goods Spring is here, and Cho and her dad would like to go fishing for the weekend in New Hampshire. Cho could either go to the river in town where anyone can fish without a permit, or she could drive up to a pond located on her family's property PRIVATE PROPERTY in the countryside to fish. Assume that, no matter where people fish, all of the fish that are caught would be kept (that is, there is no "catch and release" policy). The fish in the private pond are considered and whereas the fish in the river are and In other words, the fish in the private pond are an example of and the fish in the river are an example of Fishing in the river will likely lead to because of which of the following reasons? All fishermen will choose to fish in the pond believing that there are more fish there. All fishermen will choose to fish in the river because of the limited access to the pond. Anyone can fish in the river, and one person's fishing activity decreases the…
2. Four products are processed sequentially on three machines in an aircraft maintenance workshop. The following Table 1 gives the operational data of the problem. Machine 1 2 3 Unit selling price ($) Table 1: Operational data for the problem Manufacturing time (hr) per unit Cost per hr Product Product Product Product $ 1 3 4 10 2 4 2 5 1 2 4 2 1 55 45 37 75 2323 70 Capacity (hr) 500 380 450 (a) Formulate the problem as a Linear Programming (LP) problem (b) Determine the optimal product-mix in the production schedule and the optimal profit
15. Seher Aydinlatma is manufacturing light bulbs based on three months plan. We have the following demand and total capacity forecasts for the next months. Also we know the unit costs for inventory carrying, subcontracting capacity, regular and overtime working costs. March April May Overtime Beginning inventory Regular time Regular time Subcontract Overtime Subcontract Regular time Overtime Demand Capacity Regular Overtime 600 50 Subcontracting 100 Beginning inventory 50 COSTS 15 45 55 3 Regular time Overtime Subcontract Carrying cost SALES PERIOD March 650 N April 700 700 100 100 May 1000 Unit $/product $/product $/product $/product/month 800 100 100 March April May Total Capacity Available (Supply) 50 600 50 100 700 100 100 800 100 Subcontract DEMAND 650 700 1000 Fill the above table using the optimal (transportation) algorithm to generate the aggregate plan that match supply and demand estimates. 100
Describe the difference between discrete constraints and overlapping constraints?
A supermall with two levels is under construction. The plan is to install only 9 elevators at the start, although the ultimate design calls for 16. The question arises as to whether to provide necessary facilities (supports, wiring conduits, motor foundations, etc.) that would permit the installation of the additional elevators at the mere cost of their purchase and installation or to defer investment in these facilities until the elevators actually need to be installed. Additional annual expenses are estimated at $7,000 for each elevator after it's installed. Assume these costs begin one year after the installation. At an interest rate of 12%, compare the net present worth of each option over eight years. The two options are: Option A Provide these facilities now for all seven future elevators at $300,000 Option B Defer the investment as needed. Install two more elevators in two years, three more in five years, and the last two in eight years. The installation of these facilities at…
Deforrest Marine Motors manufactures engines for the speedboat racing circuit. As part of their annual planning cycle, they forecasted demand for the next four quarters. The number of available days of production and the anticipated demand are given below. Employees Production Rate Production Cost Backorder Cost Overtime Cost Overtime Limit Demand Q1 2,400 6,019,000 They also estimated many of the costs required to conduct operations planning. Some of these key figures are listed below. 30 70 units/employee/quarter Q2 2,200 $1,000/unit $200/unit/quarter $1,500/unit <= 25% of Reg. Production Q3 1,700 Q4 1,800 Hire Cost Fire Cost Subcontracting Cost Subcontracting Limit Inventory Cost Initial Inventory $1,200/employee $800/employee $1,800/unit 400 units maximum $100/unit/quarter 280 units Deforrest Marine Motors wishes to maintain the current number of employees for the entire year to follow a level strategy balanced with inventory and backorders as needed. What is the total cost of this…
Given the following data, calculate the approximate number of AP pounds needed to serve 200 guests. Item: Chicken Serving size: 6 ounces (EP) Edible yield: 65 %