#### Description of this paper

##### BUS 204 Quantitative Business Analysis Homework 7

Description

solution

Question

Question;Q1 Below are;the scores achieved during the first half of Bus 204 in a prior semester and;the final overall total course score.;How well do these averages predict the final course score?;First half grades;Q1 and 2;HW 1-6;Q Average;HW Average;MT Score;Total;13%;58%;81%;75%;26%;49%;69%;67%;52%;106%;68%;69%;93%;102%;80%;86%;73%;96%;81%;92%;55%;102%;68%;79%;82%;102%;96%;92%;68%;94%;85%;77%;62%;94%;77%;83%;30%;94%;86%;88%;88%;102%;72%;90%;86%;101%;82%;92%;63%;97%;85%;78%;42%;76%;65%;70%;68%;95%;82%;88%;28%;61%;47%;61%;59%;103%;70%;73%;61%;103%;111%;102%;60%;74%;82%;78%;50%;67%;97%;88%;35%;83%;81%;80%;41%;96%;82%;79%;58%;94%;86%;86%;64%;94%;59%;77%;36%;83%;59%;66%;48%;100%;61%;77%;64%;98%;92%;93%;62%;97%;53%;76%;22%;87%;49%;61%;48%;78%;62%;65%;83%;101%;74%;87%;55%;103%;76%;78%;51%;77%;38%;61%;64%;95%;93%;90%;31%;34%;43%;50%;57%;71%;65%;68%;44%;73%;55%;61%;29%;53%;65%;51%;66%;98%;92%;93%;93%;102%;103%;93%;68%;101%;76%;91%;34%;82%;62%;64%;66%;106%;73%;81%;18%;15%;41%;49%;63%;103%;80%;85%;60%;102%;81%;93%;65%;73%;49%;63%;78%;98%;100%;91%;70%;98%;69%;78%;63%;97%;66%;84%;Question 2 The;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 the regressions, which form yields the;highest R Squared?;Question 3 a;Example;Grippo;Grippo;Golf Glove Company maeks two different brands of golf gloves. One is a full-fingered glove;and the;other is a half-fingered model. Grippo;currently has orders for more gloves than it can produce;in time;for the upcoming golf season. The;scarace resource in the manufacture of these gloves is;labor;time. Grippo has available 400 hours in;the cutting and sewing department, 250 hours in the;finishing;department, and 150 hours in the pacckaging and shipping department. The department;time;requirements and the profit per box (1gross) are given below;Cutting and Sewing;Finishing;Packaging and Shipping;Profit;Find;the optimal product mix for;Full;Finger;3;1.5;1;\$20;Grippo;assuming Co. wants to;Half;Finger;1.5;2;1;\$25;Maximize;profit;Question 3 b;Linear;Programming On Excel;Example;Doc's Dogs;Doc's;Dog Kennels, Inc., provides overnight lodging for a variety of pets. A particular;feature;at Doc's is the quality of care the pets receive, including excellent;food. The;kennel's;dog food is made by mixing two brand-name dog food products to obtain what;Doc's;calls the "well balanced dog diet;The data for the two dog foods are below;Dog Food;Cost per Ounce;Protein (percent);Fat (Percent);Bark;Bits;\$0.025;30;20;Canine;Chow;\$0.030;40;10;If Doc;wants to be sure that his dogs receive;at least 6 ounces of protein and 2 ounces;of fat;per day, what is the minimum cost mix of the two dog food products?;Question 3 c;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 it should 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;4;The manager of a "6/10;Market" opens his store at 6AM, closes at 10PM. He wants at least 4 workers on duty during every;hour 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 perfect solution with zero surpluses and;shortages.);INPUTS;DEMAND;MATRIX A: Enter the number of workers;needed each 2 hour span.;Shift;Shift;Sun;Mon;Tue;Wed;Thu;Fri;Sat;12AM-2AM;1;2AM-4AM;2;4AM-6AM;3;6AM-8AM;4;6;3;3;3;3;3;7;8AM-10AM;5;6;3;3;3;3;3;7;10AM-12PM;6;7;4;4;4;4;4;7;12PM-2PM;7;7;4;4;4;4;4;7;2PM-4PM;8;7;4;4;4;4;4;7;4PM-6PM;9;7;4;4;4;4;5;7;6PM-8PM;10;7;4;4;4;4;5;7;8PM-10PM;11;7;4;3;3;3;5;7;10PM-12AM;12;Total Workerhours;520;Unadjusted Workers Required;13;Question 5;The Blisters Saddle Company;manufactures its saddles in three plants and sells them in four regions. The cost to transport a unit from each;plant to each region is shown. Also;shown is the anticipated demand this quarter from each region and the;capacity that each plant will have in terms of how many units it can supply;this quarter. Determine the optimal;shipping plan to minimize shipping costs.;Transportation;Cost Matrix: Cost per Unit Shipped;From Each Plant to Each Region;East;North;South;West;Supply;Plant 1;\$21.55;\$10.00;\$22.67;\$23.97;200;Plant 2;\$11.29;\$18.79;\$22.93;\$10.34;250;Plant 3;\$15.34;\$11.38;\$10.52;\$15.52;350;Demand;210;160;110;200;Q6.;Based on the asset allocation problem;solved in class, start with a 100% allocation to the S&P 500. Assume the investor wants to maximimze theminimumreturn she would have experienced;over all 30 year-periods 1928-2013 using the equity asset classes shown;below. She also wants to track the;expected returns and the worst one year loss.;Use Solver to determine the best allocation to achieve this. (Hints;Use GRG Nonlinear as the solution method and only constraint needed is;that the allocations must sum to 100%.);Optimization;How;should I allocate the money in my portfolio to maximize minimum;returns?;INPUTS;Objective: Maximize Minimum;Return over 30 years;Subject;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%;0%;0%;0%;0%;Q7;Based on the asset allocation problem;solved in class, start with a 100% allocation to the S&P 500. Assume the investor wants to maximimze the;minimum return she would have experienced over all 30 year-periods since;1927. She also wants the worst one;year return to be no more than -35%.;Use Solver to determine the best allocation to achieve this.;Optimization;How;should I allocate the money in my portfolio to maximize returns?;INPUTS;Objective: Maximize Minimum;Return over 30 years;Subject;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%;0%;0%;0%;0%;Q8 A;Joe Cool just landed his first;serious job at Cook, Books & Hyde, a major accounting firm in his home;town. The HR Department has asked how much;he wants to save each month into his retirement account. He wonders how much will be in his account;if he earns 10% and can save various amounts amounts over various time;periods. He wants to test monthly;savings of \$25, 50, 75, 100, 125, 150, 175, and \$200 and asks you to compute;much will be in the retirement account after spans of 20, 25, 30, 35, and 40;years.;Question;4;The manager of a "6/10;Market" opens his store at 6AM, closes at 10PM. He wants at least 4 workers on duty during every;hour of the week, 6 on weekends. He is;exploring the idea of using a "4-10 plan." That is, workers work 4 consecutive days;10 consecutive 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.;Shift;Shift;Sun;Mon;Tue;Wed;Thu;Fri;Sat;12AM-2AM;1;2AM-4AM;2;4AM-6AM;3;6AM-8AM;4;6;3;3;3;3;3;7;8AM-10AM;5;6;3;3;3;3;3;7;10AM-12PM;6;7;4;4;4;4;4;7;12PM-2PM;7;7;4;4;4;4;4;7;2PM-4PM;8;7;4;4;4;4;4;7;4PM-6PM;9;7;4;4;4;4;5;7;6PM-8PM;10;7;4;4;4;4;5;7;8PM-10PM;11;7;4;3;3;3;5;7;10PM-12AM;12;Total Workerhours;520;Unadjusted Workers Required;13

Paper#60440 | Written in 18-Jul-2015

Price : \$45