Assignment 1 – Garment CityOverviewFor this individual assignment, you will use skills acquired through practical laboratory exercises toautomate a business process, and to visualize the impact of the automation.You should use Microsoft Excel (or equivalent open-source software) for this assessment task.Important: This assignment specification is generated just for you. Do not distribute this specification. Ifyour personal specification is made publicly available online, academic misconduct charges may be applied.Timelines and ExpectationsPercentage value of task: 20%Due: Sunday, Week 7, 16:00 (See Course Description for date)Learning Outcomes AssessedThe following course learning outcomes are assessed by completing this assessment:A1. Prepare a basic solution to a business problem;A2. Select appropriate IT solutions for business functions;A3. Apply business information software for data visualization and analysis purposes.S1. Write basic programming logic;S3. Interpret and construct representations of business data flow and processes;K8. Outline the basic principles of programming.Assessment DetailsFor this assignment, you will complete the following set of tasks using Excel, and build an ePortfolio page todescribe your work.Task 0 – Setting upCreate an ePortfolio page for your assignment. You will submit this page to Moodle as per the lab tasks.You may call it whatever you like, for example ITECH1100 Assignment 1 – 30365985.Scenario detailsGarment City is a small clothing manufacturer, specializing in creating custom, one-of-a-kind garments.They exclusively sell their product through their online store.Garment City is run by a team of three staff members: Augusta, Benedict, and Celestine.Augusta and Benedict work together to manufacture garments. Celestine manages orders, sales anddelivery.CRICOS Provider No. 00103D Page 2 of 6Team hoursMost of the time, team members work the following shifts:Augusta works 7.5 hours on Mondays, Tuesdays and Wednesdays;Benedict works 7.5 hours on Thursdays and Fridays; andCelestine works 4.5 hours every weekday.Additionally, Augusta and Celestine share responsibility for managing the Garment City social mediapresence, with Augusta working one extra hour in the evenings on Monday, Tuesday and Wednesday, andCelestine doing the same on Thursday, Friday and Saturday.
