Show how the expected profits and order quantities for range

Assignment Help Operation Management
Reference no: EM132280924

Discussion :

You have been hired by a vendor who is preparing for an upcoming K-Pop (Korean pop music) concert featuring the singer IU (Lee Ji-eun) in Cincinnati.

The concert organizer is allowing vendors to sell IU paraphernalia. You determine that certain one-size-fits-all winter hats featuring IU's image will be sold. You have four choices for OEM suppliers of the hats.

Due to their locations, their lead times differ, along with your costs. Based on past concerts, the product sales forecast is for 3000 hats, but this estimate is uncertain depending on the concert attendance. Each hat will sell for $32.

Once the concert ends, products not sold will be bought by a discounter at a heavily reduced price of $2.40 per hat. Sales forecasts will be more accurate as the concert approaches (forecast CV's are available based on past forecasting performance). Production quality varies according to location, which is expressed as an expected production yield.

Production costs are adjusted to account for these yields (and shown below as net product cost). Because the products all require careful handling, there will be an inventory holding cost that will apply as soon as the order is placed. However, the annual holding percentage is unknown at this time. The table below summarizes the important information regarding the locations under consideration.

Create a spreadsheet that determines, for each manufacturing location, the expected profits and how many units the vendor should order from each manufacturer.

Assume that demand variation is normally distributed. Vary the annual holding cost percentage and show how the expected profits and order quantities for a range of holding rates from 10% to 40%.

Show these results in tabular and graphical form. Clearly organize and label the spreadsheet to show inputs and results (i.e., a user may wish to modify inputs later as more information becomes available). The assessment of this work will be based on the accuracy and clarity of your spreadsheet.

Reference no: EM132280924

Future value of an ordinary? annuity

?(Future value of an ordinary? annuity) The future value of 480 per year for 9 years compounded annually at 10 percent is. (Annuity payments) Mr. Bill S.? Preston, Esq., purch

Statements about packaging and channel systems

Which of the following statements about packaging is TRUE? Which of the following statements about channel systems is TRUE? Words, symbols, or logos that are legally registere

Advertising media-considered for promotion of a product

Two advertising media are being considered for promotion of a product. Radio ads cost $400 each, while newspaper ads cost $600 each. The total budget is $9,200 per week. The t

What is corporate level strategy and why is it important

What is corporate level strategy, and why is it important? What are the different levels of diversification firms can pursue by using different corporate level strategies?

Performing under the doctrine of commercial impracticability

Steel Industries, Inc., ordered steel from Interlink Metals & Chemicals. The steel was to be delivered from a Russian mill. There were political and other issues in Russia, an

Modify the transportation model to include new parameters

Explain what other factors you would consider to create a more realistic mathematical model. In your answer, discuss whether you would use a different mathematical modelling

Solve the problem to maximize profit

Formulate and solve the following problem to maximize profit: Our company sells two types of novelty items to local bookstores. Type 1 generates $3 profit for each unit sold a

Opportunity identification and opportunity exploitation

Describe the differences between opportunity identification and opportunity exploitation. Describe the main components of social entrepreneurship, and describe how social entr


Write a Review

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