Question: SHOW IN EXCEL WITH STEPS PROVIDING HOW YOU GOT THE ANSWER... Create a Pareto Chart regarding the data about types of error in a printing

SHOW IN EXCEL WITH STEPS PROVIDING HOW YOU GOT THE ANSWER...

Create a Pareto Chart regarding the data about types of error in a printing company (Hint: the pareto chart need to be created based on the total cost, only unit costs is given currently). Discuss the results found based on the pareto chart: if management has monthly allocation of $18,000, which areas should they tackle?

X Cut Calibri (Body) 11 A. A = = = Copy Paste B U A Format D7 fx =B7* C7 A B D E % TOTAL COST In a printing company, data from the previous month show the following types of errors, with the unit cost (in dollars) of rectifying each error. Construct a Pareto Chart and discuss the results. If management has monthly 1 allocation of 18,000, which areas should they tackle? (Hint: what is the total cost) 2. Error categories Frequency Unit Costs 3 Inadequate Binding 120 100 4 Paper tension 80 50 5 Paper Mis alignment 30 6 Proofreading 3500 0.5 7 Typographical 4000 0.2 8 9 10 TOTAL 12000 4000 3000 1750 100 800

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Icebreaker Company (a U.S.-based company) purchases materials from a foreign supplier on December 1, 2020, with payment of 17,000 dinars to be made on March 1, 2021. The materials are consumed...

Create a Pareto Chart regarding the data about types of error in a printing company ( Hint: the pareto chart need to be created based on the total cost, only unit costs is given currently ) . Discuss...

WBS for a project. List of resources and allocate resources based on the tasks you identified Resource allocation plan ADDITIONAL CASES INTRODUCTION This document provides four cases in addition to...

4 : 1 6 Back Assignment 5 . docx Switch To Dark Mode Assignment 5 This assignment contains 2 parts. You need to address both parts to earn full credit. Part a . Find the attached Excel File:...

Part a . Find the attached Excel File: Assignment 5 _ Charts. There are 4 excel worksheets in the excel file. Based on the instruction in each worksheet, create the following chart and provide...

This assignment contains 2 parts. You need to address both parts to earn full credit. Part a. Find the attached Excel File: Assignment 5_Charts. There are 4 excel worksheets in the excel file. Based...

Part a . Find the attached Excel File: Assignment 2 _ Part a . There are 4 excel worksheets in the excel file. Based on the instruction in each worksheet, create the following chart and provide...

Errors Reported in a Seven Day Period Continue with your examination of ways to reduce the error rate. Use the Servicing Delay vs . Support Staff data shown below to produce a scatter diagram...

Assignment Instructions - Total Quality Management Tools TOTAL QUALITY MANAGEMENT TOOLS ASSIGNMENT DESCRIPTION This assignment will provide the knowledge of how to use data to analyze and assess...

PLEASE COMPLETE ASAP!! Show me the steps to solve PART A - Process A large mail - order catalog company found that there were 2 3 , 9 8 1 wrongly addressed customer packages, a number consider...

Let's consider the following economy, represented by the aggregate demand and aggregate supply curves, whose expressions are as follows: AD: Y = (M-P) AS: P = P + (Y-Y) Y is output, M is money...

What is capital structure? Why do the capital structures of companies vary?

The required rate of return for Firm B is Selected answer will be automatically saved. For keyboard navigation, press up / down arrow keys to select an answer. a 8 % . b 1 2 % . c 6 . 8 % . d Cannot...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...