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

Discussion of business ethics

Based upon your readings and our discussion of business ethics, what in your opinion is the most important thing a company can do to ensure employees act in an ethical manner?

Describe each of the four stages of the training cycle

Briefly describe each of the four stages of the training cycle: Assessment, Design, Implementation, and Evaluation. Why is it termed a "cycle"? Apply a brief example (imaginar

Management emphasis on routine for efficiency

The __________ bureaucracy results in a management emphasis on routine for efficiency. The __________ bureaucracy results in a management emphasis on routine for efficiency.

Describe an approach to business diversity program

Describe an approach to a business diversity program that would be pragmatic and ethical. he definition of diversity rests on a valuation of differences across different group

Discuss the social-ethical and political issues

Discuss the social, ethical, and political issues that an information system raises in an organization. How can an organization ensure that these issues are not abused? Please

Develop the most talented resource pool

Coaching and mentoring programs are very useful in building a strong corporate workforce. Executive coaching and mentoring programs are key to succession planning, strategic p

Calculate the annual inventory holding costs based

Calculate the annual inventory holding costs based on the average inventory level and annual holding cost per box. Calculate the annual inventory ordering costs based on the n

Define an x-bar and r chart or an x bar and s chart

So the instructions should read to choose between either an X-Bar and R chart or an X Bar and s chart. The fundamental question that you want to address is how to know when


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