What excel function is useful for calculating revenue?

Assignment Help Accounting Basics
Reference no: EM13848857

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.

Refer to Exhibit 2-1. 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.

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?

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?

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: EM13848857

Questions Cloud

Motivating society''s persecution : Imagine you are a person accused of Witchcraft in the 16th and 17th century. Please write at least a one page journal entry from that perspective. Why do you think you are being targeted? In other words try and reflective on what is motivating societ..
What role did religion play as a motivation in the age : What role did religion play as a motivation in the age of exploration? Was it as important as the economic motive? Why or why not?
What were a few things about arafats family : What were a few things about Arafats family that confused her American friends - Have you ever had to adjust to a new environment, a new culture, or do you know someone that had to adjust to your culture?
Role of operating system in server- based services : Role of Operating System in Server- based Services
What excel function is useful for calculating revenue? : What Excel function is useful for calculating revenue? Explain why it is useful.
Calculate the values for all resistors : This item covers Modules 5-8.  Scan, handwrite answers and upload solutions.  Show all required calculations for full credit.
Organization mission vision and values : My Organization of Choice- In depth- Information From Annual Reports, business/sector news, web-sites-  Organization's Mission, Vision and Values, Strategic initiatives or new directions and Leaders- Who are they, visible, clear
Waiting time t between successive occurrences of an event e : waiting time T between successive occurrences of an event E
What amount should sharp report current income tax payable : There were no deferred income tax rate was 35% in 2009 and 40% thereafter. In its 2011 balance sheet, what amount should sharp report as current income tax payable?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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