4.5 Chapter Problems

User Generated

1993_

Mathematics

Description

You need to show all the work/steps, partial credit will be provided. Submitting just the answers (even if they are correct) does not provide for any partial credit.

please answer the attached question based on our book.

Quantitative Analysis for Management (12th Edition)

Render, Barry

Unformatted Attachment Preview

Activity 4.5 – Module Problems Complete the following problems and submit the results in either a Microsoft Word document or a Microsoft Excel spreadsheet. If you choose to use an Excel spreadsheet, place each problem on a separate sheet and label the tab with problem number. Save your document with a descriptive file name, including the assignment and your name. 4-1 Ross White’s machine shop uses 2,500 brackets during the course of a year, and this usage is relatively constant throughout the year. These brackets are purchased from a supplier 100 miles away for $19 each, and the lead time is 4 days. The holding cost per bracket per year is 10% of the unit cost and the ordering cost per order is $25. There are 250 working days per year. a. b. c. d. e. f. g. h. What is the EOQ? Given the EOQ, what is the average inventory? What is the annual inventory holding cost? In minimizing cost, how many orders would be made each year? What would be the annual ordering cost? Given the EOQ, what is the total annual inventory cost (including purchase cost)? What is the time between orders? What is the ROP? 4-2 Douglas Boats is a supplier of boating equipment for the states of Oregon and Washington. It sells 5,000 White Marine WM-4 diesel engines every year. These engines are shipped to Douglas in a shipping container of 100 cubic feet, and Douglas Boats keeps the warehouse full of these WM-4 motors. The warehouse can hold 5,000 cubic feet of boating supplies. Douglas estimates that the ordering cost is $50 per order, and the carrying cost is estimated to be $50 per motor per year. Douglas Boats is considering the possibility of expanding the warehouse for the WM-4 motors. a. How much should Douglas Boats expand. b. How much would it be worth for the company to make the expansion? Assume demand is constant throughout the year. 4-3 Ralph Janaro simply does not have time to analyze all the items in his company’s inventory. As a young manager, he has more important things to do. The following is a table of six items in inventory along with the unit cost and the demand in units. IDENTIFICATION UNIT COST DEMAND CODE ($) IN UNITS XX1 5.84 1,200 B66 5.40 1,110 3CPO 1.12 896 33CP 74.54 988 R2D2 4.80 1,257 RMS 2.08 961 Page 1 of 2 20180201173046m4_problems a. Find the total amount spent on each item during the year. What is the total investment for all these? b. Find the percentage of the total investment in inventory that is spent on each item. c. Based on the percentages in part (b), which item(s) would be classified in categories A, B, and C using ABC analysis? d. Which item(s) should Ralph most carefully control using quantitative techniques? e. How low would the demand for 33CP have to before it change to a different category? 4-4 The marginal loss on Washington Reds, a brand of apples from the state of Washington, is $40 per case. The marginal profit is $15 per case. During the past year, the mean sales of Washington Reds in cases was 41,000 cases, and the standard deviation was 4,480. How many cases of Washington Reds should be brought to market? Assume that sales follow a normal distribution. 4-5 Paula Shoemaker produces a weekly stock market report for an exclusive readership. She normally sells 3,000 reports per week, and 70% of the time her sales range from 2,850 to 3,150. The report costs Paula $25 to produce, but Paula is able to sell reports for $350 each. Of course, any reports not sold by the end of the week have no value. How many reports should Paula produce each week? 4-6 The Webster Manufacturing Company produces a popular type of serving cart. This product, the SL72, is made from the following parts: 1 unit of Part A, 1 unit of Part B, and 1 unit of Subassembly C. Each subassembly C is made up of 2 units of Part D, 4 units of Part E, and 3 units of Part F. Develop a material structure tree for this. The lead time for each of the parts in the SL72 is one week, except for Part B and Part E, which have a lead time of two weeks. a. Develop a net materials requirements plan for an order of 800 SL72s. Assume that currently there are no parts in inventory. b. Develop a net material requirements plan assuming that there are currently 150 units of Part A, 60 units of Part B, 40 units of Subassembly C, and 100 units of Part F currently in inventory. You may submit just the answers or you may submit the answers and the QM worksheets you used to arrive at the answer. Choosing the latter will afford instructors the opportunity to review your work and determine if you understand the concept but have made some minor computational error, therefore allowing them to assign some credit based on your understanding. Submitting just the answers does not provide for any partial credit. Page 2 of 2 20180201173046m4_problems
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

check attached

Activity 4.5 – Module Problems

Complete the following problems and submit the results in either a Microsoft
Word document or a Microsoft Excel spreadsheet. If you choose to use an
Excel spreadsheet, place each problem on a separate sheet and label the tab
with problem number. Save your document with a descriptive file name,
including the assignment and your name.
4-1
Ross White’s machine shop uses 2,500 brackets during the course of a year, and
this usage is relatively constant throughout the year. These brackets are purchased from a
supplier 100 miles away for $19 each, and the lead time is 4 days. The holding cost per
bracket per year is 10% of the unit cost and the ordering cost per order is $25. There are
250 working days per year.
Annual demand = 2,500
Holding cost per order = $1.90
Order cost per order = $25
Lead time = 4 days
Working days per year = 250
a. What is the EOQ?
Solution
EOQ = SQRT(2 × Quantity × Cost Per Order / Carrying Cost Per Order)
Quantity = 2,500
Cost per order = $25
Carrying/holding cost per order = 0.1 x 19 = $1.90
EOQ = Sqrt (2 x 2500 x 25/1.9)
= sqrt (65,789.47) = 256.49
= 257 units
b. Given the EOQ, what is the average inventory?
Average inventory = EOQ/2
= 257/2 = 128.5
= 129 units
c. What is the annual inventory holding cost?
Annual inventory holding cost = average inventory x holding cost
= 129 x 1.90
= $245.10
d. In minimizing cost, how many orders would be made each year?
Number of orders = demand/ working days in a year
= 2,500 / 250
= 10
e. What would be the annual ordering cost?
Annual ordering cost = orders X Cost per order
= 10 x 25
= $25...


Anonymous
Great study resource, helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags