Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation And Management

Authors: Peter Rob, Carlos Coronel

6th International Edition

061921323X, 978-0619213237

More Books

Students also viewed these Databases questions