80.2K

Verified Solution

Link Copied!

Fill the table above by using the random number function in the excel environment and solve the following questions

Find the maximum value, minimum value, and average value for each column.

If the unit sales price is less than the unit cost in randomly generated numbers, write the function that makes this value equal to the unit cost.

Which items have markups less than 25 percent?

Which item has the lowest sales?

What were Mr. Milligans biggest selling items last year? Identify the top five.

What are the companys total annual sales?

What is the companys annual gross profit?

What is the gross margin per unit for each inventory item? Which inventory item(s) has/have the largest gross margin per unit? Least?

The inventory is requested to be reduced by x $. (Randomly select the x value.) Which items would you recommend that he remove from his inventory? Why?

Assuming the employer requests a report from you, create table borders from the data, type the headings in bold font, and color the cells. (It will be in the same workbook, in a different sheet. Update the sheet's name to "Report".) (The "format cells" command must be used.)

\begin{tabular}{|l|l|l|l|l|} \hline Item No. & Unit Cost & Unit Sales Price & Average On Hand & Average Unit Sales/Year \\ \hline A001 & & & & \\ \hline A002 & & & & \\ \hline A003 & & & & \\ \hline A004 & & & & \\ \hline A005 & & & & \\ \hline A006 & & & & \\ \hline A007 & & & & \\ \hline A008 & & & & \\ \hline A009 & & & & \\ \hline A010 & & & & \\ \hline A011 & & & & \\ \hline A012 & & & & \\ \hline A013 & & & & \\ \hline A014 & & & & \\ \hline A015 & & & & \\ \hline A016 & & & & \\ \hline A017 & & & & \\ \hline A018 & & & & \\ \hline A019 & & & & \\ \hline A020 & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline Item No. & Unit Cost & Unit Sales Price & Average On Hand & Average Unit Sales/Year \\ \hline A001 & & & & \\ \hline A002 & & & & \\ \hline A003 & & & & \\ \hline A004 & & & & \\ \hline A005 & & & & \\ \hline A006 & & & & \\ \hline A007 & & & & \\ \hline A008 & & & & \\ \hline A009 & & & & \\ \hline A010 & & & & \\ \hline A011 & & & & \\ \hline A012 & & & & \\ \hline A013 & & & & \\ \hline A014 & & & & \\ \hline A015 & & & & \\ \hline A016 & & & & \\ \hline A017 & & & & \\ \hline A018 & & & & \\ \hline A019 & & & & \\ \hline A020 & & & & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer