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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started