ITECH1100 Understanding the Digital Revolution

Costs
Adrian and Beatrice, as skilled manufacturing staffff, cost $24 per hour to employ.Carolyn, a part-time employee, costs $32 per hour to employ.All staffff are also entitled to four weeks of paid annual leave, during which a casual replacement is requiredat a cost of $36 per hour.Fixed costs such as rent and insurance are $18000 per year, and utilities costs are $460 per month.

Task 1 - Costs of operating the business
Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoingcosts of running Trousers Haus.Your spreadsheet should be confifigured such that the working hours, hourly rates, and fifixed and utility costscan be varied easily.Document your fifindings in your report (approximately 100 words).Manufacturing trousersTrousers Haus receive requests through their online store, and Carolyn responds with a quote, after consulting with a member of the manufacturing team. If the customer confifirms their order, Adrian and Beatrice manufacture the ordered products, and Carolyn organizes delivery. Currently, the process for generating a quote is entirely subjective, based on the requested material and trousers size. Staffff members quote an amount based on their personal experience. For several months, staffff have been keeping track of the quote date, material, size, quote amount, and manufacturing cost for each order in a spreadsheet. As each product is hand-made, the manufacturing cost may vary between similar orders. If a quote was not accepted by the customer, then manufacturing cost is not included. This spreadsheet is available for download on Moodle.

Task 2 - Order information Using Excel, process the history of orders spreadsheet and use appropriate charts to visualize: How some aspect of quoting or manufacturing has changed over time; and How the quote amount diffffered for each staffff member. You will need to fifind a way to use Excel to associate each quote with a staffff member. Describe your approach and your fifindings in your report