Unit 7 Problems

Unit 7 Problems

Work through the problems in Excel.  Enter your answers in the following Attach your Word file or Excel spreadsheet where indicated.  YOU MUST SUBMIT YOUR EXCEL SPREADSHEET OR OTHER WORK IN ORDER TO RECEIVE CREDIT FOR THE ASSIGNMENT.  FAILURE TO SUBMIT THE EXCEL SPREADSHEET OR OTHER WORK WILL RESULT IN A GRADE OF 0.

You will only have access to the problems once.  Therefore, complete all of the problems in Excel, and then enter your answers and upload your Excel file.

Need both word and excel sheets. Allow excel to work the problems. Need the formulas included in the spread sheet.

Top of Form

 

Flag this Question

Question 1 10 pts

A manager at Strateline Manufacturing must choose between two shipping alternatives: two-day freight and five-day freight. Using five-day freight would cost $135 less than using two-day freight. The primary consideration is holding cost, which is $10 per unit a year. Two thousand items are to be shipped. Which alternative would you recommend?

 

Group of answer choices

two-day shipping

five-day shipping

 

Flag this Question

Question 2 10 pts

A manager must make a decision on shipping. There are two shippers, A and B. Both offer a two-day rate: A for $500 and B for $525. In addition, A offers a three-day rate of $460 and a nine-day rate of $400, and B offers a four-day rate of $450 and a seven-day rate of $410. Annual holding costs are 35 percent of unit price. Three hundred boxes are to be shipped, and each box has a price of $140. Which shipping alternative would you recommend? Explain.

 

Group of answer choices

A, two-day

A, three-day

A, nine-day

B, two-day

B, four-day

B, seven-day

 

Flag this Question

Question 3 10 pts

Use the assignment method to determine the best way to assign workers to jobs, given the following cost information. Compute the total cost for your assignment plan.

		JOB
		A	B	C
	1	5	8	6
Worker	2	6	7	9
	3	4	5	3

 

Worker 1 should do job

Bottom of Form

for a cost of

.

Worker 2 should do job

for a cost of Worker 3 should do job for a cost of Total cost $

 

Flag this Question

Question 4 10 pts

Assign trucks to delivery routes so that total costs are minimized, given the cost data shown. What is the total cost?

		ROUTE
		A	B	C	D	E
	1	4	5	9	8	7
	2	6	4	8	3	5
Truck	3	7	3	10	4	6
	4	5	2	5	5	8
	5	6	5	3	4	9

 

Truck 1 should take route at a cost of $ .

Truck 2 should take route at a cost of $ .

Truck 3 should take route at a cost of $ .

Truck 4 should take route at a cost of $ .

Truck 5 should take route at a cost of $ .

The total cost is $ .

 

Flag this Question

Question 5 10 pts

The following table contains information concerning four jobs that are awaiting processing at a work center.

Job	Job Time (days)	Due Date (days)
A	14	20
B	10	16
C	7	15
D	6	17

1. Sequence the jobs using (1) FCFS, (2) SPT, (3) EDD, and (4) CR. Assume the list is by order of arrival.  List the jobs in order with no spaces, such as ABCD.

     FCFS

     SPT

     EDD

     CR

  2. For each of the methods in part a, determine (1) the average job flow time, (2) the average tardiness, and (3) the average number of jobs at the work center.  Round to two decimal places.

	avg job flow time (days)	avg tardiness (days)	avg #jobs
FCFS
SPT
EDD
CR

  3. Which method is superior to the others?

 

 

Flag this Question

Question 6 10 pts

The following table shows orders to be processed at a machine shop as of 8:00 a.m. Monday. The jobs have different operations they must go through. Processing times are in days. Jobs are listed in order of arrival.

1. Determine the processing sequence at the first work center using each of these rules: (1) FCFS , (2) S/O.

2. Compute the effectiveness of each rule using each of these measures: (1) average flow time, (2) average number of jobs at the work center.  Round to two decimal places.

     FCFS average flow time

     FCFS average number of jobs

     S/O average flow time

     S/O average number of jobs

Job	Processing Time (days)	Due Date (days)	Remaining Number of Operations
A	8	20	2
B	10	18	4
C	5	25	5
D	11	17	3
E	9	35	4

 

 

Flag this Question

Question 7 0 pts

Upload your Excel file or other work here.

Upload