Sales analysis spreadsheet | Business & Finance homework help

Usingÿthe ABC Technologies Inc., Q1 2012 Sales spreadsheet, analyze the data on Q1 2012 Sales identifying the following:
ÿ

Monthly sales by Region
Quarter One sales by Region
Monthly sales by Product
Quarter One sales by Product
Monthly sales by Region, by Sales people
Quarter One sales by Region, by Sales people
Create a graph or chart that compares the data in a meaningful way, i.e. compare regions by month, compare products by month, etc…

ÿ
Createÿa spreadsheet formatted to present your analysis of the sales numbers to management. In your spreadsheet, use the following:
ÿ

Use the SUM function
The date function
An additional math or statistical function of your choice
Fill colors to differential areas of your spreadsheet
Border lines to differential area of your spreadsheet

Video and questions.. | Information Systems homework help

Watch the following videos for your Discussion Questionÿ
ÿVideo #1: https://www.youtube.com/watch?v=sVtMC3GkMr0ÿ
Video ÿ#2: ÿhttps://www.youtube.com/watch?v=pF_vtsVC3PY&list=RDLVsVtMC3GkMr0&index=6 ÿ
Video #3: https://www.youtube.com/watch?v=OsrGRU62yB4ÿ
Video #4: ÿhttps://www.youtube.com/watch?v=rNjhSYue_OEÿ
Video #5: ÿhttps://www.youtube.com/watch?v=FRUJxiQfGnkÿ
You need to watch all videos in order to answer the questions.
What did you learn from Video #1?
What did you learn from Video #2?
What did you learn from Video #3?
What did you learn from Video #4?
What did you learn from Video #5?

Boston Global Determine the Commissions on The Option Transaction Questions

I?m studying for my Accounting class and don?t understand how to answer this. Can you help me study?   CommissionsDollarAmount     Commission Rate$2,500 or less     $29 + 0.016 of dollar amount$2,501-$10,000     $49 + 0.008 of dollar amountover $10,000        $99 + 0.003 of dollar amountMaximum charge: $40 per concract on the first two contracts, plus $4 per contaet thereafter Minimum charge: $37.25 plus $1.75 per contract

Ep values | Nursing homework help

Instructions
Use the table to answer the 11 questions below. ÿBe sure to explain each answer thoroughly.ÿDo NOT include a numerical answer without explaining how you arrived at the solution.
Fasting Blood Sugar Values Table
Alpha FBS Group
Beta FBS Group
95ÿ
90
100
100
125
125
175
200
250ÿ
550
Assignment Questions
Answer the following questions in complete sentences.

What is the mean fasting blood sugar value for each group?
What is the median fasting blood sugar value for each group?
What is the mode fasting blood sugar value for each group?
What is the range of fasting blood sugar values for the Alpha Group?
What is the range of fasting blood sugar values for the Beta Group?
How stable is the range as a measure of variability? Why?
What statistical value represents the 50thpercentile?
The standard deviation (SD) for the Alpha FBS Group = 64.75.ÿWhat do these values say about how the data vary around the mean for each group? Vary between groups? (See Standard Deviation text and Table 13-8 for help).
The standard deviation (SD) for Beta FBS Group = 193.25.
If you had each patient?s fasting blood sugar value and age, what procedure will you use to make comparisons among unlike data?
If the data sets approximated a normal distribution, then what percentage of patients? fasting blood sugar values would fall within two SDs of the mean?ÿ

Changing interest rate | Business & Finance homework help

Using the Wall Street Journal, select an article about the current economic conditions and trends regarding a changing interest rate environment. How would bond values change over time? As a bond investor, what measures would you take to manage rate risk based on current economic conditions and the current interest rate trends? Select an article to justify your position.

Humber Compare and Contrast Perspectives on Euthanasia Questions

I?m working on a Biology question and need guidance to help me study. Part 1 Question 1. Using the internet or library resources, choose another country and compare and contrast perspectives on euthanasia. Which of these countries seems the most restrictive? Most accepting? you may post your conclusive opinions, if desired.   Question 2. In the case of passive euthanasia of someone who is in coma, what would doctors and the family need to know in order to make a decision? See the following link as you think about it.Part 2 – Do you think that it is easier or more difficult for children to break the cycle of poverty in the current Chronosystem’s atmosphere?        – Why or Why not?       – Name specific factors in the current chronosystem that might positively impact children growing up in poverty. 

Business finance – accounting week 1 assignment

Prior to beginning work on this assignment, review the current financial statements of Starbucks through Yahoo! Finance Links to an external site.or the EDGAR | Company Filings Links to an external site.database in the Filings and Forms page. You can access the financial statements by going to the Yahoo! Finance webpage, typing in the stock symbol of Starbucks, and then clicking on the ?Financials? tab.ÿ
Reviewing the previous quarter?s financial statements will provide you with data to construct pro forma financial statements for Starbucks and make some basic projections. This week, you will be charged with constructing two pro forma financial statements and addressing some questions about your projections. The two financial statements will include an Income Statement and Balance Sheet.
To begin your assignment, download the Financial Forecasting Template Download Financial Forecasting Template.
Part 1
Use the EDGAR | Company Filings Links to an external site.or Yahoo! Finance Links to an external site.database to download the last 10-Q from Starbucks into Excel. Use the downloaded data to complete the Income Statement and Balance Sheet on the appropriate tabs in the Financial Forecasting Template. Assume the following:

Sales will increase for the next quarter by the same percentage increase from the previous quarter to the last reported quarter. For example, if sales increased 8% from the last quarter to the current reported quarter, you will use 8% as the sales increase for your pro formas.

Calculate the expenses to determine what will change and what will remain the same.
Note: Not all costs are associated with the cost of sales. It will be up to you to determine which line items need to be increased and which ones need to be left alone. This will require you to distinguish between fixed and variable costs. For a reminder of the difference between fixed and variable costs, please watch the video Business Costs (Fixed Costs and Variable Costs) ExplainedLinks to an external site..
Within each line item expense explain your rationale, as well as provide a brief summary.
Part 2
Then, calculate a quarterly variance analysis using the Variance Analysis tab of the Financial Forecasting Template (the same template you used for Part 1). Complete the following in your variance analysis:

In the Excel template, insert the line items.
In Column C, (Q4, 20NN) enter the previous quarter?s numbers as the budget.
In Column D, (Q1, 20NN) enter the current quarter?s actual numbers.
In Column E, the spreadsheet will calculate the dollar difference between the budget and actual numbers.
In Column F, the spreadsheet will calculate the percentage change.
In Column G, analyze and speculate the rationale for the variances.

PLAGIARISM CHECK WILL BE DONE FOR ALL ASSIGNMENTSÿ

SOC 1011 Colorado State The Case of Enron Accounting Scandal Essay

Option #1: ENRON: The Smartest Guys in the Room film reflection  ENRON: The Smartest Guys in the Room (Links to an external site.) film reflection. After reading the Ritzer article (Links to an external site.) and watching the ENRON film, write an essay on any three of the following questions. Do not answer them one by one; you should craft a -level essay with a strong introduction, body, and conclusion, using APA formatting. Whichever questions you use here, you must also connect them to the Ritzer article.