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

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:

create a new spreadsheet 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. Justify your approach in word file (approximately 150 words), and attach your Excel file with word file

Quote unacceptable Review quate Confirm Order Quote acceptable ManufactureDelver item Send quote tem tem is not popular Quote unacceptable Done Confirm Order Quote acceptable Send quote Deliver item Item is n popular n stock Check Inventory X Manufacture tem stock