Question Details

[answered] BUS 237 - Assignment 2: Retail Display Due Date/Time: Check

hiii, i am doing bus 237 retail display assignment, i dont know how to copy spreadsheet into microsoft word as its not fitting in when i am copying and pasting it into the word. i also dont know how to approach the report.

BUS 237 - Assignment 2: Retail Display


Due Date/Time: Check Canvas Assignments for the due date/time for your section! Objective and Background


The purpose of this assignment is to give you experience using a range of software productivity tools to


address a realistic business task. The task is to create a visual layout for a retail display area. You will use


Microsoft Access to get sales information for a range of products, Microsoft Excel to calculate the


profitability of each product, and Microsoft Visio to create a layout for the products given a fixed amount


of display space. Finally, you will use Microsoft Word to bring all the elements of your analysis together


into a coherent and professional report.


Any retail business must display goods in order to sell them. The art in developing effective retail


management is utilizing the space in the store in order to display items that provide the largest


contribution to overall profit. Retailers attempt to draw maximum attention to their most profitable




Profitability is a function of the total profit earned on the sale of each item and the number sold. Thus,


high-price, high-margin products may be profitable even if they do not account for the largest number of


items sold. Conversely, low-price, low-margin products may be profitable if the products achieve high


sales volumes. An effective retail manager must not only be good at choosing profitable items, he or she


must also be creative in displaying these goods as an understandable theme so that customers want to


buy the goods. The most effective retail managers therefore carefully balance profitability and display


design. Scenario


You are an associate manager at Seger, a larger Scandinavian retail store specializing in products for the


workplace. Seger is going to put all of the items in the store on sale. You have been given the job of


creating a display for a collection of items of your own choosing for the sale. Your job is first to choose


which items provided in the inventory you want to sell. Once you have chosen the items, you need to


position them so that they fit into the retail display area provided. The dimensions of the display area are


provided in Figure 1 below. Some notes about organizing this space are also provided. Directions


Your job is to analyze profitability of a collection of goods to maximize potential contribution. There is a


limited space to display the goods, so not all of the goods available can (or should) be chosen. Profit


contribution is measured as sales quantity * price * gross margin (where gross margin is measured as a


percentage of sales price). There must be exactly 11 different products (from several categories)


displayed in order to draw the interest of consumers. You are also responsible for developing a theme of


1 of 5 your choice that ties the various goods together into a coherent display. The only theme that you are NOT


allowed to select is the ?Work at Home? theme.


You should make three considerations as you choose your items:


1) The contribution of the item to overall profitability.


2) The functionality of the display area and how the item fits into your selected theme.


3) The size dimensions of the item. Determining the Historical Sales of Each Product


The collection of items is provided in the Access inventory database (Seger_Inventory) containing two


tables: Products and Sales. The Products table contains information about the small subset of Seger


products considered to be top candidates for the sale, such as physical dimensions (in centimeters), selling


price, and margin. The Product_ID code reflects the category of the inventory item (100 = desks & tables,


200 = chairs, 300 = storage & shelves, 400 = boxes, 500 = lamps, 600 = vases, 700 = decoration, 800 = rugs,


900 = beds). The Sales table provides sales (in number of units sold) by date and retail outlet ? you


should estimate sales volume using this data. Use the query feature in Microsoft Access to join the tables and calculate aggregate sales for each


product. Consider the three represented Lower Mainland areas only (Burnaby, Surrey, and


Vancouver) since regional sales volume is very important. Calculating the Retailing Contribution of Each Product:


The boss has asked you to select the products for the retail display based on their potential profit


contribution. For this purpose, you must create an Excel spreadsheet showing your method for analyzing


the contribution of each product. Import the results of your historical sales query into Excel and use Excel?s arithmetic capabilities to


calculate the necessary measures and ratios.


Use Excel?s sort feature to rank the list of products in terms of contribution (highest profit at the top).


Only keep the products you want to display in the store ? remove the rest of the inventory products


from the sheet.


Create an appropriate chart in Excel that shows the amount of profit generated by each product. Use


data labels to highlight the markers on the chart so you know which marker belongs to which product. Creating a Retail Display Diagram:


Finally, you should use a general-purpose graphics tool like Microsoft Visio to create a retail display


diagram. Use Visio to map out the layout of the retail display area. Visio permits you to enter the exact


dimensions for shapes so your diagram should give a precise indication of how the space is used.


Make sure to label each product.


You should have no product extending beyond the boundaries of the displayed area as defined in


Figure 1. 2 of 5 You can use Basic Shapes in Visio to draw simple shapes (e.g., circles, squares, etc.) and label them


as your items. You can also use predefined Office Layout shapes in Visio (e.g., office accessories,


equipment, and furniture).


Figure 1: Display Area (Looking down? ?Bird's Eye? View) These are aisles that people will


use to walk by Notes: 2.50


meters This is


a wall This is also a wall 3 of 5 3.75


meters You can make use of shelving


and other props in the space.


You should assume that other


places in the store can store


stock for actual sales.


All of your chosen items must


be displayed in the space. You


are welcome to use duplicates


of the item in the space.


Items must be contained in the


display area and should not


spill out past the borders.


The height of the display area


is 3.1 meters. Some notes about use of MS Visio for this assignment:


Placing shapes on the canvas:


Select Basic Diagram to draw simple shapes and label them as your items.


Search for Office Layout to start with a template that includes office related shapes Online help: Visio basics


Getting Started with Visio, A beginner?s guide to Visio, Basic Tasks in Visio, and


Create an office layout diagram With shapes placed on the canvas: Set item dimensions by right-clicking on the shape and selecting View > Size & Position Window.


Make sure you use proper units (cm = centimeters) for dimensions. In this window you can specify the exact measures for each item (to match the items measurements stated


in the database). Since we are looking at the display from the top, you should use the Width and Depth


dimensions from the Products table to set the Width and Height (the depth dimension of the object


becomes height dimension if you are viewing that object from the top) values in Visio. Label the items by double-clicking on shape and typing the item's label (e.g., product name) There are other ways to label your items, such as using the color legend, text labels, etc. You can also


color the items and use a legend to better display the stacked items. Click on each item and from the


main menu select Format > Fill then select a Color (you can also use a toolbar).


4 of 5 Submission Instructions:


Submit via Canvas Assignments tool the following four files:


1. The Report (5 pages)


Create a Word document (in a professional memo format) addressed to your boss (in this case, your TA)


outlining your analysis and design for the retail display area. Your document should contain: A cover page with your name, student number, and the name of your TA.


Your 4 pages MS Word Report with the following sections appropriately labeled and formatted:


1) Introduction - A brief introduction that outlines the task and your methodological approach to


product selection. You also need to identify your selected theme and justify it as well as describe


the contribution rationale you used for your selection.


2) Table (copy/paste from Excel) - A list of the products you have selected for display. This list should


show the critical elements of your contribution calculations and include only the products you


selected for display. Your design of the spreadsheet is an important part of the assignment.


3) Chart (copy/paste from Excel) ? A chart that compares the contribution from each item in your




4) Display diagram (copy/paste from Visio) ? A diagram showing your retail display area. 2. Your Access Database


Your database file should contain a single saved query named ?ProfitBC2017? plus the original two tables


provided. The query should join the necessary tables and apply criteria to limit the results to those


required for subsequent contribution analysis. Hint: Create the required relationships first. 3. Your Excel Spreadsheet


Your spreadsheet file should contain one sheet showing your contribution calculations and a second sheet


showing your contribution chart. Each sheet should be named appropriately. All other sheets should be


removed. The spreadsheet should be well laid out and well documented. 4. Your Visio Diagram


Your diagram file should contain a visual representation of the retail display area. The layout of products


and their labels should be clearly marked. All dimensions should be to scale.


Marking Criteria: See the assignment grading key for the evaluation criteria used to grade this assignment.


Students are expected to work independently on this assignment, therefore, TAs have been


instructed to award a maximum grade of negative 15 (i.e., -150% cheating penalty) to students


whose submissions suggest that they collaborated with others on their assignments (report and


supporting files). This applies to the original author of the work, as well as to those whose


submissions resemble it!


Late submissions will NOT be accepted. A grade of zero will be awarded for missed deadlines. Contact your TA immediately if you are having any problems with the Canvas submission process!


5 of 5


Solution details:

This question was answered on: Sep 18, 2020

PRICE: $15 (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .

About this Question






Sep 18, 2020





We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.


Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.


Order Now