Question

In: Operations Management

The answers were given for this problem, but I am not sure how to derive them....

The answers were given for this problem, but I am not sure how to derive them. Would need any kind of help

Suppose that you sell Christmas trees each holiday season for $30 a tree. Peak selling time is the 2 weeks leading up to Christmas, but since harvesting real pine trees takes time, your supplier requires a 1 month lead time.

Your purchase cost per tree is $20. Anytime a customer comes to your store requesting a tree and it is unavailable, you give them a $5 credit (per tree) to spend on other products. (You should assume they always use this credit.) Any trees not sold before Christmas are sold to a local lumber yard at $10/tree.

Demand for this Christmas is forecasted in the following table.

Demand Probability
600 0.2
700 0.3
800 0.3
900 0.2

a) (3 points) To the nearest tree, what is the expected demand for this Christmas? (Remember, as with all questions, you should show work for full credit.) 750 trees

b) (3 points) Suppose you order exactly 800 trees, how many trees would you expect to sell? (Remember, as with all questions, you should show work for full credit.) 730 trees

c) (3 points) Suppose you order exactly 800 trees while the actual demand turns out to be 700 trees, what is your expected profit (including goodwill costs if there are any)? $6000

d) (3 points) What is the underage cost? What is the overage cost? Just by comparing the two costs, should we order more or less than the average demand? Briefly explain.

Underage: $15

Overage: $10

We should order more than average, but why? I don't understand the explanation

e) (3 points) What is the optimal order quantity given the demand in part a)? As with all questions, please show work for full credit. 800 trees

f) (1 point) What is the effective service level for the quantity you suggested in part e)? 80%

Solutions

Expert Solution

a) We get the expected number of trees by multiplying demands and the probability a ssociated with them.

b) Suppose we order 800 trees, the probability and number of trees sold are as following,

(Please note that we have only 800 trees. So even if the demand is 900, we will only be able to sell 800 trees)

c)

Number of trees bought = 800

Cost of buying trees = 800*20 = $16,000

Number of trees sold = 700

Revenue from sales = 700* 30 = 21,000

Number of trees sent to lumber yard= 100

Revenue from lumber yard = 100*10 = $1,000

Therefore, total revenue = 21,000+1,000 = $22,000

Expected profit = 22,000 - 16,000 = $6,000

d)

Underage cost is the cost incurred when the material is out of stock. Here, we have to forego a profit of $10 and a $5 credit when the trees are stock out. Hence, underage cost =10+5 = $15

Overage cost the loss we incurr if there is excess quantity available. We spend $20 for a tree and we get $10 when we give the excess trees to the lumber yard. Hence, Overage cost = 20-10 =$10.

Here, average demand is 750.

To calculate the optimal demand, we use the formula,

Criticle Fractile = Underage cost/(Underage cost + overage cost) = 15/25 = 60%.

Whenever the uderage cost is more than overage cost, we will need to order more than average.

e)

Criticle Fractile = Underage cost/(Underage cost + overage cost) = 15/25 = 60% (0.6).

We shoud order trees such that the quantity is atleast above the criticle fractile. And we always round up. Here, if we go for 600, only 0.2 is covered. With 700, we cover 0.5 and with 800 we cover 0.8.

Hence, the order quantity should be 800.

f) When we order 800, there is 80% chance that everyones requirement is met. Hence the service level is 80%


Related Solutions

I am stuck on this problem and I am not sure what the solution is. In...
I am stuck on this problem and I am not sure what the solution is. In C Write item.h and item.c. In item.h, typedef a struct (of type t_item) which contains the following information: t_item: char name[MAX_ITEM_NAME_STRING]; char description[MAX_ITEM_DESCRIPTION_STRING]; Make sure that MAX_ITEM_NAME_STRING and MAX_ITEM_DESCRIPTION_STRING are defined with suitable sizes in your item.h. Typical values are, 25 and 80, respectively. Add the following interface definition to item.h: int item_load_items(t_item items[], int max_items, char *filename); Returns the number of objects loaded...
I am working on this problem for the company AT & T and am not sure...
I am working on this problem for the company AT & T and am not sure how to start it. Draw a chart of the main inter-organizational linkage mechanisms (e.g., long -term contacts, strategic alliances, mergers) that your organization uses to manage its symbiotic resource interdependencies. Using resource dependence theory and transaction cost theory, discuss why the organization to manage its interdependencies in this way. Do you think the organization has selected the most appropriate linkage mechanisms? Why or why...
I am not sure how to construct a swap diagram regarding to information given on the...
I am not sure how to construct a swap diagram regarding to information given on the question, also, not sure how to explain the principal which underpins swap valuation An interest rate swap with notional value of £10m has a remaining life of 9 months. The terms of the swap require the 6-month LIBOR to be exchanged for 6.1% per annum with semi-annual compounding. The current swap rate being exchanged for LIBOR in swaps of all maturities is 5.1% per...
I am not sure if the ones that I did answer were correct and wanted to...
I am not sure if the ones that I did answer were correct and wanted to make sure. Answer the following questions about the anatomy of muscle: Combination of myofilaments lead to formation of ______________________ Myosin is the make-up of the ______thick______________ filament, while actin protein is the make-up of _______thin_____________ filament   Plasma membrane of muscles are known as ______sarcolemma_____________________ Sarcolemma dips down into the cell to produce tube like structures known as _____________________ Connective tissue that wraps around multiple...
These are the correct answers but I am having difficulty figuring out how these figures were...
These are the correct answers but I am having difficulty figuring out how these figures were reached. On March ​1, 2018​, Nailtique Nail Salons issued $450,000 of 15​-year, 5 percent bonds payable. The bonds were sold for $432,000. The bonds pay interest each August 31 and February 28​, and any discount or premium is amortized using​ straight-line amortization. Requirement 1. Fill in the blanks to complete each statement. a. Nailtique Nail Salons' bonds are priced at (express the price as...
I am not even sure what the question is for the problem below, but I have...
I am not even sure what the question is for the problem below, but I have highlighted what I think the question is further down: Let v = (v1, v2) and w = (w1, w2) be vectors in 2 space. The Scalar Product of v and whose notation is v (dot) w, is defined as follows: V (dot) w : = v1*w1 + v2 *w2 The scalar product (aka inner product, or dot product) Scalar product of 2 vectors in...
I have homework on this but I am not sure how to solve it and which...
I have homework on this but I am not sure how to solve it and which formula to use in excel, can u please help me Rebecca is considering buying a 2019 Genesis G70 costing $37,900 and finds that the retaining values of the vehicle over the next four years are as follows: Percent of the total value retained after 24 months: 71% Percent of the total value retained after 48 months: 53% If her interest rate is 5% compounded...
Hi, I am not able to find the correct steps and answers to solve this problem....
Hi, I am not able to find the correct steps and answers to solve this problem. Please help. Thanks! A bank offers your firm a revolving credit arrangement for up to $61 million at an interest rate of 1.48 percent per quarter. The bank also requires you to maintain a compensating balance of 2 percent against the unused portion of the credit line, to be deposited in a noninterest-bearing account. Assume you have a short-term investment account at the bank...
I am not quite sure how to get this program working or how to start it...
I am not quite sure how to get this program working or how to start it in the first place. Write a full Java program and do the following: 1- Create a generic class and declare a one dim array as a private member. 2- Add a constructor to initialize the array. 3- A set method to set the array. 4- Sort method to sort the array. 5- Print method to print the array. 6- Reverse method to reverse the...
I am not sure how to approach this. You are managing a bake sale for a...
I am not sure how to approach this. You are managing a bake sale for a club at your school. It’s being held each weekend in the fall that the football team has a home game. This year, there will be five home games. The club sells cookies in packages of two dozen. The selling price per package is $8.65. The packaging material costs $.11 (11 cents) per package. You pay the regular kitchen staff a direct labor cost for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT