Tuxedo Central Cost Analysis: A Practical Assignment for ITECH1100

Desklib provides solved assignments and past papers to help students succeed.

ITECH1100 Understanding the Digital Revolution
Assignment – 1
Task 1
Student name
Student Id

Costs
This task help in analyzing the data of a cloth manufacturing company name – Tuxedo Central
which manufactures kinds of tuxedo. The company is based on three employees.
The first task is to find the overall cost Tuxedo Central spends on the organisation.
Utilities ( $ 3120) and Insurances & rent ($ 9100) as fixed rates. Employee cost depends on their
working hours and days.
Adrian goes for three working days i.e. Monday, Tuesday and Wednesday, giving 7.5 hours ($
26 per hour)
Barnardo goes for two working days i.e. .Thursday and Friday, giving 7.5 hours ($ 26 per hour)
Calvin goes for working every weekday giving 4.5 hours ($ 24 per hour)
With the help of Excel, the overall cost of organisation is calculated as $ 218068.0.
Adrian
(Manufacturing)
Calvin
(Sales, Deliver &
orders )
Barnardo
(Manufacturing)