User Account

All Pages

Create a column chart of the monthly sales based on class

Assignment Help Microeconomics
Reference no: EM131818404

Assignment

You will continue to work with the scenario from last week. The owner thinks it will be easier to look at sales and profits if charts are used. The owner also wants to identify the Class which was not creating as much revenue as the others.

1. Use your spreadsheet from last week. If you did not calculate the sales in column E within the spreadsheet, fill in that column with numbers.

2. Create a column chart of the monthly sales based on class. Select the range A2:D5 to create the graph.

3. The months should display in the legend.

4. Give the chart a title of Monthly Sales.

5. Give the vertical, y-axis a title of Sales in $.

6. Create a pie chart showing the profit for the month of April for all three classes

7. Give the chart a title of April's Sales.

8. The legend should display the three class names.

9. Create a line chart of monthly sales based on class. Select the range the same range that you used for the column chart.

10. Give the chart a title of Monthly Sales.

11. Give the y-axis a title of Sales in $.

12. Display the legend for both the column and line chart on the right. The legend and months should display if columns and rows are properly selected.

13. Change the sheet tab name to Sales

14. Place a comment in cell A1 with your full name and GID number.

Reference no: EM131818404

Questions Cloud

Describe in reasonable detail judicial foreclosure process : Describe in reasonable detail judicial foreclosure process in your state and any alternative process that are available to avoid foreclosure within your state.
Compute the cost of the ending work in process inventory : Compute the cost of the ending work in process inventory, Compute the cost of jobs completed during May.
What is your definition of marketing : Based on both your own experiences and what you've learned, what is YOUR definition of marketing?
What amount is the current federal tax liability : or year-end 2013, Max Corporation shows a pretax financial income of $3,000,000. What amount is the current federal tax liability for Max Corp. for 2013
Create a column chart of the monthly sales based on class : Create a column chart of the monthly sales based on class. Select the range A2:D5 to create the graph. The legend should display the three class names.
What has been sonys strategic approach with regard : What was Sony's marketing program for the launch of the PS3? What is the competitive advantage of the PS3? What are the weaknesses of the PS3?
Yield same value for equity : Show that the two valuation methods proposed by Officer (1994) yield the same value for equity.
Calculate the amount of depreciation expense : Calculate the amount of depreciation expense that Concepts Solution would report on its income statement for the year ended December 31, 2008
What company would you like to call you for an interview : In the area where you live, what form of advertising do you believe is the most successful?What company would you like to call you for an interview?

Reviews

Write a Review

Microeconomics Questions & Answers

  The free rider problem

Question: Explain why the free rider problem makes it difficult for perfectly competitive markets to provide the Pareto efficient level of a public good.

  Failure of the super committee is good thing for economy

Some commentators have argued that the failure of the “Super committee” is good thing for the economy?  Do you agree?

  Case study analysis about optimum resource allocation

Case study analysis about optimum resource allocation: -  Why might you suspect (even without evidence) that the economy might not be able to produce all the schools and clinics the Ministers want? What constraints are there on an economy's productio..

  Fixed cost and vairiable cost

Questions:  :   Which of the following are likely to be fixed costs and which variable costs for a chocolate factory over the course of a month?  Explain your choice.

  Problem - total cost, average cost, marginal cost

Problem - Total Cost, Average Cost, Marginal Cost: -  Complete the following table of costs for a firm.  (Note: enter the figures in the  MC   column  between  outputs of  0 and 1, 1 and 2, 2 and 3, etc.)

  Oligopoly and demand curve problem

Problem based on Oligopoly and demand curve,  Draw and explain the demand curve facing each firm, and given this demand curve, does this mean that firms in the jeans industry do or do not compete against one another?

  Impact of external costs on resource allocation

Explain the impact of external costs and external benefits on resource allocation;  Why are public goods not produced in sufficient quantities by private markets?  Which of the following are examples of public goods (or services)? Delete the incorrec..

  Shifts in demand and movements along the demand curve

Describe the differences between shifts in demand and movements along the demand curve. What are the main factors which can shift the demand curve? Explain why they cause the demand curve to shift. Use examples and draw graphs to support your discuss..

  Article review question

Article Review Question: Read the following excerpts from the article "Fruit, veg costs surge' by Todd, Dagwell, published in the Herald on January 25th 2011 and answer questions below:

  Long-term growth, international trade & globalization

Long-term Growth, International Trade & Globalization:- This question deals with concepts such as long-term growth, international trade and globalization. Questions related to trade deficit, trade surplus, gains from trade, an international trade sce..

  European monetary union (emu) in crisis

"Does the economic bailout of Spain and Greece spell the beginning of the end for the European Monetary Union (EMU)?"

  Development game “settlers of catan”

Read the rules of the game, the overview and the almanac for the Development Game "Settlers of Catan"

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd