Calculate the salvage revenues

Assignment Help Business Management
Reference no: EM133034844

Question 1: Consider the partial solution to Pierre Simulation that we covered in the class in the worksheet Q1. Please note the prices are different in this spreadsheet from our original example but the structure of the problem is the same.  If any loaves of bread are left over at the end of the day, the charitable kitchen will now only take up to 20 loaves at a salvage price of $1.25.  That is, Pierre can only sell up to a maximum of 20 loaves to the charitable kitchen.  If he has more than 20 loaves left over, any loaves over 20 will have to be thrown away. How would now calculate the salvage revenues in Cell F14 in the worksheet Q1? Please enter your equation directly into Cell F14.

Question 2: Consider the following probability distribution for weekly demand for a particular product that you are going to use within a simulation.  Set up the VLOOKUP table that will generate demand from this distribution.  Answer this question in the sheet labeled Q1.  Also, show the statement you will use in the simulation (in Cell A20) to generate random demand for Week 1 from this distribution. 

Demand

Probability

20

0.035

25

0.145

30

0.225

35

0.275

40

0.155

45

0.105

50

0.060

 

 

Reference no: EM133034844

Questions Cloud

Prepare general journal entries to record the transactions : Prepare general journal entries to record the above transactions and the depreciation journal entries required at January 2018, 30 June 2018
Organic farming and the food industry in swaziland : There is an increasing demand in Swaziland for Organic food. This needs to be produced using environmentally friendly farming methods; no genetically modified (
What is a scatter chart : What is a scatter chart? Where can it be used? Why is it important? Explain with an example.
What is the price and duration : What is the price (p) and duration (d) of a 6 percent coupon bond maturing in 20 years and paying interest annually if the current interest rate is 9 percent
Calculate the salvage revenues : Question 1: Consider the partial solution to Pierre Simulation that we covered in the class in the worksheet Q1. Please note the prices are different in this sp
Create a security design and security policies : Create a security design and security policies - create a security design to protect the network for your chosen organisation.
Estimate the ending balance : An investor wants to invest $300,000 in a portfolio of three mutual funds. The annual fund returns are normally distributed with a mean of 2.00% and standard de
Outline the terms auditing and penetration testing : Outline the terms auditing and penetration testing that can be used to measure a network's security - List a type of hardware that can be used for security
Business proposal-making online reviewer services : Answer the following question. ELABORATE & EXPLAIN each question in a long paragraph. Answer this just like you are one of the customers of this kind of service

Reviews

Write a Review

Business Management Questions & Answers

  Shares on foreign equity markets

How do you explain why firms often list their shares on foreign equity markets? Which equity markets are the primary hosts to foreign listing?

  Examples of inside money are debit cards

Examples of inside money are debit cards, credit cards, checking accounts, and traveler's checks. Today, these examples are used in our daily transaction.

  Legal environment affects the marketing mix of companies

The cultural, economic , political and legal environment affects the Marketing mix of companies trying to enter a new market

  How does organizational culture affect individual

How does organizational culture affect individual and overall performance?

  Competing values framework

Why would a manager be stronger in one quadrant of the competing values framework yet weaker in another? how does this strength and weakness compliment

  Statement benefit both management and the company

How will the following statement benefit both management and the company?

  Profit maximizing price and quantity of resources

Explain how the profit maximizing price and quantity of resources in factor markets under perfect competition are determined by marginal analysis.

  Lean manufacturing is philosophy of production

Lean manufacturing is a philosophy of production that focuses on the minimization of resources used throughout the organization

  How do organizations encourage political activity

Did the group progress linearly from one step to another or did it experience periods of little progress punctuated by bursts of energy, as Gersick describes? Justify your response.

  Calculate a forecast for october

a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.)Forecast for October b. Using single exponential smoothing with α = 0.10 and a September forecast = 56, calculate a forecast..

  Aircraft logistics sustainability strategy

Discuss the role and benefits of financial planning in an aircraft logistics sustainability strategy.

  Economic market models

Disney World has doubled their ticket prices at their amusement parks over the last 10 years, which of the economic market models we covered explains this behavior?  Be sure to take into account that competitor parks are nearby.  Be sure to detail..

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