Answered You can hire a professional tutor to get the answer.
I need help creating a thesis and an outline on In excel:. Prepare this assignment according to the guidelines found in the APA Style Guide. An abstract is required.
I need help creating a thesis and an outline on In excel:. Prepare this assignment according to the guidelines found in the APA Style Guide. An abstract is required. My Business and Number of Answer Report For any business to realize an increase in profits at the end of a given duration, quite a number of factors can be varied. Two parameters were chosen for this business model and that is: sales and cost of sales while maintaining all the other factors constant, e.g. those relating to customers. To do this, a spreadsheet named “Profit Analyzer” was created that projects the expected profits depending on how these two chosen parameters are expected to vary quarterly i.e. their percentage rate of increase or decrease (Ken Kaufaman, 2010). When a percentage rate of change is entered under the “Variations” column for either of the two parameters, say 105% if sales are projected to increase at a rate of 5% every quarter and 96% if the cost of sale is projected to reduce at 4% each quarter, the spreadsheet computes the effects of these projections for all the quarters as well the total and the average yearly profits. Using the spreadsheet therefore, it shows that one way of achieving 30% profit by the fourth quarter is by increasing sales at a rate of 6% quarterly and reducing the cost of sales by 1% quarterly. This gives 30.7% profit increase by the fourth quarter as outlined in the table below.
VARIATIONS (based on % projected changes)
Cost of sales
(See attached “my-business.xlsx” file for the actual spreadsheet)
The effect of quarterly increase in profits at a rate of 5%, 10%, and 15% on the total yearly profits would be as outlined in the table below:
Scenario 1 (5%)
Scenario 2 (10%)
Scenario 3 (15%)
Total Yearly Profits
(See attached “my-business.xlsx” file for more detailed analysis of the three scenarios)
Ken Kaufaman. (2010, March 25). How To Make Projections That Actually Mean Something. Retrieved 2013, from Business Insider : http://www.businessinsider.