Reference no: EM13859780
Read all questions and instructions carefully.
Retail Trade Analysis
Benson & Benson Retail, Inc., is a large successful retail and grocery chain based the North East region. It is formulating a 7-year expansion plan. It is interested in diversifying its business to related retail industries by acquisition or expanding its geographical presence by opening new chains in other states where there is no presence of David. You have been requested to conduct a market research for the expansion plan. Specifically, you need to identify which retail industry is promising in which state or region in the United States and will present your study to your supervisor and the CEO. You have downloaded the retail trade census data in 2007 from U.S. Census Bureau (https://www.census.gov/retail/) and are about to analyze it.
1. Sort the records by state (in the ascending order) and by sales (in the descending order) so that one can see which industry is largest in each state.
2. At the right of the table, add two columns to show a) per capita industry sales (sales divided by population) and b) sales per firm (sales divided by firm). Format cells in a way that displays amounts in a currency format and with two decimal digits.
3. Based on Q2, find the five states among all states that have the largest per capita major household appliances sales, in order to figure out which market would be most promising for a new appliance retail store. Highlight these five states in Red. Delete all the other industry sales data from the worksheet.
4. Create a worksheet that displays the number of firms between 1500 and 3000 in "Light Green with Yellow Text." Do not delete any record.
5. Using AutoFilter, create a worksheet that displays the sales data of men's, women's, and children's wear in East and West Midwest region. Do not delete any record.
Attachment:- Data.rar
|
Calculate dhr for the combustion of ethanol
: 1. Use average bond energies to calculate ΔHr for the combustion of ethanol. CH3CH2OH(g)+3O2(g)→2CO2(g)+3H2O(g) Express your answer using four significant figures.
|
|
Calculate the yield to maturity
: Calculate the yield to maturity on each bond, ij , j = A, B, C, D.
|
|
What you want from your current and future employment
: For this assignment you are required to reflect on what you want from your current/future employment, and record your thoughts over the course of the module in the form of a reflective journal.
|
|
How an effective compensation and benefit system contributes
: Compensation and benefit philosophy
|
|
Create a worksheet that displays the number of firms
: Benson & Benson Retail, Inc., is a large successful retail and grocery chain based the North East region. Create a worksheet that displays the number of firms between 1500 and 3000 in "Light Green with Yellow Text." Do not delete any record
|
|
Question regardinng the present value of investment
: a) How much would be the present value of this investment? b) How much would be the future value of this investment at the end of 11th year?
|
|
Proposal for dissertation in supply chain management
: Submit the proposal for dissertation in MSc - Supply Chain Management and You will usually further develop this proposal in terms of final dissertation.
|
|
Write an essay of summarising your personal reflections
: Write an essay of up to 1800 words summarising your personal reflections and giving examples of your learning in relation to your SWOT and your PDP using supporting audit material used in class
|
|
Determine the values of the equalized output pulses
: The result of transmitting a single pulse through a channel is a received sequence of pulses at the sampling instants given by {0.1, 0.3, -0.2, 0.96, 0.4, -0.1, 0.1} where the leftmost sample is the earliest. The value 0.96 corresponds to the main..
|