GET READYMADE ITECH1100 SOCK LAND ASSIGNMENT SOLUTIONS - 100% PLAGIARISM FREE WORK DOCUMENT AT NOMINAL CHARGES!

ITECH1100 Understanding the Digital Revolution Assignment - Sock Land, 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 -

• 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: Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Sock Land.

Answer - Costs of operating the business

Costs of working the corporation cost consists of settled charges, for instance, rent and safety, software price and labourer pay. In this undertaking we discover the charge of operating shape for "Sock Land" clothing manufacture Company. The Sock Land is those specializes in developing custom, one-of-a-type garments and completely sell their product via their on-line shop. We have test data that is collected from the Sock Land and we ought to determine cost of working structure. The enterprise accumulate has three people are Agnes, Bridget and Chad. The rate of walking Sock Land is given following:

MOST RELIABLE AND TRUSTWORTHY ITECH1100 SOCK LAND ASSIGNMENT HELP & HOMEWORK WRITING SERVICES AT YOUR DOORSTEPS!

Cost of Operating Sock Land Business

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 differed for each staff member. Describe your approach and your findings in your ePortfolio (approximately 250-400 words), and attach the Excel file to your page.

Answer - Order information

This challenge is used to visualize of quoting quantity or manufacturing has modified over the years and quoted amount differed for each personnel member. First, we need to classify the statistics set by the usage of the individual body of workers promoting info via manner of if announcement in excel sheet

=IF(OR(B2="Monday",B2="Tuesday",B2="Wednesday"),"Agnes & Chad",IF(OR(B2="Thursday",B2="Friday"),"Bridget & Chad","Chad"))

Now we have to calculate individual staff members of selling details using following formula

=SUMIF(G2:G199,"Agnes & Chad",E2:E199)

=SUMIF(G2:G199,"Bridget & Chad",E2:E199)

=SUMIF(G2:G199,"Chad",E2:E199)

The graph for the above result is suggests that Bridget & Chad quoting quantity is lower than Agnes & Chad. Even though Agnes & Chad operating 3 days in every week so they have basic quoted quantity is greater than Bridget & Chad. The underneath chart shows that without a doubt Monday, Tuesday and Wednesday has excessive quoted quantity than Thursday and Friday.

Form above chart we can finish that Agnes & Chad working together on Monday, Tuesday and Friday and they quoted amount is 24460.Five $ and Bridget and Chad working collectively on Thursday and Friday and they quoted quantity is 11563.Three$. The workforce Chad works on Saturday but no promote on Saturday. The chart showed absolutely that Agnes and Chad quoted excessive quantity than Bridget and Chad.

SAVE DISTINCTION MARKS IN EACH ITECH1100 SOCK LAND ASSIGNMENT WHICH IS WRITTEN BY OUR PROFESSIONAL WRITER!

Task 3 - Price consistency: Using Excel, analyse the historical data you have available, and create a spreadsheet that allows a member of the Sock Land team to enter the sock material and size, and gives a quote amount.

Answer - Price consistency

Improve the company consistency the profits crew decide to recovery quoted amounted primarily based on fabric, duration just so standardize inside the quoted fee. When analysed records of garment region facts we concluded that Agnes and Chad quoted amount about 4 times of manufacturing amount and Bridget and Chad quoted quantity about 2.6 times of producing. The below method is used to validate quoted amount with new quoted amount. The above said circumstance may be executed thru the subsequent additives this is used to calculate the modern-day quoted amount via entering into cloth, size with the aid of following method.

=IF(AND(C2="Wool",D2="S",G2="Agnes & Chad"),(F2+53), IF(AND(C2="Wool",D2="M", G2="Agnes & Chad"),(F2+120),IF(AND(C2="Wool",D2="L", G2="Agnes & Chad"),(F2+66),IF(AND(C2="Wool",D2="XL", G2="Agnes & Chad"),(F2+88),IF(AND(C2="Wool",D2="XXL", G2="Agnes & Chad"),(F2+71),IF(AND(C2="Wool",D2="XS", G2="Agnes & Chad"),(F2+70),IF(AND(C2="Wool",D2="S", G2="Bridget & Chad"),(F2+137),IF(AND(C2="Wool",D2="M", G2="Bridget & Chad"),(F2+47),IF(AND(C2="Wool",D2="L", G2="Bridget & Chad"),(F2+66),IF(AND(C2="Wool",D2="XL", G2="Bridget & Chad"),(F2+68),IF(AND(C2="Wool",D2="XXL", G2="Bridget & Chad"),(F2+116),IF(AND(C2="Wool",D2="XS", G2="Bridget & Chad"),(F2+106),IF(AND(C2="Cotton",D2="S",G2="Agnes & Chad"),(F2+44),IF(AND(C2="Cotton",D2="M", G2="Agnes & Chad"),(F2+46),IF(AND(C2="Cotton",D2="L", G2="Agnes & Chad"),(F2+42),IF(AND(C2="Cotton",D2="XL", G2="Agnes & Chad"),(F2+64),IF(AND(C2="Cotton",D2="XXL", G2="Agnes & Chad"),(F2+73),IF(AND(C2="Cotton",D2="XS", G2="Agnes & Chad"),(F2+41),IF(AND(C2="Cotton",D2="S", G2="Bridget & Chad"),(F2+100),IF(AND(C2="Cotton",D2="M", G2="Bridget & Chad"),(F2+7),IF(AND(C2="Cotton",D2="L", G2="Bridget & Chad"),(F2+37),IF(AND(C2="Cotton",D2="XL", G2="Bridget & Chad"),(F2+52),IF(AND(C2="Cotton",D2="XXL", G2="Bridget & Chad"),(F2+48),IF(AND(C2="Cotton",D2="XS", G2="Bridget & Chad"),(F2+71),IF(AND(C2="Silk",D2="S",G2="Agnes & Chad"),(F2+341),IF(AND(C2="Silk",D2="M", G2="Agnes & Chad"),(F2+136),IF(AND(C2="Silk",D2="L", G2="Agnes & Chad"),(F2+408),IF(AND(C2="Silk",D2="XL", G2="Agnes & Chad"),(F2+446),IF(AND(C2="Silk",D2="XXL", G2="Agnes & Chad"),(F2+567),IF(AND(C2="Silk",D2="XS", G2="Agnes & Chad"),(F2+407),IF(AND(C2="Silk",D2="S", G2="Bridget & Chad"),(F2+100),IF(AND(C2="Silk",D2="M", G2="Bridget & Chad"),(F2+151),IF(AND(C2="Silk",D2="L", G2="Bridget & Chad"),(F2+141),IF(AND(C2="Silk",D2="XL", G2="Bridget & Chad"),(F2+165),IF(AND(C2="Silk",D2="XXL", G2="Bridget & Chad"),(F2+250),IF(AND(C2="Silk",D2="XS", G2="Bridget & Chad"),(F2+195),IF(AND(C2="Tweed",D2="L", G2="Agnes & Chad"),(F2+127),IF(AND(C2="Tweed",D2="XS", G2="Agnes & Chad"),(F2+160),IF(AND(C2="Tweed",D2="L", G2="Bridget & Chad"),(F2+152),IF(AND(C2="Tweed",D2="XS", G2="Bridget & Chad"),(F2+138),IF(AND(C2="Leather",D2="S",G2="Agnes & Chad"),(F2+13),IF(AND(C2="Leather",D2="M", G2="Agnes & Chad"),(F2+17),IF(AND(C2="Leather",D2="L", G2="Agnes & Chad"),(F2+142),IF(AND(C2="Leather",D2="XL", G2="Agnes & Chad"),(F2+196),IF(AND(C2="Leather",D2="XXL", G2="Agnes & Chad"),(F2+183),IF(AND(C2="Leather",D2="XS", G2="Agnes & Chad"),(F2+166),IF(AND(C2="Leather",D2="S", G2="Bridget & Chad"),(F2+170),IF(AND(C2="Leather",D2="M", G2="Bridget & Chad"),(F2+59),IF(AND(C2="Leather",D2="L", G2="Bridget & Chad"),(F2+59),IF(AND(C2="Leather",D2="XL", G2="Bridget & Chad"),(F2+113),IF(AND(C2="Leather",D2="XXL", G2="Bridget & Chad"),(F2+126),IF(AND(C2="Leather",D2="XS", G2="Bridget & Chad"),(F2+68),0))))))))))))))))))))))))))))))))))))))))))))))))))))

HIRE PROFESSIONAL WRITER FROM EXPERTSMINDS.COM AND GET BEST QUALITY ITECH1100 SOCK LAND ASSIGNMENT HELP AND HOMEWORK WRITING SERVICES!

Task 4 - Process improvement: Extend your spreadsheet page from task 3 to automate the above processes, allowing a member of the team to enter the sock material and size, and in addition to the quote amount indicate whether to start manufacturing immediately. It is up to you do determine how to determine which items are popular.

Answer - Process improvement

The group need to beautify their quoting process to lessen time spent looking in advance to customers to approve costs. They would like to start production right now for orders that they is probably able to promote in future, notwithstanding the truth that the customer does no longer move earlier with the order. So Sock Land automate the strategies, allowing a member of the group to enter the garment material and length, and quote quantity to check whether or not or now not to start production at once or look ahead to client evaluation. Here we classified data primarily based on material, duration and frame of workers that is used to calculate the more famous products. The following additives are used to calculate quantity of wool products sold for various periods and team of workers people.

=COUNTIFS(C2:C199,"Leather",D2:D199,"M",G2:G199,"Agnes & Chad")

=COUNTIFS(C2:C199,"Leather",D2:D199,"M",G2:G199,"Bridget & Chad")

=COUNTIFS(C2:C199,"Leather",D2:D199,"S",G2:G199,"Agnes & Chad")

=COUNTIFS(C2:C199,"Leather",D2:D199,"S",G2:G199,"Bridget & Chad")

=COUNTIFS(C2:C199,"Leather",D2:D199,"XXL",G2:G199,"Agnes & Chad")

=COUNTIFS(C2:C199,"Leather",D2:D199,"XXL",G2:G199,"Bridget & Chad")

=COUNTIFS(C2:C199,"Leather",D2:D199,"L",G2:G199,"Agnes & Chad")

=COUNTIFS(C2:C199,"Leather",D2:D199,"L",G2:G199,"Bridget & Chad")

=COUNTIFS(C2:C199,"Leather",D2:D199,"XL",G2:G199,"Agnes & Chad")

=COUNTIFS(C2:C199,"Leather",D2:D199,"XL",G2:G199,"Bridget & Chad")

=COUNTIFS(C2:C199,"Leather",D2:D199,"XS",G32:G229,"Agnes & Chad")

=COUNTIFS(C2:C199,"Leather",D2:D199,"XS",G2:G199,"Bridget & Chad")

WE HELP STUDENTS TO IMPROVE THEIR GRADES! AVAIL TOP QUALITY ITECH1100 SOCK LAND ASSIGNMENT HELP AND HOMEWORK WRITING SERVICES AT CHEAPER RATE!

Similarly we calculated for all materials, size and staff members. Finally, we concluded the following table shows popular product.

The above shows that cotton has more popular product next wool and leather so these three products are considered as popular products and start manufacture immediately or else wait for customer review.

==IF(OR(C2="Cotton",C2="Wool",C2="Leather"),"Start Manufacturing","Wait for Review")

Item Status

Swimlane:

NEVER MISS YOUR CHANCE TO EXCEL IN ITECH1100 SOCK LAND ASSIGNMENT! AVAIL AFFORDABLE AND RELIABLE ITECH1100 SOCK LAND ASSIGNMENTS HELP SERVICES OF EXPERTSMINDS.COM!

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

• ITECH2003 - Web Design Assignment Help
• ITECH1101 - IT Problem Solving Assignment Help
• IITECH2002 - Systems Modelling Assignment Help
• ITECH1103 - Big Data And Analytics Assignment Help
• ITECH1102 - Networking And Security Assignment Help
• ITECH1400 - Foundations Of Programming Assignment Help
• ITECH1104 - Cloud And Enterprise Computing Assignment Help
• TECH2001 - Game Development Fundamentals Assignment Help
• ITECH2000 - Mobile Development Fundamentals Assignment Help
• ITECH1300 - Mobile Computing Platforms And Development Fundamentals Assignment Help