Question: Please USE EXCEL and write our formula and functions. ..F.10 DAY PAPERS RANDOM DEMAND REVENUE COST GOODWILL COST NET PROFIT ORDERED NUMBER Leonard Presby's newsstand

Please USE EXCEL and write our formula and functions.

..F.10 DAY PAPERS RANDOM DEMAND REVENUE COST GOODWILL COST NET PROFIT ORDERED NUMBER Leonard Presby's newsstand uses naive forecasting to order tomorrow's papers. The number of newspapers ordered corresponds to the previous day's demands. Today's demand for papers was 22. Presby buys the newspapers for $.20 and sells them for $.50. Whenever there is unsatisfied demand, Presby estimates the lost goodwill cost at $.10. Complete the accompanying table, and answer the questions that follow. 1 22 37 2 19 3 52 4 8 DEMAND PROBABILITY 5 22 21 .25 6 61 22 .15 23 .10 24 .20 a. What is the demand on day 3? b. What is the total net profit at the end of the 6 days? c. What is the lost goodwill on day 6? d. What is the net profit on day 2? e. How many papers has Presby ordered for day 5? P 25 .30

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Leonard Presby's newsstand uses naive forecasting to order tomorrow's papers The number of newspapers ordered corresponds to the previous day's demands Today's demand for papers was 26 Presby buys...

Leonard Presbys newsstand uses naive forecasting to order tomorrows papers. The number of newspapers ordered corresponds to the previous days demands. Todays demand for papers was 22. Presby buys the...

Leonard Presby's newsstand uses naive forecasting to order tomorrow's papers. The number of newspapers ordered corresponds to the previous day's demands. Today's demand for papers was 27 Presby buys...

Leonard Presby's newsstand uses naive forecasting to order tomorrow's papers. The number of newspapers ordered corre- sponds to the previous day's demands. Today's demand for papers was 22. Presby...

Q1-Explain how the EBIT Chart works (inputs determining the outputs-the two lines on the chart Case Leahy Bread Company (LBC) in Cohen Finance Workbook, page 111( a 'caselette') SEE THE IS/BS MODEL &...

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

answer the all question please equired Homework Questions The concept of earnings power is the long-term (3 to 5 year) expectation of the company's earnings after any near-term anomalous behavior has...

Give two examples of discrete random variables that would be of interest to the manager of a clothing store.

Helium gas expands from 125 kPa, 350 K and 0.25 m3 to 100 kPa in a polytropic process with n = 1.667. How much work does it give out?

A saximponed on exports A tas inpoved on inporti. A ux ingoond en beth eaporti and ingeots. Ave non - tax action uned to makt trade. Which of the following has a demmed for curos in the forchen...

Melfus Lumber Co . and Onley, a consumer, enter into a contract for a sale of plywood. If the contract includes a clause that is perceived as grossly unfair to Onley, its enforcement may be...

In what ways is fake news fake and in what ways is it real? This activity provides an opportunity to consider which information and evidence is trustworthy. What criteria should be applied to judge...

How might Jagriti involve potential beneficiaries in her research project?

What features of your research benefited from your involvement with other stakeholders? What have you learned that you might not otherwise have been able to learn?