ARE YOU LOOKING FOR RELIABLE ITECH1100 TUXEDO DESIGN ASSIGNMENT HELP SERVICES? EXPERTSMINDS.COM IS RIGHT CHOICE AS YOUR STUDY PARTNER!

ITECH1100 Understanding the Digital Revolution Assignment - Tuxedo Design, Federation University, Australia

Overview - For this individual assignment, you will use skills acquired through practical laboratory exercises to automate a business process, and to visualize the impact of the automation.

Learning Outcomes Assessed -

• Prepare a basic solution to a business problem;
• Select appropriate IT solutions for business functions;
• Apply business information software for data visualization and analysis purposes.
• Write basic programming logic;
• Interpret and construct representations of business data flow and processes;
• Outline the basic principles of programming.

Task 1 - Costs of operating the business: Create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Tuxedo Design.

Allie and Barry are skilled full time employees of Tuxedo design but Cleo is Part time employee of Tuxedo Design

The Total cost of all the employees of Tuxedo design in regular period is

Allie:-29172

Barry:-17160

Cleo:-31680

The Total cost of all the employees of Tuxedo Design in Leave period is

Allie(Replacement):-3978

Barry(Replacement):-2340

Cleo(Replacement):-4680

Total Labour Cost for the year is 89010

Fixed cost:-$9100

Utility Cost;-$3160

To calculate manufacturing cost of whole unit we add fixed cost ,utility cost for year and total labour cost which gives the total cost as $101,230 Thus , this is operating cost of Tuxedo design for the year.

SAVE YOUR HIGHER GRADE WITH ACQUIRING ITECH1100 TUXEDO DESIGN ASSIGNMENT HELP & QUALITY HOMEWORK WRITING SERVICES OF EXPERTSMINDS.COM!

Task 2 - Order information: 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 differed for each staff member.

Quote amount is varying with time as shown in the chart of excel sheet named task 2. Quote amount is decreasing or increasing with time but there is no fix trend of its increase or decrease. Sometimes it goes to its lowest point and at the other times it reaches the peak but it has never crossed 800. It has always remained below 800.

Each staff member has different cost as every staff member has different salary which adds to manufacturing cost accordingly. So, every item has different Manufacturing cost depending upon its material, size and staff member. So,Manufacturing cost of an item can be attributed to three factors Material, size and Staff member .Manufacturing cost in turn has the direct bearing on quote amount as the manufacturing cost increase or decrease so is the quote amount varies accordingly. So, Variation of quote amount with each staff member can be related with the help of manufacturing cost. If we have to pay more to a staff member then it will lead to increase in manufacturing cost which will lead to increase in the quote amount.

Task 3 - Price consistency: Analyse the historical data you have available, and create a spreadsheet that allows a member of the Tuxedo Design team to enter the hat material and size, and gives a quote amount.

To associate material and Size with quote amount we have segregate the available data into different categories i.e.

DO YOU WANT TO EXCEL IN ITECH1100 TUXEDO DESIGN ASSIGNMENT? HIRE TRUSTED TUTORS FROM EXPERTSMINDS AND ACHIEVE SUCCESS!

To segregate data we have used nested if statement for each category and then counted the number of entries in each category with count function and then found the average quote amount for each category.

Excel Sheet 1

EXPERTSMINDS.COM ACCEPTS INSTANT AND SHORT DEADLINES ORDER FOR ITECH1100 TUXEDO DESIGN ASSIGNMENT - ORDER TODAY FOR EXCELLENCE!

Task 4 - Process improvement: Automate the above processes, allowing a member of the team to enter the hat material and size, and in addition to the quote amount indicate whether to start manufacturing immediately.

Since the items which are more in number in history have higher quote amount which indicates that they are more popular so we used the criteria that if the quote amount of an item in task 3 is greater than 130 then the item is classified as popular using "if" statement and if the quote amount is less than 130 then the item is classified as "not Popular". If the item is Popular then its manufacturing starts immediately otherwise, we have to wait for order confirmation.

Excel sheet 2

NEVER LOSE YOUR CHANCE TO EXCEL IN ITECH1100 TUXEDO DESIGN ASSIGNMENT - HIRE BEST QUALITY TUTOR FOR ASSIGNMENT HELP!

Avail the Federation University, Australia Assignment Help Service for its related units and courses such as:-

• ITECH1001 - COMMUNICATIONS AND TECHNOLOGY ASSIGNMENT HELP
• ITECH1002 - NETWORK OPERATING SYSTEMS ASSIGNMENT HELP
• ITECH1003 - NETWORK PROTOCOLS & SERVICES ASSIGNMENT HELP
• ITECH1004 - INTRODUCTION TO MULTIMEDIA ASSIGNMENT HELP
• ITECH1005 - BUSINESS INFORMATION SYSTEMS ASSIGNMENT HELP
• ITECH1006 - DATABASE MANAGEMENT SYSTEMS ASSIGNMENT HELP
• ITECH1100 - UNDERSTANDING THE DIGITAL REVOLUTION ASSIGNMENT HELP
• ITECH1101 - IT PROBLEM SOLVING ASSIGNMENT HELP
• ITECH1102 - NETWORKING AND SECURITY ASSIGNMENT HELP
• ITECH1103 - BIG DATA AND ANALYTICS ASSIGNMENT HELP
• ITECH1104 - CLOUD AND ENTERPRISE COMPUTING ASSIGNMENT HELP