I’m willing to pay someone $30.00 to do this assignment for me. Thank you in advance! Your manager could not be happier with the help you’ve provided to all of those departments requesting Excel assistance within the resort. He is now very confident handing over complex tasks to your capable hands. This week he is requesting that you exercise some expert skills. It seems he has some data that needs to be imported and cleaned up so that it is useful to the resort. He has quite a list of tasks he needs done with this data. Once the data are presentable, the analysis needs to be summarized in a short memo and placed on the last sheet in the workbook.Additionally, your manager has also heard that macros can be added to a worksheet. He wants to make the X Games calculator even more efficient and foolproof for all those using it.Just like traversing a double black diamond slope, you have the Excel knowledge to maneuver all of these tasks with excellence. This lab is for experts only.DeliverablesNOTESubmit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these step-by-step instructions.(See the Syllabus section ‘Due Dates for Assignments & Exams’ for due dates.)After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week7_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week7_Lab.xlsx.LAB 6 – What-If-AnalysisStepTaskPoints PossiblePoints ReceivedComments1Import and Organize Data1a – bImport Data5  1c -iProfessional Clean up & Formatting5  2Create Macro for X Games Calculator2a – lCreate & Record Macro6  3Assign Macro3a – fDraw Macro button5  3g – iAssociate Macro with button5  4Save Macro enabled file & Protect Calculator4a, bSave as .xlsm file type3  4cunlock user input cells4  4dAssociate Macro with button4  5Create a Documentation Sheet – Apply Watermark5a-cInsert and create documentation sheet4  5d-jCreate watermark4  6Summarize and Prepare Memo6a – dSummarize and write memo on last worksheet10  Comment in Dropbox: What you learned from completing this Lab5  TOTAL POINTS600 Week 7 Grading RubricLab ResourcesMicrosoft Office: Excel 2016Options for Accessing Microsoft Excel 2016Use a personal copy on your PC. You can request a copy of Microsoft Office 2016 via the Student Software Store icon on the Course Resources Page.If you are a MAC user, click to read the MAC User Information.If you do not have Excel 2016 installed locally, then access the software by going to the Course Resources page, Lab Resources section, and click the Virtual Lab Citrix icon.Lab StepsPreparationYou will be using Microsoft Excel 2016 for this lab.Be sure you have read the required chapter materials and reviewed the hands-on exercise videos located on the Lesson page before you begin the lab.Please do not rely solely on the hands-on exercise videos to complete this week’s lab. The videos provide detailed examples walking you through the hands-on exercises. Applying the hands-on exercise examples will provide both practice and instruction of what to complete.Begin: Open and SaveDownload the spreadsheet Week 7 Lab – Summit Ridge Mountain Resort Student.xslx. You will be prompted to save the file. Click yes.Download the spreadsheet Week 7 Lab – Import.txt. You will be prompted to save the file. Click yes.Note: If you are using the Remote Lab environment, you will need to follow the instructions for uploading the file. These instructions can be found on the Lab page when you click on the Lab icon on Course Resources.To save the spreadsheet with a new file name,open the workbook in Excel 2016; andin Excel, click File and then Save As and rename it as lastname_first initial_Week7_Lab.xlsx (Jane Doe would save the file as Doe_J_Week7_Lab.xlsx).Step 1: Import and Clean Up Text FileDownload starting student Excel file and the text file. Open the starting Excel file and navigate to Sheet1.Import the text file by using the Get External Data function on the Data Ribbon. When the Text Import Wizard displays, select My Data has headers and use a comma delimiter to organize the data.Insert a new column in between A and B and use the Text to Columns command to separate first and last name. Be sure to revise or add appropriate column names.Insert a column to the right of the HOME ADDRESS column and use a function to capitalize just the first letter in the address names. Then hide the original Address column.Insert two new columns in between City State Zip and the Unit column, and then use Text to Columns to separate these fields. Adjust column widths appropriately.On the right of the Agent column, add a column and use the Substitute function to replace ‘JG’ with ‘Jesse Gonzales,’ and then hide the original Agent column and display the full name.Add statistics to add up all sales, and then apply a 7% commission to calculate the Gonzales commission.Change the sheet name to Gonzales.Under Page Layout, select Themes and choose a business-like theme and possibly a color combination to apply professional formatting and column widths to all of this data using the image below as a guide.Cleaned Up ImportStep 2: Create the Macro in the X Games Ticket CalculatorIn this section, we will actually build a macro. A macro is simply a recording of every keystroke you perform while the Macro Recorder is turned on. You are quite simply automating keystrokes and building efficiency into your Excel file.Select the X Game Calc sheet.In order to have the Macro Tools available to you, you must have the Developer Tools. If you do not see the Developer Tab, click the File and select Options.Locate the Developer checkbox option in the Custom Ribbon tab in the Options menu, make sure it is checked, and then click OK.DeveloperYou will need to set the Macro Security level in order to develop Macro code. From the Developer Tab, click on Macro Security in the Code group. Check the Enable all macros and then click OK.Enable All MacrosRemember, a macro records every keystroke you perform while the Macro Recorder is turned on. For this Macro, we will clear the values from the ticket type and ticket quantity cells in our X Game Calculator sheet. We will turn on the Macro Recorder, delete the data in Cells E4 and E6, and then turn the Macro Recorder off.Click the Record Macro button from the Developer Tab, Code group. The Macro Recorder dialog window will open.Macro Name: Provide a user-friendly name for this recording such as CalcWipe. Note: Do not use spaces in the name.Shortcut key: Designate a shortcut key the user can press to start the macro. Try using the letter w as your shortcut key. Note: Avoid using a shortcut commonly used in Windows applications, such as CTRL-C or CTRL-P. The macro shortcut will overwrite the Windows shortcut and your users will not understand why the key combination is not copying or pasting.Store: Store the macro in this Workbook. Note: It can be stored in the Personal Macro Workbook so it can be used by other applications. Macros for common actions such as printing a workbook can be stored in the personal workbook, but they will only be available on the computer on which they are stored.Description: Provide an explanation of the functionality of the macro. Use something such as Clear input cells for X Game Calculator. See image below.Record MacroWhen you click OK, the Macro Recording begins. Select Cell E4, press the Delete key, and then select Cell E6 and press the Delete key.Then turn the Macro Recorder off by clicking the Stop Recording button from the Macro group.Step 3: View the Macro and Assign a Macro Button in the X Games Calculator SheetBehind the scenes, Excel has written a little Visual Basic for Applications (VBA) program, which you may access by clicking the Macros command.  Select the Macro you just created, and then click the Edit button.Macro NameVBA will open with your code.VBA Code TranscriptIn later courses, you may learn more about programming; however, you can follow the code and see how it instructs Excel to select a range and clear its contents. Click the X in the top-right corner of this MS VBA screen to close macro editing and return to the Excel file.Begin to add a macro button to make it easy for users to run this code. Add a Button Shape to your application using the Insert Tab, Shapes.Add a Button ShapeDraw the shape onto the application, using your mouse or drawing tool.Draw the ShapeAdd a text description to the button: ‘Clear calculator values!’Associate this button with the macro. Right-click on the shape and select Assign Macro from the menu.Associate Button With MacroSelect CalcWipe and click OK to assign the macro to the button.To prepare to test the macro, provide input into cells E4 and E6 by selecting a ticket type in cell E4 and enter a quantity in cell E6 for starting values. Then test your macro by simply clicking the button. Did it clear the contents of your input cells? If yes, congratulations on creating your first macro. If no, please return to Step 2, Part E to build the macro again.Step 4: Save the Macro-Enabled File and Turn on Protection in the X Games Calculator SheetYou will need to save this file as a macro-enabled workbook. Click the File tab and select Save As.Select Excel Macro-Enabled Workbook, which is also the .xlsm file type.By default, all cells in a worksheet are locked. This means that when the worksheet is protected, the users will not be able to enter or change data in those cells. We will protect the worksheet, but first we must unlock the user input cells. Select cells E4 and E6. Right-click and select Format Cells from the menu. In the Protection tab, uncheck the box labeled Locked.Protect the worksheet. From the Home Menu Cells group, select Format, Protection, Protect sheet. DO NOT add a password. Protect SheetRemember to save the file as an .xlsm (Macro-enabled) file. Step 5: Create a Documentation Sheet and Apply a Footer With Watermark Ski ImageClean up the formatting of your Excel workbook, taking into account professional appearance. The Minimum Requirement (per the Grading Rubric) Insert a new sheet into the workbook, name it Documentation, and move it to be the first sheet.As always, properly document all contents of the workbook on this sheet including names and brief descriptions of each sheet.Apply a business such as formatting to all of these cells.Create a watermark footer containing an experts-only ski image by first searching the Internet for an appropriate free image and save it. Use something such as the following.Experts OnlySelect Page Layout and then open the Page Setup window.Page LayoutSelect Custom Footer and then use the icon on the right side to insert the image saved above into the Center section of the Footer.Once the &[Picture] is displayed in the Center section, the Format Picture icon on the far right will be available. Click it.In the Format Picture pop-up window, select the Picture tab.Under the Image control section, select the drop-down option by Color and select Washout, and then click OK to accept it. Click Print Preview on the Page Setup window to view the results!Print Preview TranscriptIMPORTANT: Remember to save this file as a Macro-enabled workbook.Step 6: Summarize and Write MemoReturn to the worksheet named Gonzales. The analysis on this worksheet needs to be summarized in a short memo. Here are some details and ideas about the memo to be written.The memo should be written to Jesse Gonzales. Your name should also be in the From portion of the memo. Include a summary of the analysis completed.Possible thoughts to include: target sales for new fiscal period, sales for new developments, sharing expertise with others in sales, and a thank you for good work.  The memo needs to be written professionally and placed on the last sheet in the workbook.  Name the last worksheet Memo. Finish and SubmitSave your Excel file as a Macro-enabled workbook!! Your Excel file should contain four worksheets.DocumentationGonzalesX Games CalcMemoSubmit one Macro-enabled Excel file to the Dropbox. When submitting the file, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity. File naming convention: If your name is Jane Doe, then your file should be named very similar to Doe_J_Week7Lab.xlsm.

The post BIS 155 Week 7 ILabAnswers 1Bids 0Other questions 10 appeared first on homeworkhandlers.com.

“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

“Is this question part of your assignment? We will write the assignment for you. click order now and get up to 40% Discount”

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

Instructions: Please read the following case entitled ‘Best Buy Has the Blues (Shirts)’.  After reading this case, you should prepare an analysis following the guidelines I have provided. The purpose of this assignment is for you to demonstrate that you can apply the concepts, principles, and theories presented in the course readings. Your analysis must employ only the facts presented in the case description below. You must resist the temptation to introduce facts not in evidence in the case description by searching the internet for updated information. The company’s present situation is not necessarily the ideal solution that could be derived from a careful analysis of the facts as presented here. This assignment is worth 80 points.  Please post your completed case analysis under the ‘Assignments’ tab.Best Buy Has the Blues (Shirts)Down the hall from the CEO’s office at Best Buy headquarters in Minneapolis, MN, there is a row of hospital beds, each containing the effigy of an ailing or deceased American retailer. Bedside charts reveal dire financial results. A nearby sign reads, “This is where companies go when their strategies get sick.”As CEO of Best Buy, the world’s largest consumer electronics retailer, from 2002 to 2009, Brad Anderson saw his job as keeping the company in good health strategically, and keeping Best Buy’s strategy up and functioning. Anderson regularly prescribed doses of customer focus or, more precisely, focus on the customers’ experience at Best Buy. “In our world,” says Anderson, “the way you win the game isn’t the price of the TV, which is about the same for all retailers, but the experience you give customers once they are in your stores.” For Anderson, this principle led quite naturally to the corollary that success in retailing depends on the people who are most responsible for the customer’s in-store experience, “those line-level employees who interact with our customers each and every day.”This two-fold principle was at the heart of one of the first important innovations that Anderson, then the right-hand man to founder and CEO Richard Schulze, implemented at Best Buy. In 1989, the company stopped paying commissions to its sales staff and put them on salary instead. The move did not go over well with the big suppliers who expected a retailer’s salespeople to push their premium products, but customers appreciated the break from high-pressure sales tactics, and revenues at Best Buy jumped by 25% a year in the early 1990s.The same principle motivated one of the first moves that Anderson made after he became CEO in 2002. Four months after his promotion, he bought a Minneapolis start-up firm that specialized in installing and repairing personal computers. Within a year, he had opened Geek Squad “precincts” in more than 20 Best Buy stores, and by 2005 there was a Geek Squad presence in every store in the chain. Whether working at the customer’s home, in a Best Buy outlet, over the phone, or online, the Geeks constitute a first line of defense against the technological frustrations that can sap the value out of an electronics purchase and the goodwill out of a customer experience. Anderson was confident from the beginning that the technical-services market would continue to grow, but perhaps more importantly, he realized that competitors like Walmart and Costco would never offer the kind of customer services that Best Buy could offer through the Geek Squad. On sales of $1 billion, the Geek Squad now generates about $280 million in annual profit.By far, however, Anderson’s most ambitious strategic gambit has been the “customer-centricity”, or just plain “centricity”, initiative. The keys to centricity are demographics and segmentation. From store to store, the most valuable customers—the ones whose patronage is most lucrative—don’t necessarily belong to the same group of people. At one outlet, for example, the most profitable customers might be affluent tech enthusiasts; elsewhere, they may find suburban mothers, price-conscious family guys, or youthful gadget fiends. Beginning in 2003, Anderson started “centrizing” Best Buy stores by realigning them to cater to their most profitable segment or segments. A given location, for instance, may be geared toward young gadget fiends, while another might be geared toward suburban mothers. The store serving the first segment will have a broad range of videogames and special stations for trying out accessories, while the store serving the second segment will have a staff of personal shopping assistants to help a mother find the right digital camera for recording family activities. If a store caters to affluent tech enthusiasts, as about 40% of them do, there will be a home theater expert on hand.Centrized stores require specialized employees, and employees are also crucial to the success of the centricity concept because it relies on personnel who are empowered to develop the most effective in-store interactions with customers. Personal shopping assistants and home theater experts may get weeks of training, and most line-level jobs call not only for evaluating the success of the centrized experience, but also for recommending enhancements to it. “The closer you get to the customer,” says Anderson, “the better your ability to see what the needs of the business are. . . . A person in a blue shirt in a store [a Best Buy associate] probably has the best insight as to what your needs are . . . I could take you through anything we do today . . . and all of it came from some individual, usually a misunderstood and angry individual, who was sitting there saying, ‘Why don’t you do this?’ and was having trouble being heard.”Under Anderson, Best Buy has also implemented various other strategies to overcome the limitations inherent in being a retailer of commodity products at low prices and low profit margins. For one thing, the company has begun developing relationships with small high-tech start-ups in order to prime the flow of new products into the market. That’s how Best Buy got a three-month jump on competitors with Slingbox, a device that lets users channel TV programming from their homes to their PCs. Best Buy has also introduced its own branded products, including an Insignia line of PCs, TVs, and DVD players. The results in established product categories have been uneven so far, but Best Buy believes that developing its own product lines will not only allow it to compete on price with competitors like Walmart and Dell, but also help it build relationships with start-ups specializing in cutting-edge categories.More importantly, perhaps, Best Buy has reengineered its supply chain, or the flow of products from suppliers to end users. It was always very good at getting high volumes of products out of factories and onto its shelves, but in keeping with the priorities of customer-centricity, it is now focusing on the components of the process most closely related to the task of meeting the needs of customer segments. All stores carry products for every customer-centric segment, but as discussed above, centrized stores focus on the needs of just one or two segments. To meet shifts or peculiarities in store-level demand, for example, frontline employees may be empowered to override inventory management plans and stock higher inventories of certain products. As a result, suppliers must be continuously responsive to signals that come directly from stores, and agile enough to reconfigure shipments and all of the information flows related to them.Before Brad Anderson stepped down in June 2009, he expressed his faith in the effectiveness of customer-centricity to support the company’s latest, and most critical, strategic initiative. “Our customer-centric business model,” he explained, “gives us the confidence to be able to grow outside the United States. We know that we must do three seemingly simple things to succeed: gain deep insights into our customers’ priorities and lifestyles; figure out how we can encourage and nurture our employee ingenuity on behalf of our customers; and then, offer solutions that will result in great experiences for our customers.” So far, Anderson’s bet on centricity appears to be paying off. “We’re still figuring out how customer-centricity works in China,” reports Bob Willett, CEO of Best Buy International, but after just one year, Best Buy’s four-story, 87,000 square foot Shanghai store was already among the top-ten revenue-generating outlets in a 1,300-store global chain.In a sign of volatile times, Best Buy announced in November 2008, when fourth-quarter sales threatened to decline from 5% to a whopping 15%, that it expected revenues for fiscal 2009 (which ended in February 2009) to fall short of projections. When the smoke had cleared, sales had gone up 4%, in keeping with the company’s original projections, thanks in part to another Brad Anderson gamble that had paid off: although comparable-store sales (sales in stores that have been open for at least a year) had declined 6.8%, the losses were offset by revenues from 138 new stores that had been opened in the preceding 12 months. “While the environment continues to be as challenging as we expected,” said Anderson, “consumers are being drawn to brands that they trust, and they are responding to our customer-centric model. In this light, we believe that the market-share gains we’ve made will be sustained.”Assignment: Due to your expertise in strategic management, you have been hired by Brad Anderson to evaluate Best Buy’s current strategy and make a recommendation as to which generic competitive strategy Best Buy should adopt. You should also recommend a strategy or strategy that will help the company better compete in the home goods retailing industry, which is now in the maturity stage of the product life cycle.

The post Case Analysis Best Buy has the Blues(Shirts)Answers 0Bids 0Other questions 10 appeared first on homeworkhandlers.com.

“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

“Is this question part of your assignment? We will write the assignment for you. click order now and get up to 40% Discount”

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

N512 Diverse Populations & Health Care week 7 Assignment German and Irish case studies Question N512 Diverse Populations & Health Care Module 7 Assignment   Complete the following Case Studies: German case study Irish case study Write a 3-4 page APA essay, using two scholarly sources in addition to the textbook. ORDER A CUSTOM-WRITTEN, PLAGIARISM-FREE […]

The post N512 Diverse Populations & Health Care week 7 Assignment German and Irish case studies appeared first on OnlineNursingPapers.

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

Appalachian and African-American case studies – N512 Diverse Populations & Health Care Question N512 Diverse Populations & Health Care Module 3 Assignment   Complete the following Case Studies: African-American case study #2 Appalachian case study #1 Write a 3-4 page APA essay, using two scholarly sources in addition to the textbook. APPALACHIAN CASE STUDY #1 […]

The post Appalachian and African-American case studies – N512 Diverse Populations & Health Care appeared first on OnlineNursingPapers.

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

  N512 Diverse Populations & Health Care Module 1 Assignment   Conduct an assessment of the health care environment where you work (i.e. health department, long-term care facility, specialty clinic, inpatient hospital, etc). Specifically, examine potential barriers that may exist for a member of a minority group that has a significant presence in your community (i.e. Native American, […]

The post N512 ways to decrease barriers to health care essay appeared first on OnlineNursingPapers.

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"