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 - Price consistency Using Excel, analyse the historical data you have available, and create a spreadsheet that allows a member of the Jacket Frenzy team to enter the jacket 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 Jacket Frenzy team (or by a University lecturer). You may base your quote amount either on historical averages, or to ensure that Jacket Frenzy makes a profit. Validate your quoting approach by applying your formula to historical data. Justify your approach in word file (approximately 150 words), and attach your Excel file