Question: Please use the excel to solve it! Thank you so much!!!! B C D E F G Barbara' s gift shop places orders for Christmas

Please use the excel to solve it! Thank you so much!!!!

B C D E F G Barbara' s gift shop places orders for Christmas items during a trade show in July. One item to be ordered is a dated sterling silver tree ornament. The ornament will sell for $80. The best estimate for demand is shown in table below. The ornaments cost $55 when ordered in July. Ornaments unsold by Christmas are marked down to half price and always sell during January. How many ornaments should be ordered? In cell A9:A13, Copy and Paste Special as values to remove the formula underneath. Demand Probability 6 0. 2 12 0. 25 1 13 0. 3 12 18 0. 2 13 20 0. 05 14 15 Items Ordered ? 16

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 Mathematics Questions!

Winners Circle, Inc. manufactures medals for winners of athletic events and other contests. Its manufacturing plant has the capacity to produce 10,000 medals each month. Current monthly production is...

I'm an undergrad accounting student in an introduction to forensic accounting course.I need help getting started on a final project for this class over a fictitious company called the Grand Teton...

Tax Return problem? TAX RETURN PROBLEM 2 November 20, 2012 (60 points) Due December 10, 2012 Corinne Penrose (453-44-5321) and Norman Penrose (444-32-5890) live at 5755 Hastings Road, Santa Barbara,...

This is a project for a tax class. The facts tab contains the 20 problems that need to be entered into the other tabs. Is this something you could help me with? I will tip nicely for good work. Elf...

Tallahassee bean counters case solution and all the 5 questions beginning of the case. Also describe about equipment purchased fraud and how it was committed? NOTICE Do not make Teaching Notes...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

I need the answers or instructions on how to get the answers for all of problem three and the unfinished part of problem 4. This class is financial modeling, must use the formulas by tagging them to...

I am doing tax return project. attachments are the materials professor provide. He wants me to do a current year engagement file (Similar with prior year engagement file). AC 371 Tax Return Project...

please answer all parts thank you! Question 1(2+2+2+2+2=10 points ) - Discrete demand for newsvendor model Holiday Gift shop places orders for Christmas items during a trade show in July. One item to...

Hello tutor, kindly assist by answering the two questions below. Thank you Question 1 Holiday Gift shop places orders for Christmas items during a trade show in July. One item to be ordered is a...

Review an Annual Report to gain a general understanding of the types of financial information contained in the report and why that information might be useful to a potential reader. You will also be...

Rapid Industries has multiple divisions. One division, Iron Products, makes a component that another division, Austin, is currently purchasing on the open market. Iron Products currently has a...

What is the difference between an account receivable and a note receivable?

Question 4 \ ( 0 / 3 \ ) pts Shannon computed that she needs to put aside \ ( \ $ 1 6 5 , 4 6 3 \ ) today to fund her children's college education which begins in 6 years. She does not have that much...

A 5-year Treasury bond has a 4.7% yield. A 10-year Treasury bond yields 6.7%, and a 10-year corporate bond yields 9.7%. The market expects that inflation will average 2.7% over the next 10 years (IP...