Question Details

[answered] BA 357 Assignment 2 - Worksheet 1: MPS Approved plan Names


I need to know how to calculate the MPR for the tiller unit (K). I've attached the excel spreadsheet and the assignment criteria


BA 357 Assignment 2 - Worksheet 1: MPS Approved plan

 

Names of Group Members: Item: A Clodhopper (Winter2016) Lot Size Rule:

 

Lead Time: Safety Stock Level:

 

Current Inventory:

 

Week 1 Jan 2016

 

Week 2

 

Week 3 Week 4 Week 5 Feb 2016

 

Week 6 Week 7 Week 8 Mar 2016

 

Week 9 Week 10 Week 11 Week 12 Forecast 350 450 450 450 600 600 600 600 2400 2500 2600 2300 Customer Orders Booked 150 350 500 600 240 200 1000 1500 0 2200 2000 0 Projected On-Hand Inventory

 

MPS Scheduled Receipts

 

MPS Quantity

 

MPS Start

 

Available to Promise Item: B Clodbuster (Winter2016) Lot Size Rule:

 

Lead Time: Safety Stock Level:

 

Current Inventory:

 

Week 1 Jan 2016

 

Week 2

 

Week 3 Week 4 Week 5 Feb 2016

 

Week 6 Week 7 Week 8 Mar 2016

 

Week 9 Week 10 Week 11 Week 12 Forecast 200 300 300 300 400 400 400 400 1000 1100 600 1000 Customer Orders Booked 200 450 450 0 50 900 0 800 500 0 0 0 Projected On-Hand Inventory

 

MPS Scheduled Receipts

 

MPS Quantity MPS Start

 

Available to Promise BA 357 Assignment 2 - Worksheet 2: Bill of Materials Data

 

ClodHopper BOM (Product A) A

 

C

 

D

 

E

 

F

 

G

 

H

 

I

 

J

 

K

 

M Name

 

Quantity Assembly Time Lead Time

 

ClodHopper

 

1

 

1 week

 

Handle Bar Assembly

 

1

 

2 weeks

 

Steel Tubing 1" dia

 

12 feet

 

1 week

 

Control cable

 

6 feet

 

2 weeks

 

Control lever assembly

 

1

 

1 week

 

Grips

 

2

 

1 week

 

Powerhead assembly

 

1

 

1 week

 

Gearbox assembly

 

1

 

1 week

 

Engine (Standard)

 

1

 

2 weeks

 

Tiller blade unit

 

1

 

1 week

 

Instruction Manual

 

1

 

3 weeks ClodBuster BOM (Product B) B

 

C

 

D

 

E

 

F

 

G

 

P

 

I

 

L

 

N

 

M Name

 

Quantity Assembly Time Lead Time

 

ClodBuster

 

1

 

1 week

 

Handle Bar Assembly

 

1

 

2 weeks

 

Steel Tubing 1" dia

 

12 feet

 

1 week

 

Control cable

 

6 feet

 

2 weeks

 

Control lever assembly

 

1

 

1 week

 

Grips

 

2

 

1 week

 

HD Powerhead assembly

 

1

 

1 week

 

Gearbox assembly

 

1

 

1 week

 

Engine (Heavy Duty)

 

1

 

3 weeks

 

HD Tiller Unit

 

1

 

2 weeks

 

Instruction Manual

 

1

 

3 weeks BA 357 Assignment 2 - Worksheet 3: Inventory Records and Lot-Sizing Rules

 

Record Date: Item

 

A

 

B

 

C

 

D

 

E

 

F

 

G

 

H

 

I

 

J

 

K

 

L

 

M

 

N

 

P Name

 

ClodHopper

 

ClodBuster

 

Handle Bar Assembly

 

Steel Tubing 1" dia

 

Control cable

 

Control lever assembly

 

Grips

 

Powerhead assembly

 

Gearbox assembly

 

Engine (Standard)

 

Tiller blade unit

 

Engine (Heavy Duty)

 

Instruction Manual

 

HD Tiller Unit

 

HD Powerhead assembly 31-Dec-15 Current

 

Inventory

 

On-Hand

 

4500

 

3500

 

3100

 

60,000

 

5,000

 

2500

 

2000

 

700

 

650

 

500

 

850

 

450

 

6000

 

1250

 

900 Lot-Size Rule

 

Lot Size

 

FOQ

 

2500

 

FOQ

 

1000

 

L4L

 

POQ Period = 2 weeks

 

FOQ

 

20,000

 

L4L

 

L4L

 

FOQ

 

4000

 

FOQ

 

5000

 

FOQ

 

2500

 

POQ Period = 2 weeks

 

FOQ

 

1000

 

FOQ

 

10,000

 

POQ Period = 3 weeks

 

FOQ

 

2000 Lead or

 

Desired

 

Assembly

 

Safety

 

Time

 

Stock Level Units

 

1 week

 

1000

 

1 week

 

750

 

2 weeks

 

700

 

1 weeks

 

10,000 feet

 

2 weeks

 

10,000 feet

 

1 week

 

0

 

1 week

 

0

 

1 week

 

1000

 

1 week

 

750

 

2 weeks

 

750

 

1 week

 

750

 

3 weeks

 

500

 

3 weeks

 

2000

 

2 weeks

 

500

 

1 week

 

250 BA 357 Assignment 2 - Worksheet 4: Scheduled Receipts

 

Note: These are purchase order and production commitments scheduled in 2015 that are already scheduled for

 

completion in 2016. The sizes of the orders or production lots are listed by week of scheduled delivery. Include

 

these quantities in "Projected on-hand inventory" - do not include them in "Planned order releases." Item

 

A

 

B

 

C

 

D

 

E

 

F

 

G

 

H

 

I

 

J

 

K

 

L

 

M

 

N

 

P Name

 

ClodHopper

 

ClodBuster

 

Handle Bar Assembly

 

Steel Tubing 1" dia (feet)

 

Control cable (feet)

 

Control lever assembly

 

Grips

 

Powerhead assembly

 

Gearbox assembly

 

Engine (Standard)

 

Tiller blade unit

 

Engine (Heavy Duty)

 

Instruction Manual

 

HD Tiller Unit

 

HD Powerhead assembly Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 65,000

 

20,000 500

 

5000

 

2500 2500 1000 2500

 

1000 10,000

 

1000 2500 BA 357 Assignment 2 - Worksheet 5: MRP Forms

 

Item: Lot Size Rule:

 

Lead Time: Safety Stock Level:

 

Current Inventory:

 

Week 1 Jan 2016

 

Week 2

 

Week 3 Week 4 Week 5 Feb 2016

 

Week 6 Week 7 Week 8 Mar 2016

 

Week 9 Week 10 Week 11 Week 12 Gross Requirements

 

Scheduled Receipts

 

Projected On-Hand Inventory

 

Planned Receipts

 

Planned Order Releases Item: Lot Size Rule:

 

Lead Time: Safety Stock Level:

 

Current Inventory:

 

Week 1

 

Gross Requirements

 

Scheduled Receipts

 

Projected On-Hand Inventory

 

Planned Receipts

 

Planned Order Releases Jan 2016

 

Week 2

 

Week 3 Week 4 Week 5 Feb 2016

 

Week 6 Week 7 Week 8 Mar 2016

 

Week 9 Week 10 Week 11 Week 12 Item: Lot Size Rule:

 

Lead Time: Safety Stock Level:

 

Current Inventory:

 

Week 1 Jan 2016

 

Week 2

 

Week 3 Week 4 Week 5 Feb 2016

 

Week 6 Week 7 Week 8 Mar 2016

 

Week 9 Week 10 Week 11 Week 12 Gross Requirements

 

Scheduled Receipts

 

Projected On-Hand Inventory

 

Planned Receipts

 

Planned Order Releases Item: Lot Size Rule:

 

Lead Time: Safety Stock Level:

 

Current Inventory:

 

Week 1 Jan 2016

 

Week 2

 

Week 3 Week 4 Week 5 Feb 2016

 

Week 6 Week 7 Week 8 Mar 2016

 

Week 9 Week 10 Week 11 Week 12 Gross Requirements

 

Scheduled Receipts

 

Projected On-Hand Inventory

 

Planned Receipts

 

Planned Order Releases Item:

 

Safety Stock Level:

 

Current Inventory: Lot Size Rule:

 

Lead Time: Week 1

 

Gross Requirements

 

Scheduled Receipts

 

Projected On-Hand Inventory

 

Planned Receipts

 

Planned Order Releases Jan 2016

 

Week 2

 

Week 3 Week 4 Week 5 Feb 2016

 

Week 6 Week 7 Week 8 Mar 2016

 

Week 9 Week 10 Week 11 Week 12

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001005420.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

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

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

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 YOUR SET DEADLINE.

Order Now