Practice Modeling Decisions Quantitatively with Quest Analysis

PS5-Y34 Cristina Martinez Modeling Decisions Quantitatively Practice modeling decisions quantitatively by selecting a solution. Complete the following steps. 1. Save this file with a new name Click the File tab, click Save As, add your name to the end of the filename, then click Save. For example, save this file as PS5-Y34 Sharon Rodriguez.docx . 2. Get ready Review the responses to the following questions, which are related to whether Quest should open a branch office. Do you think Quest should open a branch office? Rating Number of responses 5 - Strongly agree 8 4 – Agree 8 3 – Neutral 2 2 – Disagree 2 1 – Strongly disagree 0 If Quest does open a branch office, should it be in Los Angeles? Rating Number of responses 5 - Strongly agree 6 4 – Agree 4 3 – Neutral 4 2 – Disagree 3 1 – Strongly disagree 3 If Quest does open a branch office in Los Angeles, should it be on our client’s corporate campus? Rating Number of responses You Try It

5 - Strongly agree 4 4 – Agree 4 3 – Neutral 4 2 – Disagree 5 1 – Strongly disagree 3 If Quest does open a branch office, should it be in Chicago? Rating Number of responses 5 - Strongly agree 6 4 – Agree 6 3 – Neutral 5 2 – Disagree 3 1 – Strongly disagree 0 3. Now you try it In the following space, answer the question of whether Quest should open a branch office, and if so, where. After reviewing all the responses, you can see that there is a strong interest towards Quest expanding their operations by opening a Branch office. A majority of people surveyed agreed that a branch office was a good idea. Between the office being located in Chicago, Los Angeles, or in Los Angeles on a client’s corporate campus, the survey responses revealed that it would be more favorable to have the office in Chicago. In summary, yes Quest should open a branch office, and it should preferably be located in Chicago. Submit the document to your instructor as requested.

PS5-Y35 Cristina Martinez Describing Data Objectively Practice describing data objectively by calculating statistics. Complete the following steps. 1. Save this file with a new name Click the File tab, click Save As, add your name to the end of the filename, then click Save. For example, save this file as PS5-Y35 Sharon Rodriguez.docx . 2. Get ready Review the following statistics: 1 – Alaska Cruise 2 – Caribbean Adventures 3 – Mediterranean Express 4 – Biking Hawaii Month Top Tour January 2 February 4 March 2 April 3 May 2 June 1 July 3 August 1 September 2 October 2 November 4 December 2 3. Now you try it You Try It

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

In the following space, indicate the most popular tour for business travelers. 1 – Alaska Cruise was the top-rated tour for 2 months. 2 – Caribbean Adventures was the top-rated tour for 6 months. 3 – Mediterranean Express was the top-rated tour for 2 months. 4 – Biking Hawaii was the top-rated tour for 2 months. After analyzing the statistics provided you can see that the Caribbean adventures tour was voted as the top-rated tour for 6 months, and the clear winner of the 4 options given for business travelers. Submit the document to your instructor as requested.

PS5-Y36 Cristina Martinez Working with Formulas and Functions Practice working with formulas and functions by entering formulas. Complete the following steps. 1. Save this file with a new name Click the File tab, click Save As, add your name to the end of the filename, then click Save. For example, save this file as PS5-Y36 Sharon Rodriguez.docx . 2. Get ready Review the following information about prospective business tours. Number of Tours Sold 447 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Totals Alaska Cruise 12 25 14 5 56 Caribbean Adventures 50 32 20 45 147 Mediterranean Express 21 48 40 15 124 Biking Hawaii 41 38 14 27 120 Totals 124 143 88 92 447 3. Now you try it Instructions : 1. In the cells with blue shading, calculate the totals for each tour. The total for the Alaska Cruise is completed for you. 2. In the cells with orange shading, calculate the totals for each quarter. The total for Quarter 1 is completed for you. 3. In the cells with green shading, calculate the total number of tours sold. Submit the document to your instructor as requested. You Try It

PS5-Y37 Katherine Cervantes Performing What-If Analyses Practice performing what-if analyses by using Microsoft Excel’s what-if analysis tools. Complete the following steps. 1. Save this file with a new name Click the File tab, click Save As, add your name to the end of the filename, then click Save. For example, save this file as PS5-Y37 Sharon Rodriguez.docx . 2. Get ready Use spreadsheet software to open the WhatIf file. 3. Now you try it 1. Click cell E14 , click the Data tab , click the What-If Analysis button , and then click Goal Seek . 2. Click the To value box, type 4,637,500 , click the By changing cell box , click cell E13 , and then click OK twice. What is the average price per trip if Quest sells 12% business trips? $1,000 What is the future revenue from sales if Quest sells 12% more trips? $4,637,500 Submit the document to your instructor as requested. You Try It

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

PS5-Y38 Katherine Cervantes Weighing Factors Practice weighing factors by assigning weights and calculating results. Complete the following steps. 1. Save this file with a new name Click the File tab, click Save As, add your name to the end of the filename, then click Save. For example, save this file as PS5-Y38 Sharon Rodriguez.docx . 2. Get ready Use spreadsheet software to open the Factors file. 3. Now you try it 1. Select the cells C11:C14 , press [Ctrl]+[C] to copy the formulas, select cells D11:F14 , then press [Ctrl]+[V] to paste the formulas 2. Click cell C15 , press [Ctrl]+[C] to copy the formula, select cells D15:F15 , then press [Ctrl]+[V] to paste the formula Which tour has the highest weighted total? Caribbean Submit the document to your instructor as requested. You Try It

PS5-Y39 Katherine Cervantes Creating Decision Trees Practice creating decision trees by completing a diagram. Complete the following steps. 1. Save this file with a new name Click the File tab, click Save As, add your name to the end of the filename, then click Save. For example, save this file as PS5-Y39 Sharon Rodriguez.docx . 2. Get ready Quest is considering whether to organize an event for business travelers to promote the popular Caribbean Adventures tour. The event would take place on the beach in San Diego. Quest would serve food from under a large canopy, but otherwise the event would take place out in the open. Depending on the weather forecast, Quest could also hold the event in a nearby marina. Below the diagram is a description of the decisions in the decision tree. Considering all of the factors and decisions in the decision tree, should Quest hold the event for business travelers indoors or outdoors? Note : This diagram is drawn vertically to fit on the page. You Try It Should Quest hold the event for business travelers outdoors or indoors? What is the weather forecast? Sunny Outdoors: 7 Indoors: 3 Overcast Outdoors: 9 Indoors: 1 Rain Possible Outdoors: 2 Indoors: 8 How humid will it be? 70% or less Outdoors: 7 Indoors: 3 More than 70% Outdoors: 2 Indoors: 8 Yes Outdoors: 0 Indoors: 10 No Outdoors: 2 Indoors: 8 Will it also be windy?

According to the diagram:  If the weather is sunny, 7 people say the event should be outdoors and 3 people say it should be indoors (perhaps because it is too hot).  If the humidity is over 70%, however, only 2 people say the event should be outdoors and 8 people say it should be indoors.  If the humidity is 70% or less, 7 people still say the event should be outdoors and 3 people say it should be indoors.  If it is overcast, 9 people say it should be outdoors, and 1 person said it should be indoors.  If rain is possible, 2 people say the event should be outdoors, and 8 people say it should be indoors  If it will also be windy, all 10 people say it should be indoors, and if it is not windy, 2 people said it should be outdoors, and 8 people said it should be indoors. 3. Now you try it Complete the description of the diagram to help Quest make their decision. Submit the document to your instructor as requested.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

You Try It PS5-Y40 Darrielle Booth Using Graphics to Display Data Practice using graphics to display data by creating a chart . Complete the following steps. 1. Save this file with a new name Click the File tab, click Save As, add your name to the end of the filename, then click Save. For example, save this file as PS5-Y40 L ana Eydlin .docx . 2. Get ready Use spreadsheet software to open the Graphics file. 3. Now you try it In Graphics.xls, use the guidelines in this chapter and the instructions in Graphics.xls to create charts to display the data graphically. Prospective Business Tours Forecasted Sales Quarter 1 Quarter 2 Quarter 3 Quarter 4 Alaska Cruise $25,200 52,50 0 29,40 0 10,500 Caribbean Adventures 87,500 56,00 0 35,00 0 78,750 Mediterranean Express 54,600 124,80 0 104,00 0 39,000 Biking Hawaii 78,925 73,15 0 26,95 0 51,975 Totals 246,225 306,45 0 195,35 0 180,225

Submit the document to your instructor as requested. PS5-TechWork Darrielle Booth

Technology @ Work: Spreadsheet Tools Explore spreadsheet tools. Complete the following steps. 1. Save this file with a new name Click the File tab, click Save As, add your name to the end of the filename, then click Save. For example, save this file as PS5-TechWork Sharon Rodriguez.docx . 2. Get ready Open a Web browser such as Internet Explorer or Firefox, and go to each of the sites mentioned in this lesson: Microsoft Office : office.microsoft.com/excel Google Docs : www.google.com/docs OpenOffice Calc : www.openoffice.org/product/calc.html Gnumeric : http://gnumeric.org Apple Numbers : www.apple.com/iwork/numbers Identify the top two or three pros and cons for each program. 3. Now you try it In the following space, list the pros and cons of each spreadsheet program. Microsoft Office Excel: Pros: 1. Lots of features, works well. 2. Works on many devices. 3. Many online tutorials available. Cons: 1. Costs money. 2. Takes time to learn. 3. Not as good for collaboration as some others. Google Docs: Pros: 1. Works online, easy to collaborate. 2. Free to use for basic things. 3. Can use it from any device with the internet. You Try It

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Cons: 1. Needs internet for everything. 2. Not as powerful for advanced things. 3. Some features aren't as strong. OpenOffice Calc: Pros: 1. Free and open for everyone. 2. Works with Microsoft Excel files. 3. Works offline without internet. Cons: 1. Updates slower. 2. Not as many tutorials. 3. Looks less fancy than other programs. Gnumeric : Pros: 1. Simple and quick to use. 2. Good for accurate numbers. 3. Free and open for everyone. . Cons: 1. Not many advanced features. 2. Not many people tutorial 3. Can have issues with certain files. Apple Numbers : Pros: 1. Works well with Apple stuff. 2. Easy for users. 3. Can collaborate with iCloud. Cons: 1. Only on Apple devices. 2. Not as many features as Excel. 3. Can have trouble with some Excel files. Submit the document to your instructor as requested.

You Try It PS5 – IC1 Darrielle Booth Independent Challenge 1 Help Lawrence Media analyze data to make a decision. Complete the following steps. Save this file with a new name Click the File tab, click Save As, add your name to the end of the filename, then click Save. For example, save this file as PS5-IC1 Sharon Rodriguez.docx . Get ready Analyze the monthly sales of shirts, including t-shirts and polo shirts, shown in Figure 5-17 (duplicated below). Identify the decision variables, constants, and output variables. Now you try it In the following space, answer these questions: What are the constants, decision variables, and output variables? How much money can Lawrence Media make per month from the sales of shirts? Which type of shirt should they promote the most aggressively? Prices are considered fixed costs, as they are considered constant variables. The algorithm's effectiveness in determining the quantity of shirts Lawrence Media can sell will impact their potential earnings. Profit is derived by multiplying the Selling Price by the quantity of goods sold Submit the document to your instructor as requested.

PS5-IC2 Cristina Martinez Independent Challenge 2 Help Sage Realty Services help potential home buyers decide whether to buy or rent a home. Complete the following steps. 1. Save this file with a new name Click the File tab, click Save As, add your name to the end of the filename, then click Save. For example, save this file as PS5-IC2 Sharon Rodriguez.docx . 2. Get ready Use spreadsheet software to open the Home file. In the Home spreadsheet, use cell shading to identify the decision variables, constants, and output variables. 3. Now you try it In the following space, enter the net annual cost of home ownership if the house increases in value by 5% each year. ( Hint : Enter the appropriate value in cell D4 and then review the results in cell D31.) Net annual cost of home ownership - $7446.00 Buy or Rent a Home? Initial Assumption Estimated annual appreciation in value of home 5% Down payment on home $20,000 Estimated closing costs 4,000 Estimated purchase price of home $285,000 Monthly rent $1,250 Cost of Renting Annual rent $15,000 Renter's annual insurance premium $400 Total annual cost of renting $15,400 Cost of Buying Mortgage loan amount $265,000 Annual interest rate 5.840% Term of mortgage (years) 30 You Try It

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Monthly mortgage payment $1,562 Annual mortgage payment $18,740 Property taxes $1,618 Homeowner's insurance $900 Maintenance $2,000 Total cost of buying $23,258 Less Adjustments: Principal reduction in mortgage $1,562 Tax savings of interest deductions $0 Tax savings of property tax Total adjustments $1,562 Annual after-tax cost of home ownership $21,696 Less: Estimated annual appreciation in value of home $14,250 Net annual cost of home ownership $7,446 Submit the document to your instructor as requested.

BSAD C222 Assignment Week 06 Group 6

Related Documents