Jacket Haus

ITECH1100 Understanding the Digital Revolution, Federation University, Australia

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

Question 1: Costs of operating the business

Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Jacket Haus.

Answer: Costs Of Operating The Business: The operating cost for any business will include the insurance cost, rent , settle expense, salary for labourer and utility cost. Here we are going to calculate operating cost for Jacket Haus business will include the utility cost and labourer salary and rent. This business of the history data collected which is used to make the system to fix automate manufacturing price. In this company Abbey, Bernice and Cindy are employs are working together with various shift days and timing. The following table shows the operating cost for Jacket Haus.

Question 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.

Answer: Order Information: The Jacket Haus has history of manufacturing details which is used to analysis the each employee sales and quote price. We need to classify the data by First, we need to classify the data individual staff selling details by if statement in excel sheet

=IF(OR(B3="Monday",B3="Tuesday",B3="Wednesday"),"Abbey &Cindy",IF(OR(B3="Thursday",B3="Friday"),"Bernice&Cindy","Cindy"))

Each employee of the selling details can calculate by following formula

=SUMIF(G3:G221,"Abbey & Cindy",E3:E221)

=SUMIF(G3:G221,"Bernice& Cindy",E3:E221)

=SUMIF(G3:G221,"Cindy",E3:E221)

This chart clearly states that Cindy won't quote any product alone on sat so total quote amount of Cindy is zero. When Abbey and Cindy work together and total quoted amount is 24244.9and Bernice and Cindyamount is 14898.8.

ORDER NEW JACKET HAUS ASSIGNMENT & GET 100% ORIGINAL SOLUTION AND QUALITY WRITTEN CONTENTS IN WELL FORMATS AND PROPER REFERENCING!

Question 3: Price consistency

Using Excel, analyse the historical data you have available, and create a spreadsheet that allows a member of the Jacket Haus team to enter the jacket material and size, and gives a quote amount.

Answer: Price consistency: The selling price should be consistency to maintain the business, so Jacket Haus team decided to fix selling price automatically which is based on previous collected data.The newly quote amount can be performed by average of each material and size. The following formula to calculate average of each material and generate new quote amount.

=IF(AND(C3="Wool",D3="S"),121.81,

IF(AND(C3="Wool",D3="M"),127.7889,

IF(AND(C3="Wool",D3="L"),145.9,

IF(AND(C3="Wool",D3="XL"),161.5846,

IF(AND(C3="Wool",D3="XXL"),161.5133,

IF(AND(C3="Wool",D3="XS"),116.9667,

Find Average of each material and size using following formula

=AVERAGEIFS(E2:E220,C2:C220,K2,D2:D220,K3)

Question 4: Process improvement

Extend your spreadsheet page from task 3 to automate the above processes, allowing a member of the team to enter the jacket 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: TheJacket Haus team decided to improve the process of quoting price to reduce the waiting time for customer to approve so this process can automate by the material , quoted amount and size of material to find the manufacture status such as start to manufacture or wait for customer review.The following formula is used to calculate number of wool products sold for various size and staff members.

=COUNTIFS(C3:C221,"Wool",D3:D221,"M")

=COUNTIFS(C3:C221,"Wool",D3:D221,"XXL")

=COUNTIFS(C3:C221,"Wool",D3:D221,"L")

=COUNTIFS(C3:C221,"Wool",D3:D221,"XL")

=COUNTIFS(C3:C221,"Wool",D3:D221,"XS")

GET ASSURED A++ GRADE IN EACH JACKET HAUS ASSIGNMENT ORDER – ORDER FOR ORIGINALLY WRITTEN SOLUTIONS!

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

The above shows that wool has more popular product next leather and cotton 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")

Business Process Model And Notation (BPMN)

MOST RELIABLE AND TRUSTWORTHY JACKET HAUS ASSIGNMENT HELP & HOMEWORK WRITING SERVICES AT YOUR DOORSTEPS!

Avail Premium Quality Federation University, Australia Assignment Help Service For Its Related Courses, Such As:

• ITECH1101 - IT Problem Solving Assignment Help
• ITECH1400 - Foundations Of Programming Assignment Help
• ITECH1104 - Cloud And Enterprise Computing Assignment Help
• ITECH1003 - Network Protocols & Services Assignment Help
• ITECH1102 - Networking And Security Assignment Help
• ITECH1004 - Introduction To Multimedia Assignment Help
• ITECH1005 - Business Information Systems Assignment Help
• ITECH1103 - Big Data And Analytics Assignment Help
• ITECH1006 - Database Management Systems Assignment Help
• ITECH1300 - Mobile Computing Platforms And Development Fundamentals Assignment Help