Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you make me the full solution please. The photo on excel its this for help to answer the word answers. Assignments 4-Problems begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} hline
can you make me the full solution please.
Assignments 4-Problems \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 1 & OrderDate & Region & Rep & Item & Units & Total & Unit Cost & & & & & & & \\ \hline 2 & 2014-01-09 & Central & Smith & Desk & 2 & 250.00 & & & & & & & & \\ \hline 3 & 20150617 & Central & Thompson & Desk & 5 & 625.00 & & SALES & Desk & Pencial & Binder & Pen Set & Pen & Totals \\ \hline 4 & 20151009 & Central & Gill & Pencil & 7 & 9.03 & & Central & 7 & 7 & 98 & 96 & 27 & \\ \hline 5 & 2015-11-17 & Central & Jardine & Binder & 11 & 54.89 & & East & 0 & 95 & 92 & 136 & 160 & \\ \hline 6 & 20150102 & Central & Smith & Binder & 87 & 1305.00 & & West & 15 & 88 & 64. & & 76 & \\ \hline 7 & 20140226 & Central & Gill & Pen & 27 & 539.73 & & Totals & & & & & & \\ \hline 8 & 20141125 & Central & Thompson & Pen Set & 96 & 479.04 & & & & & & & & \\ \hline 9 & 2015-04-07 & East & Jones & Pen Set & 62 & 309.38 & & & & & & & & \\ \hline 10 & 20141022 & East & Jones & Pen & 64 & 575.36 & & & & & & & & \\ \hline 11 & 20141229 & East & Parent & Pen Set & 74 & 1183.26 & & \multirow{3}{*}{\begin{tabular}{l} Average Sales \\ pers Region: \end{tabular}} & Central & East & West & & & \\ \hline 12 & 2015-05-23 & East & Jones & Binder & 11 & 219.89 & & & Central & East & & & & \\ \hline 13 & 20140729 & East & Parent & Binder & 81 & 1619.19 & & & & & & & & \\ \hline 14 & 2014-06-01 & East & Jones & Pencil & 95 & 189.05 & & & & & & & & \\ \hline 15 & 20150427 & East & Howard & Pen & 96 & 479.04 & & & & & & & & \\ \hline 16 & 20150824 & West & Sorvino & Desk & 3 & 825.00 & & & & & & & & \\ \hline 17 & 20150703 & West & Sorvino & Binder & 7 & 139.93 & & & & & & & & \\ \hline 18 & 20140522 & West & Thompson & Pencil & 32 & 63.68 & & & & & & & & \\ \hline 19 & 2014-03-15 & West & Sorvino & Pencil & 56 & 167.44 & & & & & & & & \\ \hline 20 & 20141129 & West & Thompson & Desk & 12 & 3.00 & & & & & & & & \\ \hline 21 & 20151014 & West & Thompson & Binder & 57 & 1139.43 & & & & & & & & \\ \hline 22 & 20150927 & West & Sorvino & Pen & 76 & 151.24 & & & & & & & & \\ \hline 23 & & & & & & & & & & & & & & \\ \hline 24 & & & & \multicolumn{2}{|c|}{ Total sales: } & & & & & & & & & \\ \hline 25 & & & & & & & & & & & & & & \\ \hline 26 & & & & \multicolumn{2}{|c|}{ Max product price: } & & & & & & & & & \\ \hline 27 & & & & & & & & & & & & & & \\ \hline 28 & & & & & & & & & & & & & & \\ \hline \end{tabular} Assignments 4-Problems \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 1 & OrderDate & Region & Rep & Item & Units & Total & Unit Cost & & & & & & & \\ \hline 2 & 2014-01-09 & Central & Smith & Desk & 2 & 250.00 & & & & & & & & \\ \hline 3 & 20150617 & Central & Thompson & Desk & 5 & 625.00 & & SALES & Desk & Pencial & Binder & Pen Set & Pen & Totals \\ \hline 4 & 20151009 & Central & Gill & Pencil & 7 & 9.03 & & Central & 7 & 7 & 98 & 96 & 27 & \\ \hline 5 & 2015-11-17 & Central & Jardine & Binder & 11 & 54.89 & & East & 0 & 95 & 92 & 136 & 160 & \\ \hline 6 & 20150102 & Central & Smith & Binder & 87 & 1305.00 & & West & 15 & 88 & 64. & & 76 & \\ \hline 7 & 20140226 & Central & Gill & Pen & 27 & 539.73 & & Totals & & & & & & \\ \hline 8 & 20141125 & Central & Thompson & Pen Set & 96 & 479.04 & & & & & & & & \\ \hline 9 & 2015-04-07 & East & Jones & Pen Set & 62 & 309.38 & & & & & & & & \\ \hline 10 & 20141022 & East & Jones & Pen & 64 & 575.36 & & & & & & & & \\ \hline 11 & 20141229 & East & Parent & Pen Set & 74 & 1183.26 & & \multirow{3}{*}{\begin{tabular}{l} Average Sales \\ pers Region: \end{tabular}} & Central & East & West & & & \\ \hline 12 & 2015-05-23 & East & Jones & Binder & 11 & 219.89 & & & Central & East & & & & \\ \hline 13 & 20140729 & East & Parent & Binder & 81 & 1619.19 & & & & & & & & \\ \hline 14 & 2014-06-01 & East & Jones & Pencil & 95 & 189.05 & & & & & & & & \\ \hline 15 & 20150427 & East & Howard & Pen & 96 & 479.04 & & & & & & & & \\ \hline 16 & 20150824 & West & Sorvino & Desk & 3 & 825.00 & & & & & & & & \\ \hline 17 & 20150703 & West & Sorvino & Binder & 7 & 139.93 & & & & & & & & \\ \hline 18 & 20140522 & West & Thompson & Pencil & 32 & 63.68 & & & & & & & & \\ \hline 19 & 2014-03-15 & West & Sorvino & Pencil & 56 & 167.44 & & & & & & & & \\ \hline 20 & 20141129 & West & Thompson & Desk & 12 & 3.00 & & & & & & & & \\ \hline 21 & 20151014 & West & Thompson & Binder & 57 & 1139.43 & & & & & & & & \\ \hline 22 & 20150927 & West & Sorvino & Pen & 76 & 151.24 & & & & & & & & \\ \hline 23 & & & & & & & & & & & & & & \\ \hline 24 & & & & \multicolumn{2}{|c|}{ Total sales: } & & & & & & & & & \\ \hline 25 & & & & & & & & & & & & & & \\ \hline 26 & & & & \multicolumn{2}{|c|}{ Max product price: } & & & & & & & & & \\ \hline 27 & & & & & & & & & & & & & & \\ \hline 28 & & & & & & & & & & & & & & \\ \hline \end{tabular} The photo on excel its this for help to answer the word answers.
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