Question Details

(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

 

Head Light

 

Tail Light

 

Wheels

 


 

1 Head Light (2)

 


 

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

 

Item No: Head Light

 

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:

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Oct 15, 2019

EXPERT

Tutor

ANSWER RATING

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.

NEW ASSIGNMENT HELP?

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.

Order Now