Baraco is a very famous restaurant, located in a Banff Rocky Mountain Resort of AB$.$ Baraco Company Ltd$.$ is formed as a corporation January $1,2023.$

As the Controller of the company, you are required to manage the following transactions, record the journal entries including the adjusting journal entries,

GST returns,file a payroll return with CRA, prepare the period end financial statements, and various cost reports and financial analysis reports.

Transaction $1$

Transaction $1$: January $1,2023,$ common shares are issued for $$500,000$ cash

Dr$.$

Cr$.$

Transaction $2$

Due to shortage of cash for the business operations, on January $1,2023,$ the company borrowed $$400,000$ from CIBC bank at $7\mathrm{.}50\%$ interest rate.

The current portion of the loan is $$3,687,$ the long$-$term portion is $$396,313.$

Dr$.$

Cr$.$

Cr$.$

Transaction $3$

On Janauary $1,2023,$ Baraco paid $$4,200$ to EBS Insurance for a $1-$ year business insurance policy with the insurance coverage beginning on Jan. $1,2023.$

Dr$.$

Cr$.$

Transaction $4$

On Jan. $1,2023,$ Baraco signed a rent lease agreement with the landloard, HELMP, and paid three months rent in advance to HELMP for $$105,000,$ $$35,000$ per month, starting from January $2023.$

Dr$.$

Cr$.$

Transaction $5$

January $5,2023,$ Braco purchased an office furniture for $$200,000$ plust GST on account from Leon's furniture store.

Dr$.$

Dr$.$

Cr$.$

Transaction $6$

January $6,2023,$ Braco hired a contractor, Universal Co$.$ to conduct the renovation for the restaurant for $$350,000$ plus GST$.$

The project was completed on January $31,2023.$ $$200,000$ was paid in cash, the balance was on account

Dr$.$

Dr$.$

Cr$.$

Cr$.$

Transaction $7$

On Jan. $10,2023$ Baraco purchased a kitchen equipment for $$145,000$ plus GST from K & B Food Equipment, $$52,250$ paid in cash, the remaining balance is on account.

Dr$.$

Dr$.$

Cr$.$

Cr$.$

Transaction $8$

On Jan. $12,2023,$ the company purchased food inventory for $$45,000$ from Best Food Inc. and beverage inventory for $ $63,600$ from ALGC respectively on account.

Assume that there is no GST charged on those food items.

Please see the inventory in details below:

Food Inventory:

Dry Food $$8,600$

Meat $17,800$

Sea Food $3,600$

Produce $15,000$

Total $$45,000$

Beverage Inventory

Bottle Beer $$18,000$

Draft Beer $16,000$

Spirit Liquor $13,000$

Wine $8,600$

Soft Drinks $8,000$

Total $$63,600$

Dr$.$

Dr$.$

Dr$.$

Dr$.$

Cr$.$

Dr$.$

Dr$.$

Dr$.$

Dr$.$

Dr$.$

Dr$.$

Cr$.$

Transaction $9$

On Jan. $15,$ Baraco sold $$16,500$ of food and beverage of $$22,000$ to customers respectively. The customers paid in cash, credit card and other payment method.

Assume that Beraco uses a perpertual inventory system.

Please see the information below:

Food Sales $$16,500$

Bottle Beer Sales $$8,500$

Draft Beer $5,780$

Liquor $3,500$

Wine $3,260$

Soft Drinks $960$

Total Beverage $$22,000$

Payment details:

Cash $$3,740$

Debit Card $8,900$

Credit Card $16,500$

Mastercard $8,800$

Amex $560$

Cash on GST Collection $1,925$

Total Payment $$40,425$

Cost of products sold :

Dry Food $$1,560$

Meat $2,500$

Sea food $1,160$

Produce $1,380$

Total Food Cost $$6,600$

Bottle Beer $$2,350$

Draft Beer $2,140$

Liquor $1,980$

Wine $870$

Soft Drinks $360$

Total Beverage Cost $7,700$

Dr$.$

Cr$.$

Cr$.$

Cr$.$

Cr$.$

Cr$.$

Cr$.$

Cr$.-$

Dr$.$

Cr$.$

Dr$.$

Cr$.$

Dr$.$

Cr$.$

Dr$.$

Cr$.$

Dr$.$

Dr$.$

Dr$.$

Dr$.$

Dr$.$

Cr$.$

Please give answers in excel. thank you