You will be creating an Excel business model for Eastern Mobile to track sales and inventory as part of this assignment. Here is the situation: A local retailer of cell phones and accessories is called Eastern Mobile. The business operates one store in Maryland and two stores in Virginia. 

Step-by-step explanation

 You must input the information into the spreadsheet before using formulas to determine the total cost of each order and the quantity of phones sold. In order to keep track of the stock levels of the various phone models, you will also need to develop a chart.

The business provides both feature phones and smartphones, as well as a range of phone accessories like cases, chargers, and screen protectors. Sales for the business are increasing, and two additional locations—one each in Virginia and Maryland—will be opened within the upcoming year. 

You have been instructed by the corporation to create an Excel business model to track revenue and inventory for the upcoming year. You will create a sales and inventory tracker for Eastern Mobile as part of this project. Three worksheets will be included in the tracker: one for sales, one for inventory, and one for shop data. 

Data on sales for the three stores will be tracked in the Sales worksheet. The sales information will consist of the sale date, store information, phone type, quantity sold, and price per unit. You will be developing a SAM project for an Eastern Mobile in this module. In eastern states, the corporation offers the sale of cell phones and service subscriptions. 

The project will keep tabs on customer data, orders placed by customers, and product inventory. A spreadsheet will be used to keep track of this data. There will be three worksheets in the spreadsheet: Customer information will be on the first worksheet. Name, address, phone number, and the service plan the consumer is on will all be included in this. 

Orders will be tracked on the second worksheet. This will include the name of the consumer, the phone they ordered, the phone’s pricing, the service plan’s price, and the overall cost. The product inventory will be tracked on the third worksheet. This will comprise the phone’s model, cost, quantity of units left on hand, and sales figures.