Excel Case 1A Parker opened The Great Sandwich Shop, LLC in Hometown, USA on August 1, 2021 The shop specializes in a variety of gourmet sandwiches and also sells bottles of their special homemade sauces and salads Congratulations You have been hired as the General Manager Your duties include maintaining the store's financial records The following transactions occurred in August 2021, the first month of operations Received four shareholders' contributions totaling $10,000 cash to form the corporation issued 400 shares of $1 par value common stock Paid two months' rent, in advance, for the store at $1,600 per month Purchased and received deli ingredients for $5,000 on account, due in 30 days Purchased supplies for $300 cash Negotiated and signed a two year $50,000 loan at the bank, receiving cash Used the money from (e) to purchase a computer for $1,400 (for recordkeeping and inventory tracking) used the balance for furniture and fixtures for the store Placed a grand opening advertisement in the local paper for $150 cash the ad ran in the current month Made sales during the grand opening week totaling $7,000 $3,000 was in cash and the rest on accounts receivable Product (Cost of Goods Sold) costs were $1,500 Made a $500 payment on accounts payable Incurred and paid employee wages of $2,100 Collected accounts receivable of $900 from customers Made a repair to one of the display cases for $300 cash Madecashsalesof$4,000duringtherestofthemonth Thecostofgoodssoldwas$500 Using the Excel, the following are required Set up appropriate T accounts for the following accounts Cash, Accounts Receivable, Supplies, Inventory, Prepaid Expenses, Equipment, Furniture and Fixtures, Accounts Payable, Notes Payable, Common Stock, Additional Paid in Capital, Sales Revenue, Cost of Goods Sold (expense), Rent Expense, Advertising Expense, Wage Expense, and Repair Expense All accounts begin with zero balances Record in the T accounts the result of each transaction for The Great Sandwich Shop in August, referencing each transaction in the accounts with the transaction letter Show the ending balances in the T accounts Note transactions (b), (h) and (m) require two types of entries, one for revenue recognition and one for the expense Prepare an income statement for the month ending August 31, 2021 Either in Word or as a text box in Excel, write a memo to Micah offering your opinion on the results of operations during the first month of business This is more than just a great job Consider what you would want to know as a business owner from a manager you have hired for the day to day activities What can be improved What seems odd for that type of business

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 15, 2024

Excel Case #1A Parker opened The Great Sandwich Shop, LLC in Hometown, USA on August 1, 2021. The shop specializes in a variety of gourmet

Excel Case #1A

Parker opened The Great Sandwich Shop, LLC in Hometown, USA on August 1, 2021. The shop specializes in a variety of gourmet sandwiches and also sells bottles of their special homemade sauces and salads. Congratulations! You have been hired as the General Manager. Your duties include maintaining the store's financial records. The following transactions occurred in August 2021, the first month of operations.

Received four shareholders' contributions totaling $10,000 cash to form the corporation; issued 400 shares of $1 par value common stock.
Paid two months' rent, in advance, for the store at $1,600 per month.
Purchased and received deli ingredients for $5,000 on account, due in 30 days.
Purchased supplies for $300 cash.
Negotiated and signed a two-year $50,000 loan at the bank, receiving cash.
Used the money from (e) to purchase a computer for $1,400 (for recordkeeping and inventory

tracking); used the balance for furniture and fixtures for the store.
Placed a grand opening advertisement in the local paper for $150 cash; the ad ran in the current

month.
Made sales during the grand opening week totaling $7,000; $3,000 was in cash and the rest on

accounts receivable. Product (Cost of Goods Sold) costs were $1,500.
Made a $500 payment on accounts payable.
Incurred and paid employee wages of $2,100.
Collected accounts receivable of $900 from customers.
Made a repair to one of the display cases for $300 cash.
Madecashsalesof$4,000duringtherestofthemonth.Thecostofgoodssoldwas$500.

Using the Excel, the following are required:

Set up appropriate T-accounts for the following accounts: Cash, Accounts Receivable, Supplies, Inventory, Prepaid Expenses, Equipment, Furniture and Fixtures, Accounts Payable, Notes Payable, Common Stock, Additional Paid-in Capital, Sales Revenue, Cost of Goods Sold (expense), Rent Expense, Advertising Expense, Wage Expense, and Repair Expense. All accounts begin with zero balances.
Record in the T-accounts the result of each transaction for The Great Sandwich Shop in August, referencing each transaction in the accounts with the transaction letter. Show the ending balances in the T-accounts. Note: transactions (b), (h) and (m) require two types of entries, one for revenue recognition and one for the expense.
Prepare an income statement for the month ending August 31, 2021.
Either in Word or as a text box in Excel, write a memo to Micah offering your opinion on the

results of operations during the first month of business. This is more than just a great job. Consider what you would want to know as a business owner from a manager you have hired for the day to day activities. What can be improved? What seems odd for that type of business?