View the step-by-step solution to:

Chapter Analysis and Assignment Using the following data go through chapter 2 and develop the requested tasks using a spreadsheet modeling:

This question was answered on Jan 24, 2013. View the Answer
Chapter Analysis and Assignment Using the following data go through chapter 2 and develop the requested tasks using a spreadsheet modeling: Race Performance Company Month Qty Costs(000) Sales(000) Jan 15000 1250 2340 Feb 16400 1620 1952 Mar 13625 1467 1675 Apr 13020 1585 2102 May 17025 1652 2054 Jun 11250 1340 1875 Jul 12345 1236 1457 Aug 18024 1784 1640 Sep 14695 1565 1987 Oct 16874 1675 2014 Nov 19785 1895 2650 Dec 20102 1874 2540 With the above information, you should be able to develop the following functions: 1. Format Costs and Sales columns in $ with two decimal points. 2. Format Qty with regular numbers with no decimal points. 3. Centralize all the Titles 4. Divide the Costs by the Qty to develop a column of Cost per Unit, Use $ and two decimal points. 5. Develop a fifth column for "Profit" by subtracting sales minus costs. Use $ decimal points. 6. Leaving two cells down and use the function Sum to obtain the total per column. 7. Two cells below column Month, use the function Count to know the number of months. 8. By using the Max and Min, determine the months with higher profits and the lowest cost per unit. 9. By using the Average function determine the mean for the all the numerical 10. Using Chart wizard develop the following charts; a. Column chart for the month and cost, a bar chart for Month vs. Sales, a line chart the month vs cost/unit vs total profit. Use a scatter chart between the profits. 11. Develop another column for Profit/unit 12. Below the Average, develop the median and standard deviation (STDEV)functions for each numerical columns. 13. Divide the STDEV by the Average to determine with of the columns of has the best control. (Use an Statistical Book and look for Variation Coefficient) 14. Develop another column where by using an IF function determine wh
Sign up to view the entire interaction

Top Answer

The solution is... View the full answer

8423553.xlsx

Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec Qty
15000
16400
13625
13020
17025
11250
12345
18024
14695
16874
19785
20102 Costs(000)
$1,250.00
$1,620.00
$1,467.00
$1,585.00
$1,652.00...

This question was asked on Jan 23, 2013 and answered on Jan 24, 2013.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards