Tasks for Suit Design Company Analysis

Task 0
The Suit Design is a cloth manufacturing company and their staff handles the orders,
sales and the delivery of the orders. The three staffs who manages these sections are
Bhavneet, Albert and Claudia. The first task is to setting up an e-portfolio of the staffs with
the help of their work shift information. The yearly working hours and working days are
calculated using basic excel formulas.
Figure 1: e-portfolio
Source: created by author
Task 1
This task calculates the operation cost of the Suit Design by the company expenses.
The expenses are provided in the case study and the working rate of the Albert. Bhavneet and
Claudia. The yearly income of these three is calculated by adding and multiplying some data
in excel. The replacement t is allowed for paid, is about 4 weeks so according to the
replacement rate and the 4 weeks the yearly expense in replacement is also calculated. Then
the utility cost is multiplied by 12 to get the yearly utility cost as it was provided on the
monthly basis. At last al the total cost and incomes of the staff is added to get the total
operating cost of Suit Design.

Figure 2: Operating cost Calculation
Source: created by author
Task 2
This task is about the visually representation of the changes in quote amount over the
time. Chart is prepared using the Pivot chart in excel and the order is counted plotted
according to the date. The chart is represented as line chart for better representation.
Second, the changes of the manufacturing is also shown according to the dates and
using pivot chart feature in excel. Line chart is used for seeing the variations of
manufacturing date wise.
Figure 3: quote cost over time
Source: Created by author