Pls solve using excel 5. As a part of their new alumni fundraising campaign, Drexel had a local artist design a craved-wooddragon statue which will be sent to all alumni who donate during the campaign. The fixed cost for thedesign and production setup is $100,000, and it costs an additional $34 per statue in material, labor,and shipping costs. The current alumni campaign asks each alum to donate $50, but after accountingfor processing costs, each donation actually brings in $42. Given the success levels of pastfundraising campaigns, Drexel is forecasting that the number of alumni who donate will be normallydistributed, with a mean of 60,000 and a standard deviation of 15,000. Once the fundraising campaignis over, any statues left will be sold through the bookstore at $10 per statue.Using 100 trials, decide whether Drexel should produce 50000, 60000, or 70000 statues. What is theprobability of a stockout during the alumni fundraising campaign?

Answered: 5. As a part of their new alumni…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

I need correct and non plagiarised answer. I will rate accordingly. What is the difference between Quantity Production and Flow Line Production?
Corral Cartage leases trucks to service its shipping contracts. Larger trucks have cheaper operating costs if there is sufficient business, but are more expensive if they are not full. CC has estimates of monthly shipping demand. What comparison method(s) would be appropriate for choosing which trucks to lease? 1.Present Worth(PW) 2.Annual Worth(AW) 3.Payback Period
Please complete the sup part: e,f and g. 1.B&H needs to decide how to manage its inventory of cameras. The demand for cameras at B&H is 200 cameras per week. Each time that B&H places an order for a new shipment of cameras, it must pay $80 in fixed processing fees. A camera costs B&H $60 to purchase. The cost for B&H to hold a camera in its store for one week is $4. Assume that the lead time for the delivery of a camera is 0 weeks.a. Suppose that B&H places orders for cameras in quantities of 50 cameras at a time and places a new order for cameras each time that it runs out. Draw a graph showing the number of cameras that B&H has on-hand in inventory at each point in time up until the time when it places its fourth-order. Label the points in time at which B&H places a new order. Assume that B&H places its first order for 50 cameras on day 0.b. Suppose again that B&H places orders for 50 cameras at a time. What will be B&H’s average holding…
As a new account assistant, Miss Fizah has been assigned to calculate the amount that should appear on Terrar Bhd’s financial statement for inventory under the lower-of-cost-or-NRV (LCRNV) rule as applied to each item in inventory. The company applies the loss method and uses an Allowance Account to record for the write down of the inventory to net realisable value (NRV). However, Madam Rabiatul, Terrar Bhd’s accountant had an argument with Mr. Zaman, senior accountant of the company regarding the method to be used to record the write down of the inventories. Madam Rabiatul wants to use the loss method to write down inventory because it is more clearly discloses the decline in the net realisable value and does not distort the cost of goods sold. But, Mr. Zaman prefers the cost-of-goods-sold method to write down because it does not call attention to the decline in net realizable value. With regards to the argument between Madam Rabiatul and Mr. Zaman: (a) What is the issue facing Madam…
In your own words, describe how you will use STAR reports to make decisions about room pricing and revenue management.
An investment proposal will have annual fixed costs of $60,000, varial costs of $35 per unit of output, and revenue of $55 per unit of output. i) Determine the break-even quantity. ii) What volume of output will be necessary for an annual profit of $60,000
Dr. Good wants to help his patients be healthy. In the past, he has allowed them to comeinto the office for free healthcare screenings and tests. He now has the opportunity toprovide free full-body CT scans and full gene mapping. The CT scan would normally costabout $4,000 and the gene mapping about $10,000. He is not certain whether he shouldoffer these new services. Most of the preventive tests and immunizations that headministered in the past were inexpensive but produced significant benefits. He thinks manyof his patients would take advantage of the new tests, but is it the right thing to do?Discussion Questions Would you recommend that Dr. Good offer the new tests? Why or why not?
Dr. Good wants to help his patients be healthy. In the past, he has allowed them to comeinto the office for free healthcare screenings and tests. He now has the opportunity toprovide free full-body CT scans and full gene mapping. The CT scan would normally costabout $4,000 and the gene mapping about $10,000. He is not certain whether he shouldoffer these new services. Most of the preventive tests and immunizations that headministered in the past were inexpensive but produced significant benefits. He thinks manyof his patients would take advantage of the new tests, but is it the right thing to do?Discussion Questions 1. How is this an example of diminishing returns in healthcare?
As a logistics specialist, you are responsible for meeting customer demand. One of your customers places orders for you to supply four products by the end of October. You have limited capacity for raw material and other facilities. You are required to satisfy customer demand by manufacturing the products and/or buying from a supplier. After consulting with the production department, you obtained the following information. Product A Product B Product C Product D Order quantity 2000 3500 1500 2500 Hours required on machine X per unit 2 4 5 3 Hours required on machine Y per unit 4 3 6 2 Raw material in kilos 5 1 4 6 Time needed for Packaging per unit 36 minutes 30 minutes 45 minutes 24 minutes Available monthly hours per month: 8,000 on machine X, 6000 on machine Y, and 3,000 hours for packaging. Purchased items from your supplier are already packaged. Available raw material per month: 5,000 kilos…
Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
What is the initial BF solution?
4) The cost driver for demand creation activity is: a. Increase in sales b. Number of orders c. Value of stock d. Value of materials stored

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS