Question: Using Excel and discribe explanation Garment Hola is a small clothing manufacturer, specializing in creating custom, one-of-a-kind garments. They exclusively sell their product through their

Using Excel and discribe explanation

Garment Hola is a small clothing manufacturer, specializing in creating custom, one-of-a-kind garments. They exclusively sell their product through their online store.

Garment Hola is run by a team of three staff members: Amir, Bhargav, and Cone.

Amir and Bhargav work together to manufacture garments. Cone manages orders, sales and delivery.

Team hours

Most of the time, team members work the following shifts:

Amir works 7.5 hours on Mondays, Tuesdays and Wednesdays;

Bhargav works 7.5 hours on Thursdays and Fridays; and

Cone works 4.5 hours every weekday.

Additionally, Amir and Cone share responsibility for managing the Garment Hola social media presence, with Amir working one extra hour in the evenings on Monday, Tuesday and Wednesday, and Cone doing the same on Thursday, Friday and Saturday.

Costs

Amir and Bhargav, as skilled manufacturing staff, cost $26 per hour to employ. Cone, a part-time employee, costs $24 per hour to employ.

All staff are also entitled to four weeks of paid annual leave, during which a casual replacement is required at a cost of $39 per hour.

Fixed costs such as rent and insurance are $9100 per year, and utilities costs are $260 per month.

please provide each formulas which used in excel.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!