ABC is a premier Bakery located in Gaborone. Your role as data analyst is to aid in monitoring sales and enhance profit. You are tasked with analyzing the dataset containing information about products in stock and those sold have been provided with the dataset of product in stock and sold. You are also tasked to analyze the data and extract the necessary insights, and visually depict each product sales through a line Table $1$: Bakery Data for Analysis

To prepare for data analysis in the Excel sheet, please follow these steps:

Generate an Excel spreadsheet resembling Table $1.$

Compute the total scale value for the two weeks. Show the function used.

Update the inventory for each product if the product stock level is less than $5.$ Show the function used.

$[4$ Marks$]$