Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(its one problem, 1st picture is the whole problem, pictures 2 and 3 are jusy close ups to be able to read it) 15 AV
(its one problem, 1st picture is the whole problem, pictures 2 and 3 are jusy close ups to be able to read it)
15 AV Sihabis Wrap is alleen rela x ed near Sure University. It is managed by Eunice Ndlove, and Eunice is preparing her first quarter asli budget for 2021. It is important to her because of the variation in volume caused by the return of the wivesity a t Help Funice complete her cash budget in the emple peided next. Firse not the following forecast informon N u mptions for Sithabiso's Wraps February March Sthabhe's Wraps Cashot for the finester of January Estimated Cash- Beginning Estimated Cash Receipts: Food Revenues Cash Sales Collection of Account Receivable Dividend Revenue Total Cash Receipts . Frice has to be reve , cost of sales, and operating expenses based on for for the months of January February March She expect to collect 80% of reves in the month they are the court me d the remaining 2016 the next month as c r iable (AR) based on her ping of accounts receivable. . She expect to collectinum 50.000 from accounts receive froes December S t ory 60% of the cost of sales in the month they are incred current method the remaining 40% the next month as accounts payable (AP). She expects to pay ina ry $19,000 from counts payable for cost of sales from December She expects to pay 70% of the operating experies in the month they wer e than the remaining 30% the next month as accounts payable (AP) . She expect to pay in a $21,000 from accounts payable for operating expenses from December She expects to pay 100% of her oping expenses in the month they are incurred. She has rent expense of $4,000 per month She pays an insurance pokum of $6.000 is the first of every que, d e expensed menedinely in the same month Eunice expects to receive S100 in dividends from a slock investment in any 2021 She expects to purchase a new range in February and the cost is expected to be 57.000 Her being cash balance in January 2021 will be $5.000 Ending cash balance for one month is the beginning cash balance of the next month She requires a minimum cash balance of 55,600 all e for energies If the budgeted cash railable in a given month is below 35.000, unice will brow a short term loan in the m e thortage from a local bank. This loan will be paid next monthlong with the 10% moothly in bo 52.000, she will pay back $2,200 (52,000LI) Estimated Cash Disbursements: Cost of Sales Cash Payments Payment of Accounts Payable Operating Expenses Cash Payments Payment of Accounts Payable Nonoperating Expenses Rent Payment Insurance Payment Payment for Acquisition of Fixed Assets Tgton D b. hehents min Preliminary Balance Minimum Cash Reguired Cash Excess or Shortage Short-term Rorrowing Lean Repayment Estimated Cavance. Endin March 96.000 33,600 32.000 36,000 Cost of Sales Operating Expenses Nonoperating Expenses Rent Expense 4.000 4.000 6.000 Current Month Second Month 30.000 Schedule of Receipts (AR) AR from December (Received in January Schedule of Payments (API Cost of Sales Operating Expenses Nonoperating Expenses Cost of Sales from December (Paid in Janus Sheet1 Recover Unsaved Workbooks. We were able to save changes to one or more filer 15 x fx Sithabis Wraps is an all-organic restaurant located near State University. It is managed by Eunice Ndlov, and Eunice is preparing her first quarter cash budget for 2021. It is important to her because of the variation in volume caused by the return of the university students. Help Eunice complete her cash budget in the template provided next. First note the following forecast information and assumptions for Sithabiso's Wraps: Eunice has budgeted her revenues, cost of sales, and operating expenses based on forecasts for the months of January, February, and March. She expects to collect 80% of revenues in the month they are generated (current month) and the remaining 20% the next month as accounts receivable (AR) based on her aging of accounts receivable. She expects to collect in January 530,000 from accounts receivable from December She expects to pay 60% of the cost of sales in the month they are incurred (current month) and the remaining 40% the next month as accounts payable (AP). She expects to pay in January $19,000 from accounts payable for cost of sales from December. She expects to pay 70% of her operating expenses in the month they are incurred (current month) and the remaining 30% the next month as accounts payable (AP). She expects to pay in January 21,000 from accounts payable for operating expenses from December She expects to pay 100% of her nonoperating expenses in the month they are incurred. She has rent expense of $4,000 per month. She pays an insurance premium of $6,000 in the first month of every quarter, and this premium is expensed immediately in the same month. Bunice expects to receive $300 in dividends from a stock investment in January 2021. She expects to purchase a new range in February and, the cost is expected to be $7,000. Her beginning cash balance in January 2021 will be $5,000. Ending cash balance for one month is the beginning cash balance of the next month. She requires a minimum cash balance of $5,000 at all times (i.c. for emergencies). If the budgeted cash available in a given month is below $5,000, Eunice will borrow a short-term loan in the amount of the shortage from a local bank. This loan will be paid next month along with the 10% monthly interest (e.g. If she borrows $2.000, she will pay back $2,200 ($2,000 1.1). Given Data: Revenues Cost of Sales Operating Expenses Nonoperating Expenses Rent Expense January 60,000 21,000 28,000 February 132,000 46,200 36,000 March 96,000 33.600 32,000 4,000 4,000 4,000 Insurance Premium 6.000 Current Month Second Month SON 30,000 40% Schedule of Receipts (AR) AR from December (Received in January Schedule of Payments (AP) Cost of Sales Operating Expenses Nonoperating Expenses Cost of Sales from December (Paid in January Operating Expenses from December (Paid in January 60% 70% 100% BON 19,000 21,000 J .00 +0 Formatting you want to recover them? March Sithabiso's Wraps - Cash Budget for the First Quarter of 2010 January February Estimated Cash- Beginning Estimated Cash Receipts: Food Revenues Cash Sales Collection of Account Receivable Dividend Revenue Total Cash Receipts Estimated Cash Disbursements: Cost of Sales Cash Payments Payment of Accounts Payable Operating Expenses Cash Payments Payment of Accounts Payable Nonoperating Expenses Rent Payment Insurance Payment Payment for Acquisition of Fixed Assets Total Cash Disbursements Preliminary Balance Minimum Cash Required Cash Excess or Shortage Short-term Borrowing Loan Repayment Estimated Cash Balance Indias 15 AV Sihabis Wrap is alleen rela x ed near Sure University. It is managed by Eunice Ndlove, and Eunice is preparing her first quarter asli budget for 2021. It is important to her because of the variation in volume caused by the return of the wivesity a t Help Funice complete her cash budget in the emple peided next. Firse not the following forecast informon N u mptions for Sithabiso's Wraps February March Sthabhe's Wraps Cashot for the finester of January Estimated Cash- Beginning Estimated Cash Receipts: Food Revenues Cash Sales Collection of Account Receivable Dividend Revenue Total Cash Receipts . Frice has to be reve , cost of sales, and operating expenses based on for for the months of January February March She expect to collect 80% of reves in the month they are the court me d the remaining 2016 the next month as c r iable (AR) based on her ping of accounts receivable. . She expect to collectinum 50.000 from accounts receive froes December S t ory 60% of the cost of sales in the month they are incred current method the remaining 40% the next month as accounts payable (AP). She expects to pay ina ry $19,000 from counts payable for cost of sales from December She expects to pay 70% of the operating experies in the month they wer e than the remaining 30% the next month as accounts payable (AP) . She expect to pay in a $21,000 from accounts payable for operating expenses from December She expects to pay 100% of her oping expenses in the month they are incurred. She has rent expense of $4,000 per month She pays an insurance pokum of $6.000 is the first of every que, d e expensed menedinely in the same month Eunice expects to receive S100 in dividends from a slock investment in any 2021 She expects to purchase a new range in February and the cost is expected to be 57.000 Her being cash balance in January 2021 will be $5.000 Ending cash balance for one month is the beginning cash balance of the next month She requires a minimum cash balance of 55,600 all e for energies If the budgeted cash railable in a given month is below 35.000, unice will brow a short term loan in the m e thortage from a local bank. This loan will be paid next monthlong with the 10% moothly in bo 52.000, she will pay back $2,200 (52,000LI) Estimated Cash Disbursements: Cost of Sales Cash Payments Payment of Accounts Payable Operating Expenses Cash Payments Payment of Accounts Payable Nonoperating Expenses Rent Payment Insurance Payment Payment for Acquisition of Fixed Assets Tgton D b. hehents min Preliminary Balance Minimum Cash Reguired Cash Excess or Shortage Short-term Rorrowing Lean Repayment Estimated Cavance. Endin March 96.000 33,600 32.000 36,000 Cost of Sales Operating Expenses Nonoperating Expenses Rent Expense 4.000 4.000 6.000 Current Month Second Month 30.000 Schedule of Receipts (AR) AR from December (Received in January Schedule of Payments (API Cost of Sales Operating Expenses Nonoperating Expenses Cost of Sales from December (Paid in Janus Sheet1 Recover Unsaved Workbooks. We were able to save changes to one or more filer 15 x fx Sithabis Wraps is an all-organic restaurant located near State University. It is managed by Eunice Ndlov, and Eunice is preparing her first quarter cash budget for 2021. It is important to her because of the variation in volume caused by the return of the university students. Help Eunice complete her cash budget in the template provided next. First note the following forecast information and assumptions for Sithabiso's Wraps: Eunice has budgeted her revenues, cost of sales, and operating expenses based on forecasts for the months of January, February, and March. She expects to collect 80% of revenues in the month they are generated (current month) and the remaining 20% the next month as accounts receivable (AR) based on her aging of accounts receivable. She expects to collect in January 530,000 from accounts receivable from December She expects to pay 60% of the cost of sales in the month they are incurred (current month) and the remaining 40% the next month as accounts payable (AP). She expects to pay in January $19,000 from accounts payable for cost of sales from December. She expects to pay 70% of her operating expenses in the month they are incurred (current month) and the remaining 30% the next month as accounts payable (AP). She expects to pay in January 21,000 from accounts payable for operating expenses from December She expects to pay 100% of her nonoperating expenses in the month they are incurred. She has rent expense of $4,000 per month. She pays an insurance premium of $6,000 in the first month of every quarter, and this premium is expensed immediately in the same month. Bunice expects to receive $300 in dividends from a stock investment in January 2021. She expects to purchase a new range in February and, the cost is expected to be $7,000. Her beginning cash balance in January 2021 will be $5,000. Ending cash balance for one month is the beginning cash balance of the next month. She requires a minimum cash balance of $5,000 at all times (i.c. for emergencies). If the budgeted cash available in a given month is below $5,000, Eunice will borrow a short-term loan in the amount of the shortage from a local bank. This loan will be paid next month along with the 10% monthly interest (e.g. If she borrows $2.000, she will pay back $2,200 ($2,000 1.1). Given Data: Revenues Cost of Sales Operating Expenses Nonoperating Expenses Rent Expense January 60,000 21,000 28,000 February 132,000 46,200 36,000 March 96,000 33.600 32,000 4,000 4,000 4,000 Insurance Premium 6.000 Current Month Second Month SON 30,000 40% Schedule of Receipts (AR) AR from December (Received in January Schedule of Payments (AP) Cost of Sales Operating Expenses Nonoperating Expenses Cost of Sales from December (Paid in January Operating Expenses from December (Paid in January 60% 70% 100% BON 19,000 21,000 J .00 +0 Formatting you want to recover them? March Sithabiso's Wraps - Cash Budget for the First Quarter of 2010 January February Estimated Cash- Beginning Estimated Cash Receipts: Food Revenues Cash Sales Collection of Account Receivable Dividend Revenue Total Cash Receipts Estimated Cash Disbursements: Cost of Sales Cash Payments Payment of Accounts Payable Operating Expenses Cash Payments Payment of Accounts Payable Nonoperating Expenses Rent Payment Insurance Payment Payment for Acquisition of Fixed Assets Total Cash Disbursements Preliminary Balance Minimum Cash Required Cash Excess or Shortage Short-term Borrowing Loan Repayment Estimated Cash Balance Indias Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started