Are You Looking For Best ITECH1100 Sock Land Assignment Help Service – Visit Expertsminds and Get Good Grades..!!

Home   Course  
Previous << || >> Next

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:

Quote date

Day

Material

Size

Quote amount

Manufacturing cost ($)

2018-06-04

Monday

Wool

XS

77.3

30.3

2018-06-05

Tuesday

Leather

XL

261

72.7

2018-06-06

Wednesday

Wool

S

69.3

38.5

2018-06-06

Wednesday

Cotton

M

70.7

26.1

2018-06-06

Wednesday

Silk

M

423.1

88.1

2018-06-07

Thursday

Silk

XXL

418.1

125.7

2018-06-07

Thursday

Wool

L

144.5

43.3

2018-06-07

Thursday

Wool

L

170.7

48

2018-06-08

Friday

Silk

M

225.3

95.3

2018-06-08

Friday

Leather

M

224

57.7

2018-06-08

Friday

Cotton

XXL

113.3

36.5

2018-06-11

Monday

Wool

M

97.7

40.1

2018-06-12

Tuesday

Cotton

L

82.1

29.1

2018-06-13

Wednesday

Wool

XL

92.1

51.7

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

Cost of Operating Sock Land Business

Team Members

Working hours per week (Hr. Mints)

Hourly rates ($)

Per Month Salary ($)

Casual Leave Replacement

Annual Salary

Agnes

25.5

26

2652

39

33150

Bridget

15

26

1560

39

19500

Chad

30

24

3120

39

39000

Fixed Cost



758.33


9100

Utility Cost



260


3120

Operating Cost



8350.33


103870

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.

Sock Land Assignment.jpg

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!

Leather, M, Agnes & Chad

5

Leather, M, Bridget & Chad

1

Leather, S, Agnes & Chad

6

Leather, S, Bridget & Chad

2

Leather, XXL, Agnes & Chad

4

Leather, XXL, Bridget & Chad

4

Leather, L, Agnes & Chad

2

Leather,L, Bridget & Chad

1

Leather, XL, Agnes & Chad

5

Leather,XL, Bridget & Chad

4

Leather, XS, Agnes & Chad

6

Leather,XS, Bridget & Chad

4

Total Leather Products

44

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

Material

No of Products

Cotton

61

Wool

57

Leather

46

Silk

28

Tweed

6


198

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:

Sock Land Assignment1.jpg

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
Tag This :- WPSM0582000905ITECH ITECH1100 Sock Land Assignment Help

get assignment Quote

Assignment Samples

    Social Conflict Assignment Help

    social conflict assignment help - The following assignment is a paper that analyses an article on a social conflict - the level of stability of families and the

Get Academic Excellence with Best Skilled Tutor! Order Assignment Now! Submit Assignment