Having Issues In Digital Revolution Assignments? Hire Digital Revolution Assignment Help At Affordable Prices!

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

ARE YOU LOOKING FOR RELIABLE DIGITAL REVOLUTION ASSIGNMENT HELP SERVICES? EXPERTSMINDS.COM IS RIGHT CHOICE AS YOUR STUDY PARTNER!

ITECH1100 Understanding the Digital Revolution Assignment - Tuxedo Zone, Federation University, Australia

Learning Outcomes - The following course learning outcomes are assessed by completing this assessment:

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.

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 Tuxedo Zone.

Answer - Tuexedo zone is doing the business of cloth manufacturing. It creates custom Tuexedos for its customers. It has hired three employees to manage the operations of its business. Three employees are named as Amanda, Bridget, and Christina. Amanda and Bridget is involved in the manufacturing of the tuexedos while Christina is involved in managing order sales and delivery. The total operational cost of the business for the year is found by addition of its fixed costs, utility costs and cost incurred in retaining employees. The addition of all the costs for the year comes out to be $ 1,01,230.

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.

Answer - This task aims at finding the change incurred in the quote amount over the period given in the excel file. To find the change, we have added the quote amount for different months and plotted a graph showing the different months and quote amount increases exponentially in July. The quote amount remains constant for the month august and September.

Digital Revolution Assignment Figure.jpg

SAVE YOUR HIGHER GRADE WITH ACQUIRING DIGITAL REVOLUTION ASSIGNMENT HELP & QUALITY HOMEWORK WRITING SERVICES OF EXPERTSMINDS.COM!

The total quote amount for a month has never crossed 12000.

The manufacturing cost of the product directly depends on the labor cost as the manufacturing cost is the sum of the cost of labor, utility cost, fixed cost and other operational costs. The quote amount of the product also depends on the manufacturing cost. If the manufacturing cost increases then, the quote amount increase and if the manufacturing cost decrease then, the quote amount also decreases. To show the relationship between the manufacturing cost and quote amount which relates to the labor cost, we have found the sum of the manufacturing cost for different months and sum of the quote amount for different months.

Digital Revolution Assignment Figure1.jpg

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

Answer - To automate the process of the finding the price of the items, we have used material and size category for the different items. There are five different material in the company named as cotton, tweed, leather, silk and wool. These material items are available in different sizes named as xs, s, m, l, xl. We have separated the quote amount from the given sheet using the 'if' statement. Average price for each item is found and this shows the fixed price of each item.

Material

Size

Quote Amount

Cotton

XS

71.65294118

Cotton

S

74.32142857

Cotton

M

77.68

Cotton

L

74.92

Cotton

XL

81.525

Silk

XS

411.6333333

Silk

S

421.65

Silk

M

435.8833333

Silk

L

642.3

Silk

XL

442.6333333

Leather

XS

164.5714286

Leather

S

194.65

Leather

M

159.1

Leather

L

203.0666667

Leather

XL

164.6

Wool

XS

132.7142857

Wool

S

133.69

Wool

M

146.4875

Wool

L

142.2363636

Wool

XL

149.625

Tweed

XS

232

Tweed

S

#DIV/0!

Tweed

M

204

Tweed

L

268.775

Tweed

XL

238.3

Cotton

XXL

91.5

Silk

XXL

553.8333333

Leather

XXL

204.2

Wool

XXL

160.4384615

Figure 3 shows the quote amount of different items

DO YOU WANT TO EXCEL IN DIGITAL REVOLUTION ASSIGNMENT? HIRE TRUSTED TUTORS FROM EXPERTSMINDS AND ACHIEVE SUCCESS!

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 tuxedo material and size, and in addition to the quote amount indicate whether to start manufacturing immediately.

Answer - It is difficult to determine that which orders should be put in the waiting list and which orders should be put in the immediate manufacturing. We have chosen the quote amount criteria to segregate the orders in the respective categories. The orders which involves manufacturing of the material which are having the quote amount more than 135 are put in the immediate manufacturing list and the orders involving the manufacturing of the material which are having the quote amount less than 135 are put in the waiting list. 'If' statement is used to follow the criteria proposed above and segregate the items in their respective categories.

Material

Size

Quote Amount

Classification of Item

Manufacturing Decision

Cotton

XS

71.65294118

Not Popular

Wait

Cotton

S

74.32142857

Not Popular

Wait

Cotton

M

77.68

Not Popular

Wait

Cotton

L

74.92

Not Popular

Wait

Cotton

XL

81.525

Not Popular

Wait

Silk

XS

411.6333333

Popular

Start immediately

Silk

S

421.65

Popular

Start immediately

Silk

M

435.8833333

Popular

Start immediately

Silk

L

642.3

Popular

Start immediately

Silk

XL

442.6333333

Popular

Start immediately

Leather

XS

164.5714286

Popular

Start immediately

Leather

S

194.65

Popular

Start immediately

Leather

M

159.1

Popular

Start immediately

Leather

L

203.0666667

Popular

Start immediately

Leather

XL

164.6

Popular

Start immediately

Wool

XS

132.7142857

Not Popular

Wait

Wool

S

133.69

Not Popular

Wait

Wool

M

146.4875

Popular

Start immediately

Wool

L

142.2363636

Popular

Start immediately

Wool

XL

149.625

Popular

Start immediately

Tweed

XS

232

Popular

Start immediately

Tweed

S

#DIV/0!

#DIV/0!

#DIV/0!

Tweed

M

204

Popular

Start immediately

Tweed

L

268.775

Popular

Start immediately

Tweed

XL

238.3

Popular

Start immediately

Cotton

XXL

91.5

Not Popular

Wait

Silk

XXL

553.8333333

Popular

Start immediately

Leather

XXL

204.2

Popular

Start immediately

Wool

XXL

160.4384615

Popular

Start immediately

Figure 4: Table showing the orders list of different items

EXPERTSMINDS.COM ACCEPTS INSTANT AND SHORT DEADLINES ORDER FOR DIGITAL REVOLUTION ASSIGNMENT - ORDER TODAY FOR EXCELLENCE!

Avail the best Federation University, Australia Assignment Help for below mentioned units and courses:-

  • 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 :- Digital Revolution Assignment Help, WPS2001530930CS

get assignment Quote

Assignment Samples

    Transfer Pricing Assignment Help

    transfer pricing assignment help - Explain what is transfer pricing. Explain transfer pricing strategies and abuses in transfer pricing strategies

    HIPAA Laws Assignment Help

    Under this assignment the role of HIPAA is being discussed in favor of a patient;s privacy breach. The duty of an fiduciary is also included in the terms.

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