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

  During the current period department a finished and

during the current period department a finished and transferred 50000 units to department b. of the 50000 units 20000

  Veras personal vehicle adjusted basis of 22000 is stolen

1. kareem bought a rental house in march 2008 for 300000 of which 50000 is allocated to land and 250000 to the

  Morgan company is considering a capital investment of

morgan company is considering a capital investment of 180000 in additional productive facilities. the new machinery is

  Bonds payable has a balance of 1000000 and premium on bonds

1. a legal document that indicates the name of the issuer the face value of the bond and such other data is called a

  Record as the cost of goods

Jag Co. purchased goods with a list price of $150,000, subject to trade discounts of 20% and 10% with no cash discounts allowable. How much should Jag Co. record as the cost of these goods?

  The company uses the fifo cost flow assumption.

The company uses the FIFO cost flow assumption .

  Prepare a product margin report for one job that involves

prepare a product margin report for one job that involves painting 400 square meters and has direct materials cost of

  On 1 july anderson ltd require 70 of equity capital of

on 1 july anderson ltd require 70 of equity capital of arthur a cost of 4 millions at the date of acquisition all

  Forest outfitters is a retailer that is preparing its

forest outfitters is a retailer that is preparing its budget for the upcoming fiscal year. management has prepared the

  The wall street journal routinely publishes summaries of

the wall street journal routinely publishes summaries of corporate quarterly and annual earnings reports in a feature

  Go the hershey website to learn how to make hershey

go the hershey website to learn how to make hershey chocolate. review the process and take a look at some of the

  Type of mobility did this event illustrate

During the Great Depression thousands of people changed social class unexpectedly and usually in a downward spiral. What type of mobility did this event illustrate?

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