User Account

All Pages

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

  Product-cost cross-subsidization problem

Product-cost cross-subsidization is more likely to occur when:

  Select two 2 public corporations in the industry with which

choose two 2 public corporations in an industry with which you are familiar - one 1 that has acquired another company

  How did mr mandoff keep his new investments at such a high

how did mr. mandoff keep his new investments at such a high rate of return and keep paying off investors and giving to

  6. what are some of your strengths and weaknesses as finance

Normal 0 false false false EN-US X-NONE X-NONE What are some of your strengt..

  The maintenance departments costs are allocated to other

the maintenance departments costs are allocated to other departments based on the number of hours of maintenance use by

  Greene company uses a plantwide overhead rate with

greene company uses a plantwide overhead rate with direct-labor hours as the allocation base. use the following

  Sondgeroth inc reports the following pretax income loss for

nol carryback and carryforward valuation account versus no valuation accountsondgeroth inc. reports the following

  What are the accounting procedures to write down the

what are the accounting procedures to write down the inventory that is due to obsolescence? under this condition what

  In a recent newspaper release the president of keene

in a recent newspaper release the president of keene company asserted that something has to be done about depreciation.

  The responsibility of the cio

Do we really need a major change in the way the IS function is structured...are the necessary changes just minor modifications to accommodate normal growth in computer uses...what are your thoughts / research in this regard?

  As you examined this week netflix and its competitors have

as you examined this week netflix and its competitors have faced interesting decisions regarding product offerings and

  Copper hill inc manufactures laser printers within a

copper hill inc. manufactures laser printers within a relevant range of production of 50000 to 70000 printers per year.

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