Hire The Expertsminds Qualified Tutors And Get Best ITECH1100 Tuxedo Design Assignment Help Service!!

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

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.

Tuxedo Design Assignment.png

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.

Tuxedo Design Assignment1.png

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.

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

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.

Material

Size

Quote Amount

Cotton

XS

71.325

Cotton

S

69.02

Cotton

M

77.08888889

Cotton

L

86.78

Cotton

XL

89.18

Silk

XS

407.7666667

Silk

S

443.9666667

Silk

M

397.4

Silk

L

358.76

Silk

XL

543.08

Leather

XS

147.3375

Leather

S

185.7

Leather

M

163.1285714

Leather

L

203.14

Leather

XL

178.05

Wool

XS

124.5166667

Wool

S

140.8

Wool

M

140.5545455

Wool

L

119.1428571

Wool

XL

152.38

Tweed

XS

212.5

Tweed

S

183.575

Tweed

M

#DIV/0!

Tweed

L

197.3

Tweed

XL

194.3

Cotton

XXL

94.025

Silk

XXL

583.5

Leather

XXL

212.65

Wool

XXL

207.8714286

Tweed

XXL

#DIV/0!

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.

Material

Size

Quote Amount

Classification of Item

Manufacturing Decision

Cotton

XS

71.325

Not Popular

Wait

Cotton

S

69.02

Not Popular

Wait

Cotton

M

77.08888889

Not Popular

Wait

Cotton

L

86.78

Not Popular

Wait

Cotton

XL

89.18

Not Popular

Wait

Silk

XS

407.7666667

Popular

Start immediately

Silk

S

443.9666667

Popular

Start immediately

Silk

M

397.4

Popular

Start immediately

Silk

L

358.76

Popular

Start immediately

Silk

XL

543.08

Popular

Start immediately

Leather

XS

147.3375

Popular

Start immediately

Leather

S

185.7

Popular

Start immediately

Leather

M

163.1285714

Popular

Start immediately

Leather

L

203.14

Popular

Start immediately

Leather

XL

178.05

Popular

Start immediately

Wool

XS

124.5166667

Not Popular

Wait

Wool

S

140.8

Popular

Start immediately

Wool

M

140.5545455

Popular

Start immediately

Wool

L

119.1428571

Not Popular

Wait

Wool

XL

152.38

Popular

Start immediately

Tweed

XS

212.5

Popular

Start immediately

Tweed

S

183.575

Popular

Start immediately

Tweed

M

#DIV/0!

#DIV/0!

#DIV/0!

Tweed

L

197.3

Popular

Start immediately

Tweed

XL

194.3

Popular

Start immediately

Cotton

XXL

94.025

Not Popular

Wait

Silk

XXL

583.5

Popular

Start immediately

Leather

XXL

212.65

Popular

Start immediately

Wool

XXL

207.8714286

Popular

Start immediately

Tweed

XXL

#DIV/0!

#DIV/0!

#DIV/0!

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
Tag This :- EM201915HEM57CS ITECH1100 Tuxedo Design Assignment Help

get assignment Quote

Assignment Samples

    Mental Health Business Assignment Help

    mental health business assignment help - The present solution is based on the topic of mental healthcare consultancy, which is written in the form of a business

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