What excel function is useful for calculating revenue

Assignment Help Financial Accounting
Reference no: EM131330495

Question 1:

A t shirt company is planning a production run for an event where the attendance (and thus demand for t-shirts) is uncertain. The event planners have indicated that they think the attendance will be 500, 750 or 1000, with probabilities of 30%, 50% and 20% respectively. The company must pre-order the blank t-shirts (cost=$5 per shirt) and it can sell finished shirts for $12 apiece. Any finished shirts that cannot be sold at the event can be sold for $2 apiece to a used clothing vendor.

A) What Excel function is useful for calculating the expected value of demand for t-shirts? What is the expected demand?

B) What Excel function is useful for calculating revenue? Explain why it is useful.

C) What are the two possible cases for the amount of t-shirts that will be sold to the used clothing vendor? How would you calculate this amount in a spreadsheet model?

D) Suppose that blank t-shirts can only be ordered from the wholesale vendor in batches of 100? How many t-shirts should the company order?

E) Suppose now that blank t-shirts can only be ordered from the wholesale vendor in batches of 50? How many t-shirts should the company order?

Reference no: EM131330495

Questions Cloud

Remote memory access penalty : The percentage of program instructions that access remote memory is 0.2%. What speedup would be achieved for the program if the remote memory access penalty could somehow be reduced to 10 ns per access?
Compute the cumulative sum of the elements : A Quad-core system is used the compute the cumulative sum of the elements in an 18-element vector. Assume that the time required on any core to perform a single addition is 2 nano-seconds.
Memory conflicts or other dependencies : What speedup is provided for the same program if 499 identical processors are included so that the system has a total of 500 processors and no memory conflicts or other dependencies occur?
Develop a sustainability indicators monitoring system : Students will be required to choose a specific enterprise (it should ideally be one with which they are somewhat familiar) and develop a sustainability indicators monitoring system for that enterprise
What excel function is useful for calculating revenue : What Excel function is useful for calculating the expected value of demand for t-shirts? What is the expected demand? What Excel function is useful for calculating revenue? Explain why it is useful.
Are there any lows that need to be addressed : Pivot the data to see totals, counts, or averages of various categories. Are there any highs? Are there any lows that need to be addressed? Subtotal the data using various categories.
Minimum time required to execute the program : a) How long does it take to execute the program if three of the processors are disabled and only one is used to execute the program? b) What is the minimum time required to execute the program if only two of the processors are used to execute the p..
Describe this oscillation : The standard parameters result in a temperature slightly below 50. Find a set of parameters that move the temperature closer to 12. This model rarely results in a constant temperature; it usually oscillates. Describe this oscillation.
Compare super bowl ads over the last few years : Visit youtube to search for and view several past superbowl ads. Compare super bowl ads over the last few years. What types of strategies were used ? Have the strategies changed over time? If so, why do you think they have? If not, why not? Which ..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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!

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