Excel Basics Project, Cost $1,$ Fall $25$

Brittany Baker is trying to create financial statements for her start$-$up company, Pizza Heaven. Brittany began the business on Jan $1,2025$ with a $$1,000$ investment from her parents. The year $2025$ is half over, and Brittany needs help to generate a profit and loss statement $($Income statement$)$ and Balance sheet. She can look online and ascertain that her cash is higher than she started the year with $($$$1,000).$

Two types of pizzas are sold, Vegetable and Carnivore. Brittany's business model is to buy the finished pizzas from her father, also a baker, shrink wrap them and ship with dry ice to states in the Southeastern US$.$ She purchased initial inventory of $50$ pizzas of each product in mid$-$January, $2025.$ Brittany pays her father $$11$ for the vegetarian and $$12$ for the meat pizza.

Sales have been good. Brittany advertises solely on her internet website. Pizza Heaven has sold $170$ vegetable and $150$ carnivore pizzas. She charges $$19$ and $$22$ each for the products, respectively. Her website hosting site charges $$\mathrm{.}65$ for each unit sold. Brittany has replenished her inventory by purchasing $150$ units of each type of pizza in March $2025$ from her father at the same cost as her initial inventory purchases. Brittany's other costs are packaging and shipping; she incurs $$4$ per pizza for these costs, regardless of pizza type. She does not currently pay herself a salary as she is running the business after her regular job.

TO DO:

Generate an income statement and balance sheet for Pizza Heaven using Excel. You will have $3$ worksheets within one workbook:

Input sheet: Type in the data given in this case;

Income statement: Create an income statement for the six months ended $\frac{6}{30}\frac{?}{25}.$ The income statement should look like this: