100% Home Layout Tables Charts SmartArt Formulas DataReview abWrap Text General Normal ClearBIU Merge" Formatting 026 TCA 321-1006 Mospitality Accounting l must be completed in excel Homework 84, Fall 2018 ithabse's Wraps Cash Budget for the Fist Quarter of 201 Student Name Sithabiso's Wraps is an all-crganic restaurant located near Stute Ulniversity, le is managed by unice Ndlovu, and Eunice is preparing her firsi-quarter cash budget for 2018 I is impectant to her because of the variation in velume causod by the vetum of the univensity students Help Eunice cemplete her cash Estimated Cash Begiening Estimated Cash Recelpts Food Revenes 7 budget in the template previded next. Fint note the following forecast information and assumetions f Sithabiso'sWrap Cath Sales BON Eunice has budpeted her revenues,cest of sales, and operating espenses hased on orecasts the months of lanuary, February, and March She expects to collect S0% of revenues in the math they are generated current month, and the remaining 207% t e fest mieh accounts receivable i R , hased en her 'ging of a cour.. receivable Collection of Account Receivable Dividend Revenue Total Cash Receipts . She expocts to collect in Jamuary 530,000 from accounts receivable from December She espects to pay 64% of the cest of sales in the month they arc incured (cuem en the remsining 40% the next month as accounts payabile (AP She expects to pay in January $19,000 rom accounts payable for cost of sales from Decenber Estimated Cash Disbursements Cet of Sale and Cash Payments Payment of Accounts Payable Operating Expeses and the remaiting 30% the nest month as accounts payable tAP She espects to pay in Januery 521000 from accounts payable for operating expenses from Cash Payments Payment of Ascouts Paya She expcts to pay 10%of h opsing espenies in the mcnsh they are nconed Nonoperating Een ent Payment urance Paymen Cash Required Excel File Edit View Insert Format Tools Data Window Help HW+4.xlsx lome Layout Tables:Charts SmartArt. Formulas Data Review |F Calibri (Body) LI 12.LA. 12A A ,1 1wrap Text, A, 1 label wrap Text. General General Normal 53 96 ,:.ee 026 Formatting paysannsurance premiumor000 expensed immediately in the same month heErstmoniEoreveryquarter, iis premiumis Eunice expects to receive $300 in dividends from a stock investment She expects to parchase a new range in February and, the cost is espeoctod to be $7,0o Her beginning cash balance in Jamuary will be $5,000 insurance Payment Payrment for Acquisition of Fixed Assets Total Cash Disbursements Ending cash balance for one moeth is the beginning cash balance of the nest month . Preliminary Balance Minimum Cash Required Cath Encess or Shortage Shors-term Borrowing Loan Repayment (including interest) Estimated Cash-Ending She regaires a minimum cash balance of $5,000 at all times (e, for emengencies). Ifthe budgeted cash available in a given month s below S5,00, Eunice will bnowssoo shortam kan in hat month from a local bank (so matter what amount the shortage is). This loan will be paid neM month kng with the 10% monthly interest (i e ss,500 will be paid, so mater what amount the shortage is. This loan will be paid ncsr 3 Reverues 4 Cost o Seles IS |Operating!penses 6 Nonoperating Expenses 37 en Expense 38 39 Insurance Premu 40 41 42 Schedule of Recigts (A) 0,000 21,000 28.000 6,200 36,000 3,600 4,000 4,000 4,000 Current Menth Second Mens 3 A from December Received in Januery 44 Sohedule of Payments(AP 45 Cout of Sales 46 Operating Expense 47 Nonoperating xpenses 48 Cost of Sales fram December Paid in lanuary) 49 Opervine Expenses trom December lu)21000 60% 40% 100% Home Layout Tables Charts SmartArt Formulas DataReview abWrap Text General Normal ClearBIU Merge" Formatting 026 TCA 321-1006 Mospitality Accounting l must be completed in excel Homework 84, Fall 2018 ithabse's Wraps Cash Budget for the Fist Quarter of 201 Student Name Sithabiso's Wraps is an all-crganic restaurant located near Stute Ulniversity, le is managed by unice Ndlovu, and Eunice is preparing her firsi-quarter cash budget for 2018 I is impectant to her because of the variation in velume causod by the vetum of the univensity students Help Eunice cemplete her cash Estimated Cash Begiening Estimated Cash Recelpts Food Revenes 7 budget in the template previded next. Fint note the following forecast information and assumetions f Sithabiso'sWrap Cath Sales BON Eunice has budpeted her revenues,cest of sales, and operating espenses hased on orecasts the months of lanuary, February, and March She expects to collect S0% of revenues in the math they are generated current month, and the remaining 207% t e fest mieh accounts receivable i R , hased en her 'ging of a cour.. receivable Collection of Account Receivable Dividend Revenue Total Cash Receipts . She expocts to collect in Jamuary 530,000 from accounts receivable from December She espects to pay 64% of the cest of sales in the month they arc incured (cuem en the remsining 40% the next month as accounts payabile (AP She expects to pay in January $19,000 rom accounts payable for cost of sales from Decenber Estimated Cash Disbursements Cet of Sale and Cash Payments Payment of Accounts Payable Operating Expeses and the remaiting 30% the nest month as accounts payable tAP She espects to pay in Januery 521000 from accounts payable for operating expenses from Cash Payments Payment of Ascouts Paya She expcts to pay 10%of h opsing espenies in the mcnsh they are nconed Nonoperating Een ent Payment urance Paymen Cash Required Excel File Edit View Insert Format Tools Data Window Help HW+4.xlsx lome Layout Tables:Charts SmartArt. Formulas Data Review |F Calibri (Body) LI 12.LA. 12A A ,1 1wrap Text, A, 1 label wrap Text. General General Normal 53 96 ,:.ee 026 Formatting paysannsurance premiumor000 expensed immediately in the same month heErstmoniEoreveryquarter, iis premiumis Eunice expects to receive $300 in dividends from a stock investment She expects to parchase a new range in February and, the cost is espeoctod to be $7,0o Her beginning cash balance in Jamuary will be $5,000 insurance Payment Payrment for Acquisition of Fixed Assets Total Cash Disbursements Ending cash balance for one moeth is the beginning cash balance of the nest month . Preliminary Balance Minimum Cash Required Cath Encess or Shortage Shors-term Borrowing Loan Repayment (including interest) Estimated Cash-Ending She regaires a minimum cash balance of $5,000 at all times (e, for emengencies). Ifthe budgeted cash available in a given month s below S5,00, Eunice will bnowssoo shortam kan in hat month from a local bank (so matter what amount the shortage is). This loan will be paid neM month kng with the 10% monthly interest (i e ss,500 will be paid, so mater what amount the shortage is. This loan will be paid ncsr 3 Reverues 4 Cost o Seles IS |Operating!penses 6 Nonoperating Expenses 37 en Expense 38 39 Insurance Premu 40 41 42 Schedule of Recigts (A) 0,000 21,000 28.000 6,200 36,000 3,600 4,000 4,000 4,000 Current Menth Second Mens 3 A from December Received in Januery 44 Sohedule of Payments(AP 45 Cout of Sales 46 Operating Expense 47 Nonoperating xpenses 48 Cost of Sales fram December Paid in lanuary) 49 Opervine Expenses trom December lu)21000 60% 40%