Cost the component parts. The company orders each parts every month. Carrying and stocking cost is 10% of the unit cost. Ordering cost is $30 per order every parts. Perform the following: (1) Develop an ABC analysis to categorize the inventories and draw a pareto chart. (üi) If the company follows the basic EOQ model, how much can be the expected company savings for its total inventory cost? Table Q4 Annual Unit Cost Total cost Quantity (units) Part No. (S) 205Y 3,200 270 810,000 196G 7,600 22.4 167,776 111D 33,000 2.5 80,000 324H 23,000 1.5 33,000 128H 52,000 0.5 25,000

Cost the component parts. The company orders each parts every month. Carrying and stocking cost is 10% of the unit cost. Ordering cost is $30 per order every parts. Perform the following: (1) Develop an ABC analysis to categorize the inventories and draw a pareto chart. (üi) If the company follows the basic EOQ model, how much can be the expected company savings for its total inventory cost? Table Q4 Annual Unit Cost Total cost Quantity (units) Part No. (S) 205Y 3,200 270 810,000 196G 7,600 22.4 167,776 111D 33,000 2.5 80,000 324H 23,000 1.5 33,000 128H 52,000 0.5 25,000

Name: Q4 The Chassis Company locates on the shores of Lake Michigan is aman
Uploaded: 2024-03-20T06:38:44.000Z
Channel: Bartleby
Description: Q4 The Chassis Company locates on the shores of Lake Michigan is amanufacturer of automobile engines. Table Q4 gives historical data oftypical annual usage of component parts for one of its six-cylinderengines. The cost of the finished engine has be

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: A cellphone provider has the business objective of wanting to determine the proportion of…

Q: Internet service: An Internet service provider sampled 520 customers, and finds that 73 of them…

A: According to the given information, we have Total number of customers = 520 73 of them experienced…

Q: Analysis of results: Which "bilingual" education model was most effective when we look at the data…

A: Given the Grade against the standardized ELA score diagram.

Q: Working at home: According to the U.S. Census Bureau, 41% of men who worked at home were college…

A: The number of women who worked at home (n) is 506.The college graduates among women who work at home…

Q: SAT has three parts. Every part is scored on 800-point scale. Critical Reading 526 594 465 561 436…

Q: Timed task: The number of minutes needed to complete a certain spreadsheet task was measured for 20…

A: Based on the data we haveSample size (n):20Minimum:2.9Q1:3.7Median:4.4Q3:5.1Maximum:6Mean (x̄):4.4…

Q: test of statistical cunning and insight: Using the images attached which best-fit line is better…

A: Given:

Q: The following table lists the income tax rates for a single person earning $50,000 per year for…

A: The table shows the number of fires per month in a city.

Q: The company "Buy more SA de Cv" conducts a market survey to evaluate the profitability of each of…

A: Given: P (predict profitable) = 0.90 P (profitable | predict profitable) = 0.70 P (profitable |…

Q: It is thought there may be a mistake in the Project Tracker. A project team member explains she…

A: A total of 6 questionnaire already been conducted than Actual % complete is 40+6 = 46% which is more…

Q: Statistics students in Oxnard College sampled 11 textbooks in the Condor bookstore and recorded the…

A: A student calculates a linear model using technology (Statistics Calculator or Computer)ˆy= _ _ _ x…

Q: Timed task: The number of minutes needed to complete a certain spreadsheet task was measured for 20…

A: The following data has been provided:…

Q: In 2016 the Better Business Bureau settled 85% of complaints they received in the United States.…

A: Introduction: We have denoted the symbol as p̂ instead of p-bar. Denote p as the true population…

Q: Smart phone: Among 245 cell phone owners aged 18-24 surveyed, 106 said their phone was an Android…

A: (b) Obtain the 98% confidence interval for the proportion of cell phone owners aged 18-24 who have…

Q: test statistic = Round to 4 decimal places. . What is the p-value for this sample? p-value = Round…

A: a). Given: The null and alternative hypothesis is as follows: The formula and calculations for the…

Q: Study using Repeated Measures Design: Here is a study using Repeated Measures Design -Do an APA…

A: Given a repeated measures study, all participants see all of the same words and participate in all…

Q: Quality Progress, February 2005, reports on improvements in customer satisfaction and loyalty made…

A: GivenPopulation proportion(n)=0.44sample size(n)=390Mean(μp^)=p=0.44standard…

Q: Is there a difference in profit in the first quarter compared to the second quarter for investor’s…

A: The data represents the values of profit in the first quarter and second quarter for each of the 9…

Q: martphone: Among 239 smartphone owners aged 18-24 surveyed, 103 said their phone was an Android…

A: The number of smartphone owners aged 1-24 surveyed (n) is 239.The number of smartphone owners said…

Q: A student calculates a linear model using technology (Statistics Calculator or Computer) (Please…

A: From the excel the following regression output can be obtained as: Therefore, the regression…

Q: A study is done In Sydney to estimate the proportion of people living there who have travelled…

A: Given: Previous estimation of proportion=0.28 Minimum error margin E=0.05 Level of…

Q: Draw boxplots (by hand is the easiest) of the data for each year For the particular Year 2 that you…

A: Draw boxplots (by hand is the easiest) of the data for each year For the particular Year 2 that you…

Q: The analyst claims that there is an increasing trend for every new year for investing the money to…

Q: Sales of a particular product for the years 2017 through 2020 have been 365, 506, 449 and 419…

A: The average of a data is computed by dividing the sum of observations by the total number of…

Q: tatistics students in Oxnard College sampled 11 textbooks in the Condor bookstore and recorded the…

A: From the given data we find the regression equation.

Q: Statistics students in Oxnard College sampled 11 textbooks in the Condor bookstore and recorded the…

A: The data is given below:Number of…

Q: tatistics students in Oxnard College sampled 11 textbooks in the Condor bookstore and recorded the…

A: Given data, X Y X*Y X*X 695 104.4 72558 483025 481 75.72 36421.32 231361 329 62.48…

Q: Working at home: According to the U.S. Census Bureau, 34% of men who worked at home were college…

A: It is given that n=500 and the sample proportion p-hat is0.34.

Q: Smartphone: Among 251 smartphone owners aged 18 - 24 surveyed, 109 said their phone was an…

A: n=251......... SampleX=109........... Success

Q: Given the following: Number of births between 30 June 2009 and 30 June 2010 in Australia was…

A: Disclaimer: Since you have posted a question with multiple sub-parts, we will solve the first three…

Q: A new drug was tested on mice to determine its effectiveness in reducing cancerous tumors. Tests…

A: Given, A new drug was tested on mice to determine its effectiveness in reducing cancerous tumors.…

Q: Smart phone: Among 245 cell phone owners aged 18-24 surveyed, 106 said their phone was an Android…

Q: Internet service: An Internet service provider sampled 538 customers and found that 78 of them…

A: From the provided information,Total number of customers = 53878 of them experienced an interruption…

Q: Meals A college student is on a “meal program.” Hisbudget allows him to spend an average of $10 per…

Q: Statistics students in Oxnard College sampled 11 textbooks in the Condor bookstore and recorded t…

A: Excel Procedure: Enter x and y data in Excel>Data>Data Analysis> ‘Regression’>Select y…

Concept explainers

Statements and Logic

Logic is the analysis of general patterns of thoughts without regard to any specific sense of context.

Topic Video

Question

Q4 The Chassis Company locates on the shores of Lake Michigan is a
manufacturer of automobile engines. Table Q4 gives historical data of
typical annual usage of component parts for one of its six-cylinder
engines. The cost of the finished engine has been increasing by about
5% a year. This is principally due to approximately the same increase in
cost of the component parts. The company orders each parts every
month. Carrying and stocking cost is 10% of the unit cost. Ordering cost
is $30 per order every parts. Perform the following:
(i)
Develop an ABC analysis to categorize the inventories and
draw a pareto chart.
(ii)
If the company follows the basic EOQ model, how much can be
the expected company savings for its total inventory cost?
Table Q4
Annual
Unit Cost
Total cost
Quantity
(units)
Part No.
($)
205Y
3,200
270
810,000
196G
7,600
22.4
167,776
111D
33,000
2.5
80,000
324H
23,000
1.5
33,000
128H
52,000
0.5
25,000

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Introduction

Step 1

Step 2

Step 3

Step 4

Step 5

Step by step

Solved in 6 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Propositional Calculus$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions

Help for part B
Q3A The table below contains on 48 houses: the value of the house and the amount of rental income in a year that the house brings in ("Capital and rental," 2013). Table: Data of House Value versus Rental Value Rental Value Rental Value Rental Value Rental 81000 6656 77000 4576 75000 7280 67500 6864 95000 7904 94000 8736 90000 6240 85000 7072 121000 12064 115000 7904 110000 7072 104000 7904 135000 8320 130000 9776 126000 6240 125000 7904 145000 8320 140000 9568 140000 9152 135000 7488 165000 13312 165000 8528 155000 7488 148000 8320 178000 11856 174000 10400 170000 9568 170000 12688 200000 12272 200000 10608 194000 11232 190000 8320 214000 8528 208000 10400 200000 10400 200000 8320 240000 10192 240000 12064 240000 11648 225000 12480 289000 11648 270000 12896 262000 10192…
Statistics students in Oxnard College sampled 11 textbooks in the Condor bookstore and recorded the number of pages in each textbook and its cost. The data are shown below: Number of Pages (x ) Cost(y ) 866 36.3 418 22.9 783 52.15 562 26.1 290 15.5 708 43.4 357 15.85 316 27.8 614 30.7 384 15.2 239 5.95 A student calculates a linear model using technology (Statistics Calculator or Computer)ˆy = x + . (Please show your answers to two decimal places)Use the model to estimate the cost when number of pages is 536.Cost = $ (Use the linear model with yor rounded coefficients and then round your answer to 2 decimal places.)
Statistics students in Oxnard College sampled 11 textbooks in the Condor bookstore and recorded the number of pages in each textbook and its cost. The data are shown below: Number of Pages (x) Cost(y) 836 75.88 695 62.6 565 40.2 990 85.2 231 27.48 383 33.64 370 25.6 638 55.04 526 42.08 752 63.16 845 78.6 A student calculates a linear model using technology (Statistics Calculator or Computer) (Please show your answers to two decimal places) %3D Use the model to estimate the cost when number of pages is 833. Cost = $ (Use the linear model with yor rounded coefficients and then round your answer to 2 %3D decimal places.)
ge 2: Has the proportion of Americans that are "20-somethings" decreased? According to the US Census Bureau, 14.8% of Americans living in 2004 were "20- somethings" (between ages 20 and 29). You take a random sample of 500 Americans and find that 59 of them fall in this age range. Has the proportion of Americans ages 20-29 decreased from what it was in 2004? for this problem (z-test or t-test).
= The average owning and operating costs for four types of vehicles in a country for a recent year include small sedans ($6556), medium sedans ($8590), SUVs ($11,389), and minivans ($9629). Use a Pareto chart to display the data. Describe any patterns. Which Pareto chart below displays the data? O A. O C. Cost Cost Owning and Operating Costs I $12000- $10000- $8000- $6000- $4000- $2000- $01 $12000- $10000- $8000- $6000- $4000- $2000- $0 Medium Minivan SUV Type of Vehicle Owning and Operating Costs SUV Minivan Medium Type of Vehicle Small Small Q O B. SO D. Cost Cost $12000- $10000- $8000+ $6000- $4000- $2000- $0- $12000- $10000- $8000- $6000- $4000- $2000 $0- Owning and Operating Costs M Medium SUV Minivan Type of Vehicle Owning and Operating Costs SUV [ Medium Minivan Type of Vehicle Small Small Q Q Next
Researchers wondered whether the size of a person's brain was related to the individual's mental capacity. They selected a sample of 5 females and 5 males and measured their MRI image pixel counts and IQ scores. The data is reported to the right. Complete parts (a) through (d) below. Click the icon to view the critical values table. 1,080,000- 780,000 MRI 130 145 (a) Draw a scatter diagram treating MRI count as the explanatory variable and IQ as the response variable. Choose the correct diagram below. OA. Q Q OB. AMRI 1,080,000- 780,000 130 IQ 145 COLO Q Q SCIER O C. AIQ 145+ 130 780,000 Females MRI IQ 866,662 130 857,782 133 MRI IQ 935,494 141 1,079,550 141 852,244 132 1,001,121 140 951,545 137 955,466 133 790,619 135 1,038,438 139 MRI Males 1,080,000 C D. 145 AIQ 130- 780,000 MRI 1,080,000 Q (b) Compute the linear correlation coefficient between MRI count and IQ. Are MRI count and IQ linearly related? Select the correct choice below and, if necessary, fill in the answer box to…
Commercial dredging operations in ancient rivers occasionally uncover archaeological artifacts of great importance. One such artifact is Bronze Age spearheads recovered from ancient rivers in Ireland. A recent study gave the following information regarding discoveries of ancient bronze spearheads in Irish rivers. River Bann Blackwater Erne Shannon Barrow No. of spearheads 23 10 15 30 14 (a) Make a Pareto chart for these data. The chart has 5 bars. Each bar is associated with a label and a value as listed below. Shannon: 30 Bann: 23 Erne: 15 Barrow: 14 Blackwater: 10 The chart has 5 bars. Each bar is associated with a label and a value as listed below. Blackwater: 10 Barrow: 14 Erne: 15 Bann: 23 Shannon: 30 The chart has 5 bars. Each bar is associated with a label and a value as listed below. Bann: 23 Barrow: 14 Blackwater: 10 Erne: 15 Shannon: 30
Fuel Economy, Minivans - The Environmental Protection Agency (EPA) publishes fuel economy values that are known to be good estimates of the fuel economy a typical driver will achieve under average driving conditions. One of the fuel economy values the EPA publishes is a combined estimate, which represents a combination of city driving (55%) and highway driving (45%). Toyota Sienna, a popular minivan, advertises an average combined fuel usage of 22 mpg. A large rental company collected the information about combined fuel economy (mpg) for their 10 Toyota Sienna minivans. The results are shown in the table below. 21.7 21 21.9 20.4 21.8 21.6 22.5 20.8 23.5 21.1 The company calculates the sample mean to be 21.63 and sample standard deviation as 0.897. Round all calculated values 4 decimal places as appropriate. 1. The management believes that Toyota has overestimated the fuel economy of the Sienna. Which set of hypotheses should we use to determine if the fuel efficiency of the Sienna is…
The stem-and-leaf plot shows house sale prices over the last week in Tacoma. The stem is in hundreds of thousands of dollars the leaf is in tens of thousands of dollars. What is the price of the most expensive house sold? 01667778999 1|02447778889999 2|0011234445667889 3|00011225 %$4
Subject: statistics
Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in the southern U.S. The owners would like to estimate weekly gross revenue as a function of advertising expenditures. Data for a sample of eight markets for a recent week follow. Weekly Gross Revenue Television Advertising Newspaper Advertising ($100s) 102.5 52.7 75.8 127.8 137.8 101.4 237.8 219.6 Market Mobile Shreveport Jackson Birmingham Little Rock Biloxi New Orleans Baton Rouge ($100s) 5.1 3.2 4.0 4.3 3.5 3.6 5.0 6.9 ($100s) 1.6 3.0 1.5 4.0 4.3 2.3 8.4 5.8 (a) Use the data to develop an estimated regression equation with the amount of television advertising as the independent variable. Let x represent the amount of television advertising. If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) ŷ Test for a significant relationship between television advertising and weekly…