PAC 2.1 - 2.5

In 2020 Sal Simonelli started Pizza My Heart Food Truck, Inc. with an old family recipe and one food truck in Fort Lauderdale, Florida. Pizza My Heart serves eleven types of pizzas, as well as breadsticks and chicken wings. They operate at local breweries in the Fort Lauderdale and Orlando areas. In 2021 Sal purchased a second food truck that his son, Franco, operates in Orlando, FL. Sal and Franco believe their business is doing well and are considering expanding to other Florida cities. This is the income statement for the last two years.

Pizza My Heart Database ormation Systems: Understand Relational Database Structure ion Systems You are an accountant at the accounting firm, DGJ, that is helping Pizza My Heart create a relational database for their business. You have already created the tables PIZZA MY HEART INCOME CTATEMENTT 203A ANO 2025 - The business wi trucks. lando for thei - The company began to turn a profit in 2025. Sales nearly doubled for the Fort Lauderdale truck and more than doubled for the Orlando truck. - With the rapid increase in sales, Sal and Franco needed a better way to capture their financial and non-financial data. Pizza My Heart Database PAC 2.1 Accounting Information Systems: Understand Relational Database Structure Now, you must create joins between the tables. PAC 2.2 Auditing: Create Analyses for Completeness of Cash first quarter. Use pivot tables where applicable. 1. Summarize daily sales, daily cash sales, and daily credit card sales by Truck 1. 2. Summarize daily deposits by Truck 1 . 3. Prepare a reconciliation of daily receipts with daily deposits. Then, identify if there are any daily sales that do not match daily deposits. PAC 2.3 Financial Accounting: Create Analyses of Sales You are preparing the first quarter sales results for Pizza My Heart. 1. Create a PivotTable that summarizes sales by Truck 1 and show the total sales for each month in the first quarter (January, February, March). 2. Create a PivotTable that summaries sales by product for the first quarter for Truck 1 . Sort the data from highest sales to lowest sales. PAC 2.4 Managerial Accounting: Create Analyses to Understand Costs per Product | You are a managerial accountant asked to prepare an analysis of costs. Use the purchases data file to answer the following questions with PivotTables: 1. What is the average of total costs per raw material ingredient? (Hint: use total costs, do not consider units). 3. Are there vendors that are charging higher than average costs for ingredients? PAC 2.5 Tax Accounting: Create Analyses to Plan for Expansion Florida population and sales tax by city data files to create a visualization that shows which cities have the largest populations and which also shows the tax rates by city. 1. What are the top ten most populated cities in Florida? 2. Use a PivotTable to determine the cities with the ten lowest tax rates. 3. Pizza My Heart is considering Tallahassee as a potential city for a new truck. Sal estimates that sales in the first year will be $150,000. How much sales tax will be collected