What is your recommendation for each type of book

Assignment Help Operation Management
Reference no: EM131385962

Calculate the EOQ and reorder point for each of the book types. Lead time for any type of book is 5 weeks.

Assume the demand data given in the spreadsheet is normally distributed. The accounting department estimates the average costs for A, B, and C books to be $5.05, $7.39, and $10.25, respectively, for a single copy. It costs 45% per year, per unit, for annual holding costs. The batch size is 3,500 for an A book, 1,000 for a B book, and 500 for a C book. The administrative cost for ordering a batch of a book has been estimated to be $125.

What is your recommendation for each type of book? Why?

How much safety stock should be held, by type of book? What is the total cost of your recommendation?

What are the advantages and disadvantages of each option?

Use a standard "300 days per year" when doing the calculations if and when "days per year" is necessary.

Verified Expert

This paper talks about the cost effectiveness in a book business. current discussion will highlight on the demand analysis of three books types, A, B and C. each of them is having different cost price and is also having different batch sizes demand. EOQ and recorder points are needed to be calculated and recommendations are made. Ecxel file is also included in this work. The work includes APA style of referencing and incited references and is written in Microsoft word.

Reference no: EM131385962

Questions Cloud

Draw up a statement of profit or loss : Draw up a statement of profit or loss for the year ending 31 December 2015, and a statement of financial position as at that date. Show all of your workings.
Write a matlab code to generate the fibonacci sequence : EE 412- Write a Matlab code to generate the Fibonacci sequence to generate the first 20 terms. Plot the golden ratio for the sequence and notice how the ratio approaches a constant.
Management plan addresses four different management function : A Strategic Management Plan addresses four different management functions: Environmental Scanning, Strategy Formulation, Strategy Implementation, Evaluation and Control.
Monopoly market-most benefit from the surplus : In a monopoly market if the people want to get the most benefit from the surplus that has been created by the market, what government can do to protect the benefit of the people?
What is your recommendation for each type of book : Calculate the EOQ and reorder point for each of the book types. Lead time for any type of book is 5 weeks. What is your recommendation for each type of book? Why
Which device will give the best ear protection in practice : A set of earmuffs has an NRR of 30 dBA, and a set of plugs has an NRR of 20dBA. Workers in a car factory are exposed to 110 dBA for 8hrs. Workers wearing the muffs take them off for half an hour each day while working due to discomfort whereas plug w..
Does this circuit have forbidden inputs : Build a feedback circuit with cross-coupled NAND gates. What input conditions cause the state of this latch-like device to be reset? To be set? Does this circuit have forbidden inputs? If so, what are they?
Recommend an emphasis on inflation or unemployment : As you now know, the Phillips Curve shows the tradeoff between unemployment and inflation. If you were Chairman Yellen, in today’s current economic state, would you recommend an emphasis on inflation or unemployment?
Explore the ethical issues that rick and rick family : Rick Stone is a 48-year-old male who is diagnosed with rapidly advancing Lou Gehrig's (ALS) disease. Explore the ethical issues that Rick and Rick's family may face in the future. As a healthcare provider, how might you advise Rick and his famil..

Reviews

inf1385962

2/13/2017 6:10:57 AM

Thanks to bear me, i know i asked so many silly questions but i am really new to this subject, so sorry for that. But hats off to your support. you are really good. thanks again.

inf1385962

2/13/2017 6:09:57 AM

Please confirm expert understands needs of answering every question thoughtfully for every book and providing solution data chart form with formula in each cell as originally requested for each book. Can you please help me to get this resolved please looking for an update. Thank you please keep me updated. Please ask expert where they got the total cost recommendation what cell. What is the total cost of your recommendation? Total cost for each book comes around, $2548.02. For Book A, the total cost comes around $1883.65, its $ 428.62 for book B and for Book C it is $235.75

inf1385962

2/13/2017 6:08:21 AM

Please have QUALITY expert address this solution Please do. Payment sent. Please see attached document. sample 20965952_1Expert.docx 20965952_2sample.xlsx Did you receive below? Sir I still have concerns regarding solution please see attachment in red regarding concerns. 20965996_1Questons -.docx Please have expert forget about the graphs. All I want is tables in excel organizing numerical answers for each book and the questions answered for each book. Please thanks What is your recommendation for each type of book? Why? How much safety stock should be held, by type of book? What is the total cost of your recommendation? What are the advantages and disadvantages of each option

len1385962

2/8/2017 1:38:45 AM

Please solve in excel, please show all formulas in cells. Need (Color) line graphs chart showing variable relationships. Please answer questions in thoughtful original answer. Provide references “Links”. Please pay close attention to the Lead-time.

Write a Review

Operation Management Questions & Answers

  What would the october forecast be if a two-period

What would the october forecast be if a two-period moving avaerage were used june-612

  Who should constitute members of the team-key stakeholders

Who should constitute members of the team, key stakeholders, and sponsors of a clinical project in a physician’s office? and In a hospital? support your choices.

  Identify an advertisement on TV that targets business market

Identify an advertisement on TV that targets the business market? Does this ad differ from the typical consumer ad? Explain and give reasons why you feel a difference exists/does not exist. What product benefit(s) is the company trying to sell? Is th..

  What component of the project plan will help you determine

What component of the project plan will help you determine how to manage this request for new requirements? Explain how this component is used to manage project changes.

  Podcasting has an ad-skipping problem

The 15-second skip button allows listeners to avoid commercials to skip ahead by increments of 15 seconds on its podcast application. Other podcastapps, such as Spotify AB and Stitcher, also feature a skip button. Why do you think podcasts are becomi..

  Calculate the production and productivity

A local market research firm has just won a contract for several thousand small projects involving data gathering and statistical analysis. In the past, the firm has assigned each project to a single member of its highly-trained professional staff.

  Before-tax operating costs-what will the cash flows

You have been asked by the president of your company to evaluate the proposed acquisition of a new special-purpose truck for $70,000. The truck falls into the MACRS 3-year class, and it will be sold after three years for $19,900. The truck will have ..

  Please cite industry examples for at least two of the six

please cite industry examples for at least two of the six supply chain strategies introduced in class and a brief

  Are there any product quality dimensions related to decision

What social costs are incurred when a company moves domestically or overseas?What role do local and national government incentives, laws, and regulations play in a decision like this one?Are there any product quality dimensions related to this decisi..

  Compute optimal order quantity and average inventory

A grocery store needs to sell 3,000 cartons of 2L 2% milk per month. The sales is relatively constant throughout the month. The owner of this grocery store purchases milk from a supplier 50 miles away for $2 per carton, and it takes a day to restock.

  Understanding of how to make important decisions

Your boss, the chief executive officer (CEO), realizes that you do not have much practice in this higher level, decision-making process and has asked you to write a memo describing your understanding of how to make important decisions.

  Why is cultural intelligence essential on the modern day

Why is cultural intelligence essential on the modern day world of management? Hint: Hall’s or Hofstede’s cultural dimensions of context, time, and interpersonal space, power distance, individualism-collectivism, masculinity/femininity, and time orien..

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