Model Answers for Review and Discussion
1—What are the total estimated operating costs, excluding the pre-opening costs, for JD Corp. in their first year (pre COVID-19)?
Table 2.
Year 1 (pre-COVID) estimated operating costs. These are a composite of the sales statistics of three actual restaurants located in Long Island, New York.
Table 2.
Year 1 (pre-COVID) estimated operating costs. These are a composite of the sales statistics of three actual restaurants located in Long Island, New York.
Weekly Sales (Year 1) | | = | $28,230 |
Dining sales | $21,280 (760 × $28) | | |
+ Bar sales | $2800 | | |
+ Takeout sales | $1200 | | |
+ Catering sales | $2950 | | |
(grocery = $0) | | | |
Cost of Sales | | = | $9307.16 |
Dining | $6809.60 ($21,280 × 0.32) | | |
+ Bar | $672 ($2800 × 0.24) | | |
+ Takeout | $408 ($1200 × 0.34) | | |
+ Catering | $796.50 ($2950 × 0.27) | | |
+ Credit card processing | $621.06 ($28,230 × 80% × 2.75%) | | |
(grocery = $0) | | | |
Recurring Weekly Costs | | = | $ 14,589.19 |
Inventory and supplies | $1129.20 ($28,230 × 0.04) | | |
Accounting/books | $276.92 ($1200 × 12 ÷ 52) | | |
Rent | $1730.77 ($7500 × 12 ÷ 52) | | |
Utility | $415.38 ($1800 × 12 ÷ 52) | | |
Waste removal | $276.92 ($1200 × 12 ÷ 52) | | |
Insurance | $115 ($5980 ÷ 52) | | |
Dining room staff | $3300 (10 × 30 × $11) | | |
Kitchen staff | $3600 (8 × 30 × $15) | | |
Management salary | $2000 ($104,000 ÷ 52) | | |
Chef salary | $1394.23 ($72,500 ÷ 52) | | |
Website/Social media | $86.54 ($375 × 12 ÷ 52) | Gross Sales | $28,230.00 |
Cable/Internet/Phone | $196.15 ($850 × 12 ÷ 52) | - Cost | $9307.16 |
POS service plan | $68.08 ($295 × 12 ÷ 52) | - Cost | $14,589.19 |
| | Weekly Net Profit (Loss) | $4333.65 (× 52) |
Start-Up Costs |
$171,900
| Annual Net Profit (Loss) | $225,334.80 |
2a—What are the total estimated operating costs, excluding pre-opening costs, for JD Corp. in their second year (during COVID-19)?
Table 3.
Year 2 (during COVID) estimated operating costs. These are a composite of the sales statistics of three actual restaurants located in Long Island, New York.
Table 3.
Year 2 (during COVID) estimated operating costs. These are a composite of the sales statistics of three actual restaurants located in Long Island, New York.
Weekly Sales (Year 2) | | = | $13,740 |
Dining sales | $2640 (120 × $22) | | |
+ Bar sales | $400 | | |
+ Takeout sales | $9750 | | |
+ Grocery sales | $950 | | |
(catering = $0) | | | |
Cost of Sales | | = | $5096.38 |
Dining | $765.60 ($2640 × 0.29) | | |
+ Bar | $96 ($400 × 0.24) | | |
+ Takeout | $3315 ($9750 × 0.34) | | |
+ Grocery | $617.50 ($950 × 0.65) | | |
+ Credit card processing | $302.28 ($13,740 × 80% × 2.75%) | | |
(catering = $0) | | | |
Recurring Weekly Costs | | = | $10,442.86 |
Inventory and supplies | $824.40 ($13,740 × 0.06) | | |
Accounting/books | $276.92 ($1200 × 12 ÷ 52) | | |
Rent | $1774.04 ($7687.50 × 12 ÷ 52) | | |
Utility | $415.38 ($1800 × 12 ÷ 52) | | |
Waste removal | $276.92 ($1200 × 12 ÷ 52) | | |
Insurance | $115 ($5980 ÷ 52) | | |
Dining room staff | $1320 (4 × 30 × $11) | | |
Kitchen staff | $2250 (5 × 30 × $15) | | |
Management salary | $1384.62 ($72,000 ÷ 52) | | |
Chef salary | $1394.23 ($72,500 ÷ 52) | | |
Website/Social media | $86.54 ($375 × 12 ÷ 52) | | |
Cable/Internet/Phone | $196.15 ($850 × 12 ÷ 52) | Gross Sales | $13,740.00 |
POS service plan | $68.08 ($295 × 12 ÷ 52) | - Cost | $5096.38 |
COVID-19 expenses | $60.58 ($3150 ÷ 52) | - Cost | $10,442.86 |
| | Weekly Net Profit (Loss) | ($1799.24) (× 52) |
Start-Up Costs |
$171,900
| Annual Net Profit (Loss) | ($93,560.48) |
2b—What is the estimated breakeven point, excluding pre-opening costs, for JD Corp. during their first year (pre COVID-19)?
The estimated breakeven point measured in dollars is derived as follows:
In the case of multiple product sales, the contribution margin is the sum of the weighted average of the contribution margins of each of the products or services.
Table 4.
Breakeven analysis. These are a composite of the sales statistics of three actual restaurants located in Long Island, New York.
Table 4.
Breakeven analysis. These are a composite of the sales statistics of three actual restaurants located in Long Island, New York.
Product/Service | Contribution Margin (x) | % of Total Sales | =Weighted Avg CM |
---|
Dining sales | 100% − 32% = 68% | 75% | 51.0% |
Bar sales | 100% − 24% = 76% | 10% | 7.6% |
Takeout sales | 100% − 34% = 66% | 5% | 3.3% |
Catering revenue | 100% − 27% = 73% | 10% | 7.3% |
| Subtotal: CM | | 69.2% |
| Less: Variable Costs | | (6.2%) |
Credit card | 2.75% | 80% | 2.2% |
Inventory & supply | | | 4% |
| Contribution Margin CM | | 63% |
Breakeven point per week in $ = $9618.56/0.63 = $15,267
Selling above the breakeven point as profit
Below the breakeven point as loss
3—How should start-up costs be factored into Cost, Breakeven, and Return-On-Investment for first year (pre-COVID)?
The start-up costs are $171,000. If this is factored in the analysis, then the fixed costs will increase. The increase will be factored over the usable number of months on the lease term, which is for 60 months on 1 December 2018. However, the store opened on 1 March 2019, making the recovery period of the start-up costs 57 months.
Hence, the fixed costs will increase by $171,900/57 months = $3015.79
Total costs inclusive of these start-up costs = $3015.79 + $9618.63 = $12,634.63
Breakeven point inclusive of these start-up costs = $12,634.42/0.63 = $20,055
Return On Investment = Net Income (Loss) − Year/Investment = Net Income (Loss) Divided By $171,900
Net Income = $225,334.80/$171,900 = 131%
Net Loss = ($93,560.48)/$171,900 = (54%)
4—What is an estimated impact of PPP on funds that can be infused into operations?
1st round: to employer (2.5 × 2019 average monthly payroll)
2nd round: to employer (2.5 × 2019 average monthly payroll)
Table 5.
Impact of PPP on labor costs. These are a composite of the sales statistics of 3 actual restaurants located in Long Island, New York.
Table 5.
Impact of PPP on labor costs. These are a composite of the sales statistics of 3 actual restaurants located in Long Island, New York.
Employee Type | Weekly Salary ∗ Limit $100,000/52 = $1923 | Total Weekly Salaries |
---|
Dining Room | $3300 | $3300 |
Kitchen | $3600 | $3600 |
Management | $2000 (limit $1923) | $1923 |
Chef | $1393 | $1393 |
Total Weekly Salaries | | $10,217 |
| | ×52 |
2019 Salaries (52 weeks) | | $531,284 |
2019 Weekly Salaries (÷52) | | $44,273.67 |
Total PPP round 1 and round 2 = 3.5 times average monthly payroll $44,273.67 × 3.5 = $154,958
Total PPP forgiveness potential = $154,958 × 2 = $309,916
Business can apply for loan forgiveness 24 weeks after the origination of the loan. If the loan is not forgiven, the interest rate on the loan is 1% per annum payback over 60 months.
5—How did the Employee Retention Tax Credit (ERTC) impact breakeven?
The ERTC provided as much as $19,000 per employee to small businesses. The ERTC (under the original CARES ACT of March 2020—Coronavirus Aid, Relief, and Economic Security Act of 2020) was initially tabulated based on the following:
- (1)
A tax credit of up to $5000 per employee (50% of the first $10,000 in eligible wages);
- (2)
Gross receipts must have declined by >50% in any quarter 2020 versus 2019;
- (3)
Businesses could not apply for both PPP and ERTC;
- (4)
Limited to employers with 100 or fewer employees.
The changes to the ERTC under the Consolidated Appropriations Act (January 2021) were as follows:
- (1)
A tax credit of up to $5000 per employee (50% of the first $10,000 in eligible wages) for 2020 plus a tax credit of up to $7000 per employee (70% of the first $10,000) for each of the first two quarters. This amounts to a tax credit of up to $19,000 per employee.
- (2)
Payroll paid for using PPP funds does not qualify.
- (3)
Gross receipts must have declined by >20% in any quarter of 2020 versus 2019 (resulting in significantly more businesses qualifying). Did they decline >20%?
- (4)
Businesses could apply for both PPP and ERTC.
- (5)
The employee threshold (which includes all affiliate businesses) was raised to a 500-employee maximum.
- (6)
These provisions were made retroactive, meaning that these changes could be applied to 2020.
The Employee Retention Tax Credit was a refundable tax credit on a percentage of the first $10,000 paid to employees. Most businesses ignored the ERTC because the option was to apply for either the ERTC or the PPP, and the PPP provided more money. The Consolidated Appropriations Act changed this to allow businesses to apply for both and businesses could claim the credit retroactively.
The act also extended the credit into the first two quarters of 2021 and raised the amount so that this credit exceeded what many businesses received in PPP, and they could apply for both. Between 12 March 2020 and 30 June 2021, the span of the credit, this could have amounted to up to $19,000 in tax credits per employee.
The qualifications were different for 2020 and 2021, but most hospitality businesses, even newly opened ones that did not qualify for PPP, qualified for the ERTC. While the concept was simple, the details of this credit were complex. Businesses were not able to use the same payroll used for forgiven PPP loans to receive the ERTC. Also, in some instances, businesses were deducting expenses on their tax return that they did not actually pay. To receive the maximum credit and calculate everything correctly, the accounting aspect was extremely important. Businesses that did not do so faced penalties and/or overpaid on their taxes.
6—What other federal relief was provided for businesses?
During most of 2020, this allowed a tax credit of up to two weeks of pay for employees absent due to reasons related to Coronavirus. Under the Consolidated Appropriations Act, this credit was extended to 31 March 2021.
Access Date: 20 December 2022
Most struggling businesses received first round PPP, whereby they were eligible to receive up to 2.5 months of payroll expenses. Fewer businesses qualified for the second round, but many in the hospitality industry qualified for both. For businesses with a NAICS code beginning with “72,” the second draw was up to 3.5 months of payroll expenses. Those businesses that qualified for both but did not apply for the first round were permitted to apply for the first round PPP ex post facto, utilize those funds, and then apply for the second round before 31 March 2021.
Access Date: 21 December 2022
This is a Federal tax credit of between $2900 and $9600 available to employers for hiring individuals from certain targeted groups who have consistently faced significant barriers to employment. The credit is applicable to each employee hired. Originally set to expire in 2020, the Consolidated Appropriations Act has been extended through 2025.
Access Date: 21 December 2022
This program provides credits against federal tax obligations when opening or expanding a business in an economically disadvantaged community. Originally set to expire in 2020, the Consolidated Appropriations Act has been extended through 2025.
Access Date: 20 December 2022
While not credits or forgivable loans, these low interest rate loans of up to $150,000 are available through the SBA.
Access Date: 20 December 2022
7—What are some suggestions for reducing operating costs during COVID-19?
Reduce scope of the menu and product offerings (fewer ingredients to purchase, purchase fewer materials, purchase ingredients in bulk); reduce the portion size of menu items to reduce inventory usage; re-evaluate the grade of products sold (lower grade is lower cost); re-negotiate rent; minimize staffing (discuss how this may impact customer satisfaction); have salaried managers take on additional hourly employee duties; minimize paid advertising; focus on social media, which is a lower cost alternative.
8—What are some suggestions for increasing alternative revenue streams and increasing takeout, grocery sales, and delivery?
Sell groceries as a convenience for customers (takeout and delivery); focus social media campaigns on takeout, delivery, and the lift of the ban on to-go alcohol sales; promote off-premise catering; sell bottled water; charge for bread.
9—What impact did the promotion of the delivery and takeout of alcohol (lift on ban) have on revenue?
The impacts included increased revenue, the opening of sales to a broader market, and more frequent patronage.
10—What was the impact of delivery, takeout, and grocery sales on perceived value? On food quality?
Delivery, takeout and grocery sales may have diminished the perceived value (not a full-service meal, no restaurant atmosphere—music, ambiance, décor; food quality deteriorates in take-out packaging—yet meal price remains the same or is increased).
11—What additional risks are associated with COVID-19?
Risk appetites and related operational strategies must be re-evaluated in times of crisis.
Specific Considerations for Enterprise Risk Management include:
- (1)
Legal? Liability related to liquor takeout and delivery; insurance policy, lease, and city/town code violations related to pop-up exterior dining structures and propane heating tanks; litigation risk related to COVID-19 exposure; canceled catered and private events due to gathering size restrictions.
- (2)
Supply chain? If using a limited number of suppliers, there is an increased risk to product availability.
- (3)
Liquidity? It is harder to exit a business or find a buyer. Any business goodwill that was cultivated prior to COVID-19 has diminished in value.
- (4)
Political? Additional governmental actions and mandates (ex. Additional restrictions, shutdowns, vaccination tracking for employees and customers) are possible.
- (5)
Operational? The impact of stimulus relief on motivation for employees to work during pandemic.
12—What are some opportunities created by COVID-19?
The opportunities created by COVID-19 include PPP loans; loan forgiveness opportunities; ERTC; lower interest rate loans; landlord non-eviction government mandates; and the availability of a larger workforce population. In addition, the pandemic led to new approaches to conducting business (Zoom events—wine tastings and cooking classes; no physical menu—contactless food ordering; food delivery, curbside pick-up, grocery sales, awareness of importance of OSHA and Board of Health guidelines).
13—Any costs not indicated above?
FICA (+7.65%); Workers’ Comp (+3.2%); Unemployment (4.9%).
14—Additional Considerations?
- (1)
Re-evaluate the legal consequences of the use of a Force Majeure clause in an insurance policy and in customer contracts in relation to business sustainability (
Januarita and Sumiyati 2021).
“A Force Majeure clause allocates the risk of loss if performance is hindered, delayed, or prevented because of an event that the parties could not have anticipated or controlled. It provides a contractual defense, the scope and effect of which will depend on the express terms of a particular contract. These terms may have been negotiated, if the parties took the time to tailor the clause to their specific transaction …”
- (2)
(Do the strategies implemented to offset COVID-19 increase risk (alcohol takeout and delivery; grocery sales; outdoor dining; staffing) require additional insurance?
- (3)
Are the limits of liability in insurance policies adequate for COVID-19 related risks?
- (4)
Owners should consider recruiting shareholders to offset risk.
- (5)
Food handling and sanitation guidelines need to be updated and established with staff, and the protocols need to be shared with patrons.
- (6)
NYS waived ‘personal guarantee’ clauses in commercial leases (lease holder not personally liable for business closure).
- (7)
Depending on the time remaining on a lease, tenants should consider renegotiating for more favorable lease terms.
- (8)
Increased takeout and delivery increases supply costs (packaging) while decreasing labor costs (service staff, dishwasher staff, etc.).
- (9)
Sustainability initiatives (recycling, re-usable materials) were minimized due to the need for one-time use disposable materials during COVID-19.