Reference no: EM131205942
Assignment
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.
Calculate the cost of new common stock
: The allied group intends to expand the company's operation by making investments in several opportunities available to the group. Accordingly the group has identified a need for additional financing in preferred and new common stock and a new bond is..
|
Will the contract curve be a straight line
: In the analysis of an exchange between two people, suppose both people have identical preferences. Will the contract curve be a straight line? Explain. Can you think of a counterexample?
|
Number of payments per period
: When you increase the number of payments per period, why does the total cash payment times the number of payments in the period not equal the original single payment for the period?
|
Determine the voltmeter reading four time
: Determine the voltmeter reading four time constants after the switch is closed.- Find the time that must pass before iC drops to 3 µA.
|
Design simple gap table and interactive graph for the sales
: Develop a Windows Excel spreadsheet to design a simple GAP table and interactive graph for the Sales department.
|
Analysis of each error showing the incorrect entry
: Sara Yu, CPA, was retained by Info Cable to prepare financial statements for April 2014.Yu accumulated all the ledger balances per Info’s records and found the following. Cash received from a customer on account was recorded as $930 instead of $390. ..
|
Current share price
: If you have a company that will pay no dividends on stock over the next nine years, but will pay a dividend of $11 per share exactly 10 years from today and will increase the dividend by 4 % per year thereafter. If the required return on this sto..
|
Discuss methods of probability sampling
: Discuss methods of probability sampling clearly indicating its advantages and disadvatages
|