Obtain A++ grades by taking ITECH1100 Hat World Assignment Help and Online Tutor Services!!

Home   Course   Federation University, Australia Assignment Help
Previous << || >> Next

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.

Graph showing variation of quote.jpg

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.

Graph showing variation of quote1.jpg

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.

Material

Size

Cotton

XS

Cotton

S

Cotton

M

Cotton

L

Cotton

XL

Silk

XS

Silk

S

Silk

M

Silk

L

Silk

XL

Leather

XS

Leather

S

Leather

M

Leather

L

Leather

XL

Wool

XS

Wool

S

Wool

M

Wool

L

Wool

XL

Tweed

XS

Tweed

S

Tweed

M

Tweed

L

Tweed

XL

Cotton

XXL

Silk

XXL

Leather

XXL

Wool

XXL

Tweed

XXL

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.

Material

Size

Quote Amount

Cotton

XS

62.24

Cotton

S

79.28181818

Cotton

M

72.78

Cotton

L

83.91428571

Cotton

XL

83.32

Silk

XS

553.925

Silk

S

546.3

Silk

M

347.7

Silk

L

521.4

Silk

XL

600.5714286

Leather

XS

144.95

Leather

S

169.6833333

Leather

M

182.0625

Leather

L

228.3

Leather

XL

189.9888889

Wool

XS

153.2727273

Wool

S

123.3444444

Wool

M

135.6130435

Wool

L

139.42

Wool

XL

166.5571429

Tweed

XS

197.4666667

Tweed

S

#DIV/0!

Tweed

M

250.5

Tweed

L

218.775

Tweed

XL

326.5

Cotton

XXL

103.325

Silk

XXL

554.3

Leather

XXL

174.8875

Wool

XXL

164.01

Tweed

XXL

#DIV/0!

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.

Material

Size

Quote Amount

Classification of Item

Manufacturing Decision

Cotton

XS

62.24

Not Popular

wait

Cotton

S

79.28181818

Not Popular

wait

Cotton

M

72.78

Not Popular

wait

Cotton

L

83.91428571

Not Popular

wait

Cotton

XL

83.32

Not Popular

wait

Silk

XS

553.925

Popular

wait

Silk

S

546.3

Popular

Start immediately

Silk

M

347.7

Popular

Start immediately

Silk

L

521.4

Popular

Start immediately

Silk

XL

600.5714286

Popular

Start immediately

Leather

XS

144.95

Not Popular

Start immediately

Leather

S

169.6833333

Popular

wait

Leather

M

182.0625

Popular

Start immediately

Leather

L

228.3

Popular

Start immediately

Leather

XL

189.9888889

Popular

Start immediately

Wool

XS

153.2727273

Popular

Start immediately

Wool

S

123.3444444

Not Popular

Start immediately

Wool

M

135.6130435

Not Popular

wait

Wool

L

139.42

Not Popular

wait

Wool

XL

166.5571429

Popular

wait

Tweed

XS

197.4666667

Popular

Start immediately

Tweed

S

#DIV/0!

#DIV/0!

Start immediately

Tweed

M

250.5

Popular

#DIV/0!

Tweed

L

218.775

Popular

Start immediately

Tweed

XL

326.5

Popular

Start immediately

Cotton

XXL

103.325

Not Popular

Start immediately

Silk

XXL

554.3

Popular

wait

Leather

XXL

174.8875

Popular

Start immediately

Wool

XXL

164.01

Popular

Start immediately

Tweed

XXL

#DIV/0!

#DIV/0!

Start immediately

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
Tag This :- WPS19SAN0205OTH, ITECH1100 Hat World Assignment Help

get assignment Quote

Assignment Samples

    Business Law Assignment Help

    business law assignment help - this report will discuss some of the practical cases and their solution based on the application of relevant law of contract.

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