# Operations mgmt problems -excel | Operations Management homework help

Please read the details before sending me a handshake.. I have attached these problem.  Thank you!

Details:  Read modules A, C, and D in Part 4: Business Analytics Modules.

Problems Note: PX means the problemmay be solved with POM for Windows and/or Excel OM.

Complete problems 14.8 and 14.9 in the textbook.

Submit one Excel file. Put each problem result on a separate sheet in your file.

14.8As the production planner for Scott Sampson

Products, Inc., you have been given a bill of material for a bracket

that is made up of a base, two springs, and four clamps. The base

is assembled from one clamp and two housings. Each clamp has

one handle and one casting. Each housing has two bearings and

one shaft. There is no inventory on hand.

a) Design a product structure noting the quantities for each item

and show the low-level coding.

b) Determine the gross quantities needed of each item if you are

to assemble 50 brackets.

c) Compute the net quantities needed if there are 25 of the base

and 100 of the clamp in stock. PX

14.9Your boss at Scott Sampson Products, Inc., has just

provided you with the schedule and lead times for the bracket in

Problem 14.8. The unit is to be prepared in week 10. The lead

times for the components are bracket (1 week), base (1 week),

spring (1 week), clamp (1 week), housing (2 weeks), handle

(1 week), casting (3 weeks), bearing (1 week), and shaft (1 week).

a)     Prepare the time-phased product structure for the bracket.

b)    In what week do you need to start the castings? PX

Details:
Complete problems B.1, B.5, B.7, B.11, and B.21 in the textbook.

Submit one Excel file. Put each problem result on a separate sheet in your file.

B.1Solve the following linear programming problem

graphically:

Maximize profit = 4X + 6Y

Subject to: X + 2Y 8

5X + 4Y 20

X, Y U 0

B.5Solve the following LP problem graphically:

Minimize cost = 24X + 15Y

Subject to: 7X + 11Y U 77

16X + 4Y U 80

X, Y U 0

B.7The Attaran Corporation manufactures two electrical

products: portable air conditioners and portable heaters. The

assembly process for each is similar in that both require a certain

PX

B.11The Sweet Smell Fertilizer Company markets bags

of manure labeled “not less than 60 lb dry weight.” The packaged

manure is a combination of compost and sewage wastes. To

provide good-quality fertilizer, each bag should contain at least

30 lb of compost but no more than 40 lb of sewage. Each pound

of compost costs Sweet Smell 5¢ and each pound of sewage costs

4¢. Use a graphical LP method to determine the least-cost blend

of compost and sewage in each bag. PX

B.21. Par, Inc., produces a standard golf bag and a deluxe

golf bag on a weekly basis. Each golf bag requires time for cutting

and dyeing and time for sewing and finishing, as shown in the following

table:

 HOURS REQUIRED PER BAG PRODUCT CUTTING AND DYEING SEWING AND FINISHING STANDARD BAG ½ 1 DELUXE BAG 1 2/3

HOURS REQUIRED PER BPRODUCT CUTTING AND DYEING SEWING AND FINISHING

The profits per bag and weekly hours available for cutting and

dyeing and for sewing and finishing are as follows:

 PRODUCT PROFIT PER UNIT (\$) STANDARD BAG 10 DELUXE BAG 8

PRODUCT PROFIT PER UNIT (\$)

 ACTIVITY WEEKLY HOURS AVAILABLE CUTTING AND DYEING 300 SEWING AND FINISHING 360

ACTIVITY WEEKLY HOURS AVAILABLE

Par, Inc., will sell whatever quantities it produces of these two

products.

a) Find the mix of standard and deluxe golf bags to produce per

week that maximizes weekly profit from these activities.

b) What is the value of the profit? PX

Details:
Complete problems D.1, D.3, D.6, and D.8 in the textbook.

Submit one Excel file. Put each problem result on a separate sheet in your file.

D.1Customers arrive at Rich Dunn’s Styling Shop at a

rate of 3 per hour, distributed in a Poisson fashion. Rich can perform

haircuts at a rate of 5 per hour, distributed exponentially.

a) Find the average number of customers waiting for haircuts.

b) Find the average number of customers in the shop.

c) Find the average time a customer waits until it is his or her turn.

d) Find the average time a customer spends in the shop.

e) Find the percentage of time that Rich is busy. PX

D.3Paul Fenster owns and manages a chili-dog and softdrink

stand near the Kean U. campus. While Paul can service 30

customers per hour on the average (m), he gets only 20 customers

per hour (l). Because Paul could wait on 50% more customers

than actually visit his stand, it doesn’t make sense to him that he

should have any waiting lines.

Paul hires you to examine the situation and to determine

some characteristics of his queue. After looking into the problem,

you find it follows the six conditions for a single-server waiting

line (as seen in Model A). What are your findings? PX

D.6Calls arrive at Lynn Ann Fish’s hotel switchboard at

a rate of 2 per minute. The average time to handle each is 20 seconds.

There is only one switchboard operator at the current time.

The Poisson and exponential distributions appear to be relevant

in this situation.

a) What is the probability that the operator is busy?

b) What is the average time that a customer must wait before

reaching the operator?

c) What is the average number of calls waiting to be answered?

PX

D.8Virginia’s Ron McPherson Electronics Corporation

retains a service crew to repair machine breakdowns that occur

on average l = 3 per 8-hour workday (approximately Poisson in

nature). The crew can service an average of m = 8 machines per

workday, with a repair time distribution that resembles the exponential

distribution.

a) What is the utilization rate of this service system?

b) What is the average downtime for a broken machine?

c) How many machines are waiting to be serviced at any given

time?

d) What is the probability that more than 1 machine is in the

system? The probability that more than 2 are broken and

waiting to be repaired or being serviced? More than 3? More

than 4? PX

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Human Resources Management (HRM)
Excellent combination.
Customer 462485, April 3rd, 2022
Excellent.
Customer 459947, April 6th, 2022
English 101
Customer 462833, April 9th, 2022
nursing
Always edit in Grammarly.
Customer 462635, April 8th, 2022
As I expected.
Customer 460551, December 15th, 2021
Statistics
super professional
Customer 462485, May 17th, 2022
Medicine
Good work
Customer 453187, May 25th, 2022
history
Excellent responses.
Customer 463049, June 5th, 2022
Good work.
Customer 463053, June 20th, 2022
Military
good job
Customer 456821, April 4th, 2022
The paper met the expectation. Thanks!
Customer 463143, September 7th, 2022
Military
good job
Customer 456821, March 28th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat