Another key part of NoTable's success is its designers, highly-paid artists who design the tables...

Question

Another key part of NoTable's success is its designers, highly-paid artists who design the tables with and for customers. They currently have five designers, and one is assigned to each purchase order. They meet extensively with each of the customers and develop comprehensive specifications.

Production steps and required raw materials are specified with the highest level of detail. Accuracy of cost estimates are of utmost importance for NoTable given that they determine a table's price.

You receive data generated by NoTable's ERP system that show the estimated and actual labor and material cost in dollars for each production order (table). You can find these data in the PurchaseOrders worksheet. You are asked to analyze how accurate the design specifications are both overall and among designers.

Determine and analvze the overall variances.

Compare variances among designers.

Please download the Excel input file. complete your Excel file. create your Word file. and submit (upload) your completed Excel and Word files.

pro2-q2-1-p1zygvxj.png pro2-q2-2-k3yg0te1.png pro2-q1-3-45nezuus.png pro2-q1-4-41xqunc1.png pro2-q2-data-k4begxhw.xlsx

Khushboo · Accepted Answer

PurchaseOrders
	PurchaseOrderId	Status	QuotedLeadTime	ActualLeadTime	Supplier	LaborEstimate	RawMaterialEstimate	LaborActual	RawMaterialActual	Designer	Designer Name	DeliveryStatus	Variances in material cost	Variances in Labor cost
	1	Delivered	30	28	1	28560.3	31416.33	26656.28	35224.37	1	Michelle Angelo	On Time	-3,808.04	1,904.02		Overall variances
	2	Delivered	30	45	3	1901.55	2263.75	2807.05	2535.4	5	Clara Walker	Disruptive	-271.65	-905.50		Particulars	Budgeted 	Actual	Difference	Favorable/Unfavorable
	3	Canceled	45	48	2	22416.52	20815.34	22416.52	29621.83	4	Alexandra Nanini	Cancelled	-8,806.49	- 0		Raw Material Cost	1249300.62	1230894.16	18406.46	Favorable
	4	Canceled	60		5	31322.72	19470.88	30476.16	26243.36	4	Alexandra Nanini	Cancelled	-6,772.48	846.56		Labor cost	1275584.72	1250193.7	25391.02	Favorable
	5	Delivered	90		6	30709.82	27096.9	23483.98	25290.44	5	Clara Walker	Early	1,806.46	7,225.84
	6	Delivered	120	133	3	5356.12	6312.57	4399.67	6503.86	5	Clara Walker	Late	-191.29	956.45
	7	Returned	60	63	2	14657.76	14250.6	15879.24	10993.32	3	Pierre Peiyo	Returned	3,257.28	-1,221.48
	8	Delivered	30	42	1	25033.8	17447.8	16689.2	21999.4	3	Pierre Peiyo	Disruptive	-4,551.60	8,344.60
	9	Returned	30		5	20146.62	22471.23	17822.01	15497.4	5	Clara Walker	Returned	6,973.83	2,324.61
	10	Delivered	60	75	3	28459.44	31403.52	29440.8	23552.64	5	Clara Walker	Disruptive	7,850.88	-981.36		ID	DesignerName	Raw Material Cost	Labor cost	Total variance
	11	Returned	30		2	8283	8283	7730.8	9387.4	4	Alexandra Nanini	Returned	-1,104.40	552.20		1	Michelle Angelo	19,757.81	-6,048.40	13,709.41
	12	Delivered	90	100	3	17558.72	21399.69	10974.2	13169.04	3	Pierre Peiyo	Late	8,230.65	6,584.52		2	Vincent Monet	-12,033.96	5,578.25	-6,455.71
	13	Canceled	45	46	1	11542.72	11542.72	8657.04	10460.59	5	Clara Walker	Cancelled	1,082.13	2,885.68		3	Pierre Peiyo	8,150.81	57,513.74	65,664.55
	14	Delivered	15	15	4	30997.05	20369.49	29225.79	23912.01	2	Vincent Monet	On Time	-3,542.52	1,771.26		4	Alexandra Nanini	-27,712.40	-27,618.44	-55,330.84
	15	Delivered	30	30	4	20634.04	16212.46	22107.9	16949.39	2	Vincent Monet	On Time	-736.93	-1,473.86		5	Clara Walker	30,244.20	-4,034.13	26,210.07
	16	Canceled			5	16238.75	16238.75	24033.35	14939.65	4	Alexandra Nanini	Cancelled	1,299.10	-7,794.60
	17	Delivered	45	40	2	7426.24	9363.52	9040.64	7426.24	5	Clara Walker	Early	1,937.28	-1,614.40
	18	Delivered	45	75	6	19417.97	13120.25	11545.82	11021.01	5	Clara Walker	Disruptive	2,099.24	7,872.15
	19	Delivered	30	29	1	12918.32	12501.6	10834.72	8334.4	3	Pierre Peiyo	On Time	4,167.20	2,083.60
	20	Returned			5	30191.35	31053.96	31916.57	21565.25	5	Clara Walker	Returned	9,488.71	-1,725.22
	21	Delivered	30	32	2	24288.28	16411	18380.32	14441.68	2	Vincent Monet	On Time	1,969.32	5,907.96
	22	Delivered	30	29	4	1188.2	1960.53	1366.43	2198.17	4	Alexandra Nanini	On Time	-237.64	-178.23
	23	Delivered	45	40	6	32941.24	22283.78	36816.68	26159.22	2	Vincent Monet	Early	-3,875.44	-3,875.44
	24	Delivered	45	123	5	33989.46	19993.8	36988.53	34989.15	5	Clara Walker	Disruptive	-14,995.35	-2,999.

Another key part of NoTable's success is its designers, highly-paid artists who design the tables with and for customers. They currently have five designers, and one is assigned to each purchase...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment