Business, 18.02.2021 21:30, tddreviews
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. 1.) What is your recommendation for each type of book? Why? 2.) How much safety stock should be held, by type of book? 3.) What is the total cost of your recommendation? 4.) What are the advantages and disadvantages of each option?
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 Module 5 EOQ Data. xlsxPreview the document 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.
Week A books B Books C Books
1 525 154 75
2 517 147 151
3 562 134 77
4 455 145 78
5 399.00 108.00 79.00
6 526.00 139.00 80.00
7 584.00 203.00 81.00
8 542.00 154.00 231.00
9 511.00 132.00 82.00
10 602.00 168.00 233.00
11 289.00 177.00 159.00
12 602.00 212.00 84.00
13 355.00 172.00 160.00
14 329.00 154.00 237.00
15 535.00 140.00 87.00
16 571.00 154.00 163.00
17 384.00 147.00 164.00
18 641.00 269.00 90.00
19 382.00 220.00 90.00
20 655.00 253.00 241.00
21 581.00 187.00 92.00
22 435.00 243.00 243.00
23 447.00 232.00 169.00
24 399.00 202.00 95.00
25 367.00 206.00 171.00
26 487.00 273.00 96.00
27 579.00 239.00 172.00
28 545.00 203.00 248.00
29 617.00 219.00 99.00
30 364.00 292.00 249.00
31 582.00 251.00 175.00
32 499.00 289.00 102.00
33 568.00 246.00 102.00
34 486.00 238.00 103.00
35 323.00 286.00 254.00
36 623.00 216.00 180.00
Answers: 2
Business, 21.06.2019 19:50, elijahbebeastin
One investigating company tracked all credit card purchase during 2012 and measured two variables: (1) the type of credit card used (visa, mastercard, american express, or discover), and (2) the amount (in dollars) of each purchase. identify the level of each variable measured.
Answers: 1
Business, 22.06.2019 11:00, PanjiUR9220
What is the correct percentage of texas teachers charged with ethics violations each year?
Answers: 2
Business, 23.06.2019 01:30, Ecneixneixnwism8984
What is a market? a. a system that allows people or companies to buy and sell products and services b. the number of companies willing to manufacture a specific product c. the ability to buy production materials in large quantities and save on costs d. a product's ability to satisfy a consumer
Answers: 2
Business, 23.06.2019 02:00, Trumpman137
In his speech on varying explanations of how the earth came into existence, eduardo begins with opinions, moves to inferences, and uses scientific facts in support of his last point. what principle of supporting material organization is eduardo utilizing in his speech?
Answers: 3
Assume the demand data given in the spreadsheet is normally distributed. The accounting department e...
Mathematics, 01.12.2020 20:50
English, 01.12.2020 20:50
Social Studies, 01.12.2020 20:50
Chemistry, 01.12.2020 20:50