Mark Jacobs, owner of Jacob’s Mini-Mart currently operates two stores
in Atlanta. His business has been very successful, and he is now
opening two new stores. He will no longer be able to manage all stores
himself, so he is hiring managers for three of the four stores. He will
continue to operate one store, and act as general manager over the
company. He is looking for an easy and efficient way to collect
information from the stores, and he would like your help with the
PART 1 Marc wants you to design a worksheet for his managers to
complete showing the sales by product category by month at each store.
He wants to be sure the managers don’t change the formulas in the
worksheet. Describes the characteristics of the worksheet.
PART 2 Describe the process Mark will use in combining the completed worksheets into on workbook and creating the summary report