I attached the case, answer the worksheet below

Operations and Financial Planning As Quality begins its journey into these new business ventures, Sherry Sharp, Quality's Certified General Accountant, needs to re-examine the "financials" in order to re-assess the monetary "health" of the business. It will be critical for her to sit down with Bob and Barry (B&B) to accurately assess whether this is the right time to proceed with 'Man Cave at Quality' and the 'Exotic Wood' Cabinetry business ventures. She has mentioned concerns about rising CPI in Canada and a continued poor performing GDP figures in the past two quarters in Canada and in the US. Samantha has sent B\&B an email a few days ago with some industry statistics that she claims needs further discussion as it pertains to their internal accounting. Here is a section of her email: "... the average return on equity for our industry is 28.8% with our top two competitors at 30.5%. Our inventory turnover currently is 74.7 days and has slowed down slightly given we trended, on average, in the past 3 years at 72.5 days. I think this tells you about our warehouse. Our Short-Term Solvency has remained consistent, but our Long-Term is up 0.5 from last year and up 0.8 from two years ago. Industry average for return on sales is trending at 11.3%. We need to go over these figures because I am concerned..." B\&B will need to (1) clearly understand their financial foundation and (2) make sure they can have the required factors of production in place (i.e., especially qualified labour) to maintain the same level of quality and operations planning in their current kitchen and bathroom cabinets business. This is critical before they make the final decision to pursue the first venture (Man Cave). B\&B realize that operations planning will have to improve moving forward. They know the importance of this from a recent installation they had at the Roger's home. They go on to explain the Rogers' situation to Samantha to emphasize the critical nature of their operations planning as it relates to their new venture(s). The following is a summary of what B&B do and some of what they have directly said/discussed with Samantha: Bob and Barry (B&B) as always, will visit a customer at their residence to conduct a full-scale walkthrough of any kitchen or bathroom design. This is critical to determine budget, timing and required resources. Their business strategy (All about trust and completing projects as promised), seems to align to their customer service motto. That said, B\&B will not often haggle with price, because they have established a solid reputation of producing quality and reliable products. They continue to use up-to-date sophisticated computer software to assist with creating two and three-dimensional designs quickly, and with high accuracy, so customers can view as "close to a real-life portrait" of the finished product. They also have their equipment, machinery, and supplies in what they believe to be in an efficient layout to ensure they can respond quickly and efficiently to customer requests (e.g., any last-minute changes). An efficient layout is necessary to help with their continuous storage challenges that have not yet been resolved. Finally, it also ensures the customer receives exactly what is wanted and there is no "misunderstanding". This accuracy also helps with many other operations planning requirements, as well as having a finished product when the customer wants it. For example, Quality will always complete painting before any cabinetry is installed. Their senior tiling expert will not install floor tiles or a backsplash until painting is completed, and when he can inspect the fitting of cabinets to the wall, as well as the distance from the bottom of the cabinet to the countertop. B\&B recognize the sensitivity and concerns of their customers and will take the time to ensure they receive precise feedback, so the job is done right, on time and on budget. The attention to detail also minimizes that amount of equipment and materials that need to be at the customer's house when having to install cabinets and/or make on-site adjustments. Bob has a formal meeting with Mr. \& Mrs. Rogers, who need their kitchen remodeled in 7-weeks, as they are hosting a large family reunion. The job seems fairly-routine, until Bob walks toward the far window. He feels the floor bending downward. He takes his level and realizes the floor is severely sloped and structurally unstable. He is very concerned, given his employees have basic carpentry (i.e., his team can install tile or hardwood flooring), but a potential structural issue such as this, may require more knowledge (i.e., a framing or flooring expert) and take more time - which he does not have. He needs to find a way to resolve this issue fast (i.e., in a day or two - at most!). Making things more challenging, the Rogers' say they would like to keep their existing kitchen for as long as possible before demolition, which Bob agreed to over the phone prior to this meeting and not having any knowledge of the floor structure issue. The project MUST be completed on December 20th given it is now November 1st (Note: Assuming this date for the Case Study purpose only). Bob needs to keep in mind some of his longer and more recent business challenges when building and installing these cabinets. Bob knows this customer will provide multiple referrals in the future, so flawless execution and meeting the time frame and his promises, is critical for the company. Current Assets: \begin{tabular}{lll|l} Cash & & $ & 203,115.25 \\ Accounts Receivable & $ & 79,530.40 \\ \hline Allowance of doubtful accounts & $ & 7,750.00 \\ \hline & & \end{tabular} \begin{tabular}{|lrr|} \hline Merchandise Inventory & $ & 159,878.20 \\ \hline Prepaid Expenses & $ & 7,313.65 \\ \hline Total Current Assets & & \\ \hline \end{tabular} Fined Assets: \begin{tabular}{l|cc|} \hline PropertyrLand & & $ \\ Building and Tools & $ & 264,200.00 \\ Accumulated Depreciation & $ & 117,210.50 \\ & $102,280.70 \\ Kitchen Equipment & $ & 91,850.60 \\ Bathroom Equipment & $ & 29,225.00 \\ Accumulated Depreciation: Kitchen Equip & $ & 23,650.00 \\ Accumulated Depreciation: Bathroom Eq. & $ & [C] \\ \hline Total Fized Assets & [E] \end{tabular} Intangible Assets: \begin{tabular}{l|l|l|l|} \hline Patent Designs & $ & 4,621.85 & \\ \hline TrademarkstCopyrights & $ & 2,100.45 & \\ \hline Total Intangible Assets & & & \\ \hline [T] & & \\ \hline \end{tabular} Liabilities CurrentLiabilities: \begin{tabular}{|l|r|r|r|} \hline Accounts Payable & $ & 121,879.40 & \\ \hline Contingent Wages & $ & 49,600.55 & \\ \hline Tanes Payable & $ & 58,730.20 & \\ \hline \multicolumn{1}{|l|}{ Total Current Liabilities } & & & \\ \hline \end{tabular} Long-TermLiabilities: MachinePayable,Due2020RawMaterialsEnviroPayable,Due2020$$122,441.1021,995.80 Vehicles and Maintenance, Due 2020$54,755.30 Total Long-Term Liabilities [I] TOTAL LIABILITIES [J] Owners' Equity; Additional Paid-In Captital Retained Earnings Total Owners" Equitg [K] TOTAL LIABILITIES AND OWNER5" EQUITY [L] B Worksheet Name: Revenue [Gross Sales] Cost of Goods Sold: \begin{tabular}{l|lr|} \hline Merchandise Inventory: Jan 1st, 2020 & $ & 104,155.15 \\ \hline Merchandise Purchases & $ & 463,975.45 \\ \hline Goods Available for Sale & & \end{tabular} Merchandise Inventory: Dec 31 st, 2020 Total Cost of Goods Sold [] GROSS PROFIT [0] DperatingEypenses: \begin{tabular}{l|r|r|} \hline Salaries and Wages & $ & 608,854.65 \\ \hline Advertising & $ & 49,481.35 \\ \hline Shipping and Transportation & $ & 38,774.55 \\ \hline Depreciation: Warehouse 8 Product Repairs & $ & 23,401.15 \\ \hline Total Selling and Shippping Expenses & \end{tabular} Administration Eypenses: \begin{tabular}{l|r|r|} Salaries and Wages & $ & 331,151.15 \\ \hline Supplies & $ & 18,150.35 \\ \hline Utilities & $ & 38,100,05 \\ \hline Depreciation: Orfice Equipment & $ & 9,580.35 \\ Interest Expenses & $ & 15,990.90 \\ Miscellaneous ExpensesiBusiness Meetings & $ & 9,948.30 \\ otal Administration Expenses & & \\ [Q] \end{tabular} TOTAL DPERATING EXPENSES [P] Operating Income (Income Before Taues) [S] Income Tanes [Cumulative] HET IHCDHE [FIHAL] [T]