Identify the best and worst selling days during the period

Assignment Help Operation Management
Reference no: EM13969301

Given the sales data shown on accompanying worksheet, describe a strategy to identify the best and worst selling days during the period (i.e., Monday through Sunday), the average sales by day, and to sort total monthly sales from lowest to highest.

Your spreadsheet is as follows. ([Spreadsheet] download spreadsheet to complete formulas as needed. This spreadsheet is only an aid and it is not considered your final solution.)

2014 Jan $8,948.45 $2,664.20 $2,261.99 $63.12 $9,579.97 $8,549.12 $3,003.78 Feb $1,355.33 $9,239.40 $2,830.44 $7,812.03 $6,153.32 $1,653.16 $5,675.18 Mar $6,875.37 $3,128.55 $3,427.12 $2,923.33 $1,761.88 $4,852.91 $7,497.51 Apr $819.12 $3,514.35 $3,716.09 $6,670.73 $7,977.09 $1,272.98 $7,397.87 May $6,331.52 $7,050.07 $9,563.82 $5,269.15 $2,548.09 $2,905.60 $2,824.17 Jun $3,860.51 $9,730.80 $1,754.55 $624.94 $5,950.75 $9,452.55 $8,746.00 Jul $8,763.37 $4,752.85 $5,933.16 $8,198.88 $3,153.03 $4,357.18 $7,783.71 Aug $2,719.26 $2,917.68 $2,867.34 $8,243.00 $2,931.38 $7,815.33 $3,985.61 Sep $1,465.60 $5,299.58 $6,689.89 $4,490.01 $9,544.27 $4,993.48 $5,031.83 Oct $1,198.28 $9,613.53 $4,500.98 $9,947.13 $7,741.69 $9,158.34 $815.95 Nov $7,230.84 $9,945.14 $1,365.19 $1,411.93 $2,697.10 $2,652.09 $5,377.05 Dec $1,809.60 $8,894.52 $7,088.61 $4,994.07 $2,122.82 $2,341.67 $3,376.56 2015 Jan $9,837.32 $3,258.07 $8,498.52 $8,687.62 $2,029.47 $4,688.71 $5,161.21 Feb $9,362.46 $19.01 $5,744.49 $1,886.99 $8,926.30 $877.47 $1,348.28 Mar $6,394.69 $8,788.72 $5,897.94 $4,064.68 $2,472.72 $4,195.19 $2,596.62 Apr $2,410.40 $1,984.99 $5,545.00 $3,945.84 $784.07 $2,853.61 $1,966.11 May $3,272.88 $9,238.73 $324.43 $5,344.85 $4,034.96 $1,980.36 $4,822.51 Jun $9,011.49 $1,868.24 $9,970.37 $3,692.95 $8,902.46 $1,471.00 $3,562.87 Jul $7,335.74 $4,826.26 $3,070.19 $305.70 $7,860.64 $9,893.90 $2,570.32 Aug $3,603.05 $4,876.36 $4,563.78 $4,130.74 $2,626.00 $5,464.33 $3,613.60

Reference no: EM13969301

What marketing mix issues should be addressed

Trax is a small us based toy manufacturing company that has outsourced most of its production to China. Up to this point the firm has only marketed its products domestically,

Hired as a business analyst

You have been hired as a Business Analyst. The business needs charts and graphs created to show the yearly totals for sales, quality, and production. Given the following speci

Comcast is attempting to increase

Comcast, the cable television provider, now offers Internet and phone services to its customers. Comcast is trying to increase the portion of customers’ expenditures spent wit

Warehouse with three in-flow arcs and three outflow arcs

Consider modeling a warehouse with three in-flow arcs and three outflow arcs.  The warehouse node is a transshipment node but has a capacity of 100.  How would one modify the

Factors that influence manufacturing process design

By taking as an example a product or a service from an industry that you are familiar with, critically discuss the main factors that influence the manufacturing/service proc

Develop a paper that will analyze role of project pricing

Develop a paper that will analyze the role of project pricing and estimating for your selected project. Include in your analysis the pricing process, labor distribution, pri

Improve the financial impact of the company

Include examples from external research to support your views. Describe a company that has used a purchasing strategy to improve the financial impact of the company. Use a

How has a recent emphasis on safe and quality patient care

What are some legislative policies and regulatory changes that have significantly impacted nursing and healthcare service delivery? How has a recent emphasis on safe and qua

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd