Use Solver Table to analyze the effect of storage capacity increase at the DCs and cotton production increase at the farms. Vary the production capacity at all three farms from 0% to 25% (in increments of 5%) and the storage capacity at all four DCs from 0% to 25% (in increments of 5%) and track the optimal profit. Comment on the change in profit with changes in the storage capacities and production capacity. Note that all changes have to be made simultaneously. You cannot run multiple Solver Table analyses.
Also read:
- Use Solver Table to analyze the effect of storage capacity increase a
- It is late June, and Sandra Huchim, head of operations at Mintendo, and Bill Smith, head of salesof We “R” Toys, are about to get together to discuss production and marketing plans for the next6 months. Mintendo is the manufacturer of the popular Game Girl handheld electronic game that is sold exclusively through We “R” Toys retail stores. The second half of the year is critical toGame Girl’s success, because a majority of its sales occur during the holiday shopping period.Sandra is worried about the impact that the upcoming holiday surge in demand will have on herproduction line. Costs to subcontract assembly of the Game Girls are expected to increase, andshe has been trying to keep costs down, given that her bonus depends on the level of productioncosts.Bill is worried about competing toy stores gaining share in the handheld electronic game marketduring the Christmas buying season. He has seen many companies lose their share by failing tokeep prices in line with the performance of their products. He would like to maximize the GameGirl market share in the handheld electronic game market.Both Sandra’s and Bill’s teams produce a joint forecast of demand over the next six months, asshown in Table 9-7.We “R” Toys sells Game Girls for $50 apiece. At the end of June, the company has an inventoryof 50,000 Game Girls. Capacity of the production facility is set purely by the number of workersassembling the Game Girls. At the end of June, the company has a workforce of 300 employees,each of whom works 8 hours of regular time at $15/hour for 20 days each month. Work rulesrequire that no employee work more than 40 hours of overtime per month. The various costs areshown in Table 9-8.Sandra, concerned about controlling costs during the periods of surging demand over theholidays, proposes to Bill that the price be lowered by $5 for the month of September. Thiswould likely increase September’s demand by 50 percent due to new customers being attractedto Game Girl. In addition, 30 percent of each of the following two months of demand wouldoccur in September as forward buys. She believes strongly that this leveling of demand will helpthe company.Bill counters with the idea of offering the same promotion in November, during the heart of thebuying season. In this case, the promotion increases November’s demand by 50 percent, owingto new customers being attracted to Game Girl. Additionally, 30 percent of December’s demandwould occur in November as forward buying. Bill wants to increase revenue and sees no betterway to do this than to offer a promotion during the peak season.a. Which option delivers the maximum profit for the supply chain: Sandra’s plan, Bill’splan, or no promotion plan at all?b. How does the answer change if a discount of $10 must be given to reach the samelevel of impact that the $5 discount received?c. Suppose Sandra’s fears about increasing outsourcing costs come to fruition and thecost rises to $22/unit for subcontracting. Does this change the decision when thediscount is $5? need to be able to explain how i got the answer not necessary to show all work but this one is giving me fits.
- Need these 2 questions answered. 150 words total 75 for each question. Files are attached. Need referenced if using other source materials including chapter pages and appendix table. Thank you Question 1) Keri is the owner of a new restaurant in the downtown area of her hometown. To continuously improve service, she would like to know if completed dishes are being delivered to the customer’s table within one minute of being completed by the chef. A random sample of 75 completed dishes showed that 60 were delivered within one minute of completion. Calculate the 90%, 95%, and 99% confidence interval for the true population proportion. Interpret your response within the context of the situation. Refer to Chapter 17, pp. 427-430 on calculating confidence intervals. Click here for Table A.2 from the appendix. Your response should be at least 75 words in length, unless otherwise specified. You are required to use at least your textbook as source material for your response. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations. Question 2) A random sample of 100 students attending a concert spent an average of $142 on their tickets with a standard deviation of $47.50. Calculate the 90%, 95%, and 99% confidence intervals for the mean amount of money spent by all students attending the concert. Interpret your response within the context of the situation. Refer to Chapter 17, pp. 427-430 on calculating confidence intervals. Click here for Table A.2 from the appendix. Your response should be at least 75 words in length, unless otherwise specified. You are required to use at least your textbook as source material for your response. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations.
- Kiosk Inventory Project Description: In this project, you will create database objects to track the inventory of items for sale in a kiosk located in a college snack bar. You will create a table and import data from Excel to create a second table. You will create a simple query, a form, and a report.
- Identify any challenges you have in setting up a linear programming problem in Excel, and solving it with Solver
- Linear Programming With Excel Solver Project
- principles of economics Which statement is true? A) Today more workers in the U.S. are members of labor unions than any time in our history. B) Today labor unions are weaker than any time in the last 100 years. C) No major labor union has called a strike since the 1940s.D) Labor unions are relatively strong in the public (government) sector. 2. Exclusive union strategy involves A) increasing the demand for the final product, thereby increasing the demand for labor. B) restricting the supply of union labor. C) setting job standards and entry qualifications for members. D) organizing all workers and bargaining for a wage.E) negotiating only after a strike has been called. 3. An example of an exclusive union would be A) the International Brotherhood of the Teamsters. B) the Communications Workers of America. C) the American Medical Association. D) the United Steel Workers. 4. In which one of these years was labor union membership the highest? A) 1940 B) 1960 C) 1980 D) 1990 5. Which of the following laws stated that attempts to monopolize, conspiracies in restraint of trade, and conspiracies to monopolize were illegal? A) The Federal Trade Commission Act B) The Clayton Act C) The Sherman Antitrust Act D) All of the choices. E) None of the choices 6.Until the passage of the Airline Deregulation Act of 1978, the Civil Aeronautics Board controlled all of the following except A) fares. B) assigned routes. C) profits. D) entry into the industry. 7. The Clayton Act prohibited A) interlocking directorates. B) all forms of monopoly. C) foreign control of U.S. corporations. D) false and deceptive advertising. 8. Which statement is true? A) Microsoft is subject to American antitrust laws, but not those of Europe, Asia, or elsewhere. B) Microsoft has never been involved in an antitrust suit. C) The European Commission fined Microsoft over $600 billion for its anticompetitive behavior. D) Microsoft has always gone out of its way to be helpful to its competitors. 9. A monopolist operates at the minimum point of her ATC curve A) only in the short run. B) only in the long run. C) in both the short run and the long run. D) in neither the short run nor the long run. 10. Which of the following is characteristic of a monopoly? A) The absence of political power B) Close substitute products C) The ability to make an economic profit in the long run D) Operating at peak efficiency. (I will send the image) 11. This firm will charge a price of A). $8. B) $9.65. C) $10. D) $12. E) $16 12. Statement I. Only natural monopolies are legal in the United States. Statement II. Large firms generally operate at peak efficiency. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 13. The nation's largest bank has assets over A) $2.5 billion. B) $25 billion. C) $250 billion. D) $800 billion. E) $1.8 trillion. 14. Which statement is true? A) Our money supply is fixed by law and can be raised by only a very small percentage each year. B) Our money supply is backed by gold. C) Credit cards are a form of money. D) Money makes an excellent store of value during times of inflation. E) One of the basic jobs of money is a standard of value. 15. The first bankers were A) goldsmiths. B) printers. C) storekeepers. D) innkeepers. E) blacksmiths. 16. Suppose you had no money in your checking account and your bank granted you overdraft privileges. You then went out and charged $20 on your debit card. How much would your bank charge you in fees for using your overdraft privileges? A) 0 B) $5 C) 15 D) 35 E) $50 17. Statement I: John Maynard Keynes called the hoarding of money at very low interest rates a "liquidity trap." Statement II: Since the late 1990s, Japan has been caught in a liquidity trap. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 18. Banks can A) create money, but not destroy money. B) destroy money, but not create money. C) create and destroy money. D) neither create nor destroy money. 19. The Federal Open Market Committee is made up of all of the following, except A) the board of governors. B) the chairman of the board of governors. C) the president of the United States. D) the president of the Federal Reserve Bank of New York. E) the presidents of four Federal Reserve Banks other than the New York Bank. 20. The Federal Reserve System A) has regional Federal Reserve Banks that make most of the decisions. B) makes decisions subject to the approval of the President. C) makes its major policy decisions in its Open Market Committee. D) makes decisions subject to the approval of Congress. 21. With economic development comes each of the following, except A) a decline in the birth rate. B) an increase in the stock of capital. C) rising per capita GDP D) a declining wage rate. 22. Our educational standards today. A) are the highest in history. B) are much higher than they were 50 years ago. C) are the same as they were 50 years ago. D) are much lower than they were 50 years ago. 23. Brazil should be classified as a(n) A) very poor LDC. B) middle-rank LDC. C) NIC. D) industrial country. 24. The most important reason for our slow rate of productivity growth over the last three decades (of those listed below) is A) lagging business sales. B) foreign imports. C) our low savings rate. D) high tax rates. 25. Structural unemployment occurs when A) workers have quit one job and are looking for a better one. B) high school graduates enter the labor market every June. C) the business cycle is in a downturn and people are laid off. D) the people without jobs have skills that don't match the available job openings. 26. Unemployment caused by economic decline or recession is called A) frictional unemployment. B) cyclical unemployment. C) natural unemployment. D) necessary unemployment. E) structural unemployment.. 27. The recession of 2001 was caused by A) the events of 9/11. B) a decline in consumer spending. C) a decline in investment spending. D) the war in Iraq. 28. A budget deficit is the A) annual excess of government spending over revenue raised by taxes, fees, and charges. B) shortfall of Social Security collections toward payment of benefits. C) amount by which tax revenues and borrowed funds fall short of government expenditures. D) excess of tax revenues over expenditures. E) amount by which tax revenues exceed borrowed funds. 29. The consumer price index is created by A) calculating the cost of a "basket" of consumer goods typically bought by an American family in any year as a percentage of their cost in a base year. B) the Congressional Budget Office. C) averaging the price increases for all consumer goods in the GDP and adding 100. D) dividing nominal dollar consumer expenditures by base year consumer expenditures. 30. Statement I: When equilibrium GDP and full employment GDP are equal, there is no inflationary gap and no deflationary gap.Statement II: Equilibrium GDP is an ideal goal that can never be attained. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 31. When government expenditures in a given year are less than tax receipts, there exists A) a budget deficit. B) public revenue. C) full-employment taxation. D) a budget surplus .32. As price rises, the quantity ______________ rises. A) demanded B) supplied C) demanded and supplied 33. If the MPC were .75, what change in government spending (in billions of dollars) would be required to cause the equilibrium level of GDP to fall by 100? A) A decrease of 25. B) A decrease of 50. C) A decrease of 75. D) A decrease of 100. E) A decrease of 125. (I will send the image) 34. When price is $8 A) quantity demanded is greater than quantity supplied and, therefore, price must fall to get to equilibrium price. B) quantity demanded is greater than quantity supplied and, therefore, price must rise to get to equilibrium price. C) quantity supplied is greater than quantity demanded and, therefore, price must fall to get to equilibrium price. D) quantity supplied is greater than quantity demanded and, therefore, price must rise to get to equilibrium price. 35. Usury is considered the charging of A) higher interest rates than people are willing to pay. B) lower interest rates than people are willing to pay C) unconscionably high interest rates. D) extremely low rates of interest. 36. The present value of a dollar rises as A) the interest rate declines and the number of years you wait for your money declines. B) the interest rate rises and the number of years you wait for your money rises. C) the interest rate declines and the number of years you wait for your money rises. D) the interest rate rises and the number of years you wait for your money declines. 37. In economics we say the amount of land is A) fixed. B) variable. C) both fixed and variable. D) neither fixed nor variable. 38. Which is not determined by supply and demand? A) The wage rate B) The interest rate C) Rent D) Profits 39. Which of the following is false? A) The supply of land is fixed. B) When the demand for a plot of land rises, its supply will rise. C) Land is most efficiently used in cities. D) The rent on a particular piece of land is based on the MRP schedule of the highest bidder. 40. If you knew that interest rates would be rising, then you would predict that the present value of $1 received 5 years from now A) would be higher. B) would be about the same. C) would be lower. D) could be higher or lower. 41. Changes in rent on a plot of land are chiefly due to A) changes in demand. B) changes in supply. C) changes in both demand and supply. D) changes in neither supply nor demand. (I will send the image) 42. The horizontal dotted line is A) a price ceiling. B) a price floor. C) either a price ceiling or a price floor. D) neither a price ceiling nor a price floor. 43. These lenders avoid using the term "interest," but their borrowers still do pay a charge for borrowing money. This would be considered ___________ lending. A) Islamic B) payday C) fringe D) sub-prime 44. __________ sees the entrepreneur as an exploiter of labor. A) Joseph Schumpeter B) Frank Knight C) Henry George D) Karl Marx 45. A more equal distribution of income A) might hurt the incentive to work .B) would not hurt the incentive to work C) would be opposed by nearly all Americans D) would hurt the poor. 46. Between 1994 and 2005 our welfare rolls A) declined substantially every year. B) declined slightly every year .C) declined most years. D) stayed about the same. E) rose most years 47.Who expressed this view? "Unlike the present period, (black) inner-city communities prior to 1960 exhibited the features of social organization—including a sense of community, positive neighborhood identification, and explicit norms and sanctions against aberrant behavior." A) Charles Murray B) William Julius Wilson C) Mickey Kaus D) Lisabeth Schorr E) Celia Dugger 48. According to Darity and Myers A) black men are becoming increasingly marginal to our economy B) the basic cause of poverty is welfare dependency C) the best solution to poverty is the negative income tax D) as our economy continues to expand, black poverty will decline (I will send the image) 49. The percentage share of income of the bottom quintile on curve X is A) 0. B) 5. C) 10. D) 15. E) 20. 50. The percentage of people living in poverty in 2006 in the U.S. was _______. A) 6 B) 11.7 C) 12.3 D) 15.2 51. Child poverty is A) much more of a problem in France, Germany, and Japan than it is in the U.S. B) less of a problem in the United States than in Canada, Britain, or Italy. C) more of a problem in Sweden, Denmark, and Ireland than it is in the U.S. D) much more of a problem in the U.S. than in virtually all other industrialized countries. 52. Statement I: Social Security payments help mostly the poor. Statement II: Poverty may be defined as a relative concept and as an absolute concept. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 53. Compared to their levels in 1999, the poverty line has ______ and the minimum hourly wage has ________. A) gone up; gone up B) stayed the same; stayed the same C) gone up; stayed the same D) stayed the same; gone up 54. In which year was the poverty rate the lowest? A) 1960 B) 1973 C) 1984 D) 1993 E) 2006 55. Which statement is true? A) Most economists support rent control laws. B) Usury laws and rent control are price ceilings. C) Usury laws have never had any effect because they are set well above interest rates. D) None of the choices. (I will send the image) 56. If price were set by the government at $3, there would be a price _____________, that would cause a ___________ of _______ units. A) floor, surplus, 12 B) floor, shortage, 12 C) ceiling, surplus, 14 D) ceiling, shortage, 14 57. Sue Ann Buchanan, can make $800,000 on the pro tennis tour, but would be willing to do it for $200,000. Her economic rent is A) $200,000. B) $600,000. C) $800,000. D) $1,000,000. 58. Despite their fantastic employment gains, African American men earn ____% of what white men earn. A) 65 B) 55 C) 60 D) 76 59. Since 1996, productivity growth has ________ and real wages have ______. A) risen; risen B) fallen; fallen C) risen; fallen D) fallen; risen. 60. Which statement is false? A) The minimum wage has NOT kept up with the rate of inflation .B) The average real hourly earnings fell steadily from 1973 to 1993. C) Workers with some high school education make about the same average annual earnings as those with high school diplomas. D) It is harder for a middle class student to get a college degree because since 1979, the cost of going to college has gone up twice as fast as the rate of inflation.
- Regardless of the career path that you choose, the ability to define and formulate problems, find solutions and communicate your results is critical. You will have one project in Intermediate Algebra that will allow you to demonstrate your skills and help your teachers assess the General Education Outcomes (listed below) as stated by Barton County Community College. General Education Outcomes Fundamental outcomes: The student shall develop: F-1. An ability and willingness to think critically about any subject area and to generate logical questions. F-2. Problem-solving skills that can be used to seek answers to questions that arise within any subject area. F-3. A set of values, attitudes, and beliefs within the context of any subject area. F-4. An understanding of the historical perspective of a given subject area and how the history of a human endeavor has interacted with development of the subject area. F-5. A knowledge of information storage, access, and retrieval and how information technologies relate to a given subject area. F-6. An appreciation of the multicultural aspects of human endeavor and how this relates to the development of a given subject within different cultures. F-7. An understanding of relevance of a given subject to the individual students life and how the student can develop habits that encourage life-long, independent learning.