Interactive graph for the sales department.

Assignment Help Management Theories

Reference no: EM13525168

One aspect of a GAP analysis is designed to show the difference between where a company is and where it wants to be. The areas of consideration might be different for each department. The financial department would consider the growth in sales versus the cost of labor and goods. Human resources would want to know the employee turnover rate, and sick leave ratio. Subjective information from customer evaluation sheets and mystery shoppers can also give useful information.

Requirements

Develop a Windows Excel spreadsheet to design a simple GAP table and interactive graph for the Sales department.

•Use your own data for the following considerations. Some of these will be subjective data from responses on customer evaluation sheets; others (sales) will be objective from sales and inventory statistics.

GAP table should include 3 headers (columns): Same period last year (SPLY), current week data, GAP or difference.

Interactive Graph - for the GAP table

Business - Mrs. Bee's Popcorn Company specializes in custom popcorn mixes, party gifts and tins, and monogramed memorabilia containers.

Considerations (Lines) - Helpfulness of staff, wait time in line, overall selection of items, diversity of products, quality and freshness of product line, sales.

Reference no: EM13525168

Questions Cloud

Explain which change the equilibrium constant : Which of the following will change the equilibrium constant. a. changing temperature, b. nothing changes the value of keq, c.varying the ititial concentration of reactants, d. varying the initial concentration of products, e. changing the volume o..

Compute unit product cost that would appear on the job : The company applies manufacturing overhead on the basis of direct labor-hours. The predetermined overhead rate is $24 per direct labor-hour - Compute the unit product cost that would appear on the job cost sheet for this job.

Find the potential energy of the pair of charges : Two point charges Q1 = +4.10 nC and Q2 = ?2.60 nC are separated by 45.0 cm. What is the potential energy of the pair of charges

A reaction is found to double when the temperature is raised : The rate of a chemical reaction is found to double when the temperature is raised from 298K to 308K. Determine the activation energy.

Interactive graph for the sales department. : Develop a Windows Excel spreadsheet to design a simple GAP table and interactive graph for the Sales department.

Find the force on the negative charge : A 8.5uC charge is at x_1= 16cm ,y_1 = 7.0cm and a -3.4uC charge is at x_2 = 4.1cm ,y_2 = 10cm. Find the force on the negative charge

Compute the unit product cost - job cost sheet : Compute the unit product cost that would appear on the job cost sheet for this job - The company applies manufacturing overhead on the basis of machine-hours.

Find the volume charge density in the region : The electric field in a certain region is given E=ax(i hat), where a= 48N/Cm and x is the position in meters. Find the volume charge density in the region

Define nuclides below the valley of stability : Nuclides below the valley of stability can become more stable through which of the following processes

User Account

All Pages