Task 1 - Costs of operating the businessWorking HoursHourly PayWeeklyPayWorkingWeeksMondayTuesdayWednesdayThursdayFridaySaturdayAndres8.58.58.50002666348Bhavesh0007.57.512641648Cindy4.54.54.54.54.502454048Replacement66666039117012Total Salary91752Rent and Insurance9100Utilities Cost (monthly)260Utilities Cost (yearly)3120Total Operating Cost (yearly)103972The operating_costs.xlsx is an editable sheet for calculating the yearly operational cost, where one can easily edit working hours, hourly rates, and fixed and utility costs for calculating the operational cost. Angres and Bhavesh, as skilled manufacturing staff, cost $26 per hour to employ. Cindy, 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.Task 2 - Sales team offers
The above two line graphs shows the change in manufacturing cost ($) over time for different materials and sizes. The quoted price for Silk was highest and for Cotton was lowest. It is hard to
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Understanding of Digital Revolutionlg...
|11
|1032
|382
Projected Annual Costs of Running Suit Revivallg...
|5
|809
|156
Automate a Business Process and Impact of the Automationlg...
|6
|723
|415
Digital Revolutionlg...
|8
|911
|428
Automated Solution for Garment Oasis: Excel Assignmentlg...