Question

**Using Excel and discribe explanation** Garment Hola is a small clothing manufacturer, specializing in creating custom,...

**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.**

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
**Using Excel and discribe explanation** Garment Hola is a small clothing manufacturer, specializing in creating custom,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Scenario details Jacket Frenzy is a small clothing manufacturer, specializing in creating custom, one-of-a-kind jackets. They...

    Scenario details Jacket Frenzy is a small clothing manufacturer, specializing in creating custom, one-of-a-kind jackets. They exclusively sell their product through their online store. Jacket Frenzy is run by a team of three staff members: April, Beatrice, and Claudia. April and Beatrice work together to manufacture jackets. Claudia manages orders, sales and delivery. Team hours Most of the time, team members work the following shifts: April works 7.5 hours on Mondays, Tuesdays and Wednesdays; Beatrice works 7.5 hours on Thursdays...

  • Project Schedules and Scheduling Tools In this assignment, you will create a schedule for the month...

    Project Schedules and Scheduling Tools In this assignment, you will create a schedule for the month of December of this year for your team members—John, Sally, Pedro, and Eunice. While creating the schedule, keep in mind the following conditions: Every employee in the company needs to work for 45 hours per week. John works from Saturdays to Wednesdays in the 6:00 a.m. to 4:00 p.m. shift, with a 1-hour lunch break. Sally works from Mondays to Thursdays in the 3:00...

  • Jacket Frenzy is a small clothing manufacturer, specializing in creating custom, one-of-a-kind jackets. They exclusively sell...

    Jacket Frenzy is a small clothing manufacturer, specializing in creating custom, one-of-a-kind jackets. They exclusively sell their product through their online store. Jacket Frenzy is run by a team of three staff members: April, Beatrice, and Claudia. April and Beatrice work together to manufacture jackets. Claudia manages orders, sales and delivery. Jacket Frenzy receive requests through their online store, and Claudia responds with a quote, after consulting with a member of the manufacturing team. If the customer confirms their order,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT