Garment Oasis: Excel Solutions for Clothing Manufacturer

Running head: GARMENT OASIS
GARMENT OASIS
Name of the Student
Name of the University
Author Note

Running head: GARMENT OASIS
Task 0:
This assignment deals with producing solutions for garment oasis by using the excel
software. In garment Oasis which is a small clothing manufacturer company that produces
one of a kind garment sells the manufactured product through a particular online store. The
three staff members of the company are Anna, Barnardo and Carrie. Anna has the task of
manufacturing garments and Barnardo also does the same. Where Clyde manages the sales,
orders and delivery. The typical working hours of the persons are shown in the following
table.
Name Working days in the week Working hours(on
weekly basis)
Additional Working
hours(in week)
Anna Monday, Tuesday and
Wednesday
22.5 3
Barnard
o
Thursday and Friday 15 0
Carrie Every weekday 22.5 3
Task 1:
The operation cost is calculated in excel and then the total outgoing cost is obtained as given
below. The total outgoing cost is the sum of the annual cost of all the employees, yearly fixed
cost and annual utility cost.
Name Specific
Working
Working
hours(pe
Additional
Working
Total
Working
Hourl
y
Annu
al

Running head: GARMENT OASIS
days r week) hours(per
week)
hours (per
week)
rates(
in $)
cost(i
n $)
Anna Monday,
Tuesday and
Wednesday
22.5 3 25.5 26 34476
Barnardo Thursday and
Friday
15 0 15 26 20280
Carrie 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