Beltway Shoe Company – Managerial Report w/ Excel spreadsheet

Beltway Shoe Company sells luxury leather shoes in the United States. The company monitors its shoe sales by collecting randomly chosen data from store locations throughout the country. They record original price, sale price, and number of days it takes to sell each unit. Each pair of shoes is classified as “Eastern Region” if it is sold in the Eastern part of the United States, or as “Western Region” if it is sold in the Western part of the country. Randomly chosen samples provided sales data for 50 Western Region and 50 Eastern Region pairs of shoes. The complete data set is in the file named Shoes, linked at the bottom of the page.

Managerial Report
Prepare a report (see below) that summarizes your assessment of the nature of the shoe market in each region. Be sure to include the following seven (7) items in your report.

See other attached files. Excel spreadsheet contains the data you will use in the managerial report and show also to show any calculations you did.