## (Solved) Question 1 (25%) Master Schedule MRP Plan Regular Bicycle

You asked to post this in here. Are you able to do this tonight??

See attachment.?

Question 1 (25%)

Master Schedule

MRP Plan

Regular Bicycle (1)

2 Wheels (1)

Component

Tail Light

Wheels

On Hand

100

50

200

Master Schedule

weeks

Deluxe Bicyle (1)

1

1 Wheels (1)

2 Tail Lights (2)

Scheduled Receipt

100 in week 2, 50 in week 3, 70 in week 7

200 in week 4, 100 in week 5, 50 in week 7

50 in week 1, 60 in week 8

2

3

4

Regular Bicycle (1)

Deluxe Bicyle (1)

5

6

30

7

8

40

9

10

11

500

50

12

13

300

100

100

600

100

200

Offset by LT

Offset by LT

MRP Plan

LT=

Q=

1

2

3

4

5

6

7

8

9

10

11

12

13

1

2

3

4

5

6

7

8

9

10

11

12

13

1

2

3

4

5

6

7

8

9

10

11

12

13

Gross requirement

schedule receipt

On hand

Net requirement

Planned order/Production

Item No: Tail Lights

LT=

Q=

Gross requirement

schedule receipt

On hand

Net requirement

Planned order

Item No: Wheels

LT=

Q=

Gross requirement

schedule receipt

On hand

Net requirement

Planned order/production

Question 2: (25%)

ABC bookstore purchases Bibles for 35 dollars each, and it cost \$40 dollars to process an order. This bookstore sells 30000 Bibles at a

uniform rate. ABC bookstore is open 5 days a week for 52 weeks per year with the excpetion of 10 holidays a year. The order lead time is 4 days

and the bookstore wants to have an average of 3 days' sales on hand as safety stock when a new order is scheduled to arrive. The holding cost is

estimated to be 25% of the item cost per year. Please fill out the blank with your calculation.

Annual Demand

daily demand

D=

d

working days

S=

H=

Unit cost

EOQ=(2DS/H)^.5

Times D/Q

Days Working Day/Times

Maximum Inv

Minimum Inv

Average Inv

Q/2*H

D/Q*S

TotalCost=

LT=

SS=

RL=

Unit cost x D

Setup/Process cost

Holding Cost

Economical Order Quantity

Times to Order

How many days (interval) to order

EOQ+SS

Safty Stock

(Max +Min)/2

Invetory Cost

Ordering Cost

Total Cost

Lead Time for the Truck to come in

Saftey Stock

dxLT+SS

Material Cost (Unit Cost x D)

Question 3: (25%)

Arctic Chill produces and sells gelato confections to Dallas' upper-middle and upper-class society. Demand is fairly uniform at 17400 servings per year. The

company can produce 65 servings per day, and there are 306 production days in a year. The setup cost for production is minimal at \$10 per production run, and

the holding cost is 40% of Unit Production Cost per year. Suppose the 3 days of daily sales will be used as the saftety stock and the unit cost to produce one

gelato confecdtion is \$30

D=

d=

Working Days=

S=

P=

p=

Unit Production Cost=

H=

How many servings should be produced in each production run?

EPL=(2DS/(H(1-D/P)))^.5

How many times of production run in a year?

How may days for each production run?

Minimum Inventory SS

Maximum Inventory

Q(1-d/p)+ SS

Average Inventory

Holding Cost= q(1-d/p)/2*H

Ordering Cost=D/Q*S

Total Costs=

Question 4: (25%)

D=

d

months

S=

H=

EOQ=(2DS/H)^.5

Times D/Q

Months working

Maximum Inv EOQ+SS

Minimum Inv SS

Average Inv

Q/2*H

D/Q*S

TotalCost=

LT= by month

SS= SDxZscore

RL=dxLT+ SDxZ

Cs(Stockout Cost)

d*LT= DL

Standard Deviation

P(D)=Stockout Pro (H/Cs*Q/D)

Probability of Majority=(1-Pd)

Z score

(Note: Assume no Safety Stock in this formula)

Apply Valley distributes apple boxes in Michigan. Demand for a particular size of apple box has been uniform. The lead time to obtain the apply boxes is 2 month,

and the average use or demand rate is 600 per month. The lead-time demand is normally distributed with a standard deviation of 80 boxes. Order cost is \$20 and

holding cost is \$0.50 per box. The estimated cost of a stockout is \$15. Please fill out the following blanks and answers the questions.

a. What is teh EOQ?

b. How many orders per year will be placed at this EOQ?

c. What is the probability of minority of a stockout that the owner can tolerate?

d. What is the reorder level based on the probability of majority?

e. How much will Apple Valley spend per year for holding, ordering and total costs?

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Oct 15, 2019

Solution~000.zip (25.37 KB)

STATUS

QUALITY

Approved

Oct 15, 2019

EXPERT

Tutor

#### YES, THIS IS LEGAL

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

• As a reference for in-depth understanding of the subject.
• As a source of ideas / reasoning for your own research (if properly referenced)
• For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

### Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.