Description of this paper

BUS 204 Quantitative Business Analysis Problems

Description

solution


Question

Question;Q1Below are the scores achieved during the first half of Bus 204 in aprior semester and the final overall total course score. How well dothese averages predict the final course score?Q1 and 2Q Average13&%52%93%73%55%82%68%62%30%88%86%63%42%68%28%59%61%60%50%35%41%58%64%36%48%64%62%22%48%83%55%51%64%31%57%44%29%66%93%68%34%66%18%63%60%65%78%70%63%First half gradesHW 1-6HW Average MT Score58%49%106%102%96%102%102%94%94%94%102%101%97%76%95%61%103%103%74%67%83%96%94%94%83%100%98%97%87%78%101%103%77%95%34%71%73%53%98%102%101%82%106%15%103%102%73%98%98%97%81%69%68%80%81%68%96%85%77%86%72%82%85%65%82%47%70%111%82%97%81%82%86%59%59%61%92%53%49%62%74%76%38%93%43%65%55%65%92%103%76%62%73%41%80%81%49%100%69%66%Total75%67%69%86%92%79%92%77%83%88%90%92%78%70%88%61%73%102%78%88%80%79%86%77%66%77%93%76%61%65%87%78%61%90%50%68%61%51%93%93%91%64%81%49%85%93%63%91%78%84%Question 2The data below show the value of a $1 investment in the S&P 500 at the end of 1926 and how it would have grown to the end of 2009 with dividends reinvested.Graph these values on a line chart, then use Excel's Trendline and test every regression option it offers, including all the polynomial options. Of all theregressions, which form yields the highest R Squared?Year19281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013Return21.7%-17.7%-28.3%-41.0%-2.9%106.5%12.1%32.9%37.9%-27.5%15.6%-8.7%-0.1%10.2.2%39.8%23.9%39.4%-14.9%-0.2%-6.7%7.9%29.0%13.2%7.7%2.5%42.4%16.4%6.2%-8.1%41.0&.9%5.1%14.6%-2.5%17.2%10.3%21.0%-7.0%43.4%34.9%-6.2%-0.7%28.5%22.0%-14.7%-20.0%47.8%32.9%21.6%.2%32.0%32.5%4.4%10.5%35.5%4.3%41.9%24.0%17.3%33.8%30.5%-16.0%34.9%8.4%43.4%3.2%14.2%14.6%7.2%-3.6%28.2%1.1%7.9%-7.5%61.7%27.8%16.0%24.3%8.9%-41.5%55.6%24.7%-11.9%18.4%29.1%Example: GrippoGrippo Golf Glove Company maeks two different brands of golf gloves. One is a full-fingered gloveand the other is a half-fingered model. Grippo currently has orders for more gloves than it can producein time for the upcoming golf season. The scarace resource in the manufacture of these gloves islabor time. Grippo has available 400 hours in the cutting and sewing department, 250 hours in thefinishing department, and 150 hours in the pacckaging and shipping department. The departmenttime requirements and the profit per box (1gross) are given below:Cutting andSewingFull FingerHalf FingerFinishingPackagingand ShippingProfit31.51.5211$20$25Find the optimal product mix forGrippo, assuming Co. wants toMaximize profitLinear Programming On ExcelExample: Doc's DogsDoc's Dog Kennels, Inc., provides overnight lodging for a variety of pets. A particularfeature at Doc's is the quality of care the pets receive, including excellent food. Thekennel's dog food is made by mixing two brand-name dog food products to obtain whatDoc's calls the "well balanced dog diet" The data for the two dog foods are below:Dog FoodBark BitsCanine ChowCost perOunceProtein (percent)Fat (Percent)$0.025$0.03030402010If Doc wants to be sure that his dogs receive at least 6 ounces of protein and 2 ouncesof fat per day, what is the minimum cost mix of the two dog food products?Mary Annette's Puppet Shop spends $10,000 per month on internet advertising to sell its toys. Google costs $.50 per click, Yahoo, $.30 per click, and Facebook,$.40 per click. The CEO wants to make sure the company spends at least 25% of its budget on each vendor. Each click on Google yields $3 in profit, Yahoo,$2, Facebook, $1. The Shop must sign a contract specifying the maximum number of clicks it will buy per month. What is the maximum number of clicks itshould buy from each vendor to maximize its profits? (Hint: Let X1 = dollars spent on Google, X2 = dollars spent on Yahoo, X3 = dollars spent on Facebook.)Question 4The manager of a "6/10 Market" opens his store at 6AM, closes at 10PM. He wants at least 4 workers on duty during everyhour of the week, 6 on weekends. Each worker works the standard 5-8 plan. Use Solver to solve this staff scheduling problem(see "Demand Matrix ") using the integer constraint. How many workers will be needed? (Hint - This will not have a perfectsolution with zero surpluses and shortages.)INPUTS:DEMAND MATRIX A: Enter the number of workers needed each 2 hour span.ShiftShiftSunMonTueWed12AM-2AM100002AM-4AM200004AM-6AM300006AM-8AM463338AM-10AM5633310AM-12PM6744412PM-2PM774442PM-4PM874444PM-6PM974446PM-8PM1074448PM-10PM11743310PM-12AM120000ThuFri000000333344444445453500Total Workerhours:Unadjusted Workers Required:Sat00077777777052013Question 5The Blisters Saddle Company manufactures its saddles in three plants and sells them in fourregions. The cost to transport a unit from each plant to each region is shown. Also shown isthe anticipated demand this quarter from each region and the capacity that each plant willhave in terms of how many units it can supply this quarter. Determine the optimal shippingplan to minimize shipping costs.Transportation Cost Matrix: Cost per Unit Shipped FromEach Plant to Each RegionPlant 1Plant 2Plant 3DemandEast$21.55$11.29$15.34210North$10.00$18.79$11.38160South$22.67$22.93$10.52110West$23.97$10.34$15.52200Supply200250350Based on the asset allocation problem solved in class, start with a 100% allocation to the S&P 500. Assume the investor wants tomaximimze the minimum return she would have experienced over all 30 year-periods 1928-2013 using the equity assetclasses shown below. She also wants to track the expected returns and the worst one year loss. Use Solver to determinethe best allocation to achieve this. (Hints: Use GRG Nonlinear as the solution method and only constraint needed is thatthe allocations must sum to 100%.)Q6.Optimization"How should I allocate the money in my portfolio to maximize minimum returns?"INPUTS:Objective: Maximize Minimum Return over 30 yearsSubject to Constraints:Sum of Allocations = 100%OUTPUTS:Minimum 30-year return (based on all 30-year returns):Expected 30-Year Return (based on all 30-year returns):Worst one year loss:Allocation:100%0%0%0%0%US StocksS&P 500-Large Cap Large Cap Small CapYearBlendGrowthGrowth37.5%44.2%28.4%1928-10.8%-10.1%-35.5%1929-28.2%-29.5%-35.3%1930-43.6%-37.2%-45.8%1931-8.5%-6.3%-0.3%193251.0%47.1%108.0%19333.0%10.8%18.6%193443.1%39.7%54.1%193530.1%24.5%47.1%1936-33.4%-34.1%-44.2%193726.4%36.7%37.3%19383.0%1.3%3.7%1939-7.6%-9.0%-5.0%1940-10.4%-13.4%-8.1%194114.9%15.6%.2%194225.4%24.0%52.9%194318.8%16.0%40.0%194434.8%33.3%59.2%1945-5.6%-7.9%-9.9%19463.7%1.2%-2.3%19472.4%2.9%-3.4%194819.8%21.2%19.9%194928.3.3%33.9%195020.9%19.8%14.6%195113.5%12.5%9.3%19520.7%3.5%-2.2%195348.8%42.8%53.0%195425.5%22.5%19.4%19557.9%9.6%6.4%1956-9.9%-8.8%-15.9%195742.8%42.0%57.1%195811.7%9.2%16.2%19591.1%3.6%-2.7%196026.3%.9%27.4%1961-9.5%-10.2%-15.0%196221.1.0%17.5%196315.6%14.4%15.5%196411.9%12.7%32.5%1965-9.3%-9.9%-6.1%196623.5%22.6%58.9%196711.1%6.6%29.6%1968-9.4%-1.5%-19.9%19691.3%-3.4%-8.6%197015.5%23.2%19.0%197117.8%16.7%5.5%1972-16.9%-25.2%-31.0%1973-27.9%-25.3%-23.3%197436.2%34.7%69.6%197524.5%15.9%41.1%1976-5.7%-6.8%21.3%19776.5%9.3%22.3%197821.1%17.9%48.7%197932.1%38.9%50.3%1980-4.1%-7.9%-1.3%198120.3%28.9%27.6%198221.6%18.4%28.7%19835.7%2.3%-11.7%198432.2%38.2%34.1%198517.4%14.7%9.0%19862.9%1.4%-8.0%198717.2%16.7%24.2%198830.2%30.6.1%1989-4.6%-1.3%-13.3%199032.6%47.7%46.6%19918.2%5.5%15.3%19929.6%-0.6%11.5%19930.1%2.9%-0.7%199437.0%39.7%.1%199521.7%27.3%17.4%199631.9%31.1%23.0%199727.5%34.1%-1.2%199821.7%22.6%28.8%1999-9.3%-9.7%2.4 00-13.0%-12.8%9.9 01-22.1%-21.3%-13.8 0228.5%21.8%39.5 0310.7%8.4.7 045.8%2.2%7.0 0514.8%10.9%14.8 066.4%10.3%2.2 07-36.7%-30.0%-36.9 0827.2&.7%31.5 0915.5%17.9%29.1 101.1%6.4%1.8 1115.9%15.3%15.6 1231.9%33.3%41.8 13Avg.MaxMinStdev0%0%International - DevelopedTotalMarketDeveloped Total Market0%0%International - Emerging34.9%-16.1%-33.8%-50.0%-7.9%83.5%4.9%46.5%38.6%-38.5%29.4%-1.8%-6.3%-7.6%19.7%36.4%28.3%47.2%-7.0%2.8%-0.6%18.7%36.1%18.0%11.9%-2.4%55.0%21.4%8.4%-13.4%51.4%12.6%-0.4%27.4%-10.7.3%17.4%21.8%-8.0%38.2%23.4%-18.2%-0.7%15.6%10.7%-22.6%-25.4%46.0%38.5%4.2%11.7%29.6%30.7%2.2%23.8%29.1%2.8%30.9%14.2%-0.8%21.8%24.0%-12.5%35.1%15.4%16.2%-0.6%34.4.7%30.2%10.0%19.8%1.0%-0.7%-18.8%39.5%15.8%7.4%17.0%1.0%-38.5%32.1%21.3%-2.5%17.4%37.1%35.2%-22.4%-41.1%-54.3%-10.6%127.0%1.7%52.2%58.9%-48.0%33.6%-7.6%-6.1%-5.1%28.9%56.8%41.4%63.7%-11.9%2.5%-3.9%18.3%50.0%12.3%11.0%-8.1%62.1%19.8%5.4%-18.7%64.3%16.8%-7.7%28.1%-10.5%24.3%22.3%36.5%-9.6%63.1%42.6%-25.8%-3.4%18.7%6.8%-28.4%-21.5%62.0%53.9%16.5%18.4%35.1%24.6%13.4%31.5%41.7%-1.2%27.9%7.5%-2.8%29.9%15.4%-23.7%44.3%30.4%22.7%1.0%30.6%23.1%32.9%-3.2%12.7%19.5%19.3%-15.5%60.7%22.6%7.6%18.6%-7.8%-36.2%46.0%27.5%-6.9%19.2%42.1%9.2%-9.9%-20.4%-34.8%4.1%77.0%10.3%6.4%12.4%-7.9%-8.1%-12.4%7.4%27.7%1.8%14.4%-7.6%4.5%-23.3%-4.5%-8.3%-6.7%6.7%11.3%0.8%12.3%31.0%8.0%-1.0%0.7%21.7%44.7%13.5%5.4%-5.4%7.4%-1.8%-3.3%-9.7%23.5%24.4%5.4%-7.4%31.8%36.8%-10.4%-21.1%33.8%5.3.0%32.2%9.8%.3%-1.7%-3.7%24.6%9.2%53.7%63.7%.6%31.1%18.6%-21.0%19.3%-8.3%39.3%11.3%4.9%5.3%-6.8%14.0&.6%-8.6%-16.8%-9.0%51.6&.6%18.5&.9%9.2%-45.1%39.5%14.1%-15.2%17.0%22.6%Small Cap11.2%-8.6%-19.3%-34.2%5.8%82.9%13.0%8.7%14.9%-6.5%-6.7%-11.4%9.3%30.6%4.2%17.2%-5.4%7.0%-22.4%-2.8%-7.1%-5.2%8.9%13.6%2.7%14.6%33.4%10.4%1.1%2.5%24.0%47.9%16.1%6.9%-3.1%9.7%-0.2%-1.2%-8.1&.1%27.5%8.0%-5.3%35.4%40.3%-8.4%-20.1%36.7%7.7%23.0%35.3%12.9%28.7%-0.1%-3.3%35.7%10.6%72.0%55.3%52.4%33.3%36.8%-17.9%4.2%-22.1%44.2%8.2%3.0%2.5%-15.9%8.6.3%-3.0%-7.4%2.8%65.2%33.8%22.9&.3%5.2%-43.1%46.4%18.1%-15.9%17.1%31.1%Total Market1.7%-9.0%-8.8%-16.7%-3.5%85.0%24.6%11.2%18.3%-4.5%-4.4%-15.4%-0.2%19.7%19.7%24.8%18.3.1%-12.3%-1.4%-14.3%-3.5%8.8%10.6%5.6%7.3%1.9%13.4%13.4%2.3%2.5%17.8%17.7%-12.7%22.3%10.8%-3.9%11.9%-1.0%12.3%28.5%21.0%16.1%39.2%31.7%15.4%-12.9%13.8%17.7&.0.9%38.5%36.8%-4.8%-25.1%23.3%14.5&.4%12.5%24.1%43.2%69.3%-10.4%64.0%12.7%79.6%-1.5%-12.8%8.1%-22.9%-22.1%60.1%-31.8%1.3%-3.8%64.1%31.6%27.8%34.8%45.6%-53.6%89.6%24.4%-21.5.0%-3.5%Value6.3%-8.9%-12.0%-23.3%0.2%99.0&.3%13.6%21.5%-4.4%-4.4%-15.2%4.1%27.5%19.4%27.7%15.3.6%-15.9%-0.7%-12.9%-3.2%11.6%14.5%7.0%12.0%13.3%15.9%13.1%4.1%10.9%31.2%21.4%-7.3%19.4%13.5%-2.0%11.1%-2.0%19.9%34.1%21.7%13.4%45.6%40.7%11.9%-15.8%24.4%18.7%30.6%30.0%38.1%41.5%-2.7%-20.8%29.6%17.3%41.4%32.6%30.6%48.8%53.0%1.0%39.5%-5.5%105.4%5.3%-8.3%12.7%-21.9%-19.1%66.2%-27.4%3.9%-0.1%75.9%35.5%29.0%39.2%48.1%-51.7%101.0%24.7%-25.7.3%-4.6%11.1%47.7%-37.2%15.0%108.0%-45.8%13.0%83.5%-50.0%11.0%51.0%-43.6%16.5%127.0%-54.3%9.5%77.0%-45.1%12.0%82.9%-43.1%13.3%89.6%-53.6%16.2%105.4%-51.7%19.7%27.2%22.9%19.6%29.8.9%22.8%.5%27.5%Based on the asset allocation problem solved in class, start with a 100% allocation to the S&P 500. Assume the investor wants tomaximimze the minimum return she would have experienced over all 30 year-periods since 1927. She also wants the worst one yearreturn to be no more than -35%. Use Solver to determine the best allocation to achieve this.Q7Optimization"How should I allocate the money in my portfolio to maximize returns?"INPUTS:Objective: Maximize Minimum Return over 30 yearsSubject to Constraints:Sum of Allocations = 100%Worst one year loss permitted:35%OUTPUTS:Minimum 30-year return (based on all 30-year returns):Expected 30-Year Return (based on all 30-year returns):Worst one year loss:100%0%0%0%0%US StocksS&P 500-Large Cap Large Cap Small CapYearBlendGrowthGrowth37.5%44.2%28.4%1928-10.8%-10.1%-35.5%1929-28.2%-29.5%-35.3%1930-43.6%-37.2%-45.8%1931-8.5%-6.3%-0.3%193251.0%47.1%108.0%19333.0%10.8%18.6%193443.1%39.7%54.1%193530.1%24.5%47.1%1936-33.4%-34.1%-44.2%193726.4%36.7%37.3%19383.0%1.3%3.7%1939-7.6%-9.0%-5.0%1940-10.4%-13.4%-8.1%194114.9%15.6%.2%194225.4%24.0%52.9%194318.8%16.0%40.0%194434.8%33.3%59.2%1945-5.6%-7.9%-9.9%19463.7%1.2%-2.3%19472.4%2.9%-3.4%194819.8%21.2%19.9%194928.3.3%33.9%195020.9%19.8%14.6%195113.5%12.5%9.3%19520.7%3.5%-2.2%195348.8%42.8%53.0%195425.5%22.5%19.4%19557.9%9.6%6.4%1956-9.9%-8.8%-15.9%195742.8%42.0%57.1%195811.7%9.2%16.2%19591.1%3.6%-2.7%196026.3%.9%27.4%1961-9.5%-10.2%-15.0%196221.1.0%17.5%196315.6%14.4%15.5%196411.9%12.7%32.5%1965-9.3%-9.9%-6.1%196623.5%22.6%58.9%196711.1%6.6%29.6%1968-9.4%-1.5%-19.9%19691.3%-3.4%-8.6%197015.5%23.2%19.0%197117.8%16.7%5.5%1972-16.9%-25.2%-31.0%1973-27.9%-25.3%-23.3%197436.2%34.7%69.6%197524.5%15.9%41.1%1976-5.7%-6.8%21.3%19776.5%9.3%22.3%197821.1%17.9%48.7%197932.1%38.9%50.3%1980-4.1%-7.9%-1.3%198120.3%28.9%27.6%198221.6%18.4%28.7%19835.7%2.3%-11.7%198432.2%38.2%34.1%198517.4%14.7%9.0%19862.9%1.4%-8.0%198717.2%16.7%24.2%198830.2%30.6.1%1989-4.6%-1.3%-13.3%199032.6%47.7%46.6%19918.2%5.5%15.3%19929.6%-0.6%11.5%19930.1%2.9%-0.7%199437.0%39.7%.1%199521.7%27.3%17.4%199631.9%31.1%23.0%199727.5%34.1%-1.2%199821.7%22.6%28.8%1999-9.3%-9.7%2.4 00-13.0%-12.8%9.9 01-22.1%-21.3%-13.8 0228.5%21.8%39.5 0310.7%8.4.7 045.8%2.2%7.0 0514.8%10.9%14.8 066.4%10.3%2.2 07-36.7%-30.0%-36.9 0827.2&.7%31.5 0915.5%17.9%29.1 101.1%6.4%1.8 1115.9%15.3%15.6 1231.9%33.3%41.8 13Avg.MaxMinStdev0%0%International - DevelopedTotalMarketDeveloped Total Market0%0%International - Emerging34.9%-16.1%-33.8%-50.0%-7.9%83.5%4.9%46.5%38.6%-38.5%29.4%-1.8%-6.3%-7.6%19.7%36.4%28.3%47.2%-7.0%2.8%-0.6%18.7%36.1%18.0%11.9%-2.4%55.0%21.4%8.4%-13.4%51.4%12.6%-0.4%27.4%-10.7.3%17.4%21.8%-8.0%38.2%23.4%-18.2%-0.7%15.6%10.7%-22.6%-25.4%46.0%38.5%4.2%11.7%29.6%30.7%2.2%23.8%29.1%2.8%30.9%14.2%-0.8%21.8%24.0%-12.5%35.1%15.4%16.2%-0.6%34.4.7%30.2%10.0%19.8%1.0%-0.7%-18.8%39.5%15.8%7.4%17.0%1.0%-38.5%32.1%21.3%-2.5%17.4%37.1%35.2%-22.4%-41.1%-54.3%-10.6%127.0%1.7%52.2%58.9%-48.0%33.6%-7.6%-6.1%-5.1%28.9%56.8%41.4%63.7%-11.9%2.5%-3.9%18.3%50.0%12.3%11.0%-8.1%62.1%19.8%5.4%-18.7%64.3%16.8%-7.7%28.1%-10.5%24.3%22.3%36.5%-9.6%63.1%42.6%-25.8%-3.4%18.7%6.8%-28.4%-21.5%62.0%53.9%16.5%18.4%35.1%24.6%13.4%31.5%41.7%-1.2%27.9%7.5%-2.8%29.9%15.4%-23.7%44.3%30.4%22.7%1.0%30.6%23.1%32.9%-3.2%12.7%19.5%19.3%-15.5%60.7%22.6%7.6%18.6%-7.8%-36.2%46.0%27.5%-6.9%19.2%42.1%9.2%-9.9%-20.4%-34.8%4.1%77.0%10.3%6.4%12.4%-7.9%-8.1%-12.4%7.4%27.7%1.8%14.4%-7.6%4.5%-23.3%-4.5%-8.3%-6.7%6.7%11.3%0.8%12.3%31.0%8.0%-1.0%0.7%21.7%44.7%13.5%5.4%-5.4%7.4%-1.8%-3.3%-9.7%23.5%24.4%5.4%-7.4%31.8%36.8%-10.4%-21.1%33.8%5.3.0%32.2%9.8%.3%-1.7%-3.7%24.6%9.2%53.7%63.7%.6%31.1%18.6%-21.0%19.3%-8.3%39.3%11.3%4.9%5.3%-6.8%14.0&.6%-8.6%-16.8%-9.0%51.6&.6%18.5&.9%9.2%-45.1%39.5%14.1%-15.2%17.0%22.6%Small Cap11.2%-8.6%-19.3%-34.2%5.8%82.9%13.0%8.7%14.9%-6.5%-6.7%-11.4%9.3%30.6%4.2%17.2%-5.4%7.0%-22.4%-2.8%-7.1%-5.2%8.9%13.6%2.7%14.6%33.4%10.4%1.1%2.5%24.0%47.9%16.1%6.9%-3.1%9.7%-0.2%-1.2%-8.1&.1%27.5%8.0%-5.3%35.4%40.3%-8.4%-20.1%36.7%7.7%23.0%35.3%12.9%28.7%-0.1%-3.3%35.7%10.6%72.0%55.3%52.4%33.3%36.8%-17.9%4.2%-22.1%44.2%8.2%3.0%2.5%-15.9%8.6.3%-3.0%-7.4%2.8%65.2%33.8%22.9&.3%5.2%-43.1%46.4%18.1%-15.9%17.1%31.1%Total Market1.7%-9.0%-8.8%-16.7%-3.5%85.0%24.6%11.2%18.3%-4.5%-4.4%-15.4%-0.2%19.7%19.7%24.8%18.3.1%-12.3%-1.4%-14.3%-3.5%8.8%10.6%5.6%7.3%1.9%13.4%13.4%2.3%2.5%17.8%17.7%-12.7%22.3%10.8%-3.9%11.9%-1.0%12.3%28.5%21.0%16.1%39.2%31.7%15.4%-12.9%13.8%17.7&.0.9%38.5%36.8%-4.8%-25.1%23.3%14.5&.4%12.5%24.1%43.2%69.3%-10.4%64.0%12.7%79.6%-1.5%-12.8%8.1%-22.9%-22.1%60.1%-31.8%1.3%-3.8%64.1%31.6%27.8%34.8%45.6%-53.6%89.6%24.4%-21.5.0%-3.5%Value6.3%-8.9%-12.0%-23.3%0.2%99.0&.3%13.6%21.5%-4.4%-4.4%-15.2%4.1%27.5%19.4%27.7%15.3.6%-15.9%-0.7%-12.9%-3.2%11.6%14.5%7.0%12.0%13.3%15.9%13.1%4.1%10.9%31.2%21.4%-7.3%19.4%13.5%-2.0%11.1%-2.0%19.9%34.1%21.7%13.4%45.6%40.7%11.9%-15.8%24.4%18.7%30.6%30.0%38.1%41.5%-2.7%-20.8%29.6%17.3%41.4%32.6%30.6%48.8%53.0%1.0%39.5%-5.5%105.4%5.3%-8.3%12.7%-21.9%-19.1%66.2%-27.4%3.9%-0.1%75.9%35.5%29.0%39.2%48.1%-51.7%101.0%24.7%-25.7.3%-4.6%11.1%47.7%-37.2%15.0%108.0%-45.8%13.0%83.5%-50.0%11.0%51.0%-43.6%16.5%127.0%-54.3%9.5%77.0%-45.1%12.0%82.9%-43.1%13.3%89.6%-53.6%16.2%105.4%-51.7%19.7%27.2%22.9%19.6%29.8.9%22.8%.5%27.5%Q8 AJoe Cool just landed his first serious job at Cook, Books & Hyde, amajor accounting firm in his home town. The HR Department hasasked how much he wants to save each month into his retirementaccount. He wonders how much will be in his account if he earns10% and can save various amounts amounts over various timeperiods. He wants to test monthly savings of $25, 50, 75, 100,125, 150, 175, and $200 and asks you to compute much will be inthe retirement account after spans of 20, 25, 30, 35, and 40 years.Q8BTom Swift is an investor but the stock market scares him. He justlearned he can invest some of the money he just inherited inlottery winnings. Sometimes people who have won a lottery andopted for a stream of payments change their minds and want tosell the stream of income for a lump sum. These people can putup their lottery winnings in an auction where investors can bid onthem. Tom is considering bidding on a stream of income that willpay $10,000 a year for the next 20 years. He is considering bidsof $50,000, $55,000, $60,000, $65,000... $100,000. He asks youto compute what return he would get with each bid if he won.Help Tom out.Question 4The manager of a "6/10 Market" opens his store at 6AM, closes at 10PM. He wants at least 4 workers on duty during everyhour of the week, 6 on weekends. He is exploring the idea of using a "4-10 plan." That is, workers work 4 consecutive days, 10consecutive hours each. Use Solver to solve this staff scheduling problem (see "Demand Matrix ") using the integer constraint.How many workers will be needed? What do you conclude about the efficiency of the 4-10 plan vs. the 5-8 plan?INPUTS:DEMAND MATRIX A: Enter the number of workers needed each 2 hour span.ShiftShiftSunMonTueWed12AM-2AM100002AM-4AM200004AM-6AM300006AM-8AM463338AM-10AM5633310AM-12PM6744412PM-2PM774442PM-4PM874444PM-6PM974446PM-8PM1074448PM-10PM11743310PM-12AM120000ThuFri000000333344444445453500Total Workerhours:Unadjusted Workers Required:Sat00077777777052013

 

Paper#53625 | Written in 18-Jul-2015

Price : $62
SiteLock