ITECH1100 | Understanding The Digital Revolution | Information technology

Home Recent Questions ITECH1100 | Understanding The Digital Revolution | Information technology

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 Sock World.

Your spreadsheet should be configured such that the working hours, hourly rates, and fixed and utility costs can be varied easily.

Document your findings in your ePortfolio page (approximately 100 words).

Manufacturing socks


Sock World receive requests through their online store, and Calvin responds with a quote, after consulting with a member of the manufacturing team. If the customer confirms their order, Albert and Bianca manufacture the ordered products, and Calvin organizes delivery.

Currently, the process for generating a quote is entirely subjective, based on the requested material and sock size. Staff members quote an amount based on their personal experience.

For several months, staff have been keeping track of the quote date, material, size, quote amount, and manufacturing cost for each order in a spreadsheet. As each product is hand-made, the manufacturing cost may vary between similar orders.

If a quote was not accepted by the customer, then manufacturing cost is not included.

This spreadsheet is available for download on Moodle.

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.

You will need to find a way to use Excel to associate each quote with a staff member.
 
Describe your approach and your findings in your ePortfolio (approximately 250-400 words), and attach the Excel file to your page.

Task 3 - Price consistency

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

Ensure that you include enough text and formatting to make your spreadsheet usable by a member of the Sock World team (or by a University lecturer).

You may base your quote amount either on historical averages, or to ensure that Sock World makes a profit.

Validate your quoting approach by applying your formula to historical data.

Justify your approach in your ePortfolio (approximately 150 words), and attach your Excel file to your ePortfolio.


Process improvement

The team want to improve their quoting process to reduce time spent waiting for customers to approve quotes.

They would like to start manufacturing immediately for orders that they might be able to sell in future, even if the customer does not go ahead with the order.

That is, they would like to change to the processes indicated in the following swimlane diagrams:
 
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 sock 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.

Justify your approach in your ePortfolio (approximately 150 words), and attach your Excel file to your ePortfolio.
Bonus challenge task (optional!)

Disclaimer:
This task is 100% optional, and you can receive full marks without attempting or completing it. It is intended to be a challenge if you are interested in such things, and the marks available do not reflect the significant research and effort required to implement it correctly. Tutors will not provide significant assistance for this challenge task.

Search Here

Latest Reviews

  • Marcus
    30 Apr, 2019

    My assignment help services are provided in the best way by this website. The writers have completed my assignment in such a way that they helped me increase my overall performance.

  • Emy
    29 Apr, 2019

    Awesome work done by the experts of this company. I visited this site to get math assignment completed. My assignment was complete in every aspect. Thanks to the professionals who provided assignment writing help.

  • Darina
    25 Apr, 2019

    All thanks to the writers of Assignment Help 4 Me who completed my Physics assignment in the right manner. The structure of the assignment was totally customized according to my needs and that too at cheap prices.

View All Reviews

Facebook

Assignment Help 4 Me