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

Home   Course
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.

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.

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

### Assignment Samples

 Safety Measures Assignment Help safety measures assignment help - The task is based on the ability of a competent person to handle all the safety measures that goes in a construction site. World War I Assignment Help world war i assignment help - This essay discusses three most significant political changes in the century preceding the start of World War I. Awareness of Euthanasia Assignment Help awareness of euthanasia assignment help - prepare a portfolio of materials for your boss relating to a controversial topic in your current field of study MIS603 Microservices Architecture Assignment Help mis603 microservices architecture assignment help - the present solution is based on the microservices architecture. The Potential Impact of Machine Vision Assignment Help the potential impact of machine vision assignment help-Federation University, Australia-Explain the concepts of software development within key industries. Discussion Board Assignment Help the paper identified the newly established law in united states that creates an impact on the healthcare organizations. the newly established law that has been. Australian Taxation Assignment Help australian taxation assignment help - For Taxation purposes, is James a resident of Australia? What is the source of his salary from Sails International?

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