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
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
This question was answered on: Sep 18, 2020
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 www.aceyourhomework.com (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 QuestionSTATUS
Sep 18, 2020EXPERT
GET INSTANT HELP/h4>
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).
NEW ASSIGNMENT HELP?
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.
WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.