Quality Related Problems to Solve.

NOTE: All problems to be solved in one EXCEL spreadsheet $($workbook$),$ each problem on a

separate tab. The text answers should also be in the same spreadsheet as the problem with proper

identification $($i$.$e$.($a$),($b$),$ etc.$)$

All calculations formulae should be shown in the cell where the variable is being calculated.

This is a requirement and points will be lost with no formulae.

Problem No$.1$

The Modern Styles Furniture Company produces a line of disassembled furniture, which comes

in a carton. The buyer is required to assemble the pieces into a usable object. One of the products

is a two$-$shelf bookcase. Here is the parts list for the product:

$1-$ back panel, $2-$ middle shelves, $1-$ package of screws

$1-$ top shelf $,2-$ side panels $,1-$ cardboard carton

This problem is concerned only with the cardboard carton and its contents. The pieces of the

bookcase are assumed to be satisfactory, but some may be missing in some cartons. This

constitutes a simplification, of course, since it ignores the problem of defective or damaged parts.

The company provides an $800$ number on the carton to assist customers who experience

difficulties. Recently, there has been a rash of calls concerning missing parts. The Company

promptly ships the missing part$($s$)$ to the aggrieved customer.

Management is concerned about the poor reputation which the Company's products are acquiring

and about the extra expense of the shipments, which should be unnecessary. In an attempt to

pinpoint the problem, some employees have been detailed to check every carton before it is

sealed up and to keep a record of their findings on a check sheet. Any parts discovered to be

missing are replaced before the carton is shipped. Here is a table of their findings for one week.

Piece Mon. Tues. Wed. Thurs. Fri. Total

$3$

$2$

$6$

$6$

$7$

$3$

Back panel

Top shelf

$1$ Middle Shelf

$2$ Middle shelves

$1$ side panel

$2$ side

Panels

Screws

Carton

Total