Write the correct mathematical models for the objective functions and constraints. 2. A toy company models space ray andzapper. The resources is limited to 1,200pounds of special plastic and 40 hours ofproduction per week. The total toysproduced cannot exceed 800 dozens perweek and the number of dozens of spacerays cannot exceed the number of dozensof Zappers by more than 450. Space raysrequire 2 pounds of plastic and 3 minutesof labor per week. Zappers require 1pound of plastic and 4 minutes of laborper week. The profit for space rays is $8per dozen and for zappers is $5 per dozen.How many for each model of toys areneeded to be produced per week tomaximize profit?

Given data is Plastic required for space ray toys = 2 pounds Labor required for space ray toys = 3…

Answered: Write the correct mathematical models…

Business

Operations Management

Write the correct mathematical models for the objective functions and constraints.

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

Discuss the basic assumptions of the assignment method of linear programming in operations?
the excel file president’s inn guest database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed- and-breakfast inn during one month. room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. guests staying for seven days or more receive a 10% discount. modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.
The information needed is on the second Image
Larry Edison is the director of the Computer Center for Buckly College. He now needs to schedule the staffing of the center. It is open from 8 A.M. until midnight. Larry has monitored the usage of the center at various times of the day, and determined that the following number of computer consultants are required: Time of Day Minimum Number of Consultants Required to Be on Duty 8 A.M.–noon 4 Noon–4 P.M. 14 4 P.M.–8 P.M. 10 8 P.M.–midnight 6 Two types of computer consultants can be hired: full-time and part-time. The full-time consultants work for 8 consecutive hours in any of the following shifts: morning (8 A.M.–4 P.M.), afternoon (noon–8 P.M.), and evening (4 P.M.–midnight). Full-time consultants are paid $52 per hour. Part-time consultants can be hired to work any of the four shifts listed in the above table. Part-time consultants are paid $30 per hour. An additional requirement is that during every time period, there must be at least 2 full-time consultants on duty…
true or false Exceeding constraints would result in a result being feasible?
Zucchero Sugar, Inc. has six processing departments for refining sugar—Affination, Carbonation, Decolorization, Boiling, Recovery, and Packaging. Conversion costs are added evenly throughout each process. Data from the month of August for the Recovery Department are as follows: Metric Tons Beginning Work−in−Process Inventory 0 Transferred in 22,000 Ending Work−in−Process Inventory 6,000 Costs Beginning Work−in−Process Inventory $0 Costs added during August : Direct materials 530,000 Direct labor 250,000 Manufacturing overhead 105,000 Total costs added during August $885,000 The ending Work−in−Process Inventory is 100% and 95% complete with respect to direct materials and conversion costs, respectively. The weighted−average method is used. How many metric tons of sugar were refined and transferred to the Packaging Department in August? A. 6,000 metric tons B.…
Dongguk Furniture Is A Manufacturer Of Fine Hand-Crafted Furniture. During The Next Production Period, Management Is management is considering producing 3 products; dining room tables, dining room chairs, and/or bookcases. The time required for each item to go through the two stages of production (assembly and finishing), the amount of wood required (fine cherry wood), and the corresponding unit profits are given in the following table, along with the amount of each resource available in the upcoming production period. Formulate the objective functions and constraints determine the breakdown of each product and the expected profit
The Primo Insurance Company is introducing two new product lines: special risk insurance and mortgages. The expected profit is $5 per unit on special risk insurance and $2 per unit on mortgages. Management wishes to establish sales quotas for the new product lines to maximize total expected profit. The work requirements are shown below Department Underwriting Administration Work-Hours per Unit Special Risk Mortgage Work-Hours Available d) Solve graphically submit on scanned graph paper( e) Solve in excel using the template provided ( 2,400 800 1,200 Claims a) Identify verbally the decisions to be made, the objective and the constraints( b) Formulate the problem in table form( c) Formulate the problem algebraically(
The Excel file President’s Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn during one month. Room rates include breakfast and are the same for one or two guests; however, any additional guests must pay an extra $20 per person per day for breakfast. Parties staying for seven days or more receive a 10% discount on the room rate as well as any additional breakfast fees. Modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.
How would you write the optimal solution for these?
Airline Scheduling. Alpha Airline wishes to schedule no more than one flight out of a given airport to each of the following cities: C, D, L, and N. The available departure slots are 8 a.m., 10 a.m., and 12 noon. Alpha leases the airplanes at the cost of $5000 before and including 10 a.m. and $3000 after 10 a.m., and is able to lease at most two per departure slot. Also, if a flight leaves for location N in a time slot, there must be a flight leaving for location L in the same time slot. The expected profit (in $1000) contribution before rental costs per flight is shown in the table below. Time Slot 8 10 12 C 10 6 6 D 9 10 9 L 14 11 10 N 18 15 10 a) Formulate an integer linear program model that can be used to find the profit-maximizing schedule. Define your decision variables as Xij = 1 if a flight to destination i occurs in time slot j and Xij = 0 otherwise; and Yj = number of airplanes rented for time slot j. Write the objective function and all the constraints. b)…
I want to know the solution to this problem done by excel solver!