Operations Management Assignment With Excel

this assignment is due in 2 days. Pls help

IDS 355

Spring 2021

Assignment 4

Due Friday 04/09 11:59pm

40 points

Instructions

Deadline

This assignment may be submitted for full credit until Friday, April 9th at 11:59pm. Late submissions will not be accepted one week after the deadline. If you need an extension for an assignment, you must ask your TA in advance. Please consult the syllabus for details about lateness penalties and extension requirements. In any event, we strongly recommend submitting your assignment early, in case problems arise with the submission process.

Problem Guidelines

Because using spreadsheet software is a basic business skill, the assignments are intended to give you practice in structuring problems as well as simply finding the answers. All problems must be solved using Excel formulas to receive credit. If, for example, you solve a problem on paper and then copy the results to Excel, you will receive no credit for that problem.

Submission Guidelines

All assignments are to be submitted using the Blackboard site. Assignments should be uploaded using the upload link associated with the assignment. It is important that all homework files include the student’s NetID, so they can be easily identified and sorted. The file containing homework assignment 1 submitted by the student with NetID rbaker2 should be named rbaker2hw1.

Make sure your submission is a working file. If you upload a corrupted file (or a file which cannot be downloaded and opened completely), you will receive 0 points for this assignment.

For this assignment, please submit one Excel file. Use a separate worksheet for each question set and label the worksheets. To rename a worksheet, right-click the worksheet tab located at the bottom of your current sheet and use the rename option. Label the tabs as “Q Set 1” and “Q Set 2”, respectively. Be sure to label all results clearly.

Question Set 1.

You are in charge of quality control for computer keyboards at Dell. You have data on twenty-five batches of keyboards, tracking five types of keyboard defects: key brightness, dusting, scissor mechanics, dead connections, and sticky keys. These data are given in the table below.

1. For each defect type, find the average number of defects per batch. So, you should have an average defect rate for displays, another for color, and so on. (2pts)

2. For each batch, find the total number of defects (the sum of all five types). So, you should have one number for batch 1, another for batch 2, and so on. (2pts)

3. Sort the five columns of defects by descending average defect rate. The lowest rate should be on the right. (4pts)

4. Sort the batches by descending total defects. The batch with the highest total should be at the top. This will not affect the column sorting from the part 3 above. (4pts)

5. Create a Pareto chart showing the average defect rate for each of the five defect types. This will be a column chart, in descending left-to-right order, with each column and the axes labeled. (8pts)

 Defects
BatchKey BrightnessDustingScissor MechanicsDead ConnectionsSticky Keys
142101
223002
331215
432020
533120
621200
732123
812001
900031
1020211
1122133
1210221
1310402
1420011
1514222
1601131
1711002
1832023
1913300
2020201
2110033
2222003
2316132
2400203
2520214

Question Set 2.

A manufacturing operation must periodically purchase bulk quantities of bolts. The bolts are purchased in boxes of 500 and are consumed at a constant rate. The operation expects to purchase 26,000 boxes over the coming year. Each box costs $140, the annual holding cost per box is $32, and the cost of placing an order is $200 (regardless of the quantity ordered). For the following questions, use the basic economic order quantity model (without quantity discounts).

1. What is the economic order quantity (in boxes)? (2pts)

2. Calculate the annual inventory holding costs based on the average inventory level and annual holding cost per box. (2pts)

3. Calculate the annual inventory ordering costs based on the number of orders expected to be placed during the coming year. (2pts)

4. Create a data table showing the total annual inventory costs (inventory holding + inventory ordering) for order quantities varying from 100 to 1050 (in increments of 50). You must use a data table structure to receive full credit for this problem. (8pts)

5. Create a scatter chart (use the one with markers and smooth lines) showing how total inventory costs are a function of the order quantity. Be sure to label your axes appropriately. Observe that the total annual inventory costs are the smallest near to the EOQ value you found in the first question above. (6pts)

Order a similar paper and get 15% discount on your first order with us

Dr. Padma Myers
Dr. Padma Myers
98% Success Rate
Read More
“Hello, I deliver nursing papers on time following instructions from the client. My primary goal is customer satisfaction. Welcome for plagiarism free papers”
Stern Frea
Stern Frea
98% Success Rate
Read More
Hi! I am an English Language and Literature graduate; I have written many academic essays, including argumentative essays, research papers, and literary analysis.
Dr. Ishid Elsa
Dr. Ishid Elsa
98% Success Rate
Read More
"Hi, count on me to deliver quality papers that meet your expectations. I write well researched papers in the fields of nursing and medicine".
Dr. Paul P. Klug
Dr. Paul P. Klug
99% Success Rate
Read More
"A top writer with proven reliability and experience. I have a 99% success rate, overall rating of 10. Hire me for quality custom written nursing papers. Thank you"

How Our Essay Writing Service Works

Tell Us Your Requirements

Fill out order details and instructions, then upload any files or additional materials if needed. Then, confirm your order by clicking “Place an Order.”

Make your payment

Your payment is processed by a secure system. We accept Mastercard, Visa, Amex, and Discover. We don’t share any informati.on with third parties

The Writing Process

You can communicate with your writer. Clarify or track order with our customer support team. Upload all the necessary files for the writer to use.

Download your paper

Check your paper on your client profile. If it meets your requirements, approve and download. If any changes are needed, request a revision to be done.

Recent Questions

Stay In Touch!

Leave your email and get discount promo codes and the best essay samples from our writers!
Chat with us
WhatsApp Your Assignment!
Hello! Welcome! We have writers online to help you at any time!