Goal Seek.xlsx

	A	B	C	D	E	F	G	H	I
1						Fixed Cost
2	Item	Cost per Unit ($)	Selling Price per Unit ($)	Quantity Sold	Cost of all Items ($)	Misc. Cost(Labour & Overhead costs)	Total Cost(Misc.+Cost of all items)	Total Revenue ($)	Profit ($)
3	Air conditioner	$1,200.00	1400	20	$24,000	$4,000	$28,000	28000	$0
4	Piano	$1,897.00	2350	4.4	$8,375	$2,000	$10,375	10375.27594	$0
5	Backup charger	$25.00	35	150	$3,750	$800	$4,550	5250	$700
6	Banknote counter	$140.00	160	98	$13,720	$600	$14,320	15680	$1,360
7	Blender	$540.00	620	24	$12,960	$550	$13,510	14880	$1,370
8	Dishwasher	$600.00	680	78	$46,800	$450	$47,250	53040	$5,790
9	Dvd player	$400.00	480	51	$20,400	$400	$20,800	24480	$3,680
10	Earphones	$180.00	260	65	$11,700	$300	$12,000	16900	$4,900
11	Radio	$450.00	520	82	$36,900	$2,500	$39,400	42640	$3,240
12	Refrigerator	$888.00	1100	56	$49,728	$3,000	$52,728	61600	$8,872
13	Fish tank	$1,254.00	1500	26	$32,604	$870	$33,474	39000	$5,526
14	Floor lamp	$75.00	110	98	$7,350	$350	$7,700	10780	$3,080
15	Game controller	$88.00	105	250	$22,000	$3,500	$25,500	26250	$750
16	Alarm clock	$40.00	65	120	$4,800	$1,500	$6,300	7800	$1,500
17	Oven	$1,510.00	1800	85	$128,350	$1,200	$129,550	153000	$23,450
18	Pressure cooker	$500.00	650	24	$12,000	$1,800	$13,800	15600	$1,800
19	Printer	$879.00	1100	65	$57,135	$2,200	$59,335	71500	$12,165
20	Projector	$1,980.00	2500	32	$63,360	$1,400	$64,760	80000	$15,240
21	Radio	$450.00	580	125	$56,250	$700	$56,950	72500	$15,550
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100