ORDER NEW ITECH1100 HAT WORLD ASSIGNMENT & GET 100% ORIGINAL SOLUTION AND QUALITY WRITTEN CONTENTS IN WELL FORMATS AND PROPER REFERENCING.

ITECH1100 - Understanding the Digital Revolution - Federation University

Assignment - Hat World

Learning Outcomes

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.

EXPERTSMINDS.COM GIVES ACCOUNTABILITY OF YOUR TIME AND MONEY - AVAIL TOP RESULTS ORIGINATED ITECH1100 HAT WORLD ASSIGNMENT HELP SERVICES AT BEST RATES!

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

Solution:

Adrian and Brutus are skilled full time employees of red hat but Calvin is Part time employee of Red Hat
The Total cost of all the employees of Red Hat in regular period is
Adrian:-29172
Brutus:-17160
Calvin:-31680
The Total cost of all the employees of Red Hat in Leave period is
Adrian(Replacement):-3978
Brutus(Replacement):-2340
Calvin(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 Red Hat for the year.

GET ASSURED A++ GRADE IN EACH ITECH1100 HAT WORLD ASSIGNMENT ORDER - ORDER FOR ORIGINALLY WRITTEN SOLUTIONS!

Task 2 - Order information
Describe your approach and your findings in your ePortfolio (approximately 250-400 words), and attach the Excel file to your page.

Solution:

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.

Figure1:-Graph showing variation of quote amount with time.

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 in turn increase the quote amount.

Figure 2 Graph showing relationship between manufacturing cost and the Quote amount

ENDLESS SUPPORT IN ITECH1100 HAT WORLD ASSIGNMENTS WRITING SERVICES - YOU GET REVISED OR MODIFIED WORK TILL YOU ARE SATISFIED WITH OUR ITECH1100 HAT WORLD ASSIGNMENT HELP SERVICES!

Task 3 - Price consistency

Analyse the historical data you have available, and create a spreadsheet that allows a member of the Hat World team to enter the hat material and size, and gives a quote amount.

Solution:

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

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

Excel Sheet 1

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.

Solution:

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 150 then the item is classified as popular using "if" statement and if the quote amount is less than 150 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

SAVE DISTINCTION MARKS IN EACH ITECH1100 HAT WORLD ASSIGNMENT WHICH IS WRITTEN BY OUR PROFESSIONAL WRITER!

Listed below some of the major courses cover under our Federation University Assignment Help Service:-

• ITECH1102 Networking and Security Assignment Help
• ITECH1101 It Problem Solving Assignment Help
• ITECH1100 Understanding the Digital Revolution Assignment Help
• ITECH3000 It Professional Engagement Assignment Help
• ITECH2000 Mobile Development Fundamentals Assignment Help
• ITECH1103 Big Data and Analytics Assignment Help
• ITECH2300 Mobile Networks and Wireless Communications Assignment Help
• ITECH3002 Professionalism and Entrepreneurship Assignment Help
• ITECH2002 Systems Modelling Assignment Help
• ITECH3100 Cloud and Mobile Security Assignment Help
• ITECH2301 Network Architecture and Design Assignment Help
• ITECH3209 Project 2 Assignment Help