Vice-president Arun Mittra speculates: We have always estimated how many transformers will be needed to meet demand. The usual method is to look at the sales figures of the last two to three months...

1 answer below »
Vice-president Arun Mittra speculates: We have always estimated how many transformers will be needed to meet demand. The usual method is to look at the sales figures of the last two to three months and also the sales figures of the last two years in the same month. Next make a guess as to how many transformers will be needed. Either we have too many transformers in stock, or there are times when there are not enough to meet our normal production levels. It is a classic case of both understocking and overstocking. Ratnaparkhi, operations head, has been given two charges by Mittra. First, to develop an analysis of the data and present a report with recommendations. Second, “to come up with a report that even a lower grade clerk in stores should be able to fathom and follow.” In an effort to develop a report that is understood by all, Ratnaparkhi decides to provide incremental amounts of information to his operations manager, who is assigned the task of developing the complete analyses. A-Cat Corporation is committed to the pursuit of a robust statistical process control (quality control) program to monitor the quality of its transformers. Ratnaparkhi, aware that the construction of quality control charts depends on means and ranges, provides the following descriptive statistics for 2006 (from Exhibit 1). 2006 Mean 801.1667 Standard Error 24.18766 Median 793 Mode 708 Standard Deviation 83.78851 Sample Variance 7020.515 Kurtosis -1.62662 Skewness 0.122258 Range 221 Minimum 695 Maximum 916 Sum 9614 Count 12 The operations manager is assigned the task of developing descriptive statistics for the remaining years, 2007–2010, that are to be submitted to the quality control department. A-Cat’s president asks Mittra, his vice-president of operations, to provide the sales department with an estimate of the mean number of transformers that are required to produce voltage regulators. Mittra, recalling the product data from 2006, which was the last year he supervised the production line, speculates that the mean number of transformers that are needed is less than 745 transformers. His analysis reveals the following: t = 2.32 p = .9798 This suggests that the mean number of transformers needed is not less than 745 but at least 745 transformers. Given that Mittra uses older (2006) data, his operations manager knows that he substantially underestimates current transformers requirements. She believes that the mean number of transformers required exceeds 1000 transformers and decides to test this using the most recent (2010) data. Initially, the operations manager possessed only data for years 2006 to 2008. However, she strongly believes that the mean number of transformers needed to produce voltage regulators has increased over the three-year period. She performs a one-way analysis of variance (ANOVA) analysis that follows:
Answered Same DayDec 26, 2021

Answer To: Vice-president Arun Mittra speculates: We have always estimated how many transformers will be needed...

David answered on Dec 26 2021
113 Votes
Section V
Operational improvement recommendations to internal and external stakeholders based
on data
A. Summarization of analysis plan for both internal an
d external stakeholders
A-cat Corporation, being a manufacturer and distributor of electrical appliances including
transformers needed to produce its voltage regulators, operates in an extremely competitive
environment. It is essential for them to consider the impact of their strategic decisions on internal
and external stakeholders. The key internal stakeholders include the VP of A-Cat Corporation,
Arun Mittra, Head of Operations Ratnaparikhi, and the Manager of Operations and the Sales
Department as well as other employees who will be affected by the decisions of management.
The key external stakeholder is the customers of A-Cat Corporation.
The firm has been estimating the transformers requirement based on past sales data for a
few months. This has been resulting in under-stocking and overstocking to a great extent. The
quantitative analysis indicates that a decision of revamping the requirement forecast method is
essential. The statistical results show that the transformer requirements increase by 0.3154 units
for every one unit increase in the sales of the refrigerators, and statistically significant (p – value
= 0.0000 < 0.05). This indicates that there will be higher accuracy in forecasting requirements of
transformers.
The impact on internal shareholders as well as external shareholders is positive. It helps
the firm as well as its internal stakeholders ensure better management of resources and be...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here