Question
Jacket Frenzy is a small clothing manufacturer, specializing in creating custom, one-of-a-kind jackets. They exclusively sell their product through their online store. Jacket Frenzy is
Jacket Frenzy is a small clothing manufacturer, specializing in creating custom, one-of-a-kind jackets. They exclusively sell their product through their online store. Jacket Frenzy is run by a team of three staff members: April, Beatrice, and Claudia. April and Beatrice work together to manufacture jackets. Claudia manages orders, sales and delivery.
Jacket Frenzy receive requests through their online store, and Claudia responds with a quote, after consulting with a member of the manufacturing team. If the customer confirms their order, April and Beatrice manufacture the ordered products, and Claudia organizes delivery. Currently, the process for generating a quote is entirely subjective, based on the requested material and jacket 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 below
Quote date | Material | Size | Quote amount | Manufacturing cost ($) |
2018-06-04 | Cotton | S | 76.3 | 25.3 |
2018-06-05 | Cotton | L | 68 | 31 |
2018-06-06 | Wool | L | 80.3 | 47.1 |
2018-06-06 | Leather | XL | 247.6 | 71.8 |
2018-06-06 | Wool | L | 78 | 46 |
2018-06-07 | Wool | M | 94.8 | 39.6 |
2018-06-08 | Wool | XS | 154.1 | 30.3 |
2018-06-08 | Wool | L | 121 | 44 |
2018-06-11 | Wool | XS | 63.3 | 31.3 |
2018-06-11 | Tweed | XL | 169 | 82 |
2018-06-12 | Wool | XS | 91.3 | 32.1 |
2018-06-13 | Wool | L | 111.6 | 45.8 |
2018-06-13 | Tweed | XL | 238 | 81 |
2018-06-13 | Wool | XXL | 114.8 | 56.6 |
2018-06-14 | Wool | L | 123.1 | 46.3 |
2018-06-14 | Wool | M | 107 | 39 |
2018-06-14 | Wool | XXL | 116.3 | 56.3 |
2018-06-14 | Cotton | XL | 94 | 31 |
2018-06-15 | Wool | XL | 156.3 | 52.1 |
2018-06-18 | Silk | S | 363.6 | 86.8 |
2018-06-18 | Wool | XS | 74 | 32 |
2018-06-18 | Cotton | M | 83.8 | 26.6 |
2018-06-19 | Cotton | L | 70.1 | 28.3 |
2018-06-20 | Tweed | XXL | 198 | 97 |
2018-06-20 | Cotton | M | 71.3 | 24.3 |
2018-06-21 | Leather | XXL | 231 | 75 |
2018-06-21 | Tweed | XL | 222.3 | 82.1 |
2018-06-22 | Silk | M | 236.6 | 93.8 |
2018-06-22 | Wool | L | 166 | 50 |
2018-06-22 | Wool | M | 154.8 | 42.6 |
2018-06-25 | Wool | XS | 100.1 | 34.3 |
2018-06-26 | Wool | S | 93 | 41 |
2018-06-26 | Cotton | L | 91.3 | 29.3 |
2018-06-27 | Wool | L | 100 | 49 |
2018-06-27 | Wool | L | 103.3 | 49.1 |
2018-06-27 | Cotton | L | 79.6 | 28.8 |
2018-06-27 | Wool | XL | 129 | 54 |
2018-06-28 | Wool | S | 155.8 | 42.6 |
2018-06-29 | Wool | XXL | 156.1 | 64.3 |
2018-07-02 | Cotton | M | 64 | 24 |
2018-07-02 | Wool | XS | 106.3 | 35.3 |
2018-07-03 | Cotton | L | 86 | 29 |
2018-07-03 | Cotton | S | 78.3 | 22.1 |
2018-07-04 | Wool | XS | 106.6 | 35.8 |
2018-07-04 | Cotton | S | 64 | 22 |
2018-07-04 | Wool | L | 122.8 | 52.6 |
2018-07-05 | Tweed | XS | 250.1 | 55.3 |
2018-07-06 | Cotton | XXL | 100 | 34 |
2018-07-06 | Cotton | M | 84.3 | 25.3 |
2018-07-06 | Cotton | L | 92 | 28 |
2018-07-09 | Tweed | XS | 173.3 | 55.1 |
2018-07-09 | Cotton | XS | 70.6 | 19.8 |
2018-07-09 | Leather | XS | 160 | 42 |
2018-07-09 | Cotton | L | 89.8 | 28.6 |
2018-07-10 | Wool | L | 115.1 | 53.3 |
2018-07-10 | Cotton | M | 73 | 24 |
2018-07-10 | Silk | S | 384.3 | 88.3 |
2018-07-10 | Leather | L | 206 | 60 |
2018-07-11 | Wool | M | 127.3 | 46.1 |
2018-07-11 | Tweed | XS | 211.6 | 56.8 |
2018-07-11 | Cotton | XXL | 104 | 33 |
2018-07-11 | Wool | XXL | 155.8 | 64.6 |
2018-07-12 | Wool | S | 165.1 | 42.3 |
2018-07-12 | Wool | XS | 125 | 36 |
2018-07-13 | Tweed | S | 276.3 | 68.3 |
2018-07-13 | Wool | S | 144 | 42 |
2018-07-13 | Wool | XL | 134.3 | 57.1 |
2018-07-13 | Wool | XXL | 192.6 | 63.8 |
2018-07-16 | Wool | M | 122 | 48 |
2018-07-17 | Cotton | XL | 75.8 | 31.6 |
2018-07-18 | Cotton | XS | 58.1 | 18.3 |
2018-07-18 | Tweed | XXL | 316 | 105 |
2018-07-19 | Wool | M | 129.3 | 50.3 |
2018-07-20 | Wool | XXL | 173 | 69 |
2018-07-23 | Leather | XS | 182.3 | 38.1 |
2018-07-23 | Wool | XXL | 135.6 | 70.8 |
2018-07-23 | Wool | S | 121 | 44 |
2018-07-23 | Leather | L | 249.8 | 57.6 |
2018-07-24 | Cotton | S | 66.1 | 22.3 |
2018-07-24 | Cotton | L | 81 | 28 |
2018-07-24 | Cotton | S | 70.3 | 22.3 |
2018-07-24 | Wool | XS | 113 | 39 |
2018-07-25 | Cotton | XS | 74.3 | 18.1 |
2018-07-25 | Tweed | M | 230.6 | 76.8 |
2018-07-26 | Silk | XL | 291 | 130 |
2018-07-26 | Cotton | L | 84.8 | 27.6 |
2018-07-26 | Wool | XS | 114.1 | 38.3 |
2018-07-26 | Leather | S | 110 | 47 |
2018-07-27 | Cotton | XS | 53.3 | 18.3 |
2018-07-30 | Wool | XS | 107 | 38 |
2018-07-31 | Leather | XS | 193.3 | 37.1 |
2018-07-31 | Cotton | XS | 73.6 | 18.8 |
2018-08-01 | Leather | S | 222 | 44 |
2018-08-01 | Silk | XL | 532.8 | 127.6 |
2018-08-02 | Silk | S | 170.1 | 96.3 |
2018-08-02 | Wool | XXL | 189 | 71 |
2018-08-03 | Cotton | XXL | 95.3 | 33.3 |
2018-08-06 | Silk | M | 499 | 103 |
2018-08-07 | Leather | L | 213.3 | 55.1 |
Task - 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 word file(approximately 250-400 words), and attach the Excel file to your page.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started