Please help solve with the constraints. Add constraints to ensure contracts are whole numbers●Add constraints to ensure raw materials never exceed the inventorySet a constraint to ensure the Total Contracts are greater or equal to the existing contracts inC7:E7 PasteClipboardE211234567891011121314151617181920AHomeXLB-InsertPage LayoutCalibri11 AA ===> abSEED 固•- $BIU AvEFontSAlignmentS⠀X ✓ fxCDA$$B1,032.50 $3,500.00 $2,467.50 $550704.50 $2,000.00 $1,295.50 $4501,575.505,000.003,424.50$750Cost Per Unit Units in Inventory Total Units Consumed$2.50750000$1.50220000$1.22370000$-$$▾Formulas Data Review View Help AcrobatGeneral$%958-00NumberSEBIndy Deck BuildersModelManufacturing CostSelling PriceProfit MarginExisting ContractsTotal ContractsRaw MaterialWoodHardwarePaintTotal Building ExpenseTotal ProfitNet ProfitCConditional Format as CellFormatting Table StylesVvStylesFInsertDeleteFormatCellsGRaw Material Required Per ModelWoodHardwarePaintRaw Materials ConsumedWoodHardwarePaintHAAΣ.Σ20055100000AY OSort & Find &Filter SelectEditing1BB310701250OOO0CCOAnalyzeDataAnalysis50095150000ShareSensitivitySensitivityK

To make it convenient, the replication of the given excel model is created.

Add constraints to ensure contracts are whole numbers Add constraints to ensure raw materials never exceed the inventory ● Set a constraint to ensure the Total Contracts are greater or equal to the existing contracts in C7:E7

Add constraints to ensure contracts are whole numbers Add constraints to ensure raw materials never exceed the inventory ● Set a constraint to ensure the Total Contracts are greater or equal to the existing contracts in C7:E7

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

SOLVE THE FOLLOWING ASSIGNMENT PROBLEM:There are 7 work teams, the same ones that must carry out 6 jobs. The time in days that each piece of equipment takes on each job is shown in the following table:Table!!! Assign jobs to teams so that the total sum of days is minimal. Indicate what this minimum amount is.
Five sorority sisters plan to attend a social function. Each requires hair styling andfitting for a gown. Assume that the times required are independent exponentiallydistributed random variables with the mean times for the fittings of 0.6, 1.2, 1.5,0.8, and 1.1 hours, respectively, and mean times for the stylings of 0.8, 1.6, 1.0,0.7, and 1.3 hours, respectively. Assume that the fittings are done before thestylings and that there is only a single hair stylist and a single seamstress available.In what sequence should they be scheduled in order to minimize the total expectedtime required for fittings and stylings?
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements areDay M T W Th F S SuRequirements 6 3 5 3 7 2 3Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have two consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S–Su pair in case of a tie.
A manufacturer is designing a product layout for a new product production. It plans to use a production line for 8 hours per day in order to meet forecasted demand of 150 units per day. The product requires 7 tasks in total. These tasks are namely, A, B, C, D, E, F, and Grespectively. Task A does not have any predecessor to start. To start Task B, it requires Task A to be completed. Starting tasks Cneeds, the task B to be completed. Also, starting task D needed task B to be completed. Task E can only start upon completion of Task C. Whereas starting task F needs the completion of both the tasks D and E. Finally, starting task G needed, task F to be completed. The processing times for tasks, A, B, C, D, E, F. and G are 2.3, 2.1, 0.9, 1.0, 1.2, 1.8, and 1.5 minutes respectively. Applying the most remaining tasks rule for balancing the assembly line, with ties broken according to longest task time first, the tasks that will be assigned to the LAST workstation are O a. All tasks O b. Gonly…
Baking dog treats in her kitchen has been a simple process for Emma to manage. She has two ovens, one sink, a refrigerator, and enough room for two people to work at the same time. However, when Emma moves her business out of her home, she will have a commercial kitchen that can accommodate as many as six people working simultaneously. She had never thought of her business as “production” until the real estate agent who showed her the space asked how many production workers she needs to accommodate. At that point, Emma realized she would be running a production system. Even worse, she realized that she had never even visited a manufacturing facility or set foot on a real production floor. How will she ever manage this process?
find the a. decision variables b. objective function c. constraints
true or false Exceeding constraints would result in a result being feasible?
Minimize Subject to z = 3x + y 3y + 5x > 30 6y + 4x 40 y + x 8 X 0 Y > 0 Solve this using the graphical method. Be sure to clearly show all steps: • Sketch the feasible region ● Determine the corner points Determine the minimum of the objective function ● Upload a picture showing your work here: Choose File No file chosen
Your town is considering updating one of the local parks. They created a linear program that had the following constraints: 1. Spend no more than $100,000 2. Spend no more than $50,000 on new playground equipment 3. Put in at least three basketball courts After running the linear program, the town saw that the program was infeasible. The town has decided to make constraints 1 & 2 goals, instead of hard constraints. How many decision variables would need to be added to the town's linear program, in order to turn it into a goal program with two soft constraints that allow deviation in both directions?
Describe the difference between discrete constraints and overlapping constraints?
A city would like to know how many vehicles it could move through its streets in an emergency. The most likely situation is an evacuation starting at the school and ending at the park. The connections between these two locations, plus their capacity and direction, is shown below. School B Path Capacity Oak Street Elm Street A 10 с E B C 20 15 1 Street D 30 2nd Street E 25 F F 20 Park G 15
E-education is a new start-up that develops, and markets MBA courses offered over the internet. The company is currently located in Chicago and employs 150 people. Due to strong growth, the company needs additional office space. The company has the option of leasing additional space at its current location in Chicago for the next two years, but after that will need to move to a new building. Another option the company is considering is moving the entire operation to a small Midwest town immediately. A third option for the company is to lease a new building in Chicago immediately. If the company goes for first option and leases new space at its current location, it can, at the end of two years, either lease a new building in Chicago or move to the small Midwest town.The following are some additional facts about the alternatives and the current situation.a) The company has a 75 percent chance of surviving the next two years.b) Leasing the new space for two years at the current location…