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

Questions Cloud

Change the carrying value : Cause the carrying value to be the same as the issue price. Not change the carrying value.

Describe potential causes of errors in preparing projected : Describe two unethical practices of some financial managers in preparing financial statements that could hurt their company. (b) Describe three potential causes of errors in preparing projected (i.e., pro forma) financial statements for a company for..

What is the repulsive force : Upon examination of a periodic table, what do the elements in Group VIA have in common (in terms of their electron configuration)?

Indifferent between accepting the project and rejecting : Is this a good project if the required return is 8%? What if it's 20%? At what discount rate would be indifferent between accepting the project and rejecting it?

Identify the best and worst selling days during the period : 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.

What is the required return : The next dividend payment by Halestorm Inc. will be $2.04 a share. The dividends are anticipated to maintain a growth rate of 4.5% forever. If the stock currently sells for $37 a share, what is the required return?

What preceded this digital technology : How does the technology work? What does it allow you to do? Is it better than its analog predecessor? flow? Does the technology have flaws or drawbacks? Are there legal and/or ethical problems associated with this technology?

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, but it is now interested in expanding into Asian and South American markets..

Why do you think the fads were adopted : Why do you think the fads were adopted? To what extent were the fads adopted to truly improve productivity and morale versus the company's desire to appear current in its management techniques compared to the competition?

User Account

All Pages