Quality$-$Productivity

If your name is not on the Cover Page you will not get the mark for this assignment.

Case Study $$ Supreme Inc.

You have just joined the Supreme Company as a financial analyst, reporting to the Controller. Based upon your recent business education at Humber, which included a wide range of subject areas, your new boss has asked you to help her review the recent changes in the manufacturing area.

Until recently, the company had offered only a limited number of standard electric motors for sale. They had purchased raw materials and the lowest level components, but produced most of the subassemblies and all of the finished products in their own plant. The company$$s profitability had declined over the years and marketing believed that customers needed both more variety of product and lower prices. In early $2022,$ the manufacturing division had been assigned the task of recommending changes to accomplish this dual goal of increasing variety and reducing costs.

Manufacturing had recommended that they change their strategy to:

$$ Buy $($rather than make in$-$house$)$ most of the subassemblies.

As tooling$-$up to produce a much wider variety of subassemblies, would take several million dollars of investment and $2-3$ years to implement. Retaining production of existing sub$-$assemblies in$-$house was not considered viable as their volumes were expected to drop dramatically, when the variety being offered increased. Also the company needed all the existing space for the more flexible final assembly process needed for the greater variety of products being sold.

$$ Build final products to customer order.

This plan had been approved in September of $2022.$ The plan and associated personnel layoffs were announced in October $2022,$ with the layoffs scheduled for December $31,2022.$ The increased variety of products had been announced in October, with the first build$-$to$-$order shipments scheduled for Jan $2023.$

Selected Historical Results:

Period Sales

$($$ $\text{'}000\text{'}$s$)$ Labour

$($$ $\text{'}000\text{'}$s$)$ Material

$($$ $\text{'}000\text{'}$s$)$ Other Costs

$($$ $\text{'}000\text{'}$s$)$

Jan $20222506310465$

Feb $2526210266$

Mar $2626510364$

April $2556410666$

May $2636610363$

June $2706910465$

July $2656810264$

Aug $2626610867$

Sept $2546910766$

Oct $2597510965$

Nov. $2657611569$

Dec $2687712070$

Jan $20232555115664$

Feb $2654715063$

Mar $2753514964$

April $2903114465$

May $2843014663$

June $2863114765$

July $2952914864$

Aug $2922914863$

Sept $3013115065$

Assignment$*$: Compile a report in Excel, which includes the following:

$1-$ Format: $(10$ marks$)$

$$ Cover Page, Table of Contents $$ listing all major sections of the report, and the page number where these sections start.

$$ Executive Summary $$ should be written after covering all the issues of this assignment. This section should appear after the table of contents page and allow your manager to have an immediate, short and clear understanding of the main findings and recommendations of your study. Use bullet points and specific figures.

$$ Tables and charts should be computer generated. They must have titles, axes labeled, and data identified.

$2-$ Calculate Labour, Material and Total Productivity $($multifactor of all costs$)$ indices, for each month and present them in a table. IE$.$ Three indices for each month. $(15$ marks$)$

$3-$ Present the $3$ indices calculated in Point $2,$ in a line graph format, on one page. $(10$ Marks$)$

$4-$ Compare the $3$ average productivity indices for the whole of $2022(12$ months$)$ with the $3$ average indices of July$-$September $($only $3$ months$)$ of $2023.$ a$)$ What is the percentage change for each index? $(12$ marks$)$ b$)$ Why do we use only $3$ late months in $2023?(3$ marks$)$

$5-$ Did the change in manufacturing strategy deliver improvements? Comment on patterns of Total Productivity, Labour Productivity and Material productivity, before and after the change in strategy and explain the reasons for each of the $3$ patterns. IE$.$ Mention the reason$($s$)$ that a productivity index went up or down. $(10$ Marks$)$

$6-$ Comment on the role of Inspection:

a$)$ In general $($One page$)(8$ marks$)$

b$)$ When $($how often?$)$ and where $($which step of their manufacturing process?$)$ should

Supreme inspect $(+-$half page$)?(7$ marks$)$

$7-$ Does higher quality $($producing a good or a service with less mistakes$/$rejects$)$ increase productivity? Explain your answer. $(10$ marks$)$

$8-$ Six Sigma

a$)$ Search the Internet to find two organizations that use Six Sigma.

List the specific Website address of each organization. $(5$ marks$)$

b$)$ Describe the use of Six Sigma in one of the above companies $(10$ marks$)$

$*$USE EXCEL ONLY! Other formats will receive zero $($create a new Sheet for each one of the $10$ topics above $$ Sheet $1$ to Sheet $10).$