View the step-by-step solution to:

Manufacturing dresses Dress receive requests through their online store, and Dham responds with a quote, after consulting with a member of the...

This question was created from ITECH1100 Understanding the Digital Revolution to be uploaded.docx https://www.coursehero.com/file/40682020/ITECH1100-Understanding-the-Digital-Revolution-to-be-uploadeddocx/

40682020-305083.jpeg

PLEASE SOLVE TASK 2 AND THE REST

40682020-305083.jpeg

Manufacturing dresses
Dress receive requests through their online store , and Cham responds with a quote , after
consulting with a member of the manufacturing team . If the customer confirms their order , Ram an
Shyam manufacture the ordered products , and Dham organizes delivery .
Currently , the process for generating a quote is entirely subjective , based on the requested materi
and dress 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 .

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question