2. Problem A-7 (Algo)You are trying to create a budget to optimize the use of a portion of yourdisposable income. You have a maximum of $1,500 per month to beallocated to food, shelter, and entertainment. The amount spent on foodand shelter combined must not exceed $1,000. The amount spent onshelter alone must not exceed $70O. Entertainment cannot exceed $700per month. Each dollar spent on food has a satisfaction value of 7, eachdollar spent on shelter has a satisfaction value of 7, and each dollar spenton entertainment has a satisfaction value of 3.Assuming a linear relationship, use the Excel Solver to determine theoptimal allocation of your funds. (Leave no cells blank - be certain toenter "O" wherever required. Round your answers to the nearest wholenumber.)Decision for FDecision for SDecision for ETotal SatisfactionResourcesUsedTotal budget$ on food and shelter$ on shelter$ on entertainment

F= Dollars spent on Food S = Dollar spent on Shelter E = Dollar spent on Entertainment

Answered: Problem A-7 (Algo) You are trying to…

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

Consider the following integer linear programming problem. Маx Z - 4x +3у Subject to: 4x + 6y < 35 5x +3y < 30 x<9 x, y 20 and integer. What is the optimal solution to the integer linear programming problem? Answer Choices: a. 22 b. 26 с. 25 d. 21
Case Discussion Smithfield Custom Furniture (Part 2) As a result of its consultants' wonderful guidance in 1901, Smithfield Custom Furniture has continued to do extremely well financially. It is now 1987, and the company has been headed by the founder's grandson, Jonas Smithfield III. He has run the company for the past twenty years. The company now has 247 retail stores. 220 stores are spread throughout the 50 states, and 27 stores are located in England, France, and Germany. Each country has 9 stores. In total, the company employs 13,000 people. Approximately 40% are manufacturing, distribution, quality control, design, delivery, administrative, and back-office work. Approximately 60% of the employees are in retail stores. It has been Smithfield Custom Furniture's mission to target the wealthiest segments of the market. The company does all its manufacturing in the United States at six facilities, recently modernized with the latest equipment. They use the finest and most…
<. FROM T. I 13 Paragraph Styles A company produces its automobile model in three plants located in Flint, Michigan; Fresno, California; and Monterrey, Mexico. The cars are distributed to dealers through the regional distribution centers located in Phoenix, Arizona; Davenport, Iowa; and Columbia, South Carolina. Anticipated production at the plants over the next month is 3,300 cars at Flint, 2,600 cars at Fresno, and. 3,100 cars at Monterrey. Based on firm orders and other requests from dealers, the company has decided that it needs to have the following numbers of cars at the regional distribution centers at the end of the month: Phoenix - 2,600 cars; Davenport- 2,800 cars; and Columbia – 3,000 cars. | In order to deal more effectively with unforeseen events (such as the road closing), the company has established two transshipment points between the plants and the regional distribution centers. The two transshipment points are located at Santa Fe, New Mexico, and Jefferson City,…
11
21. United Express Service (UES) uses large quantities of packaging materials at its four distribution hubs. After screening potential suppliers, UES identified six vendors that can provide packaging materials that will satisfy its quality standards. UES asked each of the six vendors to submit bids to satisfy annual demand at each of its four distribution hubs over the next year. The following table lists the bids received (in thousands of dollars). UES wants to ensure that each of the distribution hubs is serviced by a different vendor. Which bids should UES accept, and which vendors should UES select to supply each distribution hub? Distribution Hub Bidder 1 2 3 Martin Products 190 175 125 230 Schmidt Materials 220 150 210 235 155 Miller Containers 225 135 260 D&J Burns 170 185 190 280 Larbes Furnishings Lawler Depot 240 260 220 190 140 130 270 200
8-3 Hospitality Products, Inc. 1.Discuss briefly HPI’s competitive position and strategy.
470 q 16 a speculative stock possessees a _________ probability of _________ return and is currently _______- a. high, negative, underpriced b. high, negative, overpriced c. high, positive, overpriced d. low, negative, overpriced e. low, positive, underpriced
Ex 4.12 Formulate the linear programming model of the following problems. Titan Credit Card Marketing works for HSBC to verify and approve credit card application. TCCM receives P380 for every completed customer application. The company maintained three call agents targeting at P20,000 worth of approvals daily, altogether. In a regular working day, James can process as much as P3000 worth of applications. Mark can process twice as much as Tim. How many credit cards should each call agent process to achieve the target for the day. Formulate the LP model
Referring to Exhibit 1, what is the optimal objective function value for this problem? 500 O 300 800 O It cannot be determined from the given information.
... 13.16 A large Omaha feed mill, B. Swart Processing, prepares its 6-month aggregate plan by forecasting demand for 50-pound bags of cattle feed as follows: January, 1,000 bags; February, 1,200; March, 1,250; April, 1,450; May, 1,400; and June, 1,400. The feed mill plans to begin the new year with no inventory left over from the previous year and backorders are not permitted. It projects that capacity (during regular hours) for producing bags of feed will remain constant at 800 until the end of April, and then increase to 1,100 bags per month when a planned expansion is completed on May 1. Overtime capacity is set at 300 bags per month until the expansion, at which time it will increase to 400 bags per month. A friendly competitor in Sioux City, Iowa, is also available as a backup source to meet demand-but can provide only 500 bags total during the 6-month period. Develop a 6-month production plan for the feed mill using the transportation method. Cost data are as follows:…
Q1. General Appliance Corp. produces refrigerators at three plants: Marietta, Minneapolis and Phoenix. They ship them to major retail outlets in Chicago, Los Angeles and New York City. The accounting, production and marketing departments have provided the following information in the given tables; Plant capacities over the next planning period, retail outlet demand and unit cost of shipping between any plant and retail outlet. The company would like to minimize the cost of their transportation network by identifying how many units to ship between each plant and retail outlet. 1. Formulate this linear optimization problem by clearly listing the decision variables, objective function and constraints. 2. Create a spreadsheet model for this problem and solve it using Solver. What is the minimum cost? Plant Supply Marietta 1200 Minneapolis 800 Phoenix 1600 Retail Outlet Demand Chicago 650 Los Angeles 1450 New York City 1500…
Subject: acounting

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS