I need to respond to two of my peers

User Generated

Xhzzvr108

Business Finance

Description

In order to reinforce your understanding of the power and effectiveness of linear programming, review discussion questions 2-1, 2-2, and 2-3 in the textbook.

Discussion Question: Describe the reason why spreadsheets are so applicable to linear programming, and provide an example where linear programming is applicable with a limited data set. Post an example where a spreadsheet can be used instead of hard coding to obtain fast results.

When responding to at least two of your classmates, discuss if you agree with their reasoning for the applicability of spreadsheets to linear programming. Provide details to support your response.

Refer to the Module Two Discussion Rubric for directions on completing these discussions.

Unformatted Attachment Preview

Linear Programming and NASA Kanija Sayles posted Jul 24, 2018 7:38 PM In addition to studying the universe, the National Aerospace and Space Agency (NASA) also monitors the Earth. NASA has 51 active satellites in space monitoring the Earth’s environmental conditions (Nagaraja, 2017). Some of the components that are monitored are soil temperature, atmospheric carbon dioxide, ocean color, sea ice thickness, temperature and weather. The satellites transfer the data to the Space Communications and Navigation (SCaN), and SCaN uploads the data to data warehouses around the world (Campbell, 2018). The amount of data going to the repositories is in the petabytes. Depending on the satellite, the data goes to SCaN once every 14 hours to once a week. The majority of NASA’s information is available for public use (Mochinski, 2018). Emergency responders in California Fire Departments can use temperature data to detect hot spots in forests. These hot spots can be indicative of forest fires. Instead of sorting through Pb of data by hand, which would take decades, the limited temperature data sets can be downloaded from the repositories to an Excel spreadsheet, and maximum temperatures can be highlighted. This would provide an “at a glance” visual of where the hot spots are. A linear programming model can be created in Excel to help emergency responder make the decision to mitigate a hot spot in a forest. There are four assumptions, or technical requirements, that need to exist in the model: certainty, proportionality, additivity, and divisibility (Balakrishnan, 2013). These assumptions deal with the properties of the quantitative data. Excel is a powerful tool. It can handle large data sets. It has formulas, data analysis tools, charts and formulas to turn large data sets into useful information. What If analyses and decision making tools can be provided using the appropriate Add Ins and features within Excel (Balakrishnan, 2013). These digital options are far better than pen and paper. References Balakrishnan, N. R. (2013). Managerial decision modeling with spreadsheets (3rd ed.). Upper Saddle River: Prentice Hall. Campbell, A. (2018, June 15). Space Communication and Navigation. Retrieved from NASA.gov: https://www.nasa.gov/directorates/heo/scan/index.html Mochinski, R. (2018, June 14). NASA Freedom of Information Act (FOIA). Retrieved from NASA.gov: https://www.nasa.gov/FOIA/index.html Nagaraja, M. (2017, June 26). Earth Science Missions. Retrieved from NASA.gov: https://smd-prod.s3.amazonaws.com/science-pink/s3fspublic/thumbnails/image/Earth_Fleet_ColorKey%20webupdate%20070717.jpeg Discussion 2: Spreadsheets and LP Nicole Wisniewski posted Jul 24, 2018 3:48 PM Spreadsheets are applicable to linear programming as they provide clear structure and power calculation tools for modeling numerous scenarios. It is easy to enter linear mathematical models and then manipulate them using Excel. The Solver add-in, in particular is useful in running iterative scenarios until an optimum solution is found. I chose to play with an example using the volleyball boosters snack stand that I help run each Fall. The snack stand offers Pizza by the slice, snacks (individual size bags of chips, pretzels,etc.), candy, Gatorade and water. While this problem is a 'maximize profit' problem, I set up the Excel spreadsheet using the average sales units for each type of item, and hoped to work to find optimum pricing. The constraints entered were the max price that the boosters believe can be charged for each item, and the minimum required revenue to make the stand worth being open. Of course, the solution ended up being to charge the max price for each item. I should have just known that up front, and had given it more thought I would have. However, going through the process of determining the constraints and how to structure them, and determining how structure the scenario in general was a great exercise to play with different ways to approach the problem. Because this turned out to be such an "easy" problem, I thought about trying to find a new example, but I did learn through this exercise, so I am sticking with it. Below is a snapshot of my Excel sheet. Volleyball Boosters Concessions Pricing Mix (Maximize Profit) Pizza P Unit Price Units Profit Constraints: Pizza limit gatorade limit Snacks S 2.5 88 1.25 Gatorade G 1 15 1 Water W 2 15 2 1 1 Candy C 1 20 1 1.5 35 1.5 227.5 2.5
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Linear Programming and NASA
Kanija Sayles posted Jul 24, 2018 7:38 PM
In addition to studying the universe, the National Aerospace and Space Agency
(NASA) also monitors the Earth. NASA has 51 active satellites in space monitoring the
Earth’s environmental conditions (Nagaraja, 2017). Some of the components that are
monitored are soil temperature, atmospheric carbon dioxide, ocean color, sea ice thickness,
temperature and weather. The satellites transfer the data to the Space Communications and
Navigation (SCaN), and SCaN uploads the data to data warehouses around the world
(Campbell,

2018).

The

amount

of

data

going

to

the

repositories

is

in

the

petabytes. Depending on the satellite, the data goes to SCaN once every 14 hours to once a
week.
The majority of NASA’s information is available for public use (Mochinski,
2018). Emergency responders in California Fire Departments can use temperature data to
detect hot spots in forests. These hot spots can be indicative of forest fires. Instead of sorting
through Pb of data by hand, which would take decades, the l...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags