b. Determine if the ratio analysis (workpaper B.3.3) was appropriately performed and completed (workpapers 3.3.1 and B.3.2). Review the explanations of account fluctuations provided by the auditors. Describe any problems you identify There are total 6 issues get 5 issues to get full credit. Proper sources and explanations. WP Issue B Corparty Balance Sheets as of 3/31/20X2 and 12/31/20X1 (USD $) Audit Year December 31, 20X2 Performed by: SDM 9/15/2012 Reviewed by: IKT 9/20/20K2 B.3.1 As of 3/31/20X2 As of 12/31/20X1 As of 3/31/2001 Balance Sheet: Current Assets Cash: Storefront Cash: Corporate Accounts Cash Payroll Accounts Receivable Office Supplies Cooking Supplies Inventory: Ingredients Inventory: Cake Boxes and Cupcake Cups Inventory: Beverages Total Current Assets Long-term Assets Equipment Accumulated Depreciation Equipment Plant & Property Accumulated Depreciation: Plant & Property $125,498.76 293,728.03 123,43243 122,849.12 2.379.00 4777.00 25.190.66 1.423.05 334030 $702,618.35 $135,135.15 210,019.06 124,726.15 193,976.31 2,501.00 4713.00 25,580.09 1.190.10 3.260 90 $701,204.66 $151,293.51 57,069.58 122.931.81 159,537.02 2,133.00 3.808.00 26,779.44 434.95 2,348 50 $526,335.91 150,180.00 (82,455.00) 330,000.00 (82,500.00) 125,000.00 $440,225.00 $1.142843.35 150,180.00 (78,828.00) 330,000.00 (79,200.00) 125,000.00 $447,152.00 $1,148,356.66 150, 180.00 (66,372.co) 330,000.00 (69,300.00) 125.000.00 $469,508.00 $995,642.91 and Al long-term assets Total Assets Liabilities Accounts Payable WageTaxes Payable Corporate Income Tax Payable Dividends Payable Mortgage Payable Notes Payable: Vehicles Total Liabilities Stockholders' Equity Common Stock, Par value $1.00, Authorized 1,000,000 shares; Issued and outstanding 50,000 shares Additional Paid in Capital Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 25,712.00 0.00 21.247.78 0.00 2005731 22.555.53 $360,189.12 3.556.70 0.00 30.125.96 13.125.00 292.262.13 24SR31 $406.94 10 40.168.65 0.00 18,683.56 0.00 296,909.93 31.69.28 $387421.52 50,000.00 120,075.91 612.579.32 $782,654.23 $1,142,843.35 50,000.00 120.075.91 571.332.65 $741.408.56 $1,148 356.66 50,000.00 120,075.91 438, 146.48 SOON 422.39 $995, 843.91 2.2.1 Lurrent portion $6,555.19 at 131/20X2 and $6.236.12 at 3/31/20X1 Current portion $8,337.88 M 131/20x2 and $9, 103.75 at 3/31/20x1 Client Supporting Document 3.1.1. p. 1 of 1 Cambridge Business Plan Performed by: B. Company SDM 9h15/2oxa Income Statements for the 3 Months Ended 3/31/20X2 and 3/31/20X1 (USDS) Review Audit Year December 31, 2012 IKT 9/20/2002 PEC 0.3.2 3 Months Ended 3 Months Ended 03/31/20X2 0 3/31/20X1 $353,739.57 $343,050.56 80,649.00 91.411.50 $434, RR.57 $434 462.06 66,736.39 64,645.64 3,875.55 3,755.55 5.466.50 5,681.50 $76,078.44 $74,082.69 $35,310.13 $360,379.37 89.00 65.00 $358,399.13 $360,444.37 Revenue Sales Revenue: Corporate Accounts Sales Revenues: Storefront Total Sales Revenue Cost of Goods Sold: Ingredients Cost of Goods Sold: Boxes and Cupcake Cups Cost of Goods Sold: Beverages Total COGS Gross Profit Interest Revenue Gross Profit Plus Interest Revenue Expenses Wage Expense Wage Tax Expense Medical Insurance Expense Auto insurance Expense Interest Expense Electrical & Gas Service Expense Liability Insurance Expense Telecommunications Expense Cell Phone Service Expense Postage Expense Professional Services Expense Maintenance Expense Office Supplies Expense Dry Cleaning Expense Storefront Paper Supplies Expense Rental Expense Waste Services Expense Car Maintenance and Fuel Expense Repair Expense Water Expense Soda Machine Repair and CO2 Expense Credit Card Expense Cooking Supplies Expense Banking Fees Selling and Administrative Expenses Depreciation Expense: Equipment Depreciation Expense: Plant & Property Total Depreciation Expense Total Expenses Client Supporting Document 216,719.DO 17,971.24 8,100.00 1,035.00 3,996.90 1,523.20 3.76840 472.SO 912.00 139.50 2,070.00 1,212.00 8,050.00 398.75 778.25 4.752.00 150.00 99538 372.50 378.75 1.156.00 878.31 12,704.00 445.00 $288.978.68 217,791.00 18,077.94 17,100.00 1,035.00 4.197.69 1,700.00 3.693.50 452.00 933.00 135.90 2.122.50 1.132.00 7,342.00 416.15 869.00 4.752.00 150.00 1,026.78 38125 373.75 1.128.00 897.89 11,858.00 445.00 $298.628.45 4.152.00 3.300.00 $7,452.00 $305,480.45 B Company Performed by: SDM 9/15/20/2 Income Statements for the 3 Months Ended 3/31/20X2 and 3/31/20X1 (USD $) Reviewed by: Audit Year December 31, 20X2 TKT 9/20/20X2 RC B.3.2 3 Months Ended 3 Months Ended 03/31/2012 03/31/20X1 62,493.45 54.963.92 21,247.78 18,683.66 $41,245.67 $36.280.26 Earnings Before Income Taxes Income Tax Expense Net Income Earnings per Share $0.82 $0.73 1 1 1 . Preliminary Analytical Procedures --Balance Sheets Audit Year December 31, 20X2 Performed by SDM 10/1/20 Reviewed by: TXT 10/9/20/2 As of As of 3/31/20X2 12/31/20x1 $ Change XChange $125,498.76 293,728.03 123,432.43 122,849.12 2.379.00 4,777.00 25,190.66 1,423.05 3.340.30 $702,618.35 $135,135.15 210,019.06 124,726.15 193,976.31 2,601.00 4.713.00 25,580.09 1,190.10 3,260.80 $701,204.66 (8,636.39) 84,708.97 (293.72) (70,127.19) 775.00 1,054.00 610.57 1,232.95 1,079.50 -6.39% 1 40.33% 1 -0.24% 36,15% 2 29.76% 22.58% 2.39% 103.60% 33.11% 0.00% 4.50% 0.00% 150, 180,00 (82,455.00) 330,000.00 (82,500.00) 125,000.00 440, 225.00 $1,142,843.35 0.00 3,627.00 0.00 3,300.00 0.00 Current Assets Cash: Storefront Cash: Corporate Accounts Cash: Payroll Accounts Receivable Office Supplies Cooking Supplies Inventory: Ingredients Inventory: Cake Boxes and Cupcake Cups Inventory: Beverages Total Current Assets Long-Term Assets Equipment Accumulated Depreciation Equipment Plant & Property Accumulated Depreciation: Plant & Proprty Land Total Long-Term assets Total Assets Labalties Accounts Payable Wage Tages Payable Corporate Income Tax Payable Dividends Payable Mortgage Payable Notes Payable: Vehicles Total Liabilities Stockholders' Equity Common Stock, Par value $1.00, Authorized 1,000,000, Issued and outstanding 50,000 shares Additional Paid in Capital Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 150,180.00 (78,828,00) 330,000.00 79,200.00) 125,000.00 $447,152.00 $1,148,356.66 0.00% $25,712.00 0.00 21,247.78 0.00 290,673.81 22,555.53 360 189.12 38,556.70 0.00 38,125.96 13,125.00 292,262.13 2 4,878.31 $406,94 10 (12,844.70) 0.00 (16,878,18) (13,125.00 (1,588.32) 2.322.78) -33318 3 0.00% -44.27% -4 100.00% 5 -0.54% 19.34% 50,000.00 120.075.91 612.578.32 782,654.23 $1 142 143.35 50,000.00 120,075.91 $71,332,65 $741,408.56 $1,148,356.66 0.00 0.00 41,245.67 0.00% 0.00% 7.22% V-The fluctuation is less than TM ($23.700) and less than a so change. F.-Footed ARA Audit Workpaper B.3.1:29. 1 of 2 B Company Preliminary Analytical Procedures-Balance Sheets Audit Year December 31, 20X2 Performed by: SDM 10/1/20X2 Reviewed by: TKJ 10/9/20X2 1 - We discussed the fluctuation in the cash accounts with Miquel Lopez, Store Manager and Cash Receipts Accounting. He stated that cash fluctuates drastically depending on the timing of cash receipts and disbursements. The company tries to keep less cash in the storefront account and more cash in the operating account to earn more interest. The company has not had a significant purchase in the past year, so the overall cash balance has significantly increased. The company plans to purchase some new cooking equipment in the next year to expand the business and take on some new accounts. In addition, the company has paid down some debt. 2 - We discussed the lower AR balance from prior year with Lisa Thomas, Corporate Sales Representative. She noted that the company has seen a slight decline in Corporate Sales primarily due to having two customers reducing their purchases in 20x2. These two customers are Luigi's Bistro and Mountain Lion Restaurant. In addition, the Company has made new efforts to collect from its customers in a timelier manner. If a customer does not pay in go days, Alpine calls the customer weekly to discuss and requests payment as soon as possible. 3- We discussed changes in Accounts Payable with Lindsay McKenna. She noted that the company experienceda slight dip in purchase prices and the amount of purchases in Oi 20x2 in all of the vendors' accounts except for Mountain Dairy Company. The company expects sales to increase in Q2, so that payables will be in line with previous year activity with vendors. Milk prices have been increasing, so there is a concern that the cost of production will go up with milk and potentially sugar costs throughout 20x2. In addition, Lindsay stated that this change in the account is immaterial to the company's financial statements and is a reasonable fluctuation in this type of business. 4 - Per discussion with Miguel Lopez, the company paid the income tax payable amount of s38,125.96 from Q4 in 20x1 on January 14, 20x2. The new balance of $21,247.78 relates to the first quarter 20X2 Income tax expense. The company pays its income taxes on a quarterly basis. Miguel stated that the dividends payable was paid in the first quarter 20x2 on April 24, 20x2 to Wasatch Range Trust. The company pays the dividends an annual basis. B. Company Preliminary Analytical Procedures-Quarterly Income Statements Audit Year December 31, 20X2 Performed by: SDM 01/20X2 Reviewed by: TKJ 10/9/20/2 B.1. 2 3 Months Ended 03/31/2012 3 Months Ended 03/31/20x1$ Change Change -3.12% 3.20% Revenue Sales Revenue: Corporate Accounts Sales Revenues: Storefront Total Sales Revenue Cost of Goods Sold: Ingredients Cost of Goods Sold: Boxes and Cupcake Cups Cost of Goods Sold: Beverages Total COGS Gross Profit Interest Revenue Gross Profit Plus Interest Revenue $353,739.57 80,649.00 434,388.57 66,736,39 3,875.55 5.466.50 76078.44 358,310.13 89.00 358,399.13 $343,050.56 (10,689.01) 91,411.50 (10,762.50) 434,462.06 173.49) 64,645.54 2,090.75 3,755.55 120.00 5,681 50 215.00) 74.002.59 1995.75 360,379.37 65.00 24.00 360,444.37 36,92% Expenses Wage Expense Wage Tax Expense Medical Insurance Expense Auto insurance Expense Interest Expense Electrical & Gas Service Expense Liability insurance Expense Telecommunications Dxpense Cell Phone Service Expense Postage Expense Professional Services Expense Maintenance Expense Office Supplies Expense Dry Cleaning Expense Storefront Paper Supplies Expense Rental Dxpense Waste Services Expense 216,719.00 17,971.24 8.100.00 1,035.00 3,996.90 1,523.20 3,768.40 472.50 912.00 139.50 2,070.00 1,212.00 8,050.00 398.75 778.25 4,752,00 150.00 217,791.00 18,077.94 17,100.00 1,035.00 4.197.69 1,708.00 3,693.60 462.00 933.00 135.90 2,122.50 1132.00 7,342.00 416.15 869.00 4,752.00 150.00 (1,072.00) (106.70) 19,000.00) 0.00 (200.79) (164.80) 74.80 10:50 (21.00 3.60 152.50) 80.00 700.00 (17.40) (90.75) 0,00 0.00 -0.49% -0.59% -52.63% 0.COM -4.78% -10.82% 2.00% 2.27 2.25% 2.65 -2.47 7.07% 9.64 4.18% -10.44 0.00N 0.00N 44A Audit Workpaper B. Coworty Preliminary Analytical Procedures-Quarterly Income Statements Audit Year December 31, 20X2 Performed by: SDM 10/1/20X2 Reviewed by: TK 10/9/20X2 B.1.2 3 Months 3 Months Ended Ended 03/31/20X203/31/20x1 $ Change X Change Expenses (continued) Car Maintenance and Fuel Expense Repair Expense Water Expense Soda Machine Repair and CO2 Expense Credit Card Expense Cooking Supplies Expense Banking Fees Selling and Administrative Expenses Depreciation Expense: Equipment Depreciation Expense: Plant & Property Total Depreciation Expense Total Expenses 995.38 372.50 378.75 1,156.00 878.31 12,704.00 445.00 288,978.68 3,627.00 3,300.00 6,927.00 295,905.68 1,026.78 381.25 373.75 1,128.00 897.89 11,858.00 445.00 298,028.45 4,152.00 3,300.00 7,452.00 305,480.45 (31.40) (8.75) 5.00 28.00 (19.58) 846.00 0.00 -3.06% -2.30% 1.34% 2.48% -2.18% 7.13% 0.00% (525.00) 0.00 -12.54% 0.00% e prnings Before Income tax Income Tax Expense Net Income 62,493.45 21,247.78 $83,741.23 54,963.92 18,683.66 $73,647.58 2,564.12 13.72% Auditor Notes: -The fluctuation is less than TM ($13.700) and less than a 10% change. F-Footed 1 - The Company has seen decreases in both their corporate and storefront sales. The Company has experienced a decrease in birthday party and holiday orders leading to the decline in storefront sales Most customers order these items week before the event and pick them up in the store. The decrease incorporate accounts revenue is primarily due to two customers, Luigi Bistro and Steinberg Dis. The Company expects corporate sales to pick up through the rest of the year. 2. We discussed the change in the medical insurance expense account with Lindsay McKenna Lindsay said the increase in medical insurance expense from prior year is due to accidentally paying ooo more on each check that was written to Blue Cross Blue Shield in Qi of X1. The Company received a refund of $9,000 from the medical insurance company in April 2oX due to the mistakes in payments. A4 Audie Work paper B.3.2.po 2 of 2 B Company Preliminary Analytical Procedures-Rata Analysis Audit Year December 31, 2012 Performed by: SDM 10/1/20X2 Reviewed by: TKT 10/9/20X2 Current Ratio Quick Ratio Receivables Tumover Days Outstanding In Receivables Inventory Turnover Days of Inventory on Hand Gross Profit Percentage Profit Margin Return on Assets Return on Equity Debt to Assets Debt to Equity Company Ratios 3/31/20X2 3/31/20x1 % Change 11.360 7.094 . 60.1% 1, 10.875 6.696 62.4% 1, 2.879 2.150 33.9% 2, 126.760 169.745 -25.3% 2, 2.540 2.506 14% V 143.710 145.654 -1.3% VA 4.710 4.865 -3.2% V 0.095 0.084 13.1% 3 0.036 0.036 0.0% V, 0.060 -11.7% 4 0.274 0.330 -17.0% Sh. 0.400 0.540 -25.9% 5 0.053 March 20x1 AN Max 5.70 Current Ratio Quick Ratio Receivables Turnover Days Outstanding in Receivables Inventory Turnover Days of Inventory on Hand Gross Profit Percentage Profit Margin Return on Assets Return on Equity Debt to Assets Debt to Equity 3.95 Industry Ratios March 20x2 Min Max 1.05 15.30 0.77 14.00 1.28 - 5.68 64.30 285.43 159.54 0.24 1.51 92.29 1525.44 458.39 0.49 0.33 -0.09 0.10 0.11 -0.03 0,04 0.04 -0.04 0.23 0.08 0.00 0.74 0.19 -0.05 1.76 0.58 2.97 150.08 162 441.54 0.31 0.02 0.01 202 13.76 12.45 109 441 333.76 0.20 4.15 87.88 1830.71 0.48 1.02 -0.02 -0.160.67 0.00 0.00 3.99 0.01 010 0.09 0.29 0.04 0.21 0.55 0.26 Auditor Notes: **Calculation includes current portion of mortgage payable and notes payable based on client's amortization schedule. On y ox, the current portions of the mortgage and notes payables are 5.555-19 and 5.3.1, respectively. On oxi, the current portions of the mortgage and notes payables are 56,236.11 and 9, 103-75, respectively - Fluctuation meets expectations of being less than a so change. -The Xa ratio is within the expected range between the min and many of the industry data. AA Audit Workpaper B.3.3: pg. 1 of 2 B Company Preliminary Analytical Procedures-Ratio Analysis Audit Year December 31, 20X2 Performed by: SDM 10/1/20X2 Reviewed by: TKT 10/9/20X2 Auditor Notes (continued) Ratio Calculations Short-term (ST) Liquidity Ratios: Ability to Meet ST Obligations Current Ratio = Current Assets + Current Liabilities Quick Ratio (Current Assets - Inventories) + Current Liabilities Activity Ratios: How Effectively Assets Are Managed Receivables Turnover = Credit Sales + Receivables Days Receivables Outstanding = 365+ Receivables Turnover Inventory Turnover =COGS + Inventory Days Inventory on Hand = 365 +Inventory Turnover Profitability Ratios Gross Profit Percentage (Sales - COGS) - Sales Profit Margin = Net Income + Net Sales Return on Assets - Net Income + Total Assets Return on Equity - Net Income Total Stockholder's Equity Coverage Ratio: Long-Term Solvency (Ability of Entity to Continue as a Geling Concern) Debt to Assets - (ST Debt +LT Debt) + Total Assets Debt to Equity - (ST Debe+LT Debe) + Stockholders' Equity 1. The current ratio and quick ratios increased significantly primarily due to an increase in corporate cash of 236,658 (293.728-57,070)[8.1.1] from 3/31/20Xi to /3/2oXa. As noted in our balance sheet analysis (B.2.1), Miguel Lopez says cash fluctuates drastically depending on the timing of cash receipts and purchases. The company has not made any major purchases in the past year, but plans to make some purchases in 2013. In addition, the current liabilities in 2010 have decreased from 3/34/20Xs primarily due to the timing of paying accounts payable balances and the timing of purchases. >-The Company is collecting its receivables more quickly than it has in prior years. Per our discussion with Lisa Thomas, the Company is taking additional steps to have customers pay In a more timely manner by improving customer relationships and calling customers weekly when the customers have past due balances. 3-The Company's profit margin has increased since prior year due to increases in storefront sales and decreases in the Company's selling and administrative expenses. Per discussion with Miguel Lopez, the Company has seen great growth and has performed well in relation to the Industry competitors, largely because the Company has built its reputation for quality and has maintained good relationships with vendors to keep costs down 4 - The company's ROE is significantly lower than prior year. We have requested a time to meet with Miguel Lopez to discuss the difference in this ratio in comparison to our expectations. 5 -The company's debt to assets and debt to equity ratios have decreased from prior year due to the decrease in the long-term liabilities, along with the decreases in current accounts payable due to timing of purchases and payments of abilities). AA Audit Wortpeper B33 p 2 of 2 B company 2012 Cupcake Corporate Sales Analysis Audit Year December 31, 20X2 20X1 20X1 Cupcakes Ordered 59,493 5,095 7,052 5,694 9,622 13,057 14,021 35,419 22,809 19,529 31,674 15,210 13,766 23,850 7,602 5,608 8,396 44,794 10,235 11,391 17,922 12,677 4310 6,079 Customer Name Bon Appetito Restaurants Boulder Tea House Broken Eggs Restaurant Brown's Tavern Bubba's Fish House Buckhead Restaurants Chavez Cantina Country Barrel Restaurants Denver Bakery Caf Denver Sirloin Restaurants Elkhorn Coffee Shops Fontana Catering & Cafe Granny's Cafe High Country Coffee Julie's Wraps Little's Grill e 's Bistro Mile High Steakhouses Mountain Lion Restaurant Mountain Trout Fish House Nora's Cafe Papa's Restaurant Pebbles Inn Scotty's Taverns Smokey's Barbeque Plt Southside Cafe St. Francis Hotel and Spa Steinberg Delis The Breakfast Place The Sandwich Place UC Boulder Food Service UC Denver Food Service Cupcake Sales Revenue Shipping Revenue Corporate Sales Revenue 20x2 20x2 Cupcakes Ordered Invoice Total 62,088 149,011.20 4,464 10,713.60 7,150 17,160.00 4,225 10,140.00 10,485 25,164.00 15,013 36,031.20 15,842 38,020.80 35,163 84,391.20 24,259 58,221.60 18.578 44.587.20 34,449 82,677.60 16,067 38,560.80 13,994 33,585.60 27,365 65,676.00 10,613 25,471.20 6,218 14,923.20 6.683 16,039.20 45.628 109,509.50 25,029.60 29,445.60 20,005 48,012.00 13,496 32,390.40 3.520 8,448.00 6,288 15,091.20 17.530 42,072.00 9.164 22.471. 15,700 37,600.00 9,265 22,236.00 20.544 40.105.60 5,287 12.6 .RO $8,118 119.43 20 46,633 111,919.20 606,733 1,456,159.20 10,106.88 WRs. 1,466, 266.08 Invoice Total 142,783.20 12,228.00 16,924.80 13,665.60 23,092.80 31,336.80 33,650.40 85,005.60 54,741.50 4 6,869.60 76,017,50 36,504.00 33,038.40 57,240.00 18,244.80 13,459.20 20,150.40 107,505.60 24,564.00 27,338.40 43,012.80 30,424.80 10,344.00 14,589.60 33,852.00 22,329.60 32,277.50 25,804.80 45,561.60 10,737.50 141,475.20 106,332.00 1,891,102.40 9,657.52 1,400,759.92 O Performed by: 785 /10/2013 Reviewed by: SDM 2/12/20X Change Change Cupcakes involce Ordered Total 2,595 6,228.00 (631) (1.514.40) 98 235.20 (1,469) (3,525.60) 863 2,071.20 1,9564,694.40 1,8214,370.40 (256) 1614.40) 1,450 3,480,00 1951) 12,282.401 2,775 6,660.00! 857 2,056.80 228547.20 3,515 8,436.00 3,011 7,226.40 610 1,464.00 (1,713) (4,111.20) 835 2,004.00 194 465.60 878 2,107.20 2,083 4.999.20 819 1,965.60 (790) (1,896.00) 10,0 209 501 14.105 9,304 13,449 10,752 13,984 4,474 58,948 44,305 579,626 3,4258,220.00 60 144.00 2,251 5.402.40 (1,487) 13,568.80 1.560 3,744.00 813 1,951.20 (830) (1,992.00 2,328 5.587,20 HRS. Aet Audit Workpapler AR 3.3: Po. 1 of 2 Cambridge Business Publishers Performed by: B company 7ES 02/10/2013 20X2 Cupcake Corporate shtes Analysis Reviewed by: Audit Year December 31, 20X2 SDM 2/12/20X3 Tudatorated 78 - Agreed to Decender Total Balance. Pl- Agreed to P4 worlagers. -The Company is collecting its receivables more quickly than it has in prior years. Per our discussion with Lisa Thomas, the Company is taking additional steps to have customers pay In a more timely manner by improving customer relationships and calling customers weekly when the customers have past due balances. 3-The Company's profit margin has increased since prior year due to increases in storefront sales and decreases in the Company's selling and administrative expenses. Per discussion with Miguel Lopez, the Company has seen great growth and has performed well in relation to the Industry competitors, largely because the Company has built its reputation for quality and has maintained good relationships with vendors to keep costs down 4 - The company's ROE is significantly lower than prior year. We have requested a time to meet with Miguel Lopez to discuss the difference in this ratio in comparison to our expectations. 5 -The company's debt to assets and debt to equity ratios have decreased from prior year due to the decrease in the long-term liabilities, along with the decreases in current accounts payable due to timing of purchases and payments of abilities). AA Audit Wortpeper B33 p 2 of 2 B company 2012 Cupcake Corporate Sales Analysis Audit Year December 31, 20X2 20X1 20X1 Cupcakes Ordered 59,493 5,095 7,052 5,694 9,622 13,057 14,021 35,419 22,809 19,529 31,674 15,210 13,766 23,850 7,602 5,608 8,396 44,794 10,235 11,391 17,922 12,677 4310 6,079 Customer Name Bon Appetito Restaurants Boulder Tea House Broken Eggs Restaurant Brown's Tavern Bubba's Fish House Buckhead Restaurants Chavez Cantina Country Barrel Restaurants Denver Bakery Caf Denver Sirloin Restaurants Elkhorn Coffee Shops Fontana Catering & Cafe Granny's Cafe High Country Coffee Julie's Wraps Little's Grill e 's Bistro Mile High Steakhouses Mountain Lion Restaurant Mountain Trout Fish House Nora's Cafe Papa's Restaurant Pebbles Inn Scotty's Taverns Smokey's Barbeque Plt Southside Cafe St. Francis Hotel and Spa Steinberg Delis The Breakfast Place The Sandwich Place UC Boulder Food Service UC Denver Food Service Cupcake Sales Revenue Shipping Revenue Corporate Sales Revenue 20x2 20x2 Cupcakes Ordered Invoice Total 62,088 149,011.20 4,464 10,713.60 7,150 17,160.00 4,225 10,140.00 10,485 25,164.00 15,013 36,031.20 15,842 38,020.80 35,163 84,391.20 24,259 58,221.60 18.578 44.587.20 34,449 82,677.60 16,067 38,560.80 13,994 33,585.60 27,365 65,676.00 10,613 25,471.20 6,218 14,923.20 6.683 16,039.20 45.628 109,509.50 25,029.60 29,445.60 20,005 48,012.00 13,496 32,390.40 3.520 8,448.00 6,288 15,091.20 17.530 42,072.00 9.164 22.471. 15,700 37,600.00 9,265 22,236.00 20.544 40.105.60 5,287 12.6 .RO $8,118 119.43 20 46,633 111,919.20 606,733 1,456,159.20 10,106.88 WRs. 1,466, 266.08 Invoice Total 142,783.20 12,228.00 16,924.80 13,665.60 23,092.80 31,336.80 33,650.40 85,005.60 54,741.50 4 6,869.60 76,017,50 36,504.00 33,038.40 57,240.00 18,244.80 13,459.20 20,150.40 107,505.60 24,564.00 27,338.40 43,012.80 30,424.80 10,344.00 14,589.60 33,852.00 22,329.60 32,277.50 25,804.80 45,561.60 10,737.50 141,475.20 106,332.00 1,891,102.40 9,657.52 1,400,759.92 O Performed by: 785 /10/2013 Reviewed by: SDM 2/12/20X Change Change Cupcakes involce Ordered Total 2,595 6,228.00 (631) (1.514.40) 98 235.20 (1,469) (3,525.60) 863 2,071.20 1,9564,694.40 1,8214,370.40 (256) 1614.40) 1,450 3,480,00 1951) 12,282.401 2,775 6,660.00! 857 2,056.80 228547.20 3,515 8,436.00 3,011 7,226.40 610 1,464.00 (1,713) (4,111.20) 835 2,004.00 194 465.60 878 2,107.20 2,083 4.999.20 819 1,965.60 (790) (1,896.00) 10,0 209 501 14.105 9,304 13,449 10,752 13,984 4,474 58,948 44,305 579,626 3,4258,220.00 60 144.00 2,251 5.402.40 (1,487) 13,568.80 1.560 3,744.00 813 1,951.20 (830) (1,992.00 2,328 5.587,20 HRS. Aet Audit Workpapler AR 3.3: Po. 1 of 2 Cambridge Business Publishers Performed by: B company 7ES 02/10/2013 20X2 Cupcake Corporate shtes Analysis Reviewed by: Audit Year December 31, 20X2 SDM 2/12/20X3 Tudatorated 78 - Agreed to Decender Total Balance. Pl- Agreed to P4 worlagers.