Desklib - Online Library for Study Material and Solved Assignments

Task 0:
The name of employee and their corresponding working hours in a week is represented in the
following table. The company named as Shirt Land is specialized in manufacturing shirts.
The work is divided among the three employees. Andrea and Bernita produces shirts while
Chris handles the sales and the delivery.
Name Specific Working days Working hours(per
week)
Additional Working
hours(per week)
Andre
a
Monday, Tuesday and
Wednesday
22.5 3
Bernit
a
Thursday and Friday 15 0
Chris Every weekday 22.5 3
Task 1:
Now, the wages and the fixed and utility cost in a year of the company is calculated by
suitable formula and with the provided information as given in the excel file. The table is
given below.

Name Specific
Working
days
Working
hours(pe
r week)
Additional
Working
hours(per
week)
Total
Working
hours (per
week)
Hourly
rates(i
n $)
Annua
l
cost(in
$)
Andrea Monday,
Tuesday and
Wednesday
22.5 3 25.5 26 34476
Bernita Thursday and
Friday
15 0 15 26 20280
Chris Every
weekday
22.5 3 25.5 24 31824
The
replacement
employee
66 39 10296
Yearly
Fixed
cost(in $)
9100
Annual
Utility
cost(in $)
3120
Annual
Total
Outgoing
cost(in $)
109096

So, the total outgoing cost of Shirt Land is $109096.
Task 2:
The different quote amount and manufacturing cost of the shirt in different date and time is
represented by the following bar charts.