Business Decision Making: Excel Tools for Production Process Evaluation

Running Head: Business Decision Making
1
Project Report: Business Decision Making

Business Decision Making
2
Contents
Introduction.......................................................................................................................3
Purpose of the report.....................................................................................................3
Description of problem.................................................................................................3
Methodology.....................................................................................................................3
Findings............................................................................................................................5
Recommendation or conclusion.......................................................................................5
References.........................................................................................................................7

Business Decision Making
3
Introduction:
In the report, various excel tools have been evaluated to manage the production
process of ABCD limited. In this report, various excel tools have been used to reach over a
conclusion about the total production units. It explains that how much production units must
be produced of Football and Basketball by the company.
Purpose of the report:
The main purpose of conducting this study and prepare the report is to evaluate the
production process of ABCD limited and make a recommendation to the company about total
production units. This report explains to the management of the company that how much
basketball and football must be manufactured by the company to improve the profitability
position and the overall return of the company. This decision has been made after evaluating
all the production aspect of the business.
Description of problem:
The case explains that the ABCD is a manufacturing company which produces the
sports equipment that includes football and basketball. On the basis of the given machine
hours, total production units of the business has been measured. As well as various other
production aspects such as labour hour, selling price etc has also been taken into concern for
this report.
Methodology:
To evaluate the company’s production units and the level where the profitability level
of the business would be at its best, a excel report has been prepared. In order to solve the
case, machine hours has been taken into context and it has been found that in the given
machine hours how much units could be produced by the company which could be sold and
offer huge return to the company (Brooks & Mukherjee, 2013). The calculations brief the
total labour hour to produce the unit of basketball and football is 0.5 and 0.3 hour.
The evaluation explains that in case of manufacturing the football and basketball,
machine hours would be 21000 which are quite lesser than the available machine hours. So,
the company could improve the production level of equipments. In case of utilizing all the
machine hours, company should manufacture 55000 units and 40000 units of basketball and