Assignment 1 - Dress Haus

Running head: ASSIGNMENT 1 - DRESS HAUS
Assignment 1 - Dress Haus
Name of the Student
Name of the University
Authors note

ASSIGNMENT 1 - DRESS HAUS
1
Task 0
For this project the main objective is automating the quoting process for the Dress
Haus products which are custom made according to the customer requirement or mentioned
for the order. The organization has three employees Alice, Bethany, and Carol. Two skilled
employees Alice and Bethany manufactures dresses on the other Carol who is a part time
employee is responsible for managing orders, sales and delivery of the dresses to the
customers.
Following table shows the total working hours and the wage/hour.
Nam
e Days
Day
Count
Shift
hours
Overt
ime
Total
Shift
Hour
Alice Mondays, Tuesdays and Wednesdays; 3 7.5 3 25.5
0
Beth
any Thursdays and Fridays 2 7.5 15
0
Caro
l
Mondays, Tuesdays, Wednesdays,
Thursdays, Fridays and Saturdays 6 4.5 3 30
Task 1
Operating cost for the business is given by the following table that is also present in
the accompanied excel sheet.
Name Days
Day
Cou
nt
Shif
tho
urs
Ov
erti
me
Total
Shift
Hour
Pay
/
Ho
ur
We
kly
Pay
Alice
Mondays, Tuesdays and
Wednesdays; 3 7.5 3 25.5
$
26.
00
$
663
.00
0 $

ASSIGNMENT 1 - DRESS HAUS
2
-
Bethany Thursdays and Fridays 2 7.5 15
$
26.
00
$
390
.00
0
$
-
Carol
Mondays, Tuesdays,
Wednesdays, Thursdays,
Fridays and Saturdays 6 4.5 3 30
$
24.
00
$
720
.00
Replacement
worker for 4
Weeks 70.5
$
39.
00
$2,
749
.50
Yearly
Payable to
Employees
Alice
$
34,476.00
Bethany
$
20,280.00
Carol
$
37,440.00
Replacement
Worker
$
10,998.00
Total
$
1,03,194.00
Insurance
Cost
$
9,100.00
Utility
cost($260/Mo
nth)
$
3,120.00
Total
Operation
al Cost
$
1,15,414.00