How aggressive should a grants manager become in cleaning up an embarrassing error? Explain the reason(s) for your position. If you have any real-world experience/examples, feel free to share but do not disclose names. You can determine the number of sources you need.
Effective Grants Management
Author: Ward, Deborah
A company has four distribution centers, located in Atlanta, Lexington, Milwaukee, and Salt Lake City, and ships to 12 retail stores, located in Seattle, San Francisco, Las Vegas, Tucson, Denver, Charlotte, Minneapolis, Fayetteville, Birmingham, Orlando, Cleveland, and Philadelphia. The company wants to minimize the transportation costs of shipping one of its products. The per-unit shipping cost from each distribution center to each retail location and the amounts currently in inventory and ordered at each retail location are shown in the accompanying table.
Develop and solve an optimization model to minimize the total transportation cost and answer parts a and b.
a. What is the minimum cost of shipping?
First, develop a linear optimization model to determine the optimal mix to minimize total cost. Copy the shipping data into Excel. For the purposes of this solution, create an Excel spreadsheet as shown here .2
Next, add cells to function as the variables, in this case, the number of units shipped from each distribution center to each city. The cell B17 references the number of units from Atlanta to Seattle, the cell B18 references the number of units from Atlanta to San Francisco, the cell C17 references the number of units from Lexington to Seattle, and so on. The static value 0 has been entered into these cells as shown here as a starting point.
Note that this table can be created by copying the original table and filling the entries with zeroes.
Next, identify the objective function. In this case, the objective function is the sum of the number of units from each distribution center to each city times their respective costs. While the individual cells and cell ranges can be referred to using cell references or names, for this exercise, use cell references to write the objective function.
Next, write each constraint as a mathematical equation or inequality. In this case, the constraints are the number of units available at each distribution center and the number of units needed in each city.
Write the constraint for the number of units that can be shipped from Atlanta.
Write the constraint for the number of units that can be shipped from Lexington.
Write the constraint for the number of units that can be shipped from Milwaukee.
Write the constraint for the number of units that can be shipped from Salt Lake City.
Write the constraint for the number of units supplied to Seattle.
Write the constraint for the number of units supplied to San Francisco.
Write the constraint for the number of units supplied to Las Vegas.
Write a research paper on the methods that they have used in terms of social, economical, political, and environmental aspects. This paper is focusing on smart and sustainable cities, how this place is being sustainable and smart building, what kind of methods and approaches they are doing, etc.
Write 400 word responses in your journal for both the Hundley show and your LACMA visit (so 800 words total).
Consider responding to:
What does the accumulation of so many elements in Hundley’s work do to your anxiety level? Does it raise it or lower it or neither?
What are some of the themes you picked up on in Hundley’s work?
What is the vibe of the materials that Hundley uses?
What works stood out to you at LACMA? Why?
What questions did you have?
Which shows were you most drawn to from the BCAM and the Resnick building at LACMA?
Mirza Manufacturing makes four electronic products, each of which comprises three main materials: magnet, wire, and casing. The products are shipped to three distribution centers in North America, Europe, and Asia. Marketing has specified that no location should receive more than the maximum demand and that each location should receive at least the minimum demand. The material costs per unit are magnet–$0.61 , wire–$0.31 , and casing–$0.33 . The following tables show all of the production information, including the number of units of each material required in each unit. Develop and solve an appropriate linear optimization model to maximize net profit.
First, develop a linear optimization model to determine the optimal mix to maximize profit. Define variable names to use for the number of units of each product shipped to each distribution center. For the purposes of this solution process, use NAA for units of product A shipped to the North American distribution center, NAB for units of product B shipped to the North American distribution center, EUA for units of product A shipped to the European distribution center, AA for units of product A shipped to the Asian distribution center, and so on.
Next, identify the objective function. In this case, the objective function is the total profit, the total revenue minus all of the costs. Write the objective function.
Profit Total Revenue Total Production Cost Packing and Shipping Costs Material Cost= − − −
Next, write an equation to calculate each term in the objective function. Write the equation for total revenue.Write the equation for total production cost.
Write the equation for packaging and shipping costs.
Write the equation for the material cost. To do so, first find the equations for the total number of materials used. Start with total number of magnets used.
Next, write the equation for the amount of wire used.
Next, write the equation for the amount of casing used.
Write the equation for the material cost.
Material Cost (Magnets used) (Wire used) (Casing used)= 0.61 + 0.31 + 0.33
Next, write each constraint as a mathematical equation or inequality. In this case, the minimum and maximum demand and the available raw material.
Write the constraint for the demand for Product A in North America.
Write the constraint for the demand for Product B in North America.
Write the constraint for the demand for Product A in Europe.
Write the constraint for the demand for Product A in Asia.
Jaycee’s department store chain is planning to open a new store. It needs to decide how to allocate the 100,000 square feet of available floor space among seven departments. The accompanying data includes the expected performance of each department per month, in terms of square feet (sf). The company has gathered $20 million to invest in floor stock. The risk column is a measure of risk associated with investment in floor stock based on past data from other stores and accounts for outdated inventory, pilferage, breakage, and so on. For instance, electronics loses 24% of its total investment, furniture loses 12% of its total investment, and so on. The amount of risk should be no more than 10% of the total investment. Assume that it is not required that the entire available floor space be used. Answer parts a and b below.
a. Develop a linear optimization model to maximize profit.
Define variable names to use for the square feet for each department. For the purposes of this solution process, use E for square feet of Electronics, F for square feet of Furniture, M for square feet of Men’s clothing, C for square feet of Clothing, J for square feet of Jewelry, B for square feet of Books, and A for square feet of Appliances.
Next, identify the objective function. In this case, the objective function is the sum of the square feet of each department times their respective expected profits. Write the objective function.
maximum profit.
Next, write each constraint as a mathematical equation or inequality. In this case, the constraints are the amount of available floor space, investment capital, the maximum risk, and the minimum and maximum floor space for each department.
Write the constraint for the amount of floor space that can be used.
Write the constraint for the amount of investment capital that can be used.
Calculate the risk per square foot of floor space used by multiplying the risk as a percentage of money invested by the investment per square foot.
What impact does the color of wine have on the rating?
Our team has experienced writers that follow all the codes used in professionalism when writing academic essays. We focus our services on satisfied clients. Through critical attention to detail, our writers abide by all the instructions given by clients. Additionally, the paper format is done according to the dictates of the client in respect to the set academic style. We are proud of completing outstanding top-quality papers.